Mein Provider hat nun eine Servermigration durchgeführt auf PHP 5.0.1 bzw. PHP 4.3.8. Die Site läuft im Fontend auch problemlos. Allerdings habe ich festgetellt, dass im Backend nichts mehr wirklich funktioniert.
-> z.B Beispiel wenn ich eine neue Kategorie erfasse ist die ganze Navigation weg (auch im Frontend!)
Also habe ich ein Update auf die Version 4.4.4 durchgeführt.
1. erscheint eine riesige Fehlerliste im "Upgrade Error Log", was man ja ignorieren kann
2. besteht das Problem immer noch!
3. im error-log steht folgendes:
Code: Alles auswählen
[17-Sep-2004 12:37:36] Invalid SQL: lock tables con_sequence write<br><br>
[17-Sep-2004 12:37:36] lock() failed.
[17-Sep-2004 12:37:36] cannot lock con_sequence - has it been created?
[17-Sep-2004 12:37:36] Invalid SQL: INSERT INTO
con_actionlog
SET
idlog = 0,
user_id = '48a365b4ce1e322a55ae9017f3daf0c0',
idclient = 1,
idlang = 1,
idaction = 10,
idcatart = '0',
logtimestamp = '2004-09-17 12:37:36'<br><br>
[17-Sep-2004 12:37:44] Invalid SQL: lock tables con_sequence write<br><br>
[17-Sep-2004 12:37:44] lock() failed.
[17-Sep-2004 12:37:44] cannot lock con_sequence - has it been created?
[17-Sep-2004 12:37:44] Invalid SQL: INSERT INTO
con_actionlog
SET
idlog = 0,
user_id = '48a365b4ce1e322a55ae9017f3daf0c0',
idclient = 1,
idlang = 1,
idaction = 10,
idcatart = '0',
logtimestamp = '2004-09-17 12:37:44'<br><br>
[17-Sep-2004 12:37:44] Invalid SQL: lock tables con_sequence write<br><br>
[17-Sep-2004 12:37:44] lock() failed.
[17-Sep-2004 12:37:44] cannot lock con_sequence - has it been created?
[17-Sep-2004 12:37:44] Invalid SQL: lock tables con_sequence write<br><br>
[17-Sep-2004 12:37:44] lock() failed.
[17-Sep-2004 12:37:44] cannot lock con_sequence - has it been created?
[17-Sep-2004 12:37:44] Invalid SQL: lock tables con_sequence write<br><br>
[17-Sep-2004 12:37:44] lock() failed.
[17-Sep-2004 12:37:44] cannot lock con_sequence - has it been created?
[17-Sep-2004 12:37:44] Invalid SQL: INSERT INTO con_cat_lang (idcatlang, idcat, idlang, name, visible, public, idtplcfg) VALUES('0','0','3','Test','0','1','0')<br><br>
[17-Sep-2004 12:37:44] Invalid SQL: lock tables con_sequence write<br><br>
[17-Sep-2004 12:37:44] lock() failed.
[17-Sep-2004 12:37:44] cannot lock con_sequence - has it been created?
[17-Sep-2004 12:37:44] Invalid SQL: lock tables con_sequence write<br><br>
[17-Sep-2004 12:37:44] lock() failed.
[17-Sep-2004 12:37:44] cannot lock con_sequence - has it been created?
[17-Sep-2004 12:37:44] Invalid SQL: INSERT INTO con_cat_tree (idtree, idcat, level) VALUES ('0', '3', '1')<br><br>
[17-Sep-2004 12:37:44] Invalid SQL: lock tables con_sequence write<br><br>
[17-Sep-2004 12:37:44] lock() failed.
[17-Sep-2004 12:37:44] cannot lock con_sequence - has it been created?
[17-Sep-2004 12:37:44] Invalid SQL: INSERT INTO con_cat_tree (idtree, idcat, level) VALUES ('0', '8', '1')<br><br>
[17-Sep-2004 12:37:44] Invalid SQL: lock tables con_sequence write<br><br>
[17-Sep-2004 12:37:44] lock() failed.
[17-Sep-2004 12:37:44] cannot lock con_sequence - has it been created?
[17-Sep-2004 12:37:44] Invalid SQL: INSERT INTO con_cat_tree (idtree, idcat, level) VALUES ('0', '19', '1')<br><br>
[17-Sep-2004 12:37:44] Invalid SQL: lock tables con_sequence write<br><br>
[17-Sep-2004 12:37:44] lock() failed.
[17-Sep-2004 12:37:44] cannot lock con_sequence - has it been created?
[17-Sep-2004 12:37:44] Invalid SQL: INSERT INTO con_cat_tree (idtree, idcat, level) VALUES ('0', '20', '1')<br><br>
[17-Sep-2004 12:37:44] Invalid SQL: lock tables con_sequence write<br><br>
[17-Sep-2004 12:37:44] lock() failed.
[17-Sep-2004 12:37:44] cannot lock con_sequence - has it been created?
[17-Sep-2004 12:37:44] Invalid SQL: INSERT INTO con_cat_tree (idtree, idcat, level) VALUES ('0', '21', '1')<br><br>
[17-Sep-2004 12:37:44] Invalid SQL: lock tables con_sequence write<br><br>
[17-Sep-2004 12:37:44] lock() failed.
[17-Sep-2004 12:37:44] cannot lock con_sequence - has it been created?
[17-Sep-2004 12:37:44] Invalid SQL: INSERT INTO con_cat_tree (idtree, idcat, level) VALUES ('0', '22', '1')<br><br>
[17-Sep-2004 12:37:44] Invalid SQL: lock tables con_sequence write<br><br>
[17-Sep-2004 12:37:44] lock() failed.
[17-Sep-2004 12:37:44] cannot lock con_sequence - has it been created?
[17-Sep-2004 12:37:44] Invalid SQL: INSERT INTO con_cat_tree (idtree, idcat, level) VALUES ('0', '12', '0')<br><br>
[17-Sep-2004 12:37:44] Invalid SQL: lock tables con_sequence write<br><br>
[17-Sep-2004 12:37:44] lock() failed.
[17-Sep-2004 12:37:44] cannot lock con_sequence - has it been created?
[17-Sep-2004 12:37:44] Invalid SQL: INSERT INTO con_cat_tree (idtree, idcat, level) VALUES ('0', '2', '0')<br><br>
[17-Sep-2004 12:37:44] Invalid SQL: lock tables con_sequence write<br><br>
[17-Sep-2004 12:37:44] lock() failed.
[17-Sep-2004 12:37:44] cannot lock con_sequence - has it been created?
[17-Sep-2004 12:37:44] Invalid SQL: INSERT INTO con_cat_tree (idtree, idcat, level) VALUES ('0', '17', '1')<br><br>
[17-Sep-2004 12:37:44] Invalid SQL: lock tables con_sequence write<br><br>
[17-Sep-2004 12:37:44] lock() failed.
[17-Sep-2004 12:37:44] cannot lock con_sequence - has it been created?
[17-Sep-2004 12:37:44] Invalid SQL: INSERT INTO con_cat_tree (idtree, idcat, level) VALUES ('0', '4', '1')<br><br>
[17-Sep-2004 12:37:44] Invalid SQL: lock tables con_sequence write<br><br>
[17-Sep-2004 12:37:44] lock() failed.
[17-Sep-2004 12:37:44] cannot lock con_sequence - has it been created?
[17-Sep-2004 12:37:44] Invalid SQL: INSERT INTO con_cat_tree (idtree, idcat, level) VALUES ('0', '5', '1')<br><br>
[17-Sep-2004 12:37:44] Invalid SQL: lock tables con_sequence write<br><br>
[17-Sep-2004 12:37:44] lock() failed.
[17-Sep-2004 12:37:44] cannot lock con_sequence - has it been created?
[17-Sep-2004 12:37:44] Invalid SQL: INSERT INTO con_cat_tree (idtree, idcat, level) VALUES ('0', '26', '1')<br><br>
[17-Sep-2004 12:37:44] Invalid SQL: lock tables con_sequence write<br><br>
[17-Sep-2004 12:37:44] lock() failed.
[17-Sep-2004 12:37:44] cannot lock con_sequence - has it been created?
[17-Sep-2004 12:37:44] Invalid SQL: INSERT INTO con_cat_tree (idtree, idcat, level) VALUES ('0', '27', '1')<br><br>
[17-Sep-2004 12:37:44] Invalid SQL: lock tables con_sequence write<br><br>
[17-Sep-2004 12:37:44] lock() failed.
[17-Sep-2004 12:37:44] cannot lock con_sequence - has it been created?
[17-Sep-2004 12:37:44] Invalid SQL: INSERT INTO con_cat_tree (idtree, idcat, level) VALUES ('0', '23', '0')<br><br>
[17-Sep-2004 12:37:44] Invalid SQL: lock tables con_sequence write<br><br>
[17-Sep-2004 12:37:44] lock() failed.
[17-Sep-2004 12:37:44] cannot lock con_sequence - has it been created?
[17-Sep-2004 12:37:44] Invalid SQL: INSERT INTO con_cat_tree (idtree, idcat, level) VALUES ('0', '24', '1')<br><br>
[17-Sep-2004 12:43:00] Invalid SQL: lock tables con_sequence write<br><br>
[17-Sep-2004 12:43:00] lock() failed.
[17-Sep-2004 12:43:00] cannot lock con_sequence - has it been created?
[17-Sep-2004 12:43:00] Invalid SQL: INSERT INTO
con_actionlog
SET
idlog = 0,
user_id = '48a365b4ce1e322a55ae9017f3daf0c0',
idclient = 1,
idlang = 1,
idaction = 330,
idcatart = 0,
logtimestamp = '2004-09-17 12:43:00'<br><br>
[17-Sep-2004 12:43:08] Invalid SQL: lock tables con_sequence write<br><br>
[17-Sep-2004 12:43:08] lock() failed.
[17-Sep-2004 12:43:08] cannot lock con_sequence - has it been created?
[17-Sep-2004 12:43:08] Invalid SQL: INSERT INTO
con_actionlog
SET
idlog = 0,
user_id = '48a365b4ce1e322a55ae9017f3daf0c0',
idclient = 1,
idlang = 1,
idaction = 330,
idcatart = 0,
logtimestamp = '2004-09-17 12:43:08'<br><br>
[17-Sep-2004 12:44:04] Invalid SQL: lock tables con_sequence write<br><br>
[17-Sep-2004 12:44:04] lock() failed.
[17-Sep-2004 12:44:04] cannot lock con_sequence - has it been created?
[17-Sep-2004 12:44:04] Invalid SQL: INSERT INTO
con_actionlog
SET
idlog = 0,
user_id = '48a365b4ce1e322a55ae9017f3daf0c0',
idclient = 1,
idlang = 1,
idaction = 330,
idcatart = 0,
logtimestamp = '2004-09-17 12:44:04'<br><br>
[17-Sep-2004 12:52:09] Invalid SQL: lock tables con_sequence write<br><br>
[17-Sep-2004 12:52:09] lock() failed.
[17-Sep-2004 12:52:09] cannot lock con_sequence - has it been created?
[17-Sep-2004 12:52:09] Invalid SQL: INSERT INTO
con_actionlog
SET
idlog = 0,
user_id = '48a365b4ce1e322a55ae9017f3daf0c0',
idclient = 1,
idlang = 1,
idaction = 330,
idcatart = 0,
logtimestamp = '2004-09-17 12:52:09'<br><br>
[17-Sep-2004 13:09:45] Invalid SQL: lock tables con_sequence write<br><br>
[17-Sep-2004 13:09:45] lock() failed.
[17-Sep-2004 13:09:45] cannot lock con_sequence - has it been created?
[17-Sep-2004 13:09:45] Invalid SQL: INSERT INTO
con_actionlog
SET
idlog = 0,
user_id = '48a365b4ce1e322a55ae9017f3daf0c0',
idclient = 1,
idlang = 1,
idaction = 330,
idcatart = 0,
logtimestamp = '2004-09-17 13:09:45'<br><br>
[17-Sep-2004 13:59:14] Invalid SQL: lock tables con_sequence write<br><br>
[17-Sep-2004 13:59:14] lock() failed.
[17-Sep-2004 13:59:14] cannot lock con_sequence - has it been created?
[17-Sep-2004 13:59:14] Invalid SQL: INSERT INTO
con_actionlog
SET
idlog = 0,
user_id = '48a365b4ce1e322a55ae9017f3daf0c0',
idclient = 1,
idlang = 1,
idaction = 330,
idcatart = 0,
logtimestamp = '2004-09-17 13:59:14'<br><br>
[17-Sep-2004 13:59:30] Invalid SQL: lock tables con_sequence write<br><br>
[17-Sep-2004 13:59:30] lock() failed.
[17-Sep-2004 13:59:30] cannot lock con_sequence - has it been created?
[17-Sep-2004 13:59:30] Invalid SQL: INSERT INTO
con_actionlog
SET
idlog = 0,
user_id = '48a365b4ce1e322a55ae9017f3daf0c0',
idclient = 1,
idlang = 1,
idaction = 350,
idcatart = '0',
logtimestamp = '2004-09-17 13:59:30'<br><br>
Ich habe im Forum leider keine hilfreichen Beiträge dazu gefunden...
So wie es für mich aussieht, gibt's scheinbar ein Probleme bei einem Update, das auf diesen neuen Servern mit PHP 5.0.1/PHP 4.3.8 durchgeführt wird...
Hat jemand schon ähnliche Erfahrungen gemacht?
Für Hilfe bin ich sehr dankbar....
Uups...