Suche

[Snow2002]

Moin!
Heute bin ich mit einem Paket von 1&1 zu Yellohost umgezogen. Alle Daten wurden per FTP wieder hoch geladen und auch die Datenbank wurde von Yellohost eingespielt. Die Config.php habe ich auch geändert.
Außer dieser MEldung Table 'dps13130_1.{prefix}_sys_session' doesn't exist
passiert leider nix. Als Admin einloggen geht auch nicht... Das Ganze schaut so aus:
http://www.graffiti-dortmund.de/version2/html/index.php
Damit bin ich leider überfordert... Kann evtl. jemand helfen?

Gruß, Marcus

[onkel]

Hallo,

Ich glaube xxx_sys_session ist bei dir vorhanden nur beschädigt versuch mal zu reparieren,  wenn sie sich nicht reparieren lässt dann lösch sie und nimm die ich angehängt habe.

Anhängen geht hier nicht, dann nimm sie so

http://flophostlist.de/nuke_sys_session.sql

[Snow2002]

Hi Onkel!
Danke, die Fehlermeldung ist nun weg! Aber irgendwas stimmt da vorne und hinten noch nicht. die index.php oder admin.php kann man zwar aufrufen, aber Log ins werden nicht akzeptiert. Außerdem fehlt so ziemlich alles...?

[munzur]

Hi!

Also das die Datein per FTP alle  richtig raufgeladen wurden kann ich mir schon vorstellen.
Aber möglicherweisse hast du oder wer auch immer entweder keinen richtigen Backup von der DB gemacht oder die von Yellowhost haben beim aufspielen was falsch gemacht.

Ich weiss nicht was du verwendest aber vielleicht liegt es ja auch an den Encodern.

L.g

[Snow2002]

Mit den Encodern weiß ich nicht. Wenn man wenigstens Fehlermeldungen hätte, aber da taucht ja nicht eine Meldung auf?! Die Datenbank hat zumindest exat die Größe, die sie auch beim alten Provider hatte. Vergleichen kann ich sie aber auch nicht mehr weil 1&1 direkt alles dicht gemacht hat...

Gruß, Marcus

[munzur]

Hi!

Aktivier mal in der Config.php

Debug-Modus aktiv?  Ja  Nein
SQL-Fehler anzeigen? Ja  Nein
alle SQL-Anfragen anzeigen? Ja  Nein

Setzt die mal auf ja!


$mxConf['mxDebugService']    = "1";
$mxConf['mxSqlErrorDebug']   = "1";
$mxConf['mxSqlDebug']        = "1";


L.g

[Snow2002]

Hm..oh wei oh wei Gesagt, getan, mit folgendem Ergebnis:

Code Auswählen Erweitern


SQL query:
select main_module from nuke_main WHERE main_module <> ''


Error sql_query():
qry: select main_module from {prefix}_main WHERE main_module <> ''
descr: Table 'dps13130_1.{prefix}_main' doesn't exist ( mysql 1146 )
details:
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),


Error sql_fetch_row():
descr: mysql_fetch_row(): supplied argument is not a valid MySQL result resource
details:
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),


SQL query:
SELECT Count(sid) FROM nuke_stories WHERE (nuke_stories.ihome=0 OR nuke_stories.catid=0) AND (nuke_stories.alanguage LIKE 'german%' OR nuke_stories.alanguage='') AND nuke_stories.time <= now()


Error sql_query():
qry: SELECT Count(sid) FROM {prefix}_stories WHERE ({prefix}_stories.ihome=0 OR {prefix}_stories.catid=0) AND ({prefix}_stories.alanguage LIKE 'german%' OR {prefix}_stories.alanguage='') AND {prefix}_stories.time <= now()
descr: Table 'dps13130_1.{prefix}_stories' doesn't exist ( mysql 1146 )
details:
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),


Error sql_fetch_row():
descr: mysql_fetch_row(): supplied argument is not a valid MySQL result resource
details:
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),


