Nur Text | Text mit Bildern

pragmaMx Support Forum

pragmaMx => Installation & Update => Thema gestartet von: BigBugg am 12 April 2004, 02:07:37

Titel: SQL Error nach (während) installation, komisch!?!
Beitrag von: BigBugg am 12 April 2004, 02:07:37
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?


Code Auswählen

Die Datenbank 'hp' ist vorhanden.

Die Tabellen wurden erstellt (88 von 88)


und dann steht

Code Auswählen

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:

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

[Editiert am 12/4/2004 von BigBugg]
Titel: Re: SQL Error nach (während) installation, komisch!?!
Beitrag von: _Gerry_ am 12 April 2004, 02:32:02
http://www.pragmamx.org/modules.php?name=eBoard&file=viewthread&tid=9318

http://www.pragmamx.org/modules.php?name=eBoard&file=viewthread&tid=8075
Titel: Re: SQL Error nach (während) installation, komisch!?!
Beitrag von: Future am 12 April 2004, 02:41:53
Bitte Code Verkürzen, da der Thread so unübersichtlich wird ...
THX
Nur Text | Text mit Bildern