+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived General Discussion (https://forum.codeigniter.com/forumdisplay.php?fid=21)
+--- Thread: Error 1064 (/showthread.php?tid=23069)
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?