CodeIgniter Forums
Error 1064 - Printable Version

+- CodeIgniter Forums (
+-- Forum: Archived Discussions (
+--- Forum: Archived General Discussion (
+--- Thread: Error 1064 (/thread-23069.html)

Error 1064 - El Forum - 09-29-2009

Hi all,

can anybody help me to solve these kind of problems? It looks like the MySQL version has sbeen changed, because this used to work without problems. But as I don't see any filename, it's pretty hard. It happens when registering using dx_auth.

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 '0, activation_key, created) VALUES ('meagain', '$1$CMd58YwR$7slZyj5Zb/lU2pBvJaZz' at line 1

INSERT INTO user_temp (username, password, email, last_ip, 0, activation_key, created) VALUES ('meagain', '$1$CMd58YwR$7slZyj5Zb/lU2pBvJaZza.', '[email protected]', '', 'realname', '9e7909934556671b40ebefb2c9f61381', '2009-09-29 16:10:43')

Error 1064 - El Forum - 09-29-2009

I have no experience of dx_auth .. but do you really have a column called '0' ? It seems that that should be the 'real name' column?