Parašė newlifeboy· 2007 Lap. 27 17:11:50
#1
Sveiki . isidejau i web as ta profile.php su ivertinimu poto bandau pradyt ta sql uzklausa
CREATE TABLE `prefix_user_ratings` (
`rated_id` BIGINT( 20 ) NOT NULL AUTO_INCREMENT ,
`rate_user` BIGINT( 20 ) NOT NULL ,
`rate_subject` BIGINT( 20 ) NOT NULL ,
`rate_opt` ENUM( '1', '2', '3', '4', '5', '6', '7', '8', '9', '10' ) NOT NULL ,
`rate_date` BIGINT( 20 ) NOT NULL ,
`rate_ip` VARCHAR( 255 ) NOT NULL ,
PRIMARY KEY (`rated_id`)
) TYPE = innodb;
Ir meta sita err
Error
SQL query:
ErrorSQL query : CREATE TABLE `prefix_user_ratings` (
`rated_id` BIGINT( 20 ) NOT NULL AUTO_INCREMENT ,
`rate_user` BIGINT( 20 ) NOT NULL ,
`rate_subject` BIGINT( 20 ) NOT NULL ,
`rate_opt` ENUM( '1', '2', '3', '4', '5', '6', '7', '8', '9', '10' ) NOT NULL ,
`rate_date` BIGINT( 20 ) NOT NULL ,
`rate_ip` VARCHAR( 255 ) NOT NULL ,
PRIMARY KEY ( `rated_id` )
) TYPE = innodbMySQL said : Documentation
MySQL said: Documentation
#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 'Error
SQL query:
CREATE TABLE `prefix_user_ratings` (
`rated_id` BIGINT( ' at line 1
Kas gali pasakyt ka daryt kad butu viskas ok ? Is anksto dekui ;)
Redagavo newlifeboy· 2007 Lap. 27 17:11:59