Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

#294 mysql reserved word used for column name

v2.13
closed
RUSSO Bruno
Framework (117)
5
2012-09-17
2005-08-30
Zachary Spath
No

In the table frm_settings there is a column named
"order". Order is a reserved word in mysql. I found
this error when I attempted to restore a backup.

mysqldump --opt -B groupoffice > backup.sql -u root -p

mysql < backup.sql -u root -p

I have no records in this table so I just commented out
the table's create statement.

Why wouldn't this error be caught during the installation?

Zak

Discussion

  • RUSSO Bruno
    RUSSO Bruno
    2005-08-30

    Logged In: YES
    user_id=1200941

    fields have to be escaped like this :
    INSERT INTO frm_settings ( order,...) VALUES ('ASC',...);

    Make sure that the script you made from the non empty
    database does escape the fields name.

    I know having a column named order is not a good choice,
    maybe some kind of bad youngster choice :)

     
  • Logged In: YES
    user_id=1312539

    This Tracker item was closed automatically by the system. It was
    previously set to a Pending status, and the original submitter
    did not respond within 14 days (the time period specified by
    the administrator of this Tracker).