Note the upgraded forum! If you are experiencing issues logging in, you may need to reset your password which should send an email. If the email doesn't arrive, be sure to check your spam folder just in case.

Database Error

edited July 2011 in Modules
I'm getting this error when I create a new category through the admin.
Any ideas as to what I could be doing wrong?
A bug, perhaps?


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 'order, section, link) VALUES ('', 'Test', '', 'yes', '', 'News', '') ON DUPLICAT' at line 1

INSERT IGNORE INTO categories (id, name, description, published, order, section, link) VALUES ('', 'Test', '', 'yes', '', 'News', '') ON DUPLICATE KEY UPDATE id = LAST_INSERT_ID(id), name = VALUES(name), description = VALUES(description), published = VALUES(published), order = VALUES(order), section = VALUES(section), link = VALUES(link)

Filename: core/MY_DB_mysql_driver.php

Line Number: 265

Comments

  • edited 12:28AM
    What version of MySQL are you running?
  • edited 12:28AM
    MySQL 5.5.9 running locally via MAMP.
  • edited July 2011
    Is there anything that you can see that may be wrong with this query like perhaps. What happens if you run this query outside of PHP (in phpMyAdmin or other MySQL management app):
    INSERT IGNORE INTO categories (id, name, description, published, order, section, link) VALUES ('', 'Test', '', 'yes', '', 'News', '') ON DUPLICATE KEY UPDATE id = LAST_INSERT_ID(id), name = VALUES(name), description = VALUES(description), published = VALUES(published), order = VALUES(order), section = VALUES(section), link = VALUES(link)
  • edited 12:28AM
    Excellent, thanks.

    I threw that query into SQLpro and got the same error.
    I had someone else come by and put another set of eyes on it, and it was the use of the word 'order', which is a reserved word in SQL, that was causing the problem.

    I changed the name of the column and the query ran fine.

    So, problem solved!
Sign In or Register to comment.