SQL Error nach (während) installation, komisch!?!

Begonnen von BigBugg, 12 April 2004, 02:07:37

⏪ vorheriges - nächstes ⏩

0 Mitglieder und 1 Gast betrachten dieses Thema.

BigBugg

Hallo Leute,

habe genau nach install Anleitung den inhalt der "html" Verzeichnisse von "vkpmx_base_v002" und "vkpmx_addon_v002" per FTP auf den Server geuppt. Bei schritt 9 bekomme ich folgenden SQL Error, kann mir jamand sagen warum dieser Fehler kommt?



Die Datenbank 'hp' ist vorhanden.

Die Tabellen wurden erstellt (88 von 88)


und dann steht


Es sind folgende Fehler aufgetreten:


Error: Table 'hp.mx_eBoard_forums' doesn't exist
Query: INSERT INTO mx_eBoard_forums (type, fid, name, status, lastpost, moderator, displayorder, private, description, allowhtml, allowsmilies, allowbbcode, guestposting, userlist, theme, posts, threads, fup, postperm, allowimgcode, totaltime) VALUES ('group', 1, 'First Category', 'on', '', '', 0, '', '', '', '', '', '', '', '', 0, 0, 0, '1|1', '', 0);

Error: Table 'hp.mx_eBoard_forums' doesn't exist
Query: INSERT INTO mx_eBoard_forums (type, fid, name, status, lastpost, moderator, displayorder, private, description, allowhtml, allowsmilies, allowbbcode, guestposting, userlist, theme, posts, threads, fup, postperm, allowimgcode, totaltime) VALUES ('forum', 2, 'First Forum', 'on', '', '', 0, '', '', 'no', 'yes', 'yes', 'yes', '', '', 0, 0, 1, '1|1', 'yes', 0);

Error: Table 'hp.mx_eBoard_forums' doesn't exist
Query: INSERT INTO mx_eBoard_forums (type, fid, name, status, lastpost, moderator, displayorder, private, description, allowhtml, allowsmilies, allowbbcode, guestposting, userlist, theme, posts, threads, fup, postperm, allowimgcode, totaltime) VALUES ('sub', 3, 'First Sub-Forum', 'on', '', '', 0, '', '', 'no', 'yes', 'yes', 'yes', '', '', 0, 0, 2, '1|1', 'yes', 0);

Error: Table 'hp.mx_eBoard_ranks' doesn't exist
Query: INSERT INTO mx_eBoard_ranks (title, posts, id, stars, allowavatars, avatarrank) VALUES ('Newbie', 1, 1, 1, 'yes', '');

Error: Table 'hp.mx_eBoard_ranks' doesn't exist
Query: INSERT INTO mx_eBoard_ranks (title, posts, id, stars, allowavatars, avatarrank) VALUES ('Junior Member', 2, 2, 2, 'yes', '');

Error: Table 'hp.mx_eBoard_ranks' doesn't exist
Query: INSERT INTO mx_eBoard_ranks (title, posts, id, stars, allowavatars, avatarrank) VALUES ('Member', 100, 3, 3, 'yes', '');

Error: Table 'hp.mx_eBoard_ranks' doesn't exist
Query: INSERT INTO mx_eBoard_ranks (title, posts, id, stars, allowavatars, avatarrank) VALUES ('Senior Member', 500, 4, 4, 'yes', '');

Error: Table 'hp.mx_eBoard_ranks' doesn't exist
Query: INSERT INTO mx_eBoard_ranks (title, posts, id, stars, allowavatars, avatarrank) VALUES ('Posting Freak', 1000, 5, 5, 'yes', '');

Error: Table 'hp.mx_eBoard_smilies' doesn't exist
Query: INSERT INTO mx_eBoard_smilies (type, code, url, id) VALUES ('picon', '', 'smilies/smile.gif', 1);

Error: Table 'hp.mx_eBoard_smilies' doesn't exist
Query: INSERT INTO mx_eBoard_smilies (type, code, url, id) VALUES ('picon', '', 'smilies/bigsmile.gif', 2);

