[drupal-devel] [bug] "TYPES" is not a legal field name table "BLOCKS"

[JonBob]

 Project:      Drupal
 Version:      cvs
 Component:    block.module
 Category:     bug reports
 Priority:     critical
 Assigned to:  Anonymous
 Reported by:  Philippe
 Updated by:   JonBob
 Status:       patch

I'm a bit confused by this. The word "types" doesn't show up here:
http://dev.mysql.com/doc/mysql/en/reserved-words.html


JonBob



Previous comments:
------------------------------------------------------------------------

February 5, 2005 - 08:31 : Philippe

There was a "TYPES" field added to the BLOCKS table. MySQL does not like
this; "types" is considered a reserved word. (MySQL-server-4.1.0-0) The
field name needs to be changed to something else.


------------------------------------------------------------------------

February 5, 2005 - 08:37 : Philippe

Attachment: http://drupal.org/files/issues/types.diff (3.51 KB)

here's a patch


------------------------------------------------------------------------

February 9, 2005 - 16:35 : andremolnar

Changing Status to patch.
I guess we didn't catch this - the field wasn't orginally called types.
 Good eye.
andre


------------------------------------------------------------------------

February 9, 2005 - 16:39 : Dries

I suggest we name this field 'nodes'.  Also, we'll need an upgrade path
for those who are running CVS HEAD.


-- 
View: http://drupal.org/node/16817
Edit: http://drupal.org/project/comments/add/16817