Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

column not found in the new Codeigniter version 4.1.5 #17

Open
seunex17 opened this issue Nov 19, 2021 · 2 comments
Open

column not found in the new Codeigniter version 4.1.5 #17

seunex17 opened this issue Nov 19, 2021 · 2 comments

Comments

@seunex17
Copy link

seunex17 commented Nov 19, 2021

Am using this package in my project and it working perfectly in my CodeIgniter v4.1.4 but after upgrading to v4.1.5 there is now error say 'column not fund'

The issue observe is trying to create the db_prefix multiple times.

ERROR - 2021-11-19 03:10:21 --> Unknown column 'zd_`zd_users.user_username' in 'where clause'
CRITICAL - 2021-11-19 03:10:21 --> Unknown column 'zd_`zd_users.user_username' in 'where clause'
#0 C:\xampp\htdocs\clients\occidoma\vendor\codeigniter4\framework\system\Database\MySQLi\Connection.php(292): mysqli->query('SELECT COUNT(*)...', 0)
#1 C:\xampp\htdocs\clients\occidoma\vendor\codeigniter4\framework\system\Database\BaseConnection.php(670): CodeIgniter\Database\MySQLi\Connection->execute('SELECT COUNT(*)...')
#2 C:\xampp\htdocs\clients\occidoma\vendor\codeigniter4\framework\system\Database\BaseConnection.php(598): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT COUNT(*)...')
#3 C:\xampp\htdocs\clients\occidoma\vendor\codeigniter4\framework\system\Database\BaseBuilder.php(1527): CodeIgniter\Database\BaseConnection->query('SELECT COUNT(*)...', Array, false)
#4 C:\xampp\htdocs\clients\occidoma\vendor\irsyadulibad\codeigniter4-datatables\src\TableProcessor.php(35): CodeIgniter\Database\BaseBuilder->countAllResults(false)
#5 C:\xampp\htdocs\clients\occidoma\vendor\irsyadulibad\codeigniter4-datatables\src\DataTableMethods.php(101): Irsyadulibad\DataTables\TableProcessor->count()
#6 C:\xampp\htdocs\clients\occidoma\vendor\irsyadulibad\codeigniter4-datatables\src\TableProcessor.php(42): Irsyadulibad\DataTables\DataTableMethods->filterRecords()
#7 C:\xampp\htdocs\clients\occidoma\vendor\irsyadulibad\codeigniter4-datatables\src\TableProcessor.php(27): Irsyadulibad\DataTables\TableProcessor->doQuery()
#8 C:\xampp\htdocs\clients\occidoma\app\Controllers\Admin\AccountController.php(332): Irsyadulibad\DataTables\TableProcessor->make()
#9 C:\xampp\htdocs\clients\occidoma\vendor\codeigniter4\framework\system\CodeIgniter.php(824): App\Controllers\Admin\AccountController->ajaxListStaffAccount()
#10 C:\xampp\htdocs\clients\occidoma\vendor\codeigniter4\framework\system\CodeIgniter.php(410): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Admin\AccountController))
#11 C:\xampp\htdocs\clients\occidoma\vendor\codeigniter4\framework\system\CodeIgniter.php(318): CodeIgniter\CodeIgniter->handleRequest(NULL, Object(Config\Cache), false)
#12 C:\xampp\htdocs\clients\occidoma\public\index.php(37): CodeIgniter\CodeIgniter->run()
#13 {main}

How can i fix this please i have fork the repo to reproduce this issue.

@irsyadulibad
Copy link
Owner

Hello, I've tried it, and it works fine on codeigniter v4.1.5
image
code

@seunex17
Copy link
Author

Do you use db prefix on your end? Am using db prefix

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants