Nethox Posted September 25, 2011 Share Posted September 25, 2011 Hey guys. I keep getting this error and I can't find what's wrong with the SQL syntax. I do know that you're not supposed to put single quotes around integers but I don't think it's what's causing the issue. I made a script that echoes the SQL syntax when there's an error for debugging : Database query failed: 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 'mod) VALUES ('', 'nethox2', '89671260714cbd0eff69a9b6e0ae4c45b2efd67a', 'max', '' at line 1 Last SQL query: INSERT INTO users (id, username, hashed_password, first_name, last_name, admin, mod) VALUES ('', 'nethox2', '89671260714cbd0eff69a9b6e0ae4c45b2efd67a', 'max', 'lab', '1', '0') Quote Link to comment https://forums.phpfreaks.com/topic/247838-cant-find-whats-wrong-with-this-sql-syntax/ Share on other sites More sharing options...
Pikachu2000 Posted September 25, 2011 Share Posted September 25, 2011 MOD is a MySQL reserved word. Quote Link to comment https://forums.phpfreaks.com/topic/247838-cant-find-whats-wrong-with-this-sql-syntax/#findComment-1272631 Share on other sites More sharing options...
Nethox Posted September 25, 2011 Author Share Posted September 25, 2011 ROFL, would never have guessed that... Thanks alot you saved me alot of time! Quote Link to comment https://forums.phpfreaks.com/topic/247838-cant-find-whats-wrong-with-this-sql-syntax/#findComment-1272632 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.