#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2001
    Posts
    5
    Rep Power
    0

    Red face


    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 source. search for "referer" i cant figure this out. If anyone could help i would greatly appreciate it.

    # 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?<br>rnAdd the options you like. This box will appear only if yournhas been logged like Admin. No others users can view this.<br>rn<li><a href=admin.php>Administration</a>rn<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<br>nr<br>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.rnAlso you can add HTML commands like <a href=http://phpnuke.org>links</a>, <b>Bold</b> text, images, etc.rnJust 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>rn<li><a href=topics.php>Topics</a>rn<li><a href=sections.php>Sections</a>rn<li><a href=links.php>Web Links</a>rn<li><a href=friend.php>Recommend Us</a>rn<li><a href=memberslist.php>Members List</a>rn<li><a href=user.php>Your Account</a>rn<li><a href=submit.php>Submit News</a>rn<li><a href=stats.php>Stats</a>rn<li><a href=top.php>Top 10</a>rn<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.rnAlso you can add HTML commands like <a href=http://phpnuke.org>links</a>, <b>Bold</b> text, images, etc.rnJust use you imagination.');
    INSERT INTO rblocks VALUES (2,'Information','<center>rnSite made with:<br>rn<a href=http://phpnuke.org><img src=images/powered/phpnuke.gif border=0></a><br>rn');

    #
    # 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'
    #


  2. #2
  3. Ole` Timer
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 2000
    Location
    N.W. Iowa
    Posts
    472
    Rep Power
    17
    Try changing the CREATE TABLE for the referer table to this:

    Code:
    # 
    # Table structure for table 'referer' 
    # 
    CREATE TABLE referer ( 
    rid int(11) NOT NULL auto_increment, 
    url varchar(100) NOT NULL DEFAULT '',
    PRIMARY KEY (rid) 
    );
    Mickalo

    Thunder Rain Internet Publishing

    Custom Programming & Database development
    Providing Personal/Business
    Internet Solutions that work!
  4. #3
  5. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2001
    Posts
    5
    Rep Power
    0

    :( no working.


    i tried it and that doesnt seem to fix it. thanks a lot though, at least it was a shot.

    regards.
  6. #4
  7. Ole` Timer
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 2000
    Location
    N.W. Iowa
    Posts
    472
    Rep Power
    17
    Did you try to just create the referer table?? What type of error did you get?? Make sure the table doesn't already exist or Add above to the CREATE TABLE:

    DROP referer IF EXISTS;

    Mickalo

    Thunder Rain Internet Publishing

    Custom Programming & Database development
    Providing Personal/Business
    Internet Solutions that work!
  8. #5
  9. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2001
    Posts
    5
    Rep Power
    0
    I created the table fine manually. For some reason I don't think the problem has anything to do with that error. The referrer table doesnt exist. Im not to familiar with mysql and this is my last resort. Thanks guys.
  10. #6
  11. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2001
    Posts
    5
    Rep Power
    0
    referer is a table in the database not a seperate file.
  12. #7
  13. No Profile Picture
    Apprentice Deity
    Devshed Loyal (3000 - 3499 posts)

    Join Date
    Jul 1999
    Location
    Niagara Falls (On the wrong side of the gorge)
    Posts
    3,237
    Rep Power
    22
    The problem is not in the create table syntax. Whenever you receive an error, the first character displayed as the source of error (in this case the first # after the last insert of the previous table), is where you need to start looking from but in a BACKWARDS direction.

    There's something wrong with the previous inserts, but I can't see what it might be. I'd suggest removing those two inserts from the schema dump text and try it then. If all goes well, you can do those inserts later.
  14. #8
  15. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2001
    Posts
    5
    Rep Power
    0

    weird stuff


    well i ran each statment by themselves and it is now working. i'm still not sure why the entire file didnt run but running all those by hand wasnt take care guys.

    regards
    -andy.

IMN logo majestic logo threadwatch logo seochat tools logo