Error: Table 'hp.mx_eBoard_smilies' doesn't exist
Query: INSERT INTO mx_eBoard_smilies (type, code, url, id) VALUES ('picon', '', 'smilies/sad.gif', 3);

Error: Table 'hp.mx_eBoard_smilies' doesn't exist
Query: INSERT INTO mx_eBoard_smilies (type, code, url, id) VALUES ('picon', '', 'smilies/cry_smile.gif', 4);

Error: Table 'hp.mx_eBoard_smilies' doesn't exist
Query: INSERT INTO mx_eBoard_smilies (type, code, url, id) VALUES ('picon', '', 'smilies/wink.gif', 5);

Error: Table 'hp.mx_eBoard_smilies' doesn't exist
Query: INSERT INTO mx_eBoard_smilies (type, code, url, id) VALUES ('picon', '', 'smilies/cool.gif', 6);

Error: Table 'hp.mx_eBoard_smilies' doesn't exist
Query: INSERT INTO mx_eBoard_smilies (type, code, url, id) VALUES ('picon', '', 'smilies/mad3.gif', 7);

Error: Table 'hp.mx_eBoard_smilies' doesn't exist
Query: INSERT INTO mx_eBoard_smilies (type, code, url, id) VALUES ('picon', '', 'smilies/shocked.gif', 8);

Error: Table 'hp.mx_eBoard_smilies' doesn't exist
Query: INSERT INTO mx_eBoard_smilies (type, code, url, id) VALUES ('picon', '', 'smilies/tongue.gif', 9);

Error: Table 'hp.mx_eBoard_smilies' doesn't exist
Query: INSERT INTO mx_eBoard_smilies (type, code, url, id) VALUES ('picon', '', 'smilies/puzzled.gif', 10);

Error: Table 'hp.mx_eBoard_smilies' doesn't exist
Query: INSERT INTO mx_eBoard_smilies (type, code, url, id) VALUES ('picon', '', 'smilies/exclamation_smile.gif', 11);

Error: Table 'hp.mx_eBoard_smilies' doesn't exist
Query: INSERT INTO mx_eBoard_smilies (type, code, url, id) VALUES ('picon', '', 'smilies/mad.gif', 12);

Error: Table 'hp.mx_eBoard_smilies' doesn't exist
Query: INSERT INTO mx_eBoard_smilies (type, code, url, id) VALUES ('picon', '', 'smilies/achtung.gif', 13);

Error: Table 'hp.mx_eBoard_smilies' doesn't exist
Query: INSERT INTO mx_eBoard_smilies (type, code, url, id) VALUES ('picon', '', 'smilies/exclamation.gif', 14);

Error: Table 'hp.mx_eBoard_smilies' doesn't exist
Query: INSERT INTO mx_eBoard_smilies (type, code, url, id) VALUES ('picon', '', 'smilies/question.gif', 15);

Error: Table 'hp.mx_eBoard_smilies' doesn't exist
Query: INSERT INTO mx_eBoard_smilies (type, code, url, id) VALUES ('picon', '', 'smilies/thumbup.gif', 16);

Error: Table 'hp.mx_eBoard_smilies' doesn't exist
Query: INSERT INTO mx_eBoard_smilies (type, code, url, id) VALUES ('picon', '', 'smilies/thumbdown.gif', 17);

Error: Table 'hp.mx_eBoard_smilies' doesn't exist
Query: INSERT INTO mx_eBoard_smilies (type, code, url, id) VALUES ('smiley', ':)', 'smilies/smile.gif', 18);

Error: Table 'hp.mx_eBoard_smilies' doesn't exist
Query: INSERT INTO mx_eBoard_smilies (type, code, url, id) VALUES ('smiley', ':D', 'smilies/bigsmile.gif', 19);

