bugruQueue - Bugs: bug #19323, Use of a MySQL reserved word in...

 
 

bug #19323: Use of a MySQL reserved word in the default database shema

Submitter:  None
Submitted:  Fri 16 Mar 2007 11:52:51 AM UTC
   
 
Category:  None Severity:  3 - Normal
Item Group:  None Status:  None
Privacy:  Public Assigned to:  None
Open/Closed:  Open
* Mandatory Fields

Add a New Comment Rich Markup
   

Tue 09 Oct 2007 06:27:44 PM UTC, comment #1: 

The problem is on line 378 of ruqueue.sql (as of ruqueue 1.2.2) - it's not action but "condition" which is a MySQL reserved word. It would be preferable to change this field name in the next major release, as it is probably bad style.

However, quoting the word with back-quotes in the .sql file will allow use of the word.

Jason Antman <jantman>
Fri 16 Mar 2007 11:52:51 AM UTC, original submission:  

On the version 5.0.26-12 of MySQL "ACTION" is apparently a reserved word

so the following table creation did not work :

CREATE TABLE script(
id int( 10 ) NOT NULL AUTO_INCREMENT ,
queue varchar( 80 ) default NULL ,
condition varchar( 80 ) default NULL ,
ACTION varchar( 200 ) default NULL ,
template varchar( 200 ) default NULL ,
PRIMARY KEY ( id )
) TYPE = MYISAM ;

Anonymous

 

(Note: upload size limit is set to 16384 kB, after insertion of the required escape characters.)

Attach Files:
   
   
Comment:
   

No files currently attached

 

Depends on the following items: None found

Items that depend on this one: None found

 

Carbon-Copy List
  • -email is unavailable- added by jantman (Posted a comment)
  •  

    There are 0 votes so far. Votes easily highlight which items people would like to see resolved in priority, independently of the priority of the item set by tracker managers.

    Only logged-in users can vote.

     

    No changes have been made to this item

    Back to the top

    Powered by Savane 3.13-02a9.
    Corresponding source code