PDA

View Full Version : There was an error creating the mySQL database table


mkiely
11-09-2006, 01:46 PM
Here's the comlete message:

> The connection to the mySQL database was successful!
> There was an error creating the mySQL database table.
The error was reported as:
You have an error in your SQL syntax near '`epc_calendar` ( `id` int(7) NOT NULL auto_increment, `startDate` int(11) NO' at line 1

It appears that there is a syntax error in the script. Can you you provide a SQL file with the table install script so that I can fiqure out the problem?

Thanks

Brian
11-09-2006, 03:41 PM
Haven't seen this one before...

What version of PHP is on your server?

FWIW, the SQL command is:

CREATE TABLE `epc_calendar` (
`id` int(7) NOT NULL auto_increment,
`startDate` int(11) NOT NULL default '0',
`endDate` int(11) NOT NULL default '0',
`startTime` time NOT NULL default '00:00:00',
`endTime` time NOT NULL default '00:00:00',
`eventType` text NOT NULL,
`repeatx` int(7) NOT NULL default '0',
`title` text NOT NULL,
`descr` text NOT NULL,
`days` int(7) NOT NULL default '0',
`stop` int(7) NOT NULL default '0',
`month` tinyint(2) NOT NULL default '0',
`weekDay` tinyint(1) NOT NULL default '0',
`weekNumber` tinyint(1) NOT NULL default '0',
`category` text NOT NULL,
`eventKey` text NOT NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=6 ;

If you see the problem, please reply with the issue. :classic:

mkiely
11-10-2006, 05:51 PM
Thanks for the SQL instructions. By removing the single quotes around the field names did the trick.

I'm using MySQL 3.22.32

Marty

Brian
11-10-2006, 06:16 PM
Glad you got it to work. :)