Database table nuke_config error

Nuke Cadet Joined: Feb 08, 2003 Posts: 1 Location: USA

Hello

I am getting some errors because I cannot seem to insert the table nuke_config

I copy and pasted from the nuke.sql file the insert code for the nuke_config table. Here is the insert code:

INSERT INTO nuke_config VALUES ('PHP-Nuke Powered Site','http://yoursite.com','logo.gif','Your slogan here','September 2002','webmaster@yoursite.com',0,'DeepBlue','<a href=\'http://phpnuke.org\' target=\'blank\'><img src=\'images/powered/nuke.gif\' border=\'0\' Alt=\'Web site powered by PHP-Nuke\' hspace=\'10\'></a> ','All logos and trademarks in this site are property of their respective owner. The comments are property of their posters, all the rest © 2002 by me','You can syndicate our news using the file <a href=\'backend.php\'>backend.php</a> or <a href=\'ultramode.txt\'>ultramode.txt</a>',4096,'Anonymous',5,1,1,1,1,10,10,1,30,0,1,'PHP-Nuke Powered Site','en-us','english','en_US',0,0,0,'me@yoursite.com','NEWS for my site','Hey! You got a new submission for your site.','webmaster','Mail sent from WebMail service at PHP-Nuke Powered Site\r\n- http://yoursite.com',1,'/var/www/html/modules/WebMail/tmp/',0,0,'modules/WebMail/attachments/','','0','Your account',-1,'modules/WebMail/images',1,0,1,1,1000,3,'*****','Web site engine\'s code is Copyright © 2002 by <a href=\"http://phpnuke.org\">PHP-Nuke</a>. All Rights Reserved. PHP-Nuke is Free Software released under the <a href=\"http://www.gnu.org\">GNU/GPL license</a>.','6.0')

When I ran this sql statement I got this error:

You have an error in your SQL syntax near '0,0,1,'PHP-Nuke Powered Site','en-us','english','en_US',0,0,0,'me@yoursite.com' at line 2

I cannot seem to figure out where in the SQL statement above the error is occuring.

THIS IS MY ONLY ISSUE...PLEASE HELP!

Thanks,

bigashish

Joined: Jan 31, 2004 Posts: -88

if there are lines beginning with a - replace them with a #

ArtificialIntel

Posted: Sat Feb 08, 2003 8:12 pm

copy the following code into a file, name it fixnuke.php, upload it to where config.php is and point your browser to it, much like you did with analyzer.php, once done, delete it.

Code:

<?php

#####################################################
#####################################################

require("config.php");

$host = $dbhost;
$database = $dbname;
$username = $dbuname;
$password = $dbpass;
mysql_connect($host, $username, $password);
@mysql_select_db($database);

# Just upload this file to nuke's main dir (where config.php is)
# and point your browser to
# http://your_nuke_url/fixnuke.php
#
################### BEGIN THE FIX ###################

mysql_query("DROP TABLE IF EXISTS ".$prefix."_config");
mysql_query("CREATE TABLE ".$prefix."_config (
sitename varchar(255) NOT NULL default '',
nukeurl varchar(255) NOT NULL default '',
site_logo varchar(255) NOT NULL default '',
slogan varchar(255) NOT NULL default '',
startdate varchar(50) NOT NULL default '',
adminmail varchar(255) NOT NULL default '',
anonpost tinyint(1) NOT NULL default '0',
Default_Theme varchar(255) NOT NULL default '',
foot1 text NOT NULL,
foot2 text NOT NULL,
foot3 text NOT NULL,
commentlimit int(9) NOT NULL default '4096',
anonymous varchar(255) NOT NULL default '',
minpass tinyint(1) NOT NULL default '5',
pollcomm tinyint(1) NOT NULL default '1',
articlecomm tinyint(1) NOT NULL default '1',
broadcast_msg tinyint(1) NOT NULL default '1',
my_headlines tinyint(1) NOT NULL default '1',
top int(3) NOT NULL default '10',
storyhome int(2) NOT NULL default '10',
user_news tinyint(1) NOT NULL default '1',
oldnum int(2) NOT NULL default '30',
ultramode tinyint(1) NOT NULL default '0',
banners tinyint(1) NOT NULL default '1',
backend_title varchar(255) NOT NULL default '',
backend_language varchar(10) NOT NULL default '',
language varchar(100) NOT NULL default '',
locale varchar(10) NOT NULL default '',
multilingual tinyint(1) NOT NULL default '0',
useflags tinyint(1) NOT NULL default '0',
notify tinyint(1) NOT NULL default '0',
notify_email varchar(255) NOT NULL default '',
notify_subject varchar(255) NOT NULL default '',
notify_message varchar(255) NOT NULL default '',
notify_from varchar(255) NOT NULL default '',
footermsgtxt text NOT NULL,
email_send tinyint(1) NOT NULL default '1',
attachmentdir varchar(255) NOT NULL default '',
attachments tinyint(1) NOT NULL default '0',
attachments_view tinyint(1) NOT NULL default '0',
download_dir varchar(255) NOT NULL default '',
defaultpopserver varchar(255) NOT NULL default '',
singleaccount tinyint(1) NOT NULL default '',
singleaccountname varchar(255) NOT NULL default '',
numaccounts tinyint(2) NOT NULL default '-1',
imgpath varchar(255) NOT NULL default '',
filter_forward tinyint(1) NOT NULL default '1',
moderate tinyint(1) NOT NULL default '0',
admingraphic tinyint(1) NOT NULL default '1',
httpref tinyint(1) NOT NULL default '1',
httprefmax int(5) NOT NULL default '1000',
CensorMode tinyint(1) NOT NULL default '3',
CensorReplace varchar(10) NOT NULL default '',
copyright text NOT NULL,
Version_Num varchar(10) NOT NULL default ''
) TYPE=MyISAM");

mysql_query("INSERT INTO ".$prefix."_config VALUES ('PHP-Nuke Powered Site','http://yoursite.com','logo.gif','Your slogan here','February 2003','webmaster@yoursite.com',0,'DeepBlue','<a href=\"http://phpnuke.org\" target=\"blank\"><img src=\"images/powered/nuke.gif\" border=\"0\" Alt=\"Web site powered by PHP-Nuke\" hspace=\"10\"></a> ','All logos and trademarks in this site are property of their respective owner. The comments are property of their posters, all the rest © 2003 by me','You can syndicate our news using the file <a href=\"backend.php\">backend.php</a> or <a href=\"ultramode.txt\">ultramode.txt</a>',4096,'Anonymous',5,1,1,1,1,10,10,1,30,0,1,'PHP-Nuke Powered Site','en-us','english','en_US',0,0,0,'me@yoursite.com','NEWS for my site','Hey! You got a new submission for your site.','webmaster','Mail sent from WebMail service at PHP-Nuke Powered Site\r\n- http://yoursite.com',1,'/var/www/html/modules/WebMail/tmp/',0,0,'modules/WebMail/attachments/','','0','Your account',-1,'modules/WebMail/images',1,0,1,1,1000,3,'*****','Web site engine code is Copyright © 2003 by <a href=\"http://phpnuke.org\">PHP-Nuke</a>. All Rights Reserved. PHP-Nuke is Free Software released under the <a href=\"http://www.gnu.org\">GNU/GPL license</a>.','6.0')");
echo "Go back to your <a href=\"index.php\">website</a>.";
?>