Weird Codeigniter query builder bug when running Select query

Asked Jul 22 '19 at 03:06

Active Jul 22 '19 at 07:32

Viewed 94 times

I'm working on a query that checks if a user exists in the database. The query returns an error :

"Table inventory_db.tbl_userss' doesn't exists".

The problem is in my code I'm cleary stating that the table name is just tbl_users not tbl_userss.

$query = $this->db->select('username')
    ->where('username', $username)
    ->get('tbl_users');

return $query->row();

Just yesterday it was working fine, didn't changed anything in my code. If it helps the database collation is utf-8 unicode_ci.

edited Jul 22 '19 at 07:32

Mickaël Leger

asked Jul 22 '19 at 03:06

John Michael

1

Can you post the error stack trace please? – atymic Jul 22 '19 at 03:18
RDBMS you're using? – Kagiso Marvin Molekwa Jul 22 '19 at 06:57
try entering the table name qualified by the db name, `inventory_db.tbl_users` – Kagiso Marvin Molekwa Jul 22 '19 at 06:58
@marvinIsSacul MySQL, tried `inventory_db.tbl_users` same error. I also tried to alter the table to `tbl_user` then in my query I used `tbl_user`, same error. – John Michael Jul 22 '19 at 07:10
also tried `$query = $this->db->query("SELECT username FROM tbl_user WHERE username = '$username'");`, same error. – John Michael Jul 22 '19 at 07:16
Try changing your table name to `tbl_userss` and leave your code unchanged, and see... – Kagiso Marvin Molekwa Jul 22 '19 at 07:38
changed table name to `tbl_userss` throws a `Table 'inventory_db.tbl_users' doesn't exist` error. Reverted to `tbl_users` table name throws a `Table 'inventory_db.tbl_userss' doesn't exist` error. No changes made on the query. – John Michael Jul 22 '19 at 08:03

0 Answers0