SQL query:
SELECT nuke_stories.sid, nuke_stories.informant, nuke_stories.title, nuke_stories.hometext, nuke_stories.bodytext, nuke_stories.comments, nuke_stories.counter, nuke_stories.notes, nuke_stories.time, nuke_stories.alanguage, nuke_stories.acomm, nuke_stories.aid, nuke_stories.score, nuke_stories.ratings, nuke_stories.topic, nuke_topics.topicname, nuke_topics.topicimage, nuke_topics.topictext, nuke_stories_cat.catid, nuke_stories_cat.title AS cattitle, nuke_authors.url, nuke_authors.email FROM ((nuke_stories LEFT JOIN nuke_stories_cat ON nuke_stories.catid = nuke_stories_cat.catid) LEFT JOIN nuke_topics ON nuke_stories.topic = nuke_topics.topicid) LEFT JOIN nuke_authors ON nuke_stories.aid = nuke_authors.aid WHERE (nuke_stories.ihome=0 OR nuke_stories.catid=0) AND (nuke_stories.alanguage LIKE 'german%' OR nuke_stories.alanguage='') AND nuke_stories.time <= now() ORDER BY nuke_stories.time DESC LIMIT -4, 4


Error sql_query():
qry: SELECT {prefix}_stories.sid, {prefix}_stories.informant, {prefix}_stories.title, {prefix}_stories.hometext, {prefix}_stories.bodytext, {prefix}_stories.comments, {prefix}_stories.counter, {prefix}_stories.notes, {prefix}_stories.time, {prefix}_stories.alanguage, {prefix}_stories.acomm, {prefix}_stories.aid, {prefix}_stories.score, {prefix}_stories.ratings, {prefix}_stories.topic, {prefix}_topics.topicname, {prefix}_topics.topicimage, {prefix}_topics.topictext, {prefix}_stories_cat.catid, {prefix}_stories_cat.title AS cattitle, {prefix}_authors.url, {prefix}_authors.email FROM (({prefix}_stories LEFT JOIN {prefix}_stories_cat ON {prefix}_stories.catid = {prefix}_stories_cat.catid) LEFT JOIN {prefix}_topics ON {prefix}_stories.topic = {prefix}_topics.topicid) LEFT JOIN {prefix}_authors ON {prefix}_stories.aid = {prefix}_authors.aid WHERE ({prefix}_stories.ihome=0 OR {prefix}_stories.catid=0) AND ({prefix}_stories.alanguage LIKE 'german%' OR {prefix}_stories.alanguage='') AND {prefix}_stories.time <= now() ORDER BY {prefix}_stories.time DESC LIMIT -4, 4
descr: Table 'dps13130_1.{prefix}_stories' doesn't exist ( mysql 1146 )
details:
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),


Error sql_fetch_array():
descr: mysql_fetch_array(): supplied argument is not a valid MySQL result resource
details:
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),


SQL query:
REPLACE INTO nuke_tracking (tracktime, ip, uid, server, referer, requrl, trackid) VALUES ('2005-08-24 20:30:43', '80.145.5.226', '', 'www.graffitidortmund.de', '', '/version2/html/index.php', '050824194037')


Error sql_query():
qry: REPLACE INTO {prefix}_tracking (tracktime, ip, uid, server, referer, requrl, trackid) VALUES ('2005-08-24 20:30:43', '80.145.5.226', '', 'www.graffitidortmund.de', '', '/version2/html/index.php', '050824194037')
descr: Table 'dps13130_1.{prefix}_tracking' doesn't exist ( mysql 1146 )
details:
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),


SQL query:
update nuke_counter set count=count+1 where (type='total' and var='hits') or (var='MSIE' and type='browser') or (var='Windows' and type='os')


Error sql_query():
qry: update {prefix}_counter set count=count+1 where (type='total' and var='hits') or (var='MSIE' and type='browser') or (var='Windows' and type='os')
descr: Table 'dps13130_1.{prefix}_counter' doesn't exist ( mysql 1146 )
details:
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),


