Ticket #181 (closed defect: fixed)

Opened 3 years ago

Last modified 2 years ago

dbstruct.sql SQL syntax error

Reported by: anonymous Owned by: mbonetti
Priority: highest Milestone: Gregarius 0.5.1
Component: BUGS Version: 2.0
Severity: normal Keywords:
Cc:

Description

Importing dbstruct.sql using MySQL "Ver 11.18 Distrib 3.23.58" results in the message ERROR 1064 at line 117: You have an error in your SQL syntax near ''tag'' at line 1. This appears to be due to the use of single quotes instead of backticks, e.g. DROP TABLE IF EXISTS 'tag'; instead of DROP TABLE IF EXISTS `tag`;. This problem exists in svn revision 896 for the tables tag, metatag and rating.

Attachments

dbstruct.sql.diff (0 bytes) - added by anonymous 3 years ago.
patch to replace quotes with backticks

Change History

Changed 3 years ago by anonymous

patch to replace quotes with backticks

Changed 3 years ago by anonymous

  • priority changed from normal to highest
  • milestone changed from Gregarius 0.5.2 to Gregarius 0.5.1

Changed 3 years ago by mbonetti

  • status changed from new to closed
  • resolution set to fixed

in [897]. Well spotted, thank you.

Changed 2 years ago by kkkkoaaa

  • version set to 2.0
Note: See TracTickets for help on using tickets.