Error: Table 'hp.mx_eBoard_smilies' doesn't exist
Query: INSERT INTO mx_eBoard_smilies (type, code, url, id) VALUES ('smiley', ':(', 'smilies/sad.gif', 20);

Error: Table 'hp.mx_eBoard_smilies' doesn't exist
Query: INSERT INTO mx_eBoard_smilies (type, code, url, id) VALUES ('smiley', ';(', 'smilies/cry_smile.gif', 21);

Error: Table 'hp.mx_eBoard_smilies' doesn't exist
Query: INSERT INTO mx_eBoard_smilies (type, code, url, id) VALUES ('smiley', ';)', 'smilies/wink.gif', 22);

Error: Table 'hp.mx_eBoard_smilies' doesn't exist
Query: INSERT INTO mx_eBoard_smilies (type, code, url, id) VALUES ('smiley', ':cool:', 'smilies/cool.gif', 23);

Error: Table 'hp.mx_eBoard_smilies' doesn't exist
Query: INSERT INTO mx_eBoard_smilies (type, code, url, id) VALUES ('smiley', ':redhead:', 'smilies/mad3.gif', 24);

Error: Table 'hp.mx_eBoard_smilies' doesn't exist
Query: INSERT INTO mx_eBoard_smilies (type, code, url, id) VALUES ('smiley', ':P', 'smilies/tongue.gif', 25);

Error: Table 'hp.mx_eBoard_smilies' doesn't exist
Query: INSERT INTO mx_eBoard_smilies (type, code, url, id) VALUES ('smiley', ':o', 'smilies/shocked.gif', 26);

Error: Table 'hp.mx_eBoard_smilies' doesn't exist
Query: INSERT INTO mx_eBoard_smilies (type, code, url, id) VALUES ('smiley', ':puzz:', 'smilies/puzzled.gif', 27);

Error: Table 'hp.mx_eBoard_smilies' doesn't exist
Query: INSERT INTO mx_eBoard_smilies (type, code, url, id) VALUES ('smiley', ':exclam:', 'smilies/exclamation_smile.gif', 28);

Error: Table 'hp.mx_eBoard_smilies' doesn't exist
Query: INSERT INTO mx_eBoard_smilies (type, code, url, id) VALUES ('smiley', ':mad:', 'smilies/mad.gif', 29);

Error: Table 'hp.mx_eBoard_smilies' doesn't exist
Query: INSERT INTO mx_eBoard_smilies (type, code, url, id) VALUES ('smiley', ':thumbup:', 'smilies/thumbup.gif', 30);

Error: Table 'hp.mx_eBoard_smilies' doesn't exist
Query: INSERT INTO mx_eBoard_smilies (type, code, url, id) VALUES ('smiley', ':thumbdown:', 'smilies/thumbdown.gif', 31);

Error: Table 'hp.mx_eBoard_smilies' doesn't exist
Query: INSERT INTO mx_eBoard_smilies (type, code, url, id) VALUES ('smiley', ':question:', 'smilies/question.gif', 32);

Error: Table 'hp.mx_eBoard_smilies' doesn't exist
Query: INSERT INTO mx_eBoard_smilies (type, code, url, id) VALUES ('smiley', ':note:', 'smilies/achtung.gif', 33);

Error: Table 'hp.mx_eBoard_smilies' doesn't exist
Query: INSERT INTO mx_eBoard_smilies (type, code, url, id) VALUES ('smiley', ':exclams:', 'smilies/exclamation.gif', 34);

Error: Table 'hp.mx_eBoard_smilies' doesn't exist
Query: INSERT INTO mx_eBoard_smilies (type, code, url, id) VALUES ('smiley', ':yltype:', 'smilies/yltype.gif', 35);

Error: Table 'hp.mx_eBoard_smilies' doesn't exist
Query: INSERT INTO mx_eBoard_smilies (type, code, url, id) VALUES ('smiley', ':crash:', 'smilies/crash.gif', 36);

