mysql unknown error

andyw · Jan 22, 2001

When i run this sql file i get this error. I have been to alot of poles that cant help fix this error. please help.

MySQL said: You have an error in your SQL syntax near '; # # Table structure for table 'referer' # CREATE TABLE referer ( ri' at line 1

here is the file

# MySQL dump 8.8
#
# Host: localhost Database: nuke
#--------------------------------------------------------
# Server version 3.23.23-beta-log

#
# Table structure for table 'adminblock'
#

CREATE TABLE adminblock (
title varchar(60),
content text
);

#
# Dumping data for table 'adminblock'
#

INSERT INTO adminblock VALUES ('Administration','Admins can have its own box, but just one. Who need more? \r\nAdd the options you like. This box will appear only if you\r\nhas been logged like Admin. No others users can view this. \r\n<li><a href=admin.php>Administration</a>\r\n<li><a href=admin.php?op=logout>Logout</a>');

#
# Table structure for table 'authors'
#

CREATE TABLE authors (
aid varchar(30) DEFAULT '' NOT NULL,
name varchar(50),
url varchar(60),
email varchar(60),
pwd varchar(13),
counter int(11) DEFAULT '0' NOT NULL,
radminarticle tinyint(2) DEFAULT '0' NOT NULL,
radmintopic tinyint(2) DEFAULT '0' NOT NULL,
radminleft tinyint(2) DEFAULT '0' NOT NULL,
radminright tinyint(2) DEFAULT '0' NOT NULL,
radminuser tinyint(2) DEFAULT '0' NOT NULL,
radminmain tinyint(2) DEFAULT '0' NOT NULL,
radminsurvey tinyint(2) DEFAULT '0' NOT NULL,
radminsection tinyint(2) DEFAULT '0' NOT NULL,
radminlink tinyint(2) DEFAULT '0' NOT NULL,
radminephem tinyint(2) DEFAULT '0' NOT NULL,
radminfilem tinyint(2) DEFAULT '0' NOT NULL,
radminhead tinyint(2) DEFAULT '0' NOT NULL,
radminsuper tinyint(2) DEFAULT '1' NOT NULL,
PRIMARY KEY (aid)
);

#
# Dumping data for table 'authors'
#

