[drupal-devel] [bug] mysql error when installing drupal

clydefrog drupal-devel at drupal.org
Tue Apr 19 05:02:46 UTC 2005

Issue status update for http://drupal.org/node/20824

 Project:      Drupal
 Version:      4.6.0
 Component:    database system
 Category:     bug reports
 Priority:     normal
 Assigned to:  Anonymous
 Reported by:  com4
 Updated by:   clydefrog
 Status:       patch

I have no trouble with mysql server version 4.0.24_Debian-2-log. This
seems to be an early warning before 4.1 becomes popular.


Previous comments:

April 18, 2005 - 19:44 : com4

when installing drupal, i get a wierd error.

com4 at antitech:~/drupal$ /usr/local/mysql/bin/mysql -u jason -p jason <
Enter password:
ERROR 1064 at line 120: 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 'types text NOT NULL
) TYPE=MyISAM' at line 11

com4 at antitech:~/drupal$ /usr/local/mysql/bin/mysql --version
/usr/local/mysql/bin/mysql  Ver 14.3 Distrib 4.1.1-alpha, for
intel-linux (i686)

i noticed that if i changed 'types' to 'type' it wouldn't freak out.
that'll obviously break drupal though, so i'm not quite sure what's
going on.


April 18, 2005 - 19:57 : com4


Note types is on the list.

If you continue reading Martin Francis replies "The way around this is
to place backticks (`name`) around the table name and relevant column

So, I guess the fix would be to change the line from types text NOT
NULL to `types` text NOT NULL on line 130 of database.mysql.

More information about the drupal-devel mailing list