Tarih: 2006-03-05, 15:41:28 Mesaj konusu: SQL HATA
arkadaslar SQL i dump edemiyorum hata veriyor nasil giderebilirim
Server: localhost Datenbank: lovee
Fehler
Es scheint einen Fehler in Ihrer MySQL-Abfrage zu geben. Die MySQL-Fehlerausgabe, falls vorhanden, kann Ihnen auch bei der Fehleranalyse helfen.
ERROR: Unbekannte Interpunktion @ 10838
STR: ://
SQL: #
# Volcar la base de datos para la tabla `nuke_comments`
#
#
# Estructura de tabla para la tabla `nuke_config`
#
CREATE TABLE nuke_config (
sitename varchar(255) NOT NULL default '',
nukeurl varchar(255) NOT NULL defaultThis is free software, and you may redistribute it under the <a href="http://phpnuke.org/files/gpl.txt"><font class="footmsg_l">GPL</font></a>. PHP-Nuke comes with absolutely no warranty, for details, see the <a href="http://phpnuke.org/files/gpl.txt"><font class="footmsg_l">license</font></a>.', '7.6');
#
# Estructura de tabla para la tabla `nuke_counter`
#
CREATE TABLE nuke_counter (
type varchar(80) NOT NULL default '',
var varchar(80) NOT NULL default '',
count int(10) unsigned NOT NULL default '0'
) TYPE=MyISAM;
#
# Volcar la base de datos para la tabla `nuke_counter`
#
INSERT INTO nuke_counter VALUES ('total', 'hits', 1);
INSERT INTO nuke_counter VALUES ('browser', 'WebTV', 0);
INSERT INTO nuke_counter VALUES ('browser', 'Lynx', 0);
INSERT INTO nuke_counter VALUES ('browser', 'MSIE', 0);
INSERT INTO nuke_counter VALUES ('browser', 'Opera', 0);
INSERT INTO nuke_counter VALUES ('browser', 'Konqueror', 0);
INSERT INTO nuke_counter VALUES ('browser', 'Netscape', 1);
INSERT INTO nuke_counter VALUES ('browser', 'FireFox', 0);
INSERT INTO nuke_counter VALUES ('browser', 'Bot', 0);
INSERT INTO nuke_counter VALUES ('browser', 'Other', 0);
INSERT INTO nuke_counter VALUES ('os', 'Windows', 0);
INSERT INTO nuke_counter VALUES ('os', 'Linux', 1);
INSERT INTO nuke_counter VALUES ('os', 'Mac', 0);
INSERT INTO nuke_counter VALUES ('os', 'FreeBSD', 0);
INSERT INTO nuke_counter VALUES ('os', 'SunOS', 0);
INSERT INTO nuke_counter VALUES ('os', 'IRIX', 0);
INSERT INTO nuke_counter VALUES ('os', 'BeOS', 0);
INSERT INTO nuke_counter VALUES ('os', 'OS/2', 0);
INSERT INTO nuke_counter VALUES ('os', 'AIX', 0);
INSERT INTO nuke_counter VALUES ('os', 'Other', 0);
# --------------------------------------------------------
#
# Estructura de tabla para la tabla `nuke_downloads_categories`
#
CREATE TABLE nuke_downloads_categories (
cid int(11) NOT NULL auto_increment,
title varchar(50) NOT NULL default '',
cdescription text NOT NULL,
parentid int(11) NOT NULL default '0',
PRIMARY KEY (cid),
KEY cid (cid),
KEY title (title)
) TYPE=MyISAM;
#
# Volcar la base de datos para la tabla `nuke_downloads_categories`
#
#
# Estructura de tabla para la tabla `nuke_downloads_downloads`
#
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 '',
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 '',
downloadratingsummary double(6,4) NOT NULL default '0.0000',
totalvotes int(11) NOT NULL default '0',
totalcomments int(11) NOT NULL default '0',
filesize int(11) NOT NULL default '0',
version varchar(10) NOT NULL default '',
homepage varchar(200) NOT NULL default '',
PRIMARY KEY (lid),
KEY lid (lid),
KEY cid (cid),
KEY sid (sid),
KEY title (title)
) TYPE=MyISAM;
#
# Volcar la base de datos para la tabla `nuke_downloads_downloads`
#
#
# Estructura de tabla para la tabla `nuke_downloads_modrequest`
#
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 '',
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 '',
PRIMARY KEY (requestid),
UNIQUE KEY requestid (requestid)
) TYPE=MyISAM;
#
# Volcar la base de datos para la tabla `nuke_downloads_modrequest`
#
#
# Estructura de tabla para la tabla `nuke_downloads_newdownload`
#
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 '',
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 '',
PRIMARY KEY (lid),
KEY lid (lid),
KEY cid (cid),
KEY sid (sid),
KEY title (title)
) TYPE=MyISAM;
#
# Volcar la base de datos para la tabla `nuke_downloads_newdownload`
#
#
# Estructura de tabla para la tabla `nuke_encyclopedia`
#
CREATE TABLE nuke_encyclopedia (
eid int(10) NOT NULL auto_increment,
title varchar(255) NOT NULL default '',
description text NOT NULL,
elanguage varchar(30) NOT NULL default '',
active int(1) NOT NULL default '0',
PRIMARY KEY (eid),
KEY eid (eid)
) TYPE=MyISAM;
#
# Volcar la base de datos para la tabla `nuke_encyclopedia`
#
#
# Estructura de tabla para la tabla `nuke_encyclopedia_text`
#
CREATE TABLE nuke_encyclopedia_text (
tid int(10) NOT NULL auto_increment,
eid int(10) NOT NULL default '0',
title varchar(255) NOT NULL default '',
text text NOT NULL,
counter int(10) NOT NULL default '0',
PRIMARY KEY (tid),
KEY tid (tid),
KEY eid (eid),
KEY title (title)
) TYPE=MyISAM;
#
# Volcar la base de datos para la tabla `nuke_encyclopedia_text`
#
#
# Estructura de tabla para la tabla `nuke_groups`
#
CREATE TABLE nuke_groups (
id int(10) NOT NULL auto_increment,
name varchar(255) NOT NULL default '',
description text NOT NULL,
points int(10) NOT NULL default '0',
KEY id (id)
) TYPE=MyISAM;
#
# Volcar la base de datos para la tabla `nuke_groups`
#
#
# Estructura de tabla para la tabla `nuke_groups_points`
#
CREATE TABLE nuke_groups_points (
id int(10) NOT NULL auto_increment,
points int(10) NOT NULL default '0',
KEY id (id)
) TYPE=MyISAM;
#
# Volcar la base de datos para la tabla `nuke_groups_points`
#
INSERT INTO nuke_groups_points VALUES (1, 0);
INSERT INTO nuke_groups_points VALUES (2, 0);
INSERT INTO nuke_groups_points VALUES (3, 0);
INSERT INTO nuke_groups_points VALUES (4, 0);
INSERT INTO nuke_groups_points VALUES (5, 0);
INSERT INTO nuke_groups_points VALUES (6, 0);
INSERT INTO nuke_groups_points VALUES (7, 0);
INSERT INTO nuke_groups_points VALUES (8, 0);
INSERT INTO nuke_groups_points VALUES (9, 0);
INSERT INTO nuke_groups_points VALUES (10, 0);
INSERT INTO nuke_groups_points VALUES (11, 0);
INSERT INTO nuke_groups_points VALUES (12, 0);
INSERT INTO nuke_groups_points VALUES (13, 0);
INSERT INTO nuke_groups_points VALUES (14, 0);
INSERT INTO nuke_groups_points VALUES (15, 0);
INSERT INTO nuke_groups_points VALUES (16, 0);
INSERT INTO nuke_groups_points VALUES (17, 0);
INSERT INTO nuke_groups_points VALUES (18, 0);
INSERT INTO nuke_groups_points VALUES (19, 0);
INSERT INTO nuke_groups_points VALUES (20, 0);
INSERT INTO nuke_groups_points VALUES (21, 0);
# --------------------------------------------------------
#
# Estructura de tabla para la tabla `nuke_headlines`
#
CREATE TABLE nuke_headlines (
hid int(11) NOT NULL auto_increment,
sitename varchar(30) NOT NULL default '',
headlinesurl varchar(200) NOT NULL default '',
PRIMARY KEY (hid),
KEY hid (hid)
) TYPE=MyISAM;
#
# Volcar la base de datos para la tabla `nuke_headlines`
#
INSERT INTO nuke_headlines VALUES (1, 'AbsoluteGames', 'http://files.gameaholic.com/agfa.rdf');
INSERT INTO nuke_headlines VALUES (2, 'BSDToday', 'http://www.bsdtoday.com/backend/bt.rdf');
INSERT INTO nuke_headlines VALUES (3, 'BrunchingShuttlecocks', 'http://www.brunching.com/brunching.rdf');
INSERT INTO nuke_headlines VALUES (4, 'DailyDaemonNews', 'http://daily.daemonnews.org/ddn.rdf.php3');
INSERT INTO nuke_headlines VALUES (5, 'DigitalTheatre', 'http://www.dtheatre.com/backend.php3?xml=yes');
INSERT INTO nuke_headlines VALUES (6, 'DotKDE', 'http://dot.kde.org/rdf');
INSERT INTO nuke_headlines VALUES (7, 'FreeDOS', 'http://www.freedos.org/channels/rss.cgi');
INSERT INTO nuke_headlines VALUES (8, 'Freshmeat', 'http://freshmeat.net/backend/fm.rdf');
INSERT INTO nuke_headlines VALUES (9, 'Gnome Desktop', 'http://www.gnomedesktop.org/backend.php');
INSERT INTO nuke_headlines VALUES (10, 'HappyPenguin', 'http://happypenguin.org/html/news.rdf');
INSERT INTO nuke_headlines VALUES (11, 'HollywoodBitchslap', 'http://hollywoodbitchslap.com/hbs.rdf');
INSERT INTO nuke_headlines VALUES (12, 'Learning Linux', 'http://www.learninglinux.com/backend.php');
INSERT INTO nuke_headlines VALUES (13, 'LinuxCentral', 'http://linuxcentral.com/backend/lcnew.rdf');
INSERT INTO nuke_headlines VALUES (14, 'LinuxJournal', 'http://www.linuxjournal.com/news.rss');
INSERT INTO nuke_headlines VALUES (15, 'LinuxWeelyNews', 'http://lwn.net/headlines/rss');
INSERT INTO nuke_headlines VALUES (16, 'Listology', 'http://listology.com/recent.rdf');
INSERT INTO nuke_headlines VALUES (17, 'MozillaNewsBot', 'http://www.mozilla.org/newsbot/newsbot.rdf');
INSERT INTO nuke_headlines VALUES (18, 'NewsForge', 'http://www.newsforge.com/newsforge.rdf');
INSERT INTO nuke_headlines VALUES (19, 'NukeResources', 'http://www.nukeresources.com/backend.php');
INSERT INTO nuke_headlines VALUES (20, 'NukeScripts', 'http://www.nukescripts.net/backend.php');
INSERT INTO nuke_headlines VALUES (21, 'PDABuzz', 'http://www.pdabuzz.com/netscape.txt');
INSERT INTO nuke_headlines VALUES (22, 'PHP-Nuke', 'http://phpnuke.org/backend.php');
INSERT INTO nuke_headlines VALUES (23, 'PHP.net', 'http://www.php.net/news.rss');
INSERT INTO nuke_headlines VALUES (24, 'PHPBuilder', 'http://phpbuilder.com/rss_feed.php');
INSERT INTO nuke_headlines VALUES (25, 'PerlMonks', 'http://www.perlmonks.org/headlines.rdf');
INSERT INTO nuke_headlines VALUES (26, 'TheNextLevel', 'http://www.the-nextlevel.com/rdf/tnl.rdf');
INSERT INTO nuke_headlines VALUES (27, 'WebReference', 'http://webreference.com/webreference.rdf');
# --------------------------------------------------------
#
# Estructura de tabla para la tabla `nuke_journal`
#
CREATE TABLE nuke_journal (
jid int(11) NOT NULL auto_increment,
aid varchar(30) NOT NULL default '',
title varchar(80) default NULL,
bodytext text NOT NULL,
mood varchar(48) NOT NULL default '',
pdate varchar(48) NOT NULL default '',
ptime varchar(48) NOT NULL default '',
status varchar(48) NOT NULL default '',
mtime varchar(48) NOT NULL default '',
mdate varchar(48) NOT NULL default '',
PRIMARY KEY (jid),
KEY jid (jid),
KEY aid (aid)
) TYPE=MyISAM;
#
# Volcar la base de datos para la tabla `nuke_journal`
#
#
# Estructura de tabla para la tabla `nuke_links_newlink`
#
CREATE TABLE nuke_links_newlink (
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 '',
description text NOT NULL,
name varchar(100) NOT NULL default '',
email varchar(100) NOT NULL default '',
submitter varchar(60) NOT NULL default '',
PRIMARY KEY (lid),
KEY lid (lid),
KEY cid (cid),
KEY sid (sid)
) TYPE=MyISAM;
#
# Volcar la base de datos para la tabla `nuke_links_newlink`
#
#
# Volcar la base de datos para la tabla `nuke_main`
#
INSERT INTO nuke_main VALUES ('News');
# --------------------------------------------------------
#
# Estructura de tabla para la tabla `nuke_message`
#
CREATE TABLE nuke_message (
mid int(11) NOT NULL auto_increment,
title varchar(100) NOT NULL default '',
content text NOT NULL,
date varchar(14) NOT NULL default '',
expire int(7) NOT NULL default '0',
active int(1) NOT NULL default '1',
view int(1) NOT NULL default '1',
mlanguage varchar(30) NOT NULL default '',
PRIMARY KEY (mid),
UNIQUE KEY mid (mid)
) TYPE=MyISAM;
#
# Volcar la base de datos para la tabla `nuke_message`
#
INSERT INTO nuke_message VALUES (1, 'Welcome to PHP-Nuke!', '<br>Congratulations! You have now a web portal installed!. You can edit or change this message from the <a href="admin.php">Administration</a> page.\r\n<br><br>\r\n<center><b>For security reasons the best idea is to create the Super User right NOW by clicking <a href="admin.php">HERE</a></b></center>\r\n<br><br>\r\nYou can also create a user for you from the same page. Please read carefully the README file, CREDITS file to see from where comes the things and remember that this is free software released under the GPL License (read COPYING file for details). Hope you enjoy this software. Please report any bug you find when one of this annoying things happens and I\'ll try to fix it for the next release.\r\n<br><br>\r\nIf you like this software and want to make a contribution you can purchase the latest non-free version before it goes public. This can be done from <a href="http://phpnuke.org/modules.php?name=Release">here</a> or if you prefer you can become a PHP-Nuke\'s Club Member by clicking <a href="http://phpnuke.org/modules.php?name=Club">here</a> and obtain extra goodies for your system.\r\n<br><br>\r\nPHP-Nuke is an advanced and <i>intelligent</i> content management system designed and programmed with very hard work. PHP-Nuke has the biggest user\'s community in the world for this kind of application, thousands people (users and programmers) are waiting for you to join the revolution at <a href="http://phpnuke.org">http://phpnuke.org</a> where you can find thousands of modules/addons, themes, blocks, graphics, utilities and much more...\r\n<br><br>If you want to have written authorization to remove all visible copyright messages and any reference to PHP-Nuke, you can now acquire it by clicking <a href="http://phpnuke.org/modules.php?name=Commercial_License" target="new">here</a>, at the same time this will be a great support.\r\n<br><br>\r\nThanks for your support and for select PHP-Nuke as you web site\'s code! Hope you can can enjoy this application as much as we enjoy developing it!', '993373194', 0, 1, 1, '')
SQL-Befehl:
# # Volcar la base de datos para la tabla `nuke_comments` # # -------------------------------------------------------- # # Estructura de tabla para la tabla `nuke_config` # CREATE TABLE nuke_config ( sitename varchar(255) NOT NULL default '', nukeurl varchar(255) NOT NULL defaultThis is free software, and you may redistribute it under the <a href="http://phpnuke.org/files/gpl.txt"><font class="footmsg_l">GPL</font></a>. PHP-Nuke comes with absolutely no warranty, for details, see the <a href="http://phpnuke.org/files/gpl.txt"><font class="footmsg_l">license</font></a>.', '7.6'); # -------------------------------------------------------- # # Estructura de tabla para la tabla `nuke_confirm` # CREATE TABLE nuke_confirm ( confirm_id char(32) NOT NULL default '', session_id char(32) NOT NULL default '', code char(6) NOT NULL default '', PRIMARY KEY (session_id,confirm_id) ) TYPE=MyISAM; # # Volcar la base de datos para la tabla `nuke_confirm` # # -------------------------------------------------------- # # Estructura de tabla para la tabla `nuke_counter` # CREATE TABLE nuke_counter ( type varchar(80) NOT NULL default '', var varchar(80) NOT NULL default '', count int(10) unsigned NOT NULL default '0' ) TYPE=MyISAM; # # Volcar la base de datos para la tabla `nuke_counter` # INSERT INTO nuke_counter VALUES ('total', 'hits', 1); INSERT INTO nuke_counter VALUES ('browser', 'WebTV', 0); INSERT INTO nuke_counter VALUES ('browser', 'Lynx', 0); INSERT INTO nuke_counter VALUES ('browser', 'MSIE', 0); INSERT INTO nuke_counter VALUES ('browser', 'Opera', 0); INSERT INTO nuke_counter VALUES ('browser', 'Konqueror', 0); INSERT INTO nuke_counter VALUES ('browser', 'Netscape', 1); INSERT INTO nuke_counter VALUES ('browser', 'FireFox', 0); INSERT INTO nuke_counter VALUES ('browser', 'Bot', 0); INSERT INTO nuke_counter VALUES ('browser', 'Other', 0); INSERT INTO nuke_counter VALUES ('os', 'Windows', 0); INSERT INTO nuke_counter VALUES ('os', 'Linux', 1); INSERT INTO nuke_counter VALUES ('os', 'Mac', 0); INSERT INTO nuke_counter VALUES ('os', 'FreeBSD', 0); INSERT INTO nuke_counter VALUES ('os', 'SunOS', 0); INSERT INTO nuke_counter VALUES ('os', 'IRIX', 0); INSERT INTO nuke_counter VALUES ('os', 'BeOS', 0); INSERT INTO nuke_counter VALUES ('os', 'OS/2', 0); INSERT INTO nuke_counter VALUES ('os', 'AIX', 0); INSERT INTO nuke_counter VALUES ('os', 'Other', 0); # -------------------------------------------------------- # # Estructura de tabla para la tabla `nuke_downloads_categories` # CREATE TABLE nuke_downloads_categories ( cid int(11) NOT NULL auto_increment, title varchar(50) NOT NULL default '', cdescription text NOT NULL, parentid int(11) NOT NULL default '0', PRIMARY KEY (cid), KEY cid (cid), KEY title (title) ) TYPE=MyISAM; # # Volcar la base de datos para la tabla `nuke_downloads_categories` # # -------------------------------------------------------- # # Estructura de tabla para la tabla `nuke_downloads_downloads` # 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 '', 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 '', downloadratingsummary double(6,4) NOT NULL default '0.0000', totalvotes int(11) NOT NULL default '0', totalcomments int(11) NOT NULL default '0', filesize int(11) NOT NULL default '0', version varchar(10) NOT NULL default '', homepage varchar(200) NOT NULL default '', PRIMARY KEY (lid), KEY lid (lid), KEY cid (cid), KEY sid (sid), KEY title (title) ) TYPE=MyISAM; # # Volcar la base de datos para la tabla `nuke_downloads_downloads` # # -------------------------------------------------------- # # Estructura de tabla para la tabla `nuke_downloads_editorials` # 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) ) TYPE=MyISAM; # # Volcar la base de datos para la tabla `nuke_downloads_editorials` # # -------------------------------------------------------- # # Estructura de tabla para la tabla `nuke_downloads_modrequest` # 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 '', 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 '', PRIMARY KEY (requestid), UNIQUE KEY requestid (requestid) ) TYPE=MyISAM; # # Volcar la base de datos para la tabla `nuke_downloads_modrequest` # # -------------------------------------------------------- # # Estructura de tabla para la tabla `nuke_downloads_newdownload` # 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 '', 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 '', PRIMARY KEY (lid), KEY lid (lid), KEY cid (cid), KEY sid (sid), KEY title (title) ) TYPE=MyISAM; # # Volcar la base de datos para la tabla `nuke_downloads_newdownload` # # -------------------------------------------------------- # # Estructura de tabla para la tabla `nuke_downloads_votedata` # CREATE TABLE nuke_downloads_votedata ( ratingdbid int(11) NOT NULL auto_increment, ratinglid int(11) NOT NULL default '0', ratinguser varchar(60) NOT NULL default '', rating int(11) NOT NULL default '0', ratinghostname varchar(60) NOT NULL default '', ratingcomments text NOT NULL, ratingtimestamp datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (ratingdbid), KEY ratingdbid (ratingdbid) ) TYPE=MyISAM; # # Volcar la base de datos para la tabla `nuke_downloads_votedata` # # -------------------------------------------------------- # # Estructura de tabla para la tabla `nuke_encyclopedia` # CREATE TABLE nuke_encyclopedia ( eid int(10) NOT NULL auto_increment, title varchar(255) NOT NULL default '', description text NOT NULL, elanguage varchar(30) NOT NULL default '', active int(1) NOT NULL default '0', PRIMARY KEY (eid), KEY eid (eid) ) TYPE=MyISAM; # # Volcar la base de datos para la tabla `nuke_encyclopedia` # # -------------------------------------------------------- # # Estructura de tabla para la tabla `nuke_encyclopedia_text` # CREATE TABLE nuke_encyclopedia_text ( tid int(10) NOT NULL auto_increment, eid int(10) NOT NULL default '0', title varchar(255) NOT NULL default '', text text NOT NULL, counter int(10) NOT NULL default '0', PRIMARY KEY (tid), KEY tid (tid), KEY eid (eid), KEY title (title) ) TYPE=MyISAM; # # Volcar la base de datos para la tabla `nuke_encyclopedia_text` # # -------------------------------------------------------- # # Estructura de tabla para la tabla `nuke_faqanswer` # CREATE TABLE nuke_faqanswer ( id tinyint(4) NOT NULL auto_increment, id_cat tinyint(4) NOT NULL default '0', question varchar(255) default '', answer text, PRIMARY KEY (id), KEY id (id), KEY id_cat (id_cat) ) TYPE=MyISAM; # # Volcar la base de datos para la tabla `nuke_faqanswer` # # -------------------------------------------------------- # # Estructura de tabla para la tabla `nuke_faqcategories` # CREATE TABLE nuke_faqcategories ( id_cat tinyint(3) NOT NULL auto_increment, categories varchar(255) default NULL, flanguage varchar(30) NOT NULL default '', PRIMARY KEY (id_cat), KEY id_cat (id_cat) ) TYPE=MyISAM; # # Volcar la base de datos para la tabla `nuke_faqcategories` # # -------------------------------------------------------- # # Estructura de tabla para la tabla `nuke_groups` # CREATE TABLE nuke_groups ( id int(10) NOT NULL auto_increment, name varchar(255) NOT NULL default '', description text NOT NULL, points int(10) NOT NULL default '0', KEY id (id) ) TYPE=MyISAM; # # Volcar la base de datos para la tabla `nuke_groups` # # -------------------------------------------------------- # # Estructura de tabla para la tabla `nuke_groups_points` # CREATE TABLE nuke_groups_points ( id int(10) NOT NULL auto_increment, points int(10) NOT NULL default '0', KEY id (id) ) TYPE=MyISAM; # # Volcar la base de datos para la tabla `nuke_groups_points` # INSERT INTO nuke_groups_points VALUES (1, 0); INSERT INTO nuke_groups_points VALUES (2, 0); INSERT INTO nuke_groups_points VALUES (3, 0); INSERT INTO nuke_groups_points VALUES (4, 0); INSERT INTO nuke_groups_points VALUES (5, 0); INSERT INTO nuke_groups_points VALUES (6, 0); INSERT INTO nuke_groups_points VALUES (7, 0); INSERT INTO nuke_groups_points VALUES (8, 0); INSERT INTO nuke_groups_points VALUES (9, 0); INSERT INTO nuke_groups_points VALUES (10, 0); INSERT INTO nuke_groups_points VALUES (11, 0); INSERT INTO nuke_groups_points VALUES (12, 0); INSERT INTO nuke_groups_points VALUES (13, 0); INSERT INTO nuke_groups_points VALUES (14, 0); INSERT INTO nuke_groups_points VALUES (15, 0); INSERT INTO nuke_groups_points VALUES (16, 0); INSERT INTO nuke_groups_points VALUES (17, 0); INSERT INTO nuke_groups_points VALUES (18, 0); INSERT INTO nuke_groups_points VALUES (19, 0); INSERT INTO nuke_groups_points VALUES (20, 0); INSERT INTO nuke_groups_points VALUES (21, 0); # -------------------------------------------------------- # # Estructura de tabla para la tabla `nuke_headlines` # CREATE TABLE nuke_headlines ( hid int(11) NOT NULL auto_increment, sitename varchar(30) NOT NULL default '', headlinesurl varchar(200) NOT NULL default '', PRIMARY KEY (hid), KEY hid (hid) ) TYPE=MyISAM; # # Volcar la base de datos para la tabla `nuke_headlines` # INSERT INTO nuke_headlines VALUES (1, 'AbsoluteGames', 'http://files.gameaholic.com/agfa.rdf'); INSERT INTO nuke_headlines VALUES (2, 'BSDToday', 'http://www.bsdtoday.com/backend/bt.rdf'); INSERT INTO nuke_headlines VALUES (3, 'BrunchingShuttlecocks', 'http://www.brunching.com/brunching.rdf'); INSERT INTO nuke_headlines VALUES (4, 'DailyDaemonNews', 'http://daily.daemonnews.org/ddn.rdf.php3'); INSERT INTO nuke_headlines VALUES (5, 'DigitalTheatre', 'http://www.dtheatre.com/backend.php3?xml=yes'); INSERT INTO nuke_headlines VALUES (6, 'DotKDE', 'http://dot.kde.org/rdf'); INSERT INTO nuke_headlines VALUES (7, 'FreeDOS', 'http://www.freedos.org/channels/rss.cgi'); INSERT INTO nuke_headlines VALUES (8, 'Freshmeat', 'http://freshmeat.net/backend/fm.rdf'); INSERT INTO nuke_headlines VALUES (9, 'Gnome Desktop', 'http://www.gnomedesktop.org/backend.php'); INSERT INTO nuke_headlines VALUES (10, 'HappyPenguin', 'http://happypenguin.org/html/news.rdf'); INSERT INTO nuke_headlines VALUES (11, 'HollywoodBitchslap', 'http://hollywoodbitchslap.com/hbs.rdf'); INSERT INTO nuke_headlines VALUES (12, 'Learning Linux', 'http://www.learninglinux.com/backend.php'); INSERT INTO nuke_headlines VALUES (13, 'LinuxCentral', 'http://linuxcentral.com/backend/lcnew.rdf'); INSERT INTO nuke_headlines VALUES (14, 'LinuxJournal', 'http://www.linuxjournal.com/news.rss'); INSERT INTO nuke_headlines VALUES (15, 'LinuxWeelyNews', 'http://lwn.net/headlines/rss'); INSERT INTO nuke_headlines VALUES (16, 'Listology', 'http://listology.com/recent.rdf'); INSERT INTO nuke_headlines VALUES (17, 'MozillaNewsBot', 'http://www.mozilla.org/newsbot/newsbot.rdf'); INSERT INTO nuke_headlines VALUES (18, 'NewsForge', 'http://www.newsforge.com/newsforge.rdf'); INSERT INTO nuke_headlines VALUES (19, 'NukeResources', 'http://www.nukeresources.com/backend.php'); INSERT INTO nuke_headlines VALUES (20, 'NukeScripts', 'http://www.nukescripts.net/backend.php'); INSERT INTO nuke_headlines VALUES (21, 'PDABuzz', 'http://www.pdabuzz.com/netscape.txt'); INSERT INTO nuke_headlines VALUES (22, 'PHP-Nuke', 'http://phpnuke.org/backend.php'); INSERT INTO nuke_headlines VALUES (23, 'PHP.net', 'http://www.php.net/news.rss'); INSERT INTO nuke_headlines VALUES (24, 'PHPBuilder', 'http://phpbuilder.com/rss_feed.php'); INSERT INTO nuke_headlines VALUES (25, 'PerlMonks', 'http://www.perlmonks.org/headlines.rdf'); INSERT INTO nuke_headlines VALUES (26, 'TheNextLevel', 'http://www.the-nextlevel.com/rdf/tnl.rdf'); INSERT INTO nuke_headlines VALUES (27, 'WebReference', 'http://webreference.com/webreference.rdf'); # -------------------------------------------------------- # # Estructura de tabla para la tabla `nuke_journal` # CREATE TABLE nuke_journal ( jid int(11) NOT NULL auto_increment, aid varchar(30) NOT NULL default '', title varchar(80) default NULL, bodytext text NOT NULL, mood varchar(48) NOT NULL default '', pdate varchar(48) NOT NULL default '', ptime varchar(48) NOT NULL default '', status varchar(48) NOT NULL default '', mtime varchar(48) NOT NULL default '', mdate varchar(48) NOT NULL default '', PRIMARY KEY (jid), KEY jid (jid), KEY aid (aid) ) TYPE=MyISAM; # # Volcar la base de datos para la tabla `nuke_journal` # # -------------------------------------------------------- # # Estructura de tabla para la tabla `nuke_journal_comments` # CREATE TABLE nuke_journal_comments ( cid int(11) NOT NULL auto_increment, rid varchar(48) NOT NULL default '', aid varchar(30) NOT NULL default '', comment text NOT NULL, pdate varchar(48) NOT NULL default '', ptime varchar(48) NOT NULL default '', PRIMARY KEY (cid), KEY cid (cid), KEY rid (rid), KEY aid (aid) ) TYPE=MyISAM; # # Volcar la base de datos para la tabla `nuke_journal_comments` # # -------------------------------------------------------- # # Estructura de tabla para la tabla `nuke_journal_stats` # CREATE TABLE nuke_journal_stats ( id int(11) NOT NULL auto_increment, joid varchar(48) NOT NULL default '', nop varchar(48) NOT NULL default '', ldp varchar(24) NOT NULL default '', ltp varchar(24) NOT NULL default '', micro varchar(128) NOT NULL default '', PRIMARY KEY (id), KEY id (id) ) TYPE=MyISAM; # # Volcar la base de datos para la tabla `nuke_journal_stats` # # -------------------------------------------------------- # # Estructura de tabla para la tabla `nuke_links_categories` # CREATE TABLE nuke_links_categories ( cid int(11) NOT NULL auto_increment, title varchar(50) NOT NULL default '', cdescription text NOT NULL, parentid int(11) NOT NULL default '0', PRIMARY KEY (cid), KEY cid (cid) ) TYPE=MyISAM; # # Volcar la base de datos para la tabla `nuke_links_categories` # # -------------------------------------------------------- # # Estructura de tabla para la tabla `nuke_links_editorials` # CREATE TABLE nuke_links_editorials ( linkid 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 (linkid), KEY linkid (linkid) ) TYPE=MyISAM; # # Volcar la base de datos para la tabla `nuke_links_editorials` # # -------------------------------------------------------- # # Estructura de tabla para la tabla `nuke_links_links` # CREATE TABLE nuke_links_links ( 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 '', 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 '', linkratingsummary double(6,4) NOT NULL default '0.0000', totalvotes int(11) NOT NULL default '0', totalcomments int(11) NOT NULL default '0', PRIMARY KEY (lid), KEY lid (lid), KEY cid (cid), KEY sid (sid) ) TYPE=MyISAM; # # Volcar la base de datos para la tabla `nuke_links_links` # # -------------------------------------------------------- # # Estructura de tabla para la tabla `nuke_links_modrequest` # CREATE TABLE nuke_links_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 '', description text NOT NULL, modifysubmitter varchar(60) NOT NULL default '', brokenlink int(3) NOT NULL default '0', PRIMARY KEY (requestid), UNIQUE KEY requestid (requestid) ) TYPE=MyISAM; # # Volcar la base de datos para la tabla `nuke_links_modrequest` # # -------------------------------------------------------- # # Estructura de tabla para la tabla `nuke_links_newlink` # CREATE TABLE nuke_links_newlink ( 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 '', description text NOT NULL, name varchar(100) NOT NULL default '', email varchar(100) NOT NULL default '', submitter varchar(60) NOT NULL default '', PRIMARY KEY (lid), KEY lid (lid), KEY cid (cid), KEY sid (sid) ) TYPE=MyISAM; # # Volcar la base de datos para la tabla `nuke_links_newlink` # # -------------------------------------------------------- # # Estructura de tabla para la tabla `nuke_links_votedata` # CREATE TABLE nuke_links_votedata ( ratingdbid int(11) NOT NULL auto_increment, ratinglid int(11) NOT NULL default '0', ratinguser varchar(60) NOT NULL default '', rating int(11) NOT NULL default '0', ratinghostname varchar(60) NOT NULL default '', ratingcomments text NOT NULL, ratingtimestamp datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (ratingdbid), KEY ratingdbid (ratingdbid) ) TYPE=MyISAM; # # Volcar la base de datos para la tabla `nuke_links_votedata` # # -------------------------------------------------------- # # Estructura de tabla para la tabla `nuke_main` # CREATE TABLE nuke_main ( main_module varchar(255) NOT NULL default '' ) TYPE=MyISAM; # # Volcar la base de datos para la tabla `nuke_main` # INSERT INTO nuke_main VALUES ('News'); # -------------------------------------------------------- # # Estructura de tabla para la tabla `nuke_message` # CREATE TABLE nuke_message ( mid int(11) NOT NULL auto_increment, title varchar(100) NOT NULL default '', content text NOT NULL, date varchar(14) NOT NULL default '', expire int(7) NOT NULL default '0', active int(1) NOT NULL default '1', view int(1) NOT NULL default '1', mlanguage varchar(30) NOT NULL default '', PRIMARY KEY (mid), UNIQUE KEY mid (mid) ) TYPE=MyISAM; # # Volcar la base de datos para la tabla `nuke_message` # INSERT INTO nuke_message VALUES (1, 'Welcome to PHP-Nuke!', '<br>Congratulations! You have now a web portal installed!. You can edit or change this message from the <a href="admin.php">Administration</a> page.\r\n<br><br>\r\n<center><b>For security reasons the best idea is to create the Super User right NOW by clicking <a href="admin.php">HERE</a></b></center>\r\n<br><br>\r\nYou can also create a user for you from the same page. Please read carefully the README file, CREDITS file to see from where comes the things and remember that this is free software released under the GPL License (read COPYING file for details). Hope you enjoy this software. Please report any bug you find when one of this annoying things happens and I\'ll try to fix it for the next release.\r\n<br><br>\r\nIf you like this software and want to make a contribution you can purchase the latest non-free version before it goes public. This can be done from <a href="http://phpnuke.org/modules.php?name=Release">here</a> or if you prefer you can become a PHP-Nuke\'s Club Member by clicking <a href="http://phpnuke.org/modules.php?name=Club">here</a> and obtain extra goodies for your system.\r\n<br><br>\r\nPHP-Nuke is an advanced and <i>intelligent</i> content management system designed and programmed with very hard work. PHP-Nuke has the biggest user\'s community in the world for this kind of application, thousands people (users and programmers) are waiting for you to join the revolution at <a href="http://phpnuke.org">http://phpnuke.org</a> where you can find thousands of modules/addons, themes, blocks, graphics, utilities and much more...\r\n<br><br>If you want to have written authorization to remove all visible copyright messages and any reference to PHP-Nuke, you can now acquire it by clicking <a href="http://phpnuke.org/modules.php?name=Commercial_License" target="new">here</a>, at the same time this will be a great support.\r\n<br><br>\r\nThanks for your support and for select PHP-Nuke as you web site\'s code! Hope you can can enjoy this application as much as we enjoy developing it!', '993373194', 0, 1, 1, '')
MySQL meldet:
#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 'defaultThis is free software, and you may redistribute it under
Bu forumda yeni başlıklar açamazsınız Bu forumdaki başlıklara cevap veremezsiniz Bu forumdaki mesajlarınızı değiştiremezsiniz Bu forumdaki mesajlarınızı silemezsiniz Bu forumdaki anketlerde oy kullanamazsınız