INSERT INTO authors VALUES ('God','God','

http://phpnuke.org','http://phpnuke.org','Password',1,0,0,0,0,0,0,0,0,0,0,0,0,1);

#
# Table structure for table 'autonews'
#

CREATE TABLE autonews (
anid int(11) NOT NULL auto_increment,
aid varchar(30) DEFAULT '' NOT NULL,
title varchar(80) DEFAULT '' NOT NULL,
time varchar(19) DEFAULT '' NOT NULL,
hometext text DEFAULT '' NOT NULL,
bodytext text DEFAULT '' NOT NULL,
topic int(3) DEFAULT '1' NOT NULL,
informant varchar(20) DEFAULT '' NOT NULL,
notes text DEFAULT '' NOT NULL,
PRIMARY KEY (anid)
);

#
# Dumping data for table 'autonews'
#

#
# Table structure for table 'banner'
#

CREATE TABLE banner (
bid int(11) NOT NULL auto_increment,
cid int(11) DEFAULT '0' NOT NULL,
imptotal int(11) DEFAULT '0' NOT NULL,
impmade int(11) DEFAULT '0' NOT NULL,
clicks int(11) DEFAULT '0' NOT NULL,
imageurl varchar(100) DEFAULT '' NOT NULL,
clickurl varchar(200) DEFAULT '' NOT NULL,
date datetime,
PRIMARY KEY (bid)
);

#
# Dumping data for table 'banner'
#

#
# Table structure for table 'bannerclient'
#

CREATE TABLE bannerclient (
cid int(11) NOT NULL auto_increment,
name varchar(60) DEFAULT '' NOT NULL,
contact varchar(60) DEFAULT '' NOT NULL,
email varchar(60) DEFAULT '' NOT NULL,
login varchar(10) DEFAULT '' NOT NULL,
passwd varchar(10) DEFAULT '' NOT NULL,
extrainfo text DEFAULT '' NOT NULL,
PRIMARY KEY (cid)
);

#
# Dumping data for table 'bannerclient'
#

#
# Table structure for table 'bannerfinish'
#

CREATE TABLE bannerfinish (
bid int(11) NOT NULL auto_increment,
cid int(11) DEFAULT '0' NOT NULL,
impressions int(11) DEFAULT '0' NOT NULL,
clicks int(11) DEFAULT '0' NOT NULL,
datestart datetime,
dateend datetime,
PRIMARY KEY (bid)
);

#
# Dumping data for table 'bannerfinish'
#

#
# Table structure for table 'comments'
#

CREATE TABLE comments (
tid int(11) NOT NULL auto_increment,
pid int(11) DEFAULT '0',
sid int(11) DEFAULT '0',
date datetime,
name varchar(60) DEFAULT '' NOT NULL,
email varchar(60),
url varchar(60),
host_name varchar(60),
subject varchar(60) DEFAULT '' NOT NULL,
comment text DEFAULT '' NOT NULL,
score tinyint(4) DEFAULT '0' NOT NULL,
reason tinyint(4) DEFAULT '0' NOT NULL,
PRIMARY KEY (tid)
);

#
# Dumping data for table 'comments'
#

INSERT INTO comments VALUES (1,0,1,'2000-12-04 12:00:00','','','','150.10.10.10','Re: Welcome to PHP-Nuke 4.3','FIRST COMMENT!\r \n\r \nAll my life I wanted to do this

',0,0);

#
# Table structure for table 'counter'
#

CREATE TABLE counter (
type varchar(80) DEFAULT '' NOT NULL,
var varchar(80) DEFAULT '' NOT NULL,
count int(10) unsigned DEFAULT '0' NOT NULL
);

#
# Dumping data for table 'counter'
#

INSERT INTO counter VALUES ('total','hits',1);
INSERT INTO counter VALUES ('browser','WebTV',0);
INSERT INTO counter VALUES ('browser','Lynx',0);
INSERT INTO counter VALUES ('browser','MSIE',0);
INSERT INTO counter VALUES ('browser','Opera',0);
INSERT INTO counter VALUES ('browser','Konqueror',0);
INSERT INTO counter VALUES ('browser','Netscape',1);
INSERT INTO counter VALUES ('browser','Bot',0);
INSERT INTO counter VALUES ('browser','Other',0);
INSERT INTO counter VALUES ('os','Windows',0);
INSERT INTO counter VALUES ('os','Linux',1);
INSERT INTO counter VALUES ('os','Mac',0);
INSERT INTO counter VALUES ('os','FreeBSD',0);
INSERT INTO counter VALUES ('os','SunOS',0);
INSERT INTO counter VALUES ('os','IRIX',0);
INSERT INTO counter VALUES ('os','BeOS',0);
INSERT INTO counter VALUES ('os','OS/2',0);
INSERT INTO counter VALUES ('os','AIX',0);
INSERT INTO counter VALUES ('os','Other',0);

#
# Table structure for table 'ephem'
#

CREATE TABLE ephem (
eid int(11) NOT NULL auto_increment,
did int(2) DEFAULT '0' NOT NULL,
mid int(2) DEFAULT '0' NOT NULL,
yid int(4) DEFAULT '0' NOT NULL,
content text DEFAULT '' NOT NULL,
PRIMARY KEY (eid)
);

#
# Dumping data for table 'ephem'
#

#
# Table structure for table 'headlines'
#

CREATE TABLE headlines (
hid int(11) NOT NULL auto_increment,
sitename varchar(30) DEFAULT '' NOT NULL,
url varchar(100) DEFAULT '' NOT NULL,
headlinesurl varchar(200) DEFAULT '' NOT NULL,
status tinyint(1) DEFAULT '0' NOT NULL,
PRIMARY KEY (hid)
);

#
# Dumping data for table 'headlines'
#

INSERT INTO headlines VALUES (1,'PHP-Nuke','

http://phpnuke.org','http://phpnuke.org/backend.php',0);

INSERT INTO headlines VALUES (2,'LinuxPreview','

http://linuxpreview.org','http://linuxpreview.org/backend.php3',0);

INSERT INTO headlines VALUES (3,'Slashdot','

http://slashdot.org','http://slashdot.org/slashdot.rdf',0);

INSERT INTO headlines VALUES (4,'NewsForge','

http://www.newsforge.com','http://www.newsforge.com/newsforge.rdf',0);

INSERT INTO headlines VALUES (5,'PHPBuilder','

http://phpbuilder.com','http://phpbuilder.com/rss_feed.php',0);

INSERT INTO headlines VALUES (6,'Linux.com','

http://linux.com','http://linux.com/mrn/front_page.rss',0);

INSERT INTO headlines VALUES (7,'Freshmeat','

http://freshmeat.net','http://freshmeat.net/backend/fm.rdf',0);

INSERT INTO headlines VALUES (8,'AppWatch','

http://static.appwatch.com','http://static.appwatch.com/appwatch.rdf',0);

INSERT INTO headlines VALUES (9,'LinuxWeelyNews','

http://lwn.net','http://lwn.net/headlines/rss',0);

INSERT INTO headlines VALUES (10,'HappyPenguin','

http://happypenguin.org','http://happypenguin.org/html/news.rdf',0);

INSERT INTO headlines VALUES (11,'Segfault','

http://segfault.org','http://segfault.org/stories.xml',0);

INSERT INTO headlines VALUES (13,'KDE','

http://www.kde.org','http://www.kde.org/news/kdenews.rdf',0);

INSERT INTO headlines VALUES (14,'Perl.com','

http://www.perl.com','http://www.perl.com/pace/perlnews.rdf',0);

INSERT INTO headlines VALUES (15,'Themes.org','

http://themes.org','http://www.themes.org/news.rdf.phtml',0);

INSERT INTO headlines VALUES (16,'BrunchingShuttlecocks','

http://www.brunching.com','http://www.brunching.com/brunching.rdf',0);

INSERT INTO headlines VALUES (17,'MozillaNewsBot','

http://www.mozilla.org/newsbot/','http://www.mozilla.org/newsbot/newsbot.rdf',0);

INSERT INTO headlines VALUES (18,'NewsTrolls','

http://newstrolls.com','http://newstrolls.com/newstrolls.rdf',0);

INSERT INTO headlines VALUES (19,'FreakTech','

http://sunsite.auc.dk/FreakTech/','http://sunsite.auc.dk/FreakTech/FreakTech.rdf',0);

INSERT INTO headlines VALUES (20,'AbsoluteGames','

http://files.gameaholic.com','http://files.gameaholic.com/agfa.rdf',0);

INSERT INTO headlines VALUES (21,'SciFi-News','

http://www.technopagan.org/sf-news/','http://www.technopagan.org/sf-news/rdf.php',0);

INSERT INTO headlines VALUES (22,'SisterMachineGun','

http://www.smg.org','http://www.smg.org/index/mynetscape.html',0);

INSERT INTO headlines VALUES (23,'LinuxM68k','

http://www.linux-m68k.org','http://www.linux-m68k.org/linux-m68k.rdf',0);

INSERT INTO headlines VALUES (24,'Protest.net','

http://www.protest.net','http://www.protest.net/netcenter_rdf.cgi',0);

INSERT INTO headlines VALUES (25,'HollywoodBitchslap','

http://hollywoodbitchslap.com','http://hollywoodbitchslap.com/hbs.rdf',0);

INSERT INTO headlines VALUES (26,'DrDobbsTechNetCast','

http://www.technetcast.com','http://www.technetcast.com/tnc_headlines.rdf',0);

INSERT INTO headlines VALUES (27,'RivaExtreme','

http://rivaextreme.com','http://rivaextreme.com/ssi/rivaextreme.rdf.cdf',0);

INSERT INTO headlines VALUES (28,'Linuxpower','

http://linuxpower.org','http://linuxpower.org/linuxpower.rdf',0);

INSERT INTO headlines VALUES (29,'PBSOnline','

http://www.pbs.org','http://cgi.pbs.org/cgi-registry/featuresrdf.pl',0);

INSERT INTO headlines VALUES (30,'Listology','

http://www.listology.com','http://listology.com/recent.rdf',0);

INSERT INTO headlines VALUES (31,'Linuxdev.net','

http://linuxdev.net','http://linuxdev.net/archive/news.cdf',0);

INSERT INTO headlines VALUES (32,'LinuxNewbie','

http://www.linuxnewbie.org','http://www.linuxnewbie.org/news.cdf',0);

INSERT INTO headlines VALUES (33,'exoScience','

http://www.exosci.com','http://www.exosci.com/exosci.rdf',0);

INSERT INTO headlines VALUES (34,'Technocrat','

http://www.technocrat.net','http://technocrat.net/rdf',0);

INSERT INTO headlines VALUES (35,'PDABuzz','

http://www.pdabuzz.com','http://www.pdabuzz.com/netscape.txt',0);

INSERT INTO headlines VALUES (36,'MicroUnices','

http://mu.current.nu','http://mu.current.nu/mu.rdf',0);

INSERT INTO headlines VALUES (37,'TheNextLevel','

http://www.the-nextlevel.com','http://www.the-nextlevel.com/rdf/tnl.rdf',0);

INSERT INTO headlines VALUES (38,'Gnotices','

http://news.gnome.org/gnome-news/','http://news.gnome.org/gnome-news/rdf',0);

INSERT INTO headlines VALUES (39,'DailyDaemonNews','

http://daily.daemonnews.org','http://daily.daemonnews.org/ddn.rdf.php3',0);

INSERT INTO headlines VALUES (40,'PerlMonks','

http://www.perlmonks.org','http://www.perlmonks.org/headlines.rdf',0);

INSERT INTO headlines VALUES (41,'PerlNews','

http://news.perl.org','http://news.perl.org/perl-news-short.rdf',0);

INSERT INTO headlines VALUES (42,'BSDToday','

http://www.bsdtoday.com','http://www.bsdtoday.com/backend/bt.rdf',0);

INSERT INTO headlines VALUES (43,'DotKDE','

http://dot.kde.org','http://dot.kde.org/rdf',0);

INSERT INTO headlines VALUES (44,'GeekNik','

http://www.geeknik.net','http://www.geeknik.net/backend/weblog.rdf',0);

INSERT INTO headlines VALUES (45,'HotWired','

http://www.hotwired.com','http://www.hotwired.com/webmonkey/meta/headlines.rdf',0);

INSERT INTO headlines VALUES (46,'JustLinux','

http://www.justlinux.com','http://www.justlinux.com/backend/features.rdf',0);

INSERT INTO headlines VALUES (47,'LAN-Systems','

http://www.lansystems.com','http://www.lansystems.com/backend/gazette_news_backend.rdf',0);

INSERT INTO headlines VALUES (48,'LinuxCentral','

http://linuxcentral.com','http://linuxcentral.com/backend/lcnew.rdf',0);

INSERT INTO headlines VALUES (49,'Linux.nu','

http://www.linux.nu','http://www.linux.nu/backend/lnu.rdf',0);

INSERT INTO headlines VALUES (50,'Lin-x-pert','

http://www.lin-x-pert.com','http://www.lin-x-pert.com/linxpert_apps.rdf',0);

INSERT INTO headlines VALUES (51,'MaximumBSD','

http://www.maximumbsd.com','http://www.maximumbsd.com/backend/weblog.rdf',0);

INSERT INTO headlines VALUES (52,'SolarisCentral','

http://www.SolarisCentral.org','http://www.SolarisCentral.org/news/SolarisCentral.rdf',0);

INSERT INTO headlines VALUES (53,'DigitalTheatre','

http://www.dtheatre.com','http://www.dtheatre.com/backend.php3?xml=yes',0);

#
# Table structure for table 'lblocks'
#

CREATE TABLE lblocks (
id tinyint(4) NOT NULL auto_increment,
title varchar(60),
content text,
PRIMARY KEY (id)
);

#
# Dumping data for table 'lblocks'
#

INSERT INTO lblocks VALUES (1,'First Left Block','You can add/remove/edit blocks for your site with PHP-Nuke.\r\nAlso you can add HTML commands like <a href=

http://phpnuke.org>links</a>,

Bold text, images, etc.\r\nJust use you imagination.');
INSERT INTO lblocks VALUES (2,'Special Sections','What about a <a href=sections.php>Special Sections</a>option in the PHP-Nuke code? A place to publish reviews, special articles, interviews, or whatever, independent of the main news.');

#
# Table structure for table 'links_categories'
#

CREATE TABLE links_categories (
cid int(11) NOT NULL auto_increment,
title varchar(50) DEFAULT '' NOT NULL,
cdescription text DEFAULT '' NOT NULL,
PRIMARY KEY (cid)
);

#
# Dumping data for table 'links_categories'
#

#
# Table structure for table 'links_editorials'
#

CREATE TABLE links_editorials (
linkid int(11) DEFAULT '0' NOT NULL,
adminid varchar(60) DEFAULT '' NOT NULL,
editorialtimestamp datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
editorialtext text DEFAULT '' NOT NULL,
editorialtitle varchar(100) DEFAULT '' NOT NULL,
PRIMARY KEY (linkid)
);

#
# Dumping data for table 'links_editorials'
#

#
# Table structure for table 'links_links'
#

CREATE TABLE links_links (
lid int(11) NOT NULL auto_increment,
cid int(11) DEFAULT '0' NOT NULL,
sid int(11) DEFAULT '0' NOT NULL,
title varchar(100) DEFAULT '' NOT NULL,
url varchar(100) DEFAULT '' NOT NULL,
description text DEFAULT '' NOT NULL,
date datetime,
name varchar(60) DEFAULT '' NOT NULL,
email varchar(60) DEFAULT '' NOT NULL,
hits int(11) DEFAULT '0' NOT NULL,
submitter varchar(60) DEFAULT '' NOT NULL,
linkratingsummary double(6,4) DEFAULT '0.0000' NOT NULL,
totalvotes int(11) DEFAULT '0' NOT NULL,
totalcomments int(11) DEFAULT '0' NOT NULL,
PRIMARY KEY (lid)
);

#
# Dumping data for table 'links_links'
#

#
# Table structure for table 'links_modrequest'
#

CREATE TABLE links_modrequest (
requestid int(11) NOT NULL auto_increment,
lid int(11) DEFAULT '0' NOT NULL,
cid int(11) DEFAULT '0' NOT NULL,
sid int(11) DEFAULT '0' NOT NULL,
title varchar(100) DEFAULT '' NOT NULL,
url varchar(100) DEFAULT '' NOT NULL,
description text DEFAULT '' NOT NULL,
modifysubmitter varchar(60) DEFAULT '' NOT NULL,
brokenlink int(3) DEFAULT '0' NOT NULL,
PRIMARY KEY (requestid),
UNIQUE requestid (requestid)
);

#
# Dumping data for table 'links_modrequest'
#

#
# Table structure for table 'links_newlink'
#

CREATE TABLE links_newlink (
lid int(11) NOT NULL auto_increment,
cid int(11) DEFAULT '0' NOT NULL,
sid int(11) DEFAULT '0' NOT NULL,
title varchar(100) DEFAULT '' NOT NULL,
url varchar(100) DEFAULT '' NOT NULL,
description text DEFAULT '' NOT NULL,
name varchar(60) DEFAULT '' NOT NULL,
email varchar(60) DEFAULT '' NOT NULL,
submitter varchar(60) DEFAULT '' NOT NULL,
PRIMARY KEY (lid)
);

#
# Dumping data for table 'links_newlink'
#

#
# Table structure for table 'links_subcategories'
#

CREATE TABLE links_subcategories (
sid int(11) NOT NULL auto_increment,
cid int(11) DEFAULT '0' NOT NULL,
title varchar(50) DEFAULT '' NOT NULL,
PRIMARY KEY (sid)
);

#
# Dumping data for table 'links_subcategories'
#

#
# Table structure for table 'links_votedata'
#

CREATE TABLE links_votedata (
ratingdbid int(11) NOT NULL auto_increment,
ratinglid int(11) DEFAULT '0' NOT NULL,
ratinguser varchar(60) DEFAULT '' NOT NULL,
rating int(11) DEFAULT '0' NOT NULL,
ratinghostname varchar(60) DEFAULT '' NOT NULL,
ratingcomments text DEFAULT '' NOT NULL,
ratingtimestamp datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
PRIMARY KEY (ratingdbid)
);

#
# Dumping data for table 'links_votedata'
#

#
# Table structure for table 'mainblock'
#

CREATE TABLE mainblock (
title varchar(60),
content text
);

#
# Dumping data for table 'mainblock'
#

INSERT INTO mainblock VALUES ('Main Menu','<li><a href=index.php>Home</a>\r\n<li><a href=topics.php>Topics</a>\r\n<li><a href=sections.php>Sections</a>\r\n<li><a href=links.php>Web Links</a>\r\n<li><a href=friend.php>Recommend Us</a>\r\n<li><a href=memberslist.php>Members List</a>\r\n<li><a href=user.php>Your Account</a>\r\n<li><a href=submit.php>Submit News</a>\r\n<li><a href=stats.php>Stats</a>\r\n<li><a href=top.php>Top 10</a>\r\n<li><a href=faq.php>FAQ</a>');

#
# Table structure for table 'poll_data'
#

CREATE TABLE poll_data (
pollID int(11) DEFAULT '0' NOT NULL,
optionText char(50) DEFAULT '' NOT NULL,
optionCount int(11) DEFAULT '0' NOT NULL,
voteID int(11) DEFAULT '0' NOT NULL
);

#
# Dumping data for table 'poll_data'
#

INSERT INTO poll_data VALUES (1,'Ummmm, not bad',0,1);
INSERT INTO poll_data VALUES (1,'Cool',0,2);
INSERT INTO poll_data VALUES (1,'Terrific',0,3);
INSERT INTO poll_data VALUES (1,'The best one!',0,4);
INSERT INTO poll_data VALUES (1,'what the hell is this?',0,5);
INSERT INTO poll_data VALUES (1,'',0,6);
INSERT INTO poll_data VALUES (1,'',0,7);
INSERT INTO poll_data VALUES (1,'',0,8);
INSERT INTO poll_data VALUES (1,'',0,9);
INSERT INTO poll_data VALUES (1,'',0,10);
INSERT INTO poll_data VALUES (1,'',0,11);
INSERT INTO poll_data VALUES (1,'',0,12);

#
# Table structure for table 'poll_desc'
#

CREATE TABLE poll_desc (
pollID int(11) NOT NULL auto_increment,
pollTitle char(100) DEFAULT '' NOT NULL,
timeStamp int(11) DEFAULT '0' NOT NULL,
voters mediumint(9) DEFAULT '0' NOT NULL,
PRIMARY KEY (pollID)
);

#
# Dumping data for table 'poll_desc'
#

INSERT INTO poll_desc VALUES (1,'What do you think about PHP-Nuke?',961405160,0);

#
# Table structure for table 'pollcomments'
#

CREATE TABLE pollcomments (
tid int(11) NOT NULL auto_increment,
pid int(11) DEFAULT '0',
pollID int(11) DEFAULT '0',
date datetime,
name varchar(60) DEFAULT '' NOT NULL,
email varchar(60),
url varchar(60),
host_name varchar(60),
subject varchar(60) DEFAULT '' NOT NULL,
comment text DEFAULT '' NOT NULL,
score tinyint(4) DEFAULT '0' NOT NULL,
reason tinyint(4) DEFAULT '0' NOT NULL,
PRIMARY KEY (tid)
);

#
# Dumping data for table 'pollcomments'
#

#
# Table structure for table 'queue'
#

CREATE TABLE queue (
qid smallint(5) unsigned NOT NULL auto_increment,
uid mediumint(9) DEFAULT '0' NOT NULL,
uname varchar(40) DEFAULT '' NOT NULL,
subject varchar(100) DEFAULT '' NOT NULL,
story text,
timestamp datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
topic varchar(20) DEFAULT 'Linux' NOT NULL,
PRIMARY KEY (qid)
);

#
# Dumping data for table 'queue'
#

#
# Table structure for table 'quotes'
#

CREATE TABLE quotes (
qid int(10) unsigned NOT NULL auto_increment,
quote text,
PRIMARY KEY (qid)
);

#
# Dumping data for table 'quotes'
#

INSERT INTO quotes VALUES (1,'Nos morituri te salutamus - CBHS');

#
# Table structure for table 'rblocks'
#

CREATE TABLE rblocks (
id tinyint(4) NOT NULL auto_increment,
title varchar(60),
content text,
PRIMARY KEY (id)
);

#
# Dumping data for table 'rblocks'
#

INSERT INTO rblocks VALUES (1,'First Right Block','You can add/remove/edit blocks for your site with PHP-Nuke.\r\nAlso you can add HTML commands like <a href=

http://phpnuke.org>links</a>,

Bold text, images, etc.\r\nJust use you imagination.');
INSERT INTO rblocks VALUES (2,'Information','<center>\r\nSite made with: \r\n<a href=

http://phpnuke.org><img

src=images/powered/phpnuke.gif border=0></a> \r\n');

#
# Table structure for table 'referer'
#

CREATE TABLE referer (
rid int(11) NOT NULL auto_increment,
url varchar(100) DEFAULT '' NOT NULL,
PRIMARY KEY (rid)
);

#
# Dumping data for table 'referer'
#

#
# Table structure for table 'related'
#

CREATE TABLE related (
rid int(11) NOT NULL auto_increment,
tid int(11) DEFAULT '0' NOT NULL,
name varchar(30) DEFAULT '' NOT NULL,
url varchar(200) DEFAULT '' NOT NULL,
PRIMARY KEY (rid)
);

#
# Dumping data for table 'related'
#

#
# Table structure for table 'seccont'
#

CREATE TABLE seccont (
artid int(11) NOT NULL auto_increment,
secid int(11) DEFAULT '0' NOT NULL,
title text DEFAULT '' NOT NULL,
content text DEFAULT '' NOT NULL,
counter int(11) DEFAULT '0' NOT NULL,
PRIMARY KEY (artid)
);

#
# Dumping data for table 'seccont'
#

#
# Table structure for table 'sections'
#

CREATE TABLE sections (
secid int(11) NOT NULL auto_increment,
secname varchar(40) DEFAULT '' NOT NULL,
image varchar(50) DEFAULT '' NOT NULL,
PRIMARY KEY (secid)
);

#
# Dumping data for table 'sections'
#

#
# Table structure for table 'session'
#

CREATE TABLE session (
username varchar(25) DEFAULT '' NOT NULL,
time varchar(14) DEFAULT '' NOT NULL,
host_addr varchar(20) DEFAULT '' NOT NULL,
guest int(1) DEFAULT '0' NOT NULL
);

#
# Dumping data for table 'session'
#

#
# Table structure for table 'stories'
#

CREATE TABLE stories (
sid int(11) NOT NULL auto_increment,
aid varchar(30) DEFAULT '' NOT NULL,
title varchar(80),
time datetime,
hometext text,
bodytext text DEFAULT '' NOT NULL,
comments int(11) DEFAULT '0',
counter mediumint(8) unsigned,
topic int(3) DEFAULT '1' NOT NULL,
informant varchar(20) DEFAULT '' NOT NULL,
notes text DEFAULT '' NOT NULL,
PRIMARY KEY (sid)
);

#
# Dumping data for table 'stories'
#

INSERT INTO stories VALUES (1,'god','Welcome to PHP-Nuke!!!','2000-12-04 12:00:00','This is the first <a href=

http://phpnuke.org>article

in PHP-Nuke</a>. You can delete it. Remember to set/change nickname and/or password for the main admin user. There aren\'t any registered/default user, so maybe you want to set the first one. Pelase read carefully the README file for some details, CREDITS files to see from where comes the things and remember that this is free software under the GPL License (COPYING file for details). Hope you enjoy this software. Please report any bug you find, and you\'ll for sure, so drop me an email when one of this annoying things happens and I\'ll try to fix it for the next releases.','',1,36,10,'god','');

#
# Table structure for table 'topics'
#

CREATE TABLE topics (
topicid int(3) NOT NULL auto_increment,
topicname varchar(20),
topicimage varchar(20),
topictext varchar(40),
counter int(11) DEFAULT '0' NOT NULL,
PRIMARY KEY (topicid)
);

#
# Dumping data for table 'topics'
#

INSERT INTO topics VALUES (1,'linux','linux.gif','Linux',0);
INSERT INTO topics VALUES (2,'amd','amd.gif','AMD',0);
INSERT INTO topics VALUES (3,'aol','aol.jpg','America Online',0);
INSERT INTO topics VALUES (4,'caldera','caldera.gif','Caldera Systems',0);
INSERT INTO topics VALUES (5,'apple','mac.gif','Apple / Mac',0);
INSERT INTO topics VALUES (6,'beos','beos.gif','BeOS',0);
INSERT INTO topics VALUES (7,'compaq','compaq.gif','Compaq',0);
INSERT INTO topics VALUES (8,'corel','corel.gif','Corel',0);
INSERT INTO topics VALUES (9,'debian','debian.gif','Debian',0);
INSERT INTO topics VALUES (10,'phpnuke','phpnuke.gif','PHP-Nuke',0);
INSERT INTO topics VALUES (11,'freebsd','freebsd.gif','FreeBSD',0);
INSERT INTO topics VALUES (12,'gimp','gimp.gif','GIMP',0);
INSERT INTO topics VALUES (13,'gnome','gnome.gif','GNOME',0);
INSERT INTO topics VALUES (14,'gnu','gnu.jpg','GNU / GPL',0);
INSERT INTO topics VALUES (15,'hp','hp.gif','Hewlett Packard',0);
INSERT INTO topics VALUES (16,'ibm','ibm.gif','IBM',0);
INSERT INTO topics VALUES (17,'intel','intel.gif','Intel',0);
INSERT INTO topics VALUES (18,'java','java.gif','Java',0);
INSERT INTO topics VALUES (19,'kde','kde.gif','KDE',0);
INSERT INTO topics VALUES (20,'mandrake','mandrake.gif','Mandrake',0);
INSERT INTO topics VALUES (21,'microsoft','microsoft.gif','Microsoft',0);
INSERT INTO topics VALUES (22,'mozilla','mozilla.gif','Mozilla',0);
INSERT INTO topics VALUES (23,'netscape','netscape.gif','Netscape',0);
INSERT INTO topics VALUES (24,'perl','perl.gif','Perl',0);
INSERT INTO topics VALUES (25,'redhat','redhat.gif','Red Hat',0);
INSERT INTO topics VALUES (26,'sgi','sgi.gif','Silicon Graphics',0);
INSERT INTO topics VALUES (27,'sun','sun.gif','Sun Microsystems',0);
INSERT INTO topics VALUES (28,'suse','suse.gif','SuSE',0);
INSERT INTO topics VALUES (29,'x','x.jpg','X Window',0);

#
# Table structure for table 'users'
#

CREATE TABLE users (
uid int(11) NOT NULL auto_increment,
name varchar(60) DEFAULT '' NOT NULL,
uname varchar(25) DEFAULT '' NOT NULL,
email varchar(60) DEFAULT '' NOT NULL,
femail varchar(60) DEFAULT '' NOT NULL,
url varchar(100) DEFAULT '' NOT NULL,
pass varchar(40) DEFAULT '' NOT NULL,
storynum tinyint(4) DEFAULT '10' NOT NULL,
umode varchar(10) DEFAULT '' NOT NULL,
uorder tinyint(1) DEFAULT '0' NOT NULL,
thold tinyint(1) DEFAULT '0' NOT NULL,
noscore tinyint(1) DEFAULT '0' NOT NULL,
bio tinytext DEFAULT '' NOT NULL,
ublockon tinyint(1) DEFAULT '0' NOT NULL,
ublock tinytext DEFAULT '' NOT NULL,
theme varchar(255) DEFAULT '' NOT NULL,
commentmax int(11) DEFAULT '4096' NOT NULL,
counter int(11) DEFAULT '0' NOT NULL,
PRIMARY KEY (uid)
);

#
# Dumping data for table 'users'
#

hmerrill · Jan 23, 2001

Instead of "When I run this file...", do you mean "When I tried to load this file back into MySQL..."? What statement did you use to "run" the file? Did you use a statment in the form of:

mysql -u user -p database_name < name_of_the_above_file.sql

?
Hardy Merrill
Mission Critical Linux, Inc.

http://www.missioncriticallinux.com

HDwebdev · Jan 23, 2001

It looks like you was trying to load it into mysql with phpmyadmin which tends to choke on stuff like the empty '' that it saw in the nuke file.

I loaded that exact same nuke.sql into mysql without any problems a few days ago by doing it like hmerril said.

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

mysql unknown error

andyw

Programmer

hmerrill

Programmer

HDwebdev

Programmer

Similar threads

Part and Inventory Search

Sponsor