I tried to create a database and link it to config.php and then import bulletin.sql into it , and thats' what I get:
CREATE TABLE `sb_events` (
`ID` INT( 11 ) NOT NULL AUTO_INCREMENT ,
`visible` INT( 11 ) NOT NULL DEFAULT '0',
`event` TEXT NOT NULL ,
`details` TEXT NOT NULL ,
`event_date` DATE NOT NULL DEFAULT '0000-00-00',
`date_added` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
`author` TEXT NOT NULL ,
PRIMARY KEY ( `ID` )
) TYPE = MYISAM AUTO_INCREMENT =0;
MySQL said:
#1064 - 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 'TYPE=MyISAM AUTO_INCREMENT=0' at line 28
Am running it on my local xampp localhost , Windows7 64bit
Regards,,,
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hey guys,
I tried to create a database and link it to config.php and then import bulletin.sql into it , and thats' what I get:
CREATE TABLE `sb_events` (
`ID` INT( 11 ) NOT NULL AUTO_INCREMENT ,
`visible` INT( 11 ) NOT NULL DEFAULT '0',
`event` TEXT NOT NULL ,
`details` TEXT NOT NULL ,
`event_date` DATE NOT NULL DEFAULT '0000-00-00',
`date_added` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
`author` TEXT NOT NULL ,
PRIMARY KEY ( `ID` )
) TYPE = MYISAM AUTO_INCREMENT =0;
MySQL said:
#1064 - 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 'TYPE=MyISAM AUTO_INCREMENT=0' at line 28
Am running it on my local xampp localhost , Windows7 64bit
Regards,,,