Error: Table 'hp.mx_eBoard_smilies' doesn't exist
Query: INSERT INTO mx_eBoard_smilies (type, code, url, id) VALUES ('smiley', ':red:', 'smilies/rougi.gif', 37);

Error: Table 'hp.mx_eBoard_smilies' doesn't exist
Query: INSERT INTO mx_eBoard_smilies (type, code, url, id) VALUES ('smiley', ':knockout:', 'smilies/c.gif', 38);

Error: Table 'hp.mx_eBoard_smilies' doesn't exist
Query: INSERT INTO mx_eBoard_smilies (type, code, url, id) VALUES ('smiley', ':mad2:', 'smilies/mad2.gif', 39);

Error: Table 'hp.mx_eBoard_smilies' doesn't exist
Query: INSERT INTO mx_eBoard_smilies (type, code, url, id) VALUES ('smiley', ':cul:', 'smilies/cul.gif', 40);

Error: Table 'hp.mx_eBoard_smilies' doesn't exist
Query: INSERT INTO mx_eBoard_smilies (type, code, url, id) VALUES ('smiley', ':hallucine:', 'smilies/hallucine.gif', 41);

Error: Table 'hp.mx_eBoard_smilies' doesn't exist
Query: INSERT INTO mx_eBoard_smilies (type, code, url, id) VALUES ('smiley', ':calim:', 'smilies/calimero.gif', 42);

Error: Table 'hp.mx_eBoard_smilies' doesn't exist
Query: INSERT INTO mx_eBoard_smilies (type, code, url, id) VALUES ('smiley', ':phantom:', 'smilies/men_ani.gif', 43);

Error: Table 'hp.mx_eBoard_smilies' doesn't exist
Query: INSERT INTO mx_eBoard_smilies (type, code, url, id) VALUES ('smiley', ':heartpump:', 'smilies/heartpump.gif', 44);

Error: Table 'hp.mx_eBoard_smilies' doesn't exist
Query: INSERT INTO mx_eBoard_smilies (type, code, url, id) VALUES ('smiley', ':present:', 'smilies/present.gif', 45);

Error: Table 'hp.mx_eBoard_smilies' doesn't exist
Query: INSERT INTO mx_eBoard_smilies (type, code, url, id) VALUES ('smiley', ':gunman:', 'smilies/gun.gif', 46);

Error: Table 'hp.mx_eBoard_smilies' doesn't exist
Query: INSERT INTO mx_eBoard_smilies (type, code, url, id) VALUES ('smiley', ':heu:', 'smilies/heu.gif', 47);

Error: Table 'hp.mx_eBoard_smilies' doesn't exist
Query: INSERT INTO mx_eBoard_smilies (type, code, url, id) VALUES ('smiley', ':idea:', 'smilies/icon_idea.gif', 48);

Error: Table 'hp.mx_eBoard_smilies' doesn't exist
Query: INSERT INTO mx_eBoard_smilies (type, code, url, id) VALUES ('smiley', ':luxhello:', 'smilies/luxhello.gif', 49);

Error: Table 'hp.mx_eBoard_smilies' doesn't exist
Query: INSERT INTO mx_eBoard_smilies (type, code, url, id) VALUES ('smiley', ':devil:', 'smilies/1.gif', 50);

Error: Table 'hp.mx_eBoard_smilies' doesn't exist
Query: INSERT INTO mx_eBoard_smilies (type, code, url, id) VALUES ('smiley', ':angle:', 'smilies/ange.gif', 51);

Error: Table 'hp.mx_eBoard_themes' doesn't exist
Query: INSERT INTO mx_eBoard_themes (name, bgcolor, altbg1, altbg2, link, bordercolor, header, headertext, top, catcolor, tabletext, text, borderwidth, tablewidth, tablespace, font, fontsize, altfont, altfontsize, replyimg, newtopicimg, boardimg, postscol, color1, color2) VALUES ('moderngray', '#ffffff', '#f0f0f0', '#fbfbfb', '#6633cc', '#2a2f79', '#2a2f79', '#ffffff', '#f0f0f0', '#dededf', '#000000', '#000000', '1', '97%', '4', 'Arial', '12px', 'Verdana', '10px', 'reply.gif', 'newtopic.gif', '', '2col', 'red', 'blue');