SQL query:
select count(hour) from nuke_stats where (year='2005') and (month='8') and (date='24')


Error sql_query():
qry: select count(hour) from {prefix}_stats where (year='2005') and (month='8') and (date='24')
descr: Table 'dps13130_1.{prefix}_stats' doesn't exist ( mysql 1146 )
details:
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),


Error sql_fetch_row():
descr: mysql_fetch_row(): supplied argument is not a valid MySQL result resource
details:
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),


SQL query:
insert into nuke_stats values('2005', '8', '24', '0', '0')


Error sql_query():
qry: insert into {prefix}_stats values('2005', '8', '24', '0', '0')
descr: Table 'dps13130_1.{prefix}_stats' doesn't exist ( mysql 1146 )
details:
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),


SQL query:
insert into nuke_stats values('2005', '8', '24', '1', '0')


Error sql_query():
qry: insert into {prefix}_stats values('2005', '8', '24', '1', '0')
descr: Table 'dps13130_1.{prefix}_stats' doesn't exist ( mysql 1146 )
details:
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),


SQL query:
insert into nuke_stats values('2005', '8', '24', '2', '0')


Error sql_query():
qry: insert into {prefix}_stats values('2005', '8', '24', '2', '0')
descr: Table 'dps13130_1.{prefix}_stats' doesn't exist ( mysql 1146 )
details:
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),


SQL query:
insert into nuke_stats values('2005', '8', '24', '3', '0')


Error sql_query():
qry: insert into {prefix}_stats values('2005', '8', '24', '3', '0')
descr: Table 'dps13130_1.{prefix}_stats' doesn't exist ( mysql 1146 )
details:
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),


SQL query:
insert into nuke_stats values('2005', '8', '24', '4', '0')


Error sql_query():
qry: insert into {prefix}_stats values('2005', '8', '24', '4', '0')
descr: Table 'dps13130_1.{prefix}_stats' doesn't exist ( mysql 1146 )
details:
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),


SQL query:
insert into nuke_stats values('2005', '8', '24', '5', '0')


Error sql_query():
qry: insert into {prefix}_stats values('2005', '8', '24', '5', '0')
descr: Table 'dps13130_1.{prefix}_stats' doesn't exist ( mysql 1146 )
details:
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),


SQL query:
insert into nuke_stats values('2005', '8', '24', '6', '0')


Error sql_query():
qry: insert into {prefix}_stats values('2005', '8', '24', '6', '0')
descr: Table 'dps13130_1.{prefix}_stats' doesn't exist ( mysql 1146 )
details:
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),


SQL query:
insert into nuke_stats values('2005', '8', '24', '7', '0')


Error sql_query():
qry: insert into {prefix}_stats values('2005', '8', '24', '7', '0')
descr: Table 'dps13130_1.{prefix}_stats' doesn't exist ( mysql 1146 )
details:
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),


SQL query:
insert into nuke_stats values('2005', '8', '24', '8', '0')


Error sql_query():
qry: insert into {prefix}_stats values('2005', '8', '24', '8', '0')
descr: Table 'dps13130_1.{prefix}_stats' doesn't exist ( mysql 1146 )
details:
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),


SQL query:
insert into nuke_stats values('2005', '8', '24', '9', '0')


Error sql_query():
qry: insert into {prefix}_stats values('2005', '8', '24', '9', '0')
descr: Table 'dps13130_1.{prefix}_stats' doesn't exist ( mysql 1146 )
details:
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),


SQL query:
insert into nuke_stats values('2005', '8', '24', '10', '0')


Error sql_query():
qry: insert into {prefix}_stats values('2005', '8', '24', '10', '0')
descr: Table 'dps13130_1.{prefix}_stats' doesn't exist ( mysql 1146 )
details:
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),


SQL query:
insert into nuke_stats values('2005', '8', '24', '11', '0')


