SoloCodigo
Bases de Datos => MySQL => Mensaje iniciado por: NextorJoc en Miércoles 13 de Septiembre de 2006, 04:52
-
Hola, gracias por entrar...
Tengo PHP-Nuke instalado en un servidor de iEspana y cuando quiero importar el archivo sql me tira error....
Este es el archivo....
CREATE TABLE `nuke_downloads_adcomments` (
`comlid` int(11) NOT NULL auto_increment,
`comcid` varchar(255) NOT NULL default '',
`comcid2` varchar(255) NOT NULL default '',
`dcomlid` varchar(255) NOT NULL default '',
`comuser` varchar(255) NOT NULL default '',
`comip` varchar(255) NOT NULL default '',
`comtext` text NOT NULL,
`comtitle` varchar(255) NOT NULL default '',
PRIMARY KEY (`comlid`)
)
CREATE TABLE `nuke_downloads_advotes` (
`numvot` int(11) NOT NULL auto_increment,
`dwlid` varchar(11) NOT NULL default '',
`votip` varchar(255) NOT NULL default '',
`votuser` varchar(255) NOT NULL default '',
`votgeneral` char(2) NOT NULL default '',
`votuso` char(2) NOT NULL default '',
`votinst` char(2) NOT NULL default '',
`votfunc` char(2) NOT NULL default '',
`votapar` char(2) NOT NULL default '',
PRIMARY KEY (`numvot`)
)
CREATE TABLE `nuke_downloads_categories` (
`cid` int(11) NOT NULL auto_increment,
`title` varchar(50) NOT NULL default '',
`cdescription` text NOT NULL,
`cimagen` varchar(200) NOT NULL,
`parentid` int(11) NOT NULL default '0',
PRIMARY KEY (`cid`),
KEY `cid` (`cid`),
KEY `title` (`title`)
)
CREATE TABLE `nuke_downloads_downloads` (
`lid` int(11) NOT NULL auto_increment,
`cid` int(11) NOT NULL default '0',
`sid` int(11) NOT NULL default '0',
`title` varchar(100) NOT NULL default '',
`url` varchar(100) NOT NULL default '',
`url2` varchar(100) NOT NULL,
`url3` varchar(100) NOT NULL,
`description` text NOT NULL,
`date` datetime default NULL,
`name` varchar(100) NOT NULL default '',
`email` varchar(100) NOT NULL default '',
`hits` int(11) NOT NULL default '0',
`submitter` varchar(60) NOT NULL default '',
`filesize` int(11) NOT NULL default '0',
`version` varchar(10) NOT NULL default '',
`homepage` varchar(200) NOT NULL default '',
`imagen` varchar(200) NOT NULL,
`imagen2` varchar(200) NOT NULL,
`imagen3` varchar(200) NOT NULL,
`imagen4` varchar(200) NOT NULL,
`admin_notes` text NOT NULL,
`estado` varchar(2) NOT NULL,
`quien` varchar(255) NOT NULL,
`valoracion` varchar(255) NOT NULL,
`numvotos` varchar(255) NOT NULL,
`comentarios` varchar(255) NOT NULL,
`terms` varchar(255) NOT NULL,
PRIMARY KEY (`lid`),
KEY `lid` (`lid`),
KEY `cid` (`cid`),
KEY `sid` (`sid`),
KEY `title` (`title`)
)
CREATE TABLE `nuke_downloads_editorials` (
`downloadid` int(11) NOT NULL default '0',
`adminid` varchar(60) NOT NULL default '',
`editorialtimestamp` datetime NOT NULL default '0000-00-00 00:00:00',
`editorialtext` text NOT NULL,
`editorialtitle` varchar(100) NOT NULL default '',
PRIMARY KEY (`downloadid`),
KEY `downloadid` (`downloadid`)
)
CREATE TABLE `nuke_downloads_ewconfig` (
`amsg` text NOT NULL,
`vernum` varchar(255) NOT NULL default '',
`nedreg` varchar(255) NOT NULL default '',
`needregadd` varchar(255) NOT NULL default '',
`showblocks` varchar(255) NOT NULL default '',
`adminmenu` varchar(255) NOT NULL default '',
`comport` varchar(255) NOT NULL default '',
`ecopyright` varchar(255) NOT NULL default '',
`secodeimg` varchar(255) NOT NULL default '',
`totopnum` varchar(255) NOT NULL default '',
`mpnum` varchar(255) NOT NULL default '',
`comorder` varchar(255) NOT NULL default '',
`comlimit` varchar(255) NOT NULL default '',
`cominxord` varchar(255) NOT NULL default '',
`comreg` varchar(255) NOT NULL default '',
`colnum` varchar(255) NOT NULL,
`orderbby` varchar(255) NOT NULL,
`TOS` text NOT NULL,
`support` varchar(255) NOT NULL,
PRIMARY KEY (`vernum`)
)
CREATE TABLE `nuke_downloads_featured` (
`fid` int(11) NOT NULL auto_increment,
`dwl` int(11) NOT NULL,
PRIMARY KEY (`fid`)
)
CREATE TABLE `nuke_downloads_modrequest` (
`requestid` int(11) NOT NULL auto_increment,
`lid` int(11) NOT NULL default '0',
`cid` int(11) NOT NULL default '0',
`sid` int(11) NOT NULL default '0',
`title` varchar(100) NOT NULL default '',
`url` varchar(100) NOT NULL default '',
`url2` varchar(100) NOT NULL,
`url3` varchar(100) NOT NULL,
`description` text NOT NULL,
`modifysubmitter` varchar(60) NOT NULL default '',
`brokendownload` int(3) NOT NULL default '0',
`name` varchar(100) NOT NULL default '',
`email` varchar(100) NOT NULL default '',
`filesize` int(11) NOT NULL default '0',
`version` varchar(10) NOT NULL default '',
`homepage` varchar(200) NOT NULL default '',
`imagen` varchar(200) NOT NULL,
`imagen2` varchar(200) NOT NULL,
`imagen3` varchar(200) NOT NULL,
`imagen4` varchar(200) NOT NULL,
PRIMARY KEY (`requestid`),
UNIQUE KEY `requestid` (`requestid`)
)
CREATE TABLE `nuke_downloads_newdownload` (
`lid` int(11) NOT NULL auto_increment,
`cid` int(11) NOT NULL default '0',
`sid` int(11) NOT NULL default '0',
`title` varchar(100) NOT NULL default '',
`url` varchar(100) NOT NULL default '',
`url2` varchar(100) NOT NULL,
`url3` varchar(100) NOT NULL,
`description` text NOT NULL,
`name` varchar(100) NOT NULL default '',
`email` varchar(100) NOT NULL default '',
`submitter` varchar(60) NOT NULL default '',
`filesize` int(11) NOT NULL default '0',
`version` varchar(10) NOT NULL default '',
`homepage` varchar(200) NOT NULL default '',
`imagen` varchar(200) NOT NULL,
`imagen2` varchar(200) NOT NULL,
`imagen3` varchar(200) NOT NULL,
`imagen4` varchar(200) NOT NULL,
PRIMARY KEY (`lid`),
KEY `lid` (`lid`),
KEY `cid` (`cid`),
KEY `sid` (`sid`),
KEY `title` (`title`)
)
Y este es el Error que me tira:
Error
consulta SQL:
CREATE TABLE nuke_downloads_adcomments(
comlid int( 11 ) NOT NULL AUTO_INCREMENT ,
comcid varchar( 255 ) NOT NULL default,
comcid2 varchar( 255 ) NOT NULL default,
dcomlid varchar( 255 ) NOT NULL default,
comuser varchar( 255 ) NOT NULL default,
comip varchar( 255 ) NOT NULL default,
comtext text NOT NULL ,
comtitle varchar( 255 ) NOT NULL default,
PRIMARY KEY ( comlid )
) CREATE TABLE nuke_downloads_advotes(
numvot int( 11 ) NOT NULL AUTO_INCREMENT ,
dwlid varchar( 11 ) NOT NULL default,
votip varchar( 255 ) NOT NULL default,
votuser varchar( 255 ) NOT NULL default,
votgeneral char( 2 ) NOT NULL default,
votuso char( 2 ) NOT NULL default,
votinst char( 2 ) NOT NULL default,
votfunc char( 2 ) NOT NULL default,
votapar char( 2 ) NOT NULL default,
PRIMARY KEY ( numvot )
) CREATE TABLE nuke_downloads_categories(
cid int( 11 ) NOT NULL AUTO_INCREMENT ,
title varchar( 50 ) NOT NULL default,
cdescription text NOT NULL ,
cimagen varchar( 200 ) NOT NULL ,
parentid int( 11 ) NOT NULL default '0',
PRIMARY KEY ( cid ) ,
KEY cid( cid ) ,
KEY title( title )
) CREATE TABLE nuke_downloads_downloads(
lid int( 11 ) NOT NULL AUTO_INCREMENT ,
cid int( 11 ) NOT NULL default '0',
sid int( 11 ) NOT NULL default '0',
title varchar( 100 ) NOT NULL default,
url varchar( 100 ) NOT NULL default,
url2 varchar( 100 ) NOT NULL ,
url3 varchar( 100 ) NOT NULL ,
description text NOT NULL ,
date datetime default NULL ,
name varchar( 100 ) NOT NULL default,
email varchar( 100 ) NOT NULL default,
hits int( 11 ) NOT NULL default '0',
submitter varchar( 60 ) NOT NULL default,
filesize int( 11 ) NOT NULL default '0',
version varchar( 10 ) NOT NULL default,
homepage varchar( 200 ) NOT NULL default,
imagen varchar( 200 ) NOT NULL ,
imagen2 varchar( 200 ) NOT NULL ,
imagen3 varchar( 200 ) NOT NULL ,
imagen4 varchar( 200 ) NOT NULL ,
admin_notes text NOT NULL ,
estado varchar( 2 ) NOT NULL ,
quien varchar( 255 ) NOT NULL ,
valoracion varchar( 255 ) NOT NULL ,
numvotos varchar( 255 ) NOT NULL ,
comentarios varchar( 255 ) NOT NULL ,
terms varchar( 255 ) NOT NULL ,
PRIMARY KEY ( lid ) ,
KEY lid( lid ) ,
KEY cid( cid ) ,
KEY sid( sid ) ,
KEY title( title )
) CREATE TABLE nuke_downloads_editorials(
downloadid int( 11 ) NOT NULL default '0',
adminid varchar( 60 ) NOT NULL default,
editorialtimestamp datetime NOT NULL default '0000-00-00 00:00:00',
editorialtext text NOT NULL ,
editorialtitle varchar( 100 ) NOT NULL default,
PRIMARY KEY ( downloadid ) ,
KEY downloadid( downloadid )
) CREATE TABLE nuke_downloads_ewconfig(
X amsg text NOT NULL , (aca me pone una X en rojo)
vernum varchar( 255 ) NOT NULL default,
nedreg varchar( 255 ) NOT NULL default,
needregadd varchar( 255 ) NOT NULL default,
showblocks varchar( 255 ) NOT NULL default,
adminmenu varchar( 255 ) NOT NULL default,
comport varchar( 255 ) NOT NULL default,
ecopyright varchar( 255 ) NOT NULL default,
secodeimg varchar( 255 ) NOT NULL default,
totopnum varchar( 255 ) NOT NULL default,
mpnum varchar( 255 ) NOT NULL default,
comorder varchar( 255 ) NOT NULL default,
comlimit varchar( 255 ) NOT NULL default,
cominxord varchar( 255 ) NOT NULL default,
comreg varchar( 255 ) NOT NULL default,
colnum varchar( 255 ) NOT NULL ,
orderbby varchar( 255 ) NOT NULL ,
TOS text NOT NULL ,
support varchar( 255 ) NOT NULL ,
PRIMARY KEY ( vernum )
) CREATE TABLE nuke_downloads_featured(
fid int( 11 ) NOT NULL AUTO_INCREMENT ,
dwl int( 11 ) NOT NULL ,
PRIMARY KEY ( fid )
) CREATE TABLE nuke_downloads_modrequest(
requestid int( 11 ) NOT NULL AUTO_INCREMENT ,
lid int( 11 ) NOT NULL default '0',
cid int( 11 ) NOT NULL default '0',
sid int( 11 ) NOT NULL default '0',
title varchar( 100 ) NOT NULL default,
url varchar( 100 ) NOT NULL default,
url2 varchar( 100 ) NOT NULL ,
url3 varchar( 100 ) NOT NULL ,
description text NOT NULL ,
modifysubmitter varchar( 60 ) NOT NULL default,
brokendownload int( 3 ) NOT NULL default '0',
name varchar( 100 ) NOT NULL default,
email varchar( 100 ) NOT NULL default,
filesize int( 11 ) NOT NULL default '0',
version varchar( 10 ) NOT NULL default,
homepage varchar( 200 ) NOT NULL default,
imagen varchar( 200 ) NOT NULL ,
imagen2 varchar( 200 ) NOT NULL ,
imagen3 varchar( 200 ) NOT NULL ,
imagen4 varchar( 200 ) NOT NULL ,
PRIMARY KEY ( requestid ) ,
UNIQUE KEY requestid( requestid )
) CREATE TABLE nuke_downloads_newdownload(
lid int( 11 ) NOT NULL AUTO_INCREMENT ,
cid int( 11 ) NOT NULL default '0',
sid int( 11 ) NOT NULL default '0',
title varchar( 100 ) NOT NULL default,
url varchar( 100 ) NOT NULL default,
url2 varchar( 100 ) NOT NULL ,
url3 varchar( 100 ) NOT NULL ,
description text NOT NULL ,
name varchar( 100 ) NOT NULL default,
email varchar( 100 ) NOT NULL default,
submitter varchar( 60 ) NOT NULL default,
filesize int( 11 ) NOT NULL default '0',
version varchar( 10 ) NOT NULL default,
homepage varchar( 200 ) NOT NULL default,
imagen varchar( 200 ) NOT NULL ,
imagen2 varchar( 200 ) NOT NULL ,
imagen3 varchar( 200 ) NOT NULL ,
imagen4 varchar( 200 ) NOT NULL ,
PRIMARY KEY ( lid ) ,
KEY lid( lid ) ,
KEY cid( cid ) ,
KEY sid( sid ) ,
KEY title( title )
)
Pero lo probe en mi PC con el MySql y ando bien no me tiro ningun error...
Espero me puedan ayudar desde ya muchas gracias.
-
aparentemente te falta terminar los statement con ;
<!--sql--></div><table border='0' align='center' width='95%' cellpadding='3' cellspacing='1'><tr><td>SQL </td></tr><tr><td id='CODE'><!--sql1-->CREATE TABLE `nuke_downloads_adcomments` (
`comlid` int(11) NOT NULL auto_increment,
`comcid` varchar(255) NOT NULL default '',
`comcid2` varchar(255) NOT NULL default '',
`dcomlid` varchar(255) NOT NULL default '',
`comuser` varchar(255) NOT NULL default '',
`comip` varchar(255) NOT NULL default '',
`comtext` text NOT NULL,
`comtitle` varchar(255) NOT NULL default '',
PRIMARY KEY (`comlid`)
); <!--sql2--></td></tr></table><div class='postcolor'><!--sql3-->