Error: Table 'hp.mx_eBoard_themes' doesn't exist
Query: INSERT INTO mx_eBoard_themes (name, bgcolor, altbg1, altbg2, link, bordercolor, header, headertext, top, catcolor, tabletext, text, borderwidth, tablewidth, tablespace, font, fontsize, altfont, altfontsize, replyimg, newtopicimg, boardimg, postscol, color1, color2) VALUES ('gray', '#ffffff', '#dededf', '#eeeeee', '#333399', '#778899', '#778899', '#ffffff', '#eeeeee', '#dcdcde', '#000000', '#000000', '1', '97%', '6', 'Arial', '12px', 'Verdana', '10px', 'reply.gif', 'newtopic.gif', '', '2col', 'red', 'blue');

Error: Table 'hp.mx_eBoard_themes' doesn't exist
Query: INSERT INTO mx_eBoard_themes (name, bgcolor, altbg1, altbg2, link, bordercolor, header, headertext, top, catcolor, tabletext, text, borderwidth, tablewidth, tablespace, font, fontsize, altfont, altfontsize, replyimg, newtopicimg, boardimg, postscol, color1, color2) VALUES ('blue', '#ffffff', '#b0c0d0', '#d0e0f0', '#cc6600', '#000000', '#e0f0f9', '#000000', '#d0e0f0', '#b0c0d4', '#000000', '#000000', '1', '97%', '6', 'Arial', '12px', 'Verdana', '10px', 'reply.gif', 'newtopic.gif', '', '2col', 'red', 'blue');

Error: Table 'hp.mx_eBoard_themes' doesn't exist
Query: INSERT INTO mx_eBoard_themes (name, bgcolor, altbg1, altbg2, link, bordercolor, header, headertext, top, catcolor, tabletext, text, borderwidth, tablewidth, tablespace, font, fontsize, altfont, altfontsize, replyimg, newtopicimg, boardimg, postscol, color1, color2) VALUES ('hacknuke', '#2a2f79', '#2a2f79', '#2a2f79', '#ff9900', '#000000', '#ff9900', '#000000', '#000000', '#2a2f79', '#ffffff', '#000000', '1', '97%', '2', 'Arial', '12px', 'Verdana', '10px', 'reply.gif', 'newtopic.gif', '', '2col', 'red', 'blue');

Error: Table 'hp.mx_eBoard_themes' doesn't exist
Query: INSERT INTO mx_eBoard_themes (name, bgcolor, altbg1, altbg2, link, bordercolor, header, headertext, top, catcolor, tabletext, text, borderwidth, tablewidth, tablespace, font, fontsize, altfont, altfontsize, replyimg, newtopicimg, boardimg, postscol, color1, color2) VALUES ('coursapied', '#ffffff', '#dededf', '#eeeeee', '#333399', '#9999ff', '#9999ff', '#ffffff', '#eeeeee', '#dcdcde', '#000000', '#000000', '1', '97%', '6', 'Arial', '12px', 'Arial', '10px', 'reply.gif', 'newtopic.gif', '', '2col', 'red', 'blue');

Error: Table 'hp.mx_eBoard_themes' doesn't exist
Query: INSERT INTO mx_eBoard_themes (name, bgcolor, altbg1, altbg2, link, bordercolor, header, headertext, top, catcolor, tabletext, text, borderwidth, tablewidth, tablespace, font, fontsize, altfont, altfontsize, replyimg, newtopicimg, boardimg, postscol, color1, color2) VALUES ('postnuke', '#f6f7eb', '#e1e4ce', '#f6f7eb', '#000000', '#b1b78b', '#d9dcc2', '#000000', '#b1b78b', '#e1e4ce', '#000000', '#000000', '1', '97%', '4', 'Arial', '12px', 'Verdana', '10px', 'reply.gif', 'newtopic.gif', '', '2col', 'red', 'blue');