Error sql_query():
qry: insert into {prefix}_stats values('2005', '8', '24', '11', '0')
descr: Table 'dps13130_1.{prefix}_stats' doesn't exist ( mysql 1146 )
details:
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),


SQL query:
insert into nuke_stats values('2005', '8', '24', '12', '0')


Error sql_query():
qry: insert into {prefix}_stats values('2005', '8', '24', '12', '0')
descr: Table 'dps13130_1.{prefix}_stats' doesn't exist ( mysql 1146 )
details:
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),


SQL query:
insert into nuke_stats values('2005', '8', '24', '13', '0')


Error sql_query():
qry: insert into {prefix}_stats values('2005', '8', '24', '13', '0')
descr: Table 'dps13130_1.{prefix}_stats' doesn't exist ( mysql 1146 )
details:
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),


SQL query:
insert into nuke_stats values('2005', '8', '24', '14', '0')


Error sql_query():
qry: insert into {prefix}_stats values('2005', '8', '24', '14', '0')
descr: Table 'dps13130_1.{prefix}_stats' doesn't exist ( mysql 1146 )
details:
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),


SQL query:
insert into nuke_stats values('2005', '8', '24', '15', '0')


Error sql_query():
qry: insert into {prefix}_stats values('2005', '8', '24', '15', '0')
descr: Table 'dps13130_1.{prefix}_stats' doesn't exist ( mysql 1146 )
details:
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),


SQL query:
insert into nuke_stats values('2005', '8', '24', '16', '0')


Error sql_query():
qry: insert into {prefix}_stats values('2005', '8', '24', '16', '0')
descr: Table 'dps13130_1.{prefix}_stats' doesn't exist ( mysql 1146 )
details:
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),


SQL query:
insert into nuke_stats values('2005', '8', '24', '17', '0')


Error sql_query():
qry: insert into {prefix}_stats values('2005', '8', '24', '17', '0')
descr: Table 'dps13130_1.{prefix}_stats' doesn't exist ( mysql 1146 )
details:
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),


SQL query:
insert into nuke_stats values('2005', '8', '24', '18', '0')


Error sql_query():
qry: insert into {prefix}_stats values('2005', '8', '24', '18', '0')
descr: Table 'dps13130_1.{prefix}_stats' doesn't exist ( mysql 1146 )
details:
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),


SQL query:
insert into nuke_stats values('2005', '8', '24', '19', '0')


Error sql_query():
qry: insert into {prefix}_stats values('2005', '8', '24', '19', '0')
descr: Table 'dps13130_1.{prefix}_stats' doesn't exist ( mysql 1146 )
details:
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),


SQL query:
insert into nuke_stats values('2005', '8', '24', '20', '0')


Error sql_query():
qry: insert into {prefix}_stats values('2005', '8', '24', '20', '0')
descr: Table 'dps13130_1.{prefix}_stats' doesn't exist ( mysql 1146 )
details:
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),


SQL query:
insert into nuke_stats values('2005', '8', '24', '21', '0')


Error sql_query():
qry: insert into {prefix}_stats values('2005', '8', '24', '21', '0')
descr: Table 'dps13130_1.{prefix}_stats' doesn't exist ( mysql 1146 )
details:
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),


SQL query:
insert into nuke_stats values('2005', '8', '24', '22', '0')


Error sql_query():
qry: insert into {prefix}_stats values('2005', '8', '24', '22', '0')
descr: Table 'dps13130_1.{prefix}_stats' doesn't exist ( mysql 1146 )
details:
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),


SQL query:
insert into nuke_stats values('2005', '8', '24', '23', '0')


Error sql_query():
qry: insert into {prefix}_stats values('2005', '8', '24', '23', '0')
descr: Table 'dps13130_1.{prefix}_stats' doesn't exist ( mysql 1146 )
details:
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),


SQL query:
update nuke_stats set hits=hits+1 where (year='2005') and (month='8') and (date='24') and (hour='20')


