CREATE TABLE/s fails 1064 errors

CREATE TABLE/s fails 1064 errors

by Dennis Wier -
Number of replies: 0
When installing moodle 1.4.3 and using php 4.3.10
I get the following error:

(mysql): CREATE TABLE `mdl_config` ( `id` int(10) unsigned NOT NULL auto_increment, `name` varchar(255) NOT NULL default '', `value` text NOT NULL default '', PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`)) TYPE=MyISAM COMMENT='Moodle configuration variables'  
1064: You have an error in your SQL syntax near '`mdl_config` ( `id` int(10) unsigned NOT NULL auto_increment, `name` varchar(2' at line 1

Error

Near as I can make out, phpadmin converts two single quotes to a single double quote, producing the syntax error, probably.

I notice a hack in setup.php.  Is it relevant to add another for default?
or is the hack to be someplace else?  I did notice in some other code some fiddling with the $default variable, but NOT if it is empty!  Maybe something could be added there?


Average of ratings: -