Error: Table 'hp.mx_eBoard_themes' doesn't exist
Query: INSERT INTO mx_eBoard_themes (name, bgcolor, altbg1, altbg2, link, bordercolor, header, headertext, top, catcolor, tabletext, text, borderwidth, tablewidth, tablespace, font, fontsize, altfont, altfontsize, replyimg, newtopicimg, boardimg, postscol, color1, color2) VALUES ('default', '#ffffff', '#ffffff', '#ffffff', '#000000', '#000000', '#ffffff', '#000000', '#ffffff', '#ffffff', '#000000', '#000000', '1', '97%', '4', 'Arial', '12px', 'Verdana', '10px', 'reply.gif', 'newtopic.gif', '', '2col', 'red', 'blue');

Error: Table 'hp.mx_eBoard_themes' doesn't exist
Query: INSERT INTO mx_eBoard_themes (name, bgcolor, altbg1, altbg2, link, bordercolor, header, headertext, top, catcolor, tabletext, text, borderwidth, tablewidth, tablespace, font, fontsize, altfont, altfontsize, replyimg, newtopicimg, boardimg, postscol, color1, color2) VALUES ('XMB2', '#ffffff', '#e3e3ea', '#eeeef6', '#404060', '#ffffff', '#505070', '#ffffff', '#ffffff', '#dedee6', '#000033', '#000022', '1', '90%', '4', 'Arial', '12px', 'Verdana', '10px', 'reply.gif', 'newtopic.gif', '', '2col', 'red', 'blue');

Error: Table 'hp.mx_eBoard_whosonline' doesn't exist
Query: INSERT INTO mx_eBoard_whosonline (username, ip, time, location) VALUES ('onlinerecord', '1', 0, 'PGEgaHJlZj1cImh0dHA6Ly93d3cubWFheC1kZXNpZ24uZGVcIiB0YXJnZXQ9XCJfYmxhbmtcIj48Zm9udCBzaXplPTA+PGk+cG93ZXJlZCBieSA8Yj5lQm9hcmQ8L2I+PC9pPjwvZm9udD48L2E+');

Error: Table 'hp.mx_eBoard_words' doesn't exist
Query: INSERT INTO mx_eBoard_words (find, replace1, id) VALUES ('damn', '****', 1);

Error: Table 'hp.mx_eBoard_words' doesn't exist
Query: INSERT INTO mx_eBoard_words (find, replace1, id) VALUES ('shit', '****', 2);

Error: Table 'hp.mx_eBoard_words' doesn't exist
Query: INSERT INTO mx_eBoard_words (find, replace1, id) VALUES ('*uups*', '****', 3);

Error: Table 'hp.mx_eBoard_words' doesn't exist
Query: INSERT INTO mx_eBoard_words (find, replace1, id) VALUES ('*uups*', '*****', 4);

Error: Table 'hp.mx_eBoard_words' doesn't exist
Query: INSERT INTO mx_eBoard_words (find, replace1, id) VALUES ('asshole', '***', 5);



Wenn ich ausserdem nach der Installation das Forum starten möchte kommt im Browser diese Meldung:

 Table 'hp.mx_eBoard_whosonline' doesn't exist
[Editiert am 12/4/2004 von BigBugg]

[Editiert am 12/4/2004 von BigBugg]

_Gerry_

CMS-Version: pragmaMx 0.1.11, 1.33.2.12.2.9/2009-05-10   
PHP-Version: 5.2.0-8+etch5~pu1
MySQL-Version: 5.0.32-Debian_7etch1
Server-Version: Apache/2.2.3 (Debian) mod_ssl/2.2.3 OpenSSL/0.9.8c

Future

Bitte Code Verkürzen, da der Thread so unübersichtlich wird ...
THX