Error sql_query():
qry: update {prefix}_stats set hits=hits+1 where (year='2005') and (month='8') and (date='24') and (hour='20')
descr: Table 'dps13130_1.{prefix}_stats' doesn't exist ( mysql 1146 )
details:
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),


SQL query:
LOCK TABLES nuke_visitors WRITE


SQL query:
REPLACE INTO nuke_visitors (time, ip, module, url, uid) VALUES (1124908243, '80.145.5.226', 'Home', '/version2/html/index.php', 0)


Error sql_query():
qry: REPLACE INTO {prefix}_visitors (time, ip, module, url, uid) VALUES (1124908243, '80.145.5.226', 'Home', '/version2/html/index.php', 0)
descr: Table 'dps13130_1.{prefix}_visitors' doesn't exist ( mysql 1146 )
details:
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),


SQL query:
UNLOCK TABLES

ACHTUNG!
Ein Server-Umzug steht kurz bevor. Dadurch bedingt kann es in den nächsten Tagen zu Störungen und zeitweisem Totalausfall kommen. Wir bitten um Verständnis...



SQL query:
select mid, title, content, `date`, expire, view FROM nuke_message WHERE active=1 AND title <> '' AND content <> '' AND (mlanguage='german' OR mlanguage='') ORDER BY `date` DESC


Error sql_query():
qry: select mid, title, content, `date`, expire, view FROM {prefix}_message WHERE active=1 AND title <> '' AND content <> '' AND (mlanguage='german' OR mlanguage='') ORDER BY `date` DESC
descr: Table 'dps13130_1.{prefix}_message' doesn't exist ( mysql 1146 )
details:
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),


SQL query:
SELECT * FROM nuke_blocks WHERE (active=1) AND ((blanguage='german' OR blanguage='')) AND ((view = 0) OR (view = 3)) ORDER BY position, weight ASC


Error sql_query():
qry: SELECT * FROM {prefix}_blocks WHERE (active=1) AND ((blanguage='german' OR blanguage='')) AND ((view = 0) OR (view = 3)) ORDER BY position, weight ASC
descr: Table 'dps13130_1.{prefix}_blocks' doesn't exist ( mysql 1146 )
details:
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),


SQL query:
SELECT m.mid, m.title FROM nuke_modules AS m LEFT JOIN nuke_groups_modules AS g ON m.mid = g.module_id WHERE ((title = 'News') OR (view = 0 AND active=1) OR (view = 3 AND active=1)) ORDER BY m.title ASC


Error sql_query():
qry: SELECT m.mid, m.title FROM {prefix}_modules AS m LEFT JOIN {prefix}_groups_modules AS g ON m.mid = g.module_id WHERE ((title = 'News') OR (view = 0 AND active=1) OR (view = 3 AND active=1)) ORDER BY m.title ASC
descr: Table 'dps13130_1.{prefix}_modules' doesn't exist ( mysql 1146 )
details:
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),
file:  # line:   0, cmd: (),

Home



Sorry, keine Informationen in diesem Themenbereich.

[ News Inhalt | Thema auswählen ]

[ Zurück ]

Alle Logos und Warenzeichen auf dieser Seite sind Eigentum der jeweiligen Besitzer und Lizenzhalter.
Im übrigen gilt Haftungsausschluss. Weitere Details finden Sie im Impressum.
Die Artikel sind geistiges Eigentum des/der jeweiligen Autoren, alles andere © 2005 by Graffiti-Dortmund - Dortmunder Graffiti Community
Diese Webseite basiert auf vkpMx 2.1.b ©

Seitenerstellung in 0.0602 Sekunden, mit 35 Datenbank-Abfragen 



Fehlen irgendwie die Tabellen alle, oder irre ich mich da?

Gruß, Marcus

[munzur]

Hi!

Wie sieht den deine config file aus, bist sicher das du den Prefix richtig hast?

L.g

[Snow2002]

Hi!
die sieht so aus:

Code Auswählen Erweitern

