SQL错误 - CodeIgniter登录错误

Question

I'm trying to create a login function while learning CodeIgniter. I've validated that both the username and password are correct. The passwords are encrypted using Phppass codeigniter password library.

This is the error I get after I login with the correct information.

A Database Error Occurred

Error Number: 1064

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near

'(`session_id`, `ip_address`, `user_agent`, `last_activity`)
 VALUES ('826f937fed9' at line 1

 INSERT INTO (`session_id`, `ip_address`, `user_agent`,
 `last_activity`) VALUES ('826f937fed9185e2c121ec06b1b44b6a', '::1',
 'Mozilla/5.0 (Windows NT 6.3; WOW64) AppleWebKit/53', 1442454002)

Filename: libraries/Session.php

Line Number: 327

Answer 1

As Jarred Farrish and Darack on the PHP chatrooms pointed out the error was right in front of me! I had forgotten to add my CodeIgniter database tbl name to the config! Well, not exactly. I thought I followed the instructions from the CodeIgniter config correctly but apparently not! As the documentation differs slightly, you must in fact ADD

$config['sess_table_name'] = 'ci_sessions';

To your config.php file. Once that has been added CodeIgniter will correctly store user data in that table name provided.