menababu
07-15-2007, 11:31 AM
hello when i am trying to install any new product threw product manager i keep getting database error .any help will great
thanks
i am getting error like this
Database error in vBulletin 3.6.7:
Invalid SQL:
CREATE TABLE `radiostation` (
`stationid` INT( 10 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`name` VARCHAR( 150 ) NOT NULL ,
`url` VARCHAR( 150 ) NOT NULL ,
`addedby` INT( 10 ) NOT NULL ,
`dateadded` INT( 10 ) NOT NULL ,
`played` INT( 10 ) NOT NULL DEFAULT '0',
`description` TEXT NULL ,
`categoryid` INT( 10 ) NOT NULL DEFAULT '0'
) ENGINE = MYISAM ;;
MySQL Error : 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 'ENGINE = MYISAM' at line 10
Error Number : 1064
Date : Sunday, July 15th 2007 @ 05:20:10 AM
Script : http://desiimax.com/forums/admincp/plugin.php?do=productimport
Referrer : http://desiimax.com/forums/admincp/plugin.php?do=productadd
IP Address : 23.0.212.38
Username :mac23
Classname : vb_database
thanks
i am getting error like this
Database error in vBulletin 3.6.7:
Invalid SQL:
CREATE TABLE `radiostation` (
`stationid` INT( 10 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`name` VARCHAR( 150 ) NOT NULL ,
`url` VARCHAR( 150 ) NOT NULL ,
`addedby` INT( 10 ) NOT NULL ,
`dateadded` INT( 10 ) NOT NULL ,
`played` INT( 10 ) NOT NULL DEFAULT '0',
`description` TEXT NULL ,
`categoryid` INT( 10 ) NOT NULL DEFAULT '0'
) ENGINE = MYISAM ;;
MySQL Error : 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 'ENGINE = MYISAM' at line 10
Error Number : 1064
Date : Sunday, July 15th 2007 @ 05:20:10 AM
Script : http://desiimax.com/forums/admincp/plugin.php?do=productimport
Referrer : http://desiimax.com/forums/admincp/plugin.php?do=productadd
IP Address : 23.0.212.38
Username :mac23
Classname : vb_database