<?php // write with: $Id: settings.php,v 1.2 2005/06/05 18:46:17 Andreas Ellsel Exp $
/*******************************************************************/
/* vkpMx Content Management System Platform                  */
/* ============================                                    */
/* Copyright (C) 2004 by the vkpMx & pragmaMx Developer Team       */
/* email:        team@pragmamx.org                                 */
/* homepage:     http://www.pragmaMx.de & http://www.pragmaMx.org  */
/*******************************************************************/

// config.php ID //////////////////////
$mxConf['config_id']     = '233';
$mxConf['configtime_id'] = '1124702116';

######################################################################
# This module is to configure the main options for your site
######################################################################
# Database & System Config
#
# dbhost:       Database Hostname      (ask your Provider)
# dbname:       Database Name          (ask your Provider)
# dbuname:      Database Username      (ask your Provider)
# dbpass:       Database User-Password (ask your Provider)
# $prefix:      Your Database table's prefix
# $user_prefix: Your Users' Database table's prefix (To share it)
######################################################################

$mxConf['dbhost']      = "localhost";
$mxConf['dbname']      = "dps13130_1";
$mxConf['dbuname']     = "dps13130";
$mxConf['dbpass']      = "xxxxxxxxx";
$mxConf['prefix']      = "nuke";
$mxConf['user_prefix'] = "nuke";

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

[jubilee]

Hallo !
Ich hab fast schon den Einfruck, das er mit dem Konstrukt ${prefix} nix anfangen kann und nicht erkennt
das damit die Variable $prefix gemeint ist ....

BTW:
Ich hab mal die Datenbank-Zugangsdaten aus deinem Post gelöscht. Muss ja nicht jeder wissen

MfG
jubilee

[jubilee]

Ich hab mal die Datenbank-Zugangsdaten aus deinem Post gelöscht. Muss ja nicht jeder wissen

.
.
.

$mxConf['dbpass']      = "xxxxxxxxx";

Heh heh .... hat er doch noch selbst gemerkt

[munzur]

Heh heh .... hat er doch noch selbst gemerkt

Nein das war ich

L.g

[Snow2002]

hehe..Danke euch beiden. Also das mit dem Prefix das kommt mir auch komisch vor...Blicke da echt net mehr durch. Nützen einem von euch evtl. Zugangsdaten was oder so?

[BowlingX]

Ich hab fast schon den Einfruck, das er mit dem Konstrukt ${prefix} nix anfangen kann und nicht erkennt
das damit die Variable $prefix gemeint ist ....

Das der Debug Modus die Variable $prefix bei einem SQL_ERROR anzeigt ist normal. Ich kann mir nur vorstellen das die Datenbank nicht in Ordnung ist..

[munzur]

Hi!

Mach mal testhalber eine frische Testinstallation, viellecht werden wir draus kluger.

L.g

[RiotheRat]

Wenn das Webspace bei Yellohost ist, was die Vermutung wegen "dps..." naheliegen lässt, gibts mit {prefix} keine Probleme. Da muss irgendwie was anderes rumhupen ...

Wie wurde die DB übertragen? Der Prefix "nuke" legt nahe dass es eine bestehende Installation war / ist ...

RtR

[Andi]

Moin

Also, das {prefix} in 'dps13130_1.{prefix}_sys_session' ist in der Anzeige schon richtig.
das ist eine Sicherheitsfunktion, die verhindert, dass der "wahre prefix" in Fehlermeldungen angezeigt wird.

Sicher, dass die anderen Zugangsdaten stimmen, bzw. dass der angegebene prefix zu den Tabellen passt?

Was anderes?
Warum setzt du da ein vkpMx neu auf und steigst nicht gleich um?

[Andi]

Sodale...

lege mal im mx-Root eine php Datei mit folgendem Inhalt an und rufe sie auf:

Code Auswählen Erweitern



<?php
include('config.php');
$dbi = mysql_connect($dbhost, $dbuname, $dbpass);
mysql_select_db($dbname, $dbi);
$result=mysql_query("SHOW TABLES;");

