CodeIgniter Forums
Error 1064 - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forum-20.html)
+--- Forum: Archived General Discussion (https://forum.codeigniter.com/forum-21.html)
+--- Thread: Error 1064 (/thread-23069.html)



Error 1064 - El Forum - 09-29-2009

[eluser]webnology[/eluser]
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.

Code:
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]', '91.180.23.91', 'realname', '9e7909934556671b40ebefb2c9f61381', '2009-09-29 16:10:43')



Error 1064 - El Forum - 09-29-2009

[eluser]Flemming[/eluser]
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?