Ver Mensaje Individual
  #1 (permalink)  
Antiguo 15/01/2010, 22:26
zxcvbn
 
Fecha de Ingreso: febrero-2008
Mensajes: 24
Antigüedad: 16 años, 1 mes
Puntos: 0
#1064 - You have an error in your SQL syntax...

Pueden ustedes decirme porfavor que debo de hacer para que me deje enviar las 2 tablas de vBulletin?

ERROR 1:
Error

consulta SQL:

CREATE TABLE IF NOT EXISTS `tag` (
`tagid` int( 10 ) unsigned NOT NULL auto_increment,
`tagtext` varchar( 100 ) COLLATE utf8_spanish_ci NOT NULL default '',
`dateline` int( 10 ) unsigned NOT NULL default '0',
PRIMARY KEY ( `tagid` ) ,
UNIQUE KEY `tagtext` ( `tagtext` )
) ENGINE = MYISAM DEFAULT CHARSET = utf8 COLLATE = utf8_spanish_ci AUTO_INCREMENT =1

MySQL ha dicho: Documentación
#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 'auto_increm
ent, `tagtext` varchar(100) collate utf8_spanish_ci NOT NULL defaul' at line 2


ERROR 2:
Error

consulta SQL:

CREATE TABLE IF NOT EXISTS `tachyforumpost` (
`userid` int( 10 ) unsigned NOT NULL default '0',
`forumid` int( 10 ) unsigned NOT NULL default '0',
`lastpost` int( 10 ) unsigned NOT NULL default '0',
`lastposter` varchar( 100 ) COLLATE utf8_spanish_ci NOT NULL default '',
`lastpostid` int( 10 ) unsigned NOT NULL default '0',
`lastthread` varchar( 250 ) COLLATE utf8_spanish_ci NOT NULL default '',
`lastthreadid` int( 10 ) unsigned NOT NULL default '0',
`lasticonid` smallint( 5 ) unsigned NOT NULL default '0',
`lastprefixid` varchar( 25 ) COLLATE utf8_spanish_ci NOT NULL default '',
PRIMARY KEY ( `userid` , `forumid` ) ,
KEY `forumid` ( `forumid` )
) ENGINE = MYISAM DEFAULT CHARSET = utf8 COLLATE = utf8_spanish_ci

MySQL ha dicho: Documentación
#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 'N
ULL default '',
`lastpostid` int(10) unsigned NOT NULL default '0',
`la' at line 5