print '<h3>meine prefixe:</h3>';
print 'prefix:&nbsp;&nbsp;&nbsp;'.$prefix.'<br>';
print 'user_prefix:&nbsp;&nbsp;&nbsp;'.$user_prefix.'<br>';

print '<h3>meine Tabellen:</h3>';
while(list($tablename)=mysql_fetch_row($result)){
print $tablename.'<br>';
}
?>



sehen, was kommt....

[Snow2002]

Guten Morgen!
Also das Ganze liegt bei YelloHost. Ich wollte mit einem bestehendem Projekt von 1+1 umziehen. Das mit der Datei mache ich gleich mal, Andi... Mal sehen was bei rum kommt. Natürlich kann ich auch ein neues MX instalieren, aber wenn mein Datenbank Backup wirklich irgendwelche heftigen Bugs hat nützt das auch nix oder evtl doch? Am Provider wird es nicht liegen, die Leute da scheinen zu wissen was sie tun (im Gegensatz zu mir manchmal*seufz*).

Grzß, Marcus

[Snow2002]

Hallo Andi!
Das hier kam dabei raus:

Code Auswählen Erweitern

meine prefixe:
prefix:   nuke
user_prefix:   nuke

meine Tabellen:
bb1_access
bb1_announcements
bb1_attachments
bb1_avatars
bb1_bbcodes
bb1_boards
bb1_events
bb1_folders
bb1_groups
bb1_icons
bb1_moderators
bb1_optiongroups
bb1_options
bb1_permissions
bb1_polloptions
bb1_polls
bb1_posts
bb1_privatemessage
bb1_profilefields
bb1_ranks
bb1_searchs
bb1_sessions
bb1_smilies
bb1_styles
bb1_subscribeboards
bb1_subscribethreads
bb1_subvariablepacks
bb1_subvariables
bb1_templatepacks
bb1_templates
bb1_threads
bb1_userfields
bb1_users
bb1_votes
bb1_wordlist
bb1_wordmatch
mx29770_add_adds
mx29770_add_broken
mx29770_add_categories
mx29770_authors
mx29770_avatar
mx29770_banner
mx29770_bannerclient
mx29770_blocks
mx29770_catagories
mx29770_chatmessage
mx29770_chatroom
mx29770_chatsmile
mx29770_chatsound
mx29770_chatuser
mx29770_comments
mx29770_counter
mx29770_cpg141_albums
mx29770_cpg141_banned
mx29770_cpg141_bridge
mx29770_cpg141_categories
mx29770_cpg141_comments
mx29770_cpg141_config
mx29770_cpg141_dict
mx29770_cpg141_ecards
mx29770_cpg141_exif
mx29770_cpg141_favpics
mx29770_cpg141_filetypes
mx29770_cpg141_hit_stats
mx29770_cpg141_pictures
mx29770_cpg141_plugins
mx29770_cpg141_sessions
mx29770_cpg141_temp_data
mx29770_cpg141_usergroups
mx29770_cpg141_users
mx29770_cpg141_vote_stats
mx29770_cpg141_votes
mx29770_downloads_categories
mx29770_downloads_downloads
mx29770_downloads_editorials
mx29770_downloads_modrequest
mx29770_downloads_newdownload
mx29770_downloads_votedata
mx29770_eBoard_banned
mx29770_eBoard_forums
mx29770_eBoard_links
mx29770_eBoard_members
mx29770_eBoard_posts
mx29770_eBoard_ranks
mx29770_eBoard_smilies
mx29770_eBoard_themes
mx29770_eBoard_threads
mx29770_eBoard_whosonline
mx29770_eBoard_words
mx29770_eboard_ranks
mx29770_encyclopedia
mx29770_encyclopedia_text
mx29770_ephem
mx29770_events
mx29770_faqanswer
mx29770_faqcategories
mx29770_faqnew
mx29770_gallery_categories
mx29770_gallery_comments
mx29770_gallery_media_class
mx29770_gallery_media_types
mx29770_gallery_pictures
mx29770_gallery_pictures_newpicture
mx29770_gallery_rate_check
mx29770_gallery_template_types
mx29770_groups_access
mx29770_groups_blocks
mx29770_groups_modules
mx29770_headlines
mx29770_hip_headlines
mx29770_links_categories
mx29770_links_editorials
mx29770_links_links
mx29770_links_modrequest
mx29770_links_newlink
mx29770_links_votedata
mx29770_love_oracle
mx29770_main
mx29770_message
mx29770_modules
mx29770_ne_paragraphs
mx29770_ne_stories
mx29770_newsletter
mx29770_newsletter_send
mx29770_newsletter_sendto
mx29770_nukebook
mx29770_nukebook_queue
mx29770_pages
mx29770_pages_categories
mx29770_pinwand
mx29770_poll_check
mx29770_poll_data
mx29770_poll_desc
mx29770_pollcomments
mx29770_priv_msgs
mx29770_queue
mx29770_quiecom_shoutblock
mx29770_quiecom_shoutblock_censor
mx29770_quiecom_shoutblock_conf
mx29770_quiecom_shoutblock_emoticons
mx29770_quiecom_shoutblock_ipblock
mx29770_quiecom_shoutblock_nameblock
mx29770_quotes
mx29770_ranks
mx29770_recommend
mx29770_referer
mx29770_related
mx29770_reviews
mx29770_reviews_comments
mx29770_seccont
mx29770_sections
mx29770_securelog
mx29770_siteupdate
mx29770_smf_attachments
mx29770_smf_banned
mx29770_smf_board_permissions
mx29770_smf_boards
mx29770_smf_calendar
mx29770_smf_calendar_holidays
mx29770_smf_categories
mx29770_smf_collapsed_categories
mx29770_smf_im_recipients
mx29770_smf_instant_messages
mx29770_smf_log_actions
mx29770_smf_log_activity
mx29770_smf_log_banned
mx29770_smf_log_boards
mx29770_smf_log_errors
mx29770_smf_log_floodcontrol
mx29770_smf_log_karma
mx29770_smf_log_mark_read
mx29770_smf_log_notify
mx29770_smf_log_online
mx29770_smf_log_polls
mx29770_smf_log_search
mx29770_smf_log_topics
mx29770_smf_membergroups
mx29770_smf_members
mx29770_smf_messages
mx29770_smf_moderators
mx29770_smf_permissions
mx29770_smf_poll_choices
mx29770_smf_polls
mx29770_smf_sessions
mx29770_smf_settings
mx29770_smf_smileys
mx29770_smf_themes
mx29770_smf_topics
mx29770_spchat_access
mx29770_spchat_colors
mx29770_spchat_config
mx29770_spchat_event
mx29770_spchat_groups
mx29770_spchat_grpmember
mx29770_spchat_kicklist
mx29770_spchat_log
mx29770_spchat_message
mx29770_spchat_profile
mx29770_spchat_room
mx29770_spchat_smile
mx29770_spchat_sound
mx29770_spchat_user
mx29770_stats
mx29770_stories
mx29770_stories_cat
mx29770_topics
mx29770_tracking
mx29770_userguest
mx29770_userpoints
mx29770_users
mx29770_visitors
nuke_arcade_asteroids
nuke_arcade_banned_ip
nuke_arcade_invaders
nuke_arcade_pacman
nuke_arcade_snake1
nuke_arcade_snake2
nuke_arcade_snake3
nuke_arcade_tetris
nuke_authors
nuke_eBoard_words
nuke_priv_msgs
nuke_privmsgs
nuke_quiecom_shoutblock
nuke_quiecom_shoutblock_censor
nuke_quiecom_shoutblock_conf
nuke_quiecom_shoutblock_emoticons
nuke_quiecom_shoutblock_ipblock
nuke_quiecom_shoutblock_nameblock
nuke_sys_session
recipes_categories
recipes_recipes