Fehlerreport! Abhilfe?

[Jamiz]

Hi Leute,

Unter Administration>System is mir bei der Neuinstallation das aufgefallen:


Contenido Error Log
-------------------------------------------------------------------->

[07-Sep-2004 13:28:03] Invalid SQL: lock tables con_sequence write<br><br>
[07-Sep-2004 13:28:03] lock() failed.
[07-Sep-2004 13:28:03] cannot lock con_sequence - has it been created?
[07-Sep-2004 13:28:05] Invalid SQL: lock tables con_sequence write<br><br>
[07-Sep-2004 13:28:05] lock() failed.
[07-Sep-2004 13:28:05] cannot lock con_sequence - has it been created?
[07-Sep-2004 13:28:05] Invalid SQL: lock tables con_sequence write<br><br>
[07-Sep-2004 13:28:05] lock() failed.
[07-Sep-2004 13:28:05] cannot lock con_sequence - has it been created?
[07-Sep-2004 13:28:05] Invalid SQL: INSERT INTO con_user_prop
SET value = '',
user_id = '48a365b4ce1e322a55ae9017f3daf0c0',
type = 'backend',
name = 'lastlogintime',
iduserprop = '0'<br><br>
[07-Sep-2004 13:28:49] Invalid SQL: lock tables con_sequence write<br><br>
[07-Sep-2004 13:28:49] lock() failed.
[07-Sep-2004 13:28:49] cannot lock con_sequence - has it been created?
[07-Sep-2004 13:28:49] Invalid SQL: INSERT INTO
con_actionlog
SET
idlog = 0,
user_id = '48a365b4ce1e322a55ae9017f3daf0c0',
idclient = 1,
idlang = 1,
idaction = 328,
idcatart = '0',
logtimestamp = '2004-09-07 13:28:49'<br><br>
[07-Sep-2004 13:28:59] Invalid SQL: lock tables con_sequence write<br><br>
[07-Sep-2004 13:28:59] lock() failed.
[07-Sep-2004 13:28:59] cannot lock con_sequence - has it been created?
[07-Sep-2004 13:28:59] Invalid SQL: INSERT INTO
con_actionlog
SET
idlog = 0,
user_id = '48a365b4ce1e322a55ae9017f3daf0c0',
idclient = 1,
idlang = 1,
idaction = 327,
idcatart = '0',
logtimestamp = '2004-09-07 13:28:59'<br><br>
[07-Sep-2004 13:30:03] Invalid SQL: lock tables con_sequence write<br><br>
[07-Sep-2004 13:30:03] lock() failed.
[07-Sep-2004 13:30:03] cannot lock con_sequence - has it been created?
[07-Sep-2004 13:30:03] Invalid SQL: INSERT INTO
con_actionlog
SET
idlog = 0,
user_id = '48a365b4ce1e322a55ae9017f3daf0c0',
idclient = 1,
idlang = 1,
idaction = 18,
idcatart = '0',
logtimestamp = '2004-09-07 13:30:03'<br><br>
[07-Sep-2004 13:30:03] Invalid SQL: lock tables con_sequence write<br><br>
[07-Sep-2004 13:30:03] lock() failed.
[07-Sep-2004 13:30:03] cannot lock con_sequence - has it been created?
[07-Sep-2004 13:30:20] Invalid SQL: lock tables con_sequence write<br><br>
[07-Sep-2004 13:30:20] lock() failed.
[07-Sep-2004 13:30:20] cannot lock con_sequence - has it been created?
[07-Sep-2004 13:30:20] Invalid SQL: INSERT INTO
con_actionlog
SET
idlog = 0,
user_id = '48a365b4ce1e322a55ae9017f3daf0c0',
idclient = 1,
idlang = 1,
idaction = 347,
idcatart = '0',
logtimestamp = '2004-09-07 13:30:20'<br><br>
[07-Sep-2004 13:30:41] Invalid SQL: lock tables con_sequence write<br><br>
[07-Sep-2004 13:30:41] lock() failed.
[07-Sep-2004 13:30:41] cannot lock con_sequence - has it been created?
[07-Sep-2004 13:30:41] Invalid SQL: INSERT INTO
con_actionlog
SET
idlog = 0,
user_id = '48a365b4ce1e322a55ae9017f3daf0c0',
idclient = 1,
idlang = 1,
idaction = 347,
idcatart = '0',
logtimestamp = '2004-09-07 13:30:41'<br><br>
[07-Sep-2004 13:30:44] Invalid SQL: lock tables con_sequence write<br><br>
[07-Sep-2004 13:30:44] lock() failed.
[07-Sep-2004 13:30:44] cannot lock con_sequence - has it been created?
[07-Sep-2004 13:30:44] Invalid SQL: INSERT INTO
con_actionlog
SET
idlog = 0,
user_id = '48a365b4ce1e322a55ae9017f3daf0c0',
idclient = 1,
idlang = 1,
idaction = 347,
idcatart = '0',
logtimestamp = '2004-09-07 13:30:44'<br><br>
[07-Sep-2004 13:30:57] Invalid SQL: lock tables con_sequence write<br><br>
[07-Sep-2004 13:30:57] lock() failed.
[07-Sep-2004 13:30:57] cannot lock con_sequence - has it been created?
[07-Sep-2004 13:30:57] Invalid SQL: INSERT INTO
con_actionlog
SET
idlog = 0,
user_id = '48a365b4ce1e322a55ae9017f3daf0c0',
idclient = 1,
idlang = 1,
idaction = 347,
idcatart = '0',
logtimestamp = '2004-09-07 13:30:57'<br><br>
[07-Sep-2004 13:31:43] Invalid SQL: lock tables con_sequence write<br><br>
[07-Sep-2004 13:31:43] lock() failed.
[07-Sep-2004 13:31:43] cannot lock con_sequence - has it been created?
[07-Sep-2004 13:31:43] Invalid SQL: INSERT INTO
con_actionlog
SET
idlog = 0,
user_id = '48a365b4ce1e322a55ae9017f3daf0c0',
idclient = 1,
idlang = 1,
idaction = 328,
idcatart = '0',
logtimestamp = '2004-09-07 13:31:43'<br><br>
[07-Sep-2004 13:31:50] Invalid SQL: lock tables con_sequence write<br><br>
[07-Sep-2004 13:31:50] lock() failed.
[07-Sep-2004 13:31:50] cannot lock con_sequence - has it been created?
[07-Sep-2004 13:31:50] Invalid SQL: INSERT INTO
con_actionlog
SET
idlog = 0,
user_id = '48a365b4ce1e322a55ae9017f3daf0c0',
idclient = 1,
idlang = 1,
idaction = 23,
idcatart = '0',
logtimestamp = '2004-09-07 13:31:50'<br><br>
[07-Sep-2004 13:31:50] Invalid SQL: lock tables con_sequence write<br><br>
[07-Sep-2004 13:31:50] lock() failed.
[07-Sep-2004 13:31:50] cannot lock con_sequence - has it been created?
[07-Sep-2004 13:31:50] Invalid SQL: lock tables con_sequence write<br><br>
[07-Sep-2004 13:31:50] lock() failed.
[07-Sep-2004 13:31:50] cannot lock con_sequence - has it been created?
[07-Sep-2004 13:31:54] Invalid SQL: lock tables con_sequence write<br><br>
[07-Sep-2004 13:31:54] lock() failed.
[07-Sep-2004 13:31:54] cannot lock con_sequence - has it been created?
[07-Sep-2004 13:31:54] Invalid SQL: INSERT INTO
con_actionlog
SET
idlog = 0,
user_id = '48a365b4ce1e322a55ae9017f3daf0c0',
idclient = 1,
idlang = 1,
idaction = 23,
idcatart = '0',
logtimestamp = '2004-09-07 13:31:54'<br><br>
[07-Sep-2004 13:31:54] Invalid SQL: lock tables con_sequence write<br><br>
[07-Sep-2004 13:31:54] lock() failed.
[07-Sep-2004 13:31:54] cannot lock con_sequence - has it been created?
[07-Sep-2004 13:31:54] Invalid SQL: lock tables con_sequence write<br><br>
[07-Sep-2004 13:31:54] lock() failed.
[07-Sep-2004 13:31:54] cannot lock con_sequence - has it been created?
[07-Sep-2004 13:31:54] Invalid SQL: INSERT INTO con_template_conf
(idtplcfg, idtpl, author) VALUES
('0', '0', 'sysadmin')<br><br>
[07-Sep-2004 13:31:54] Invalid SQL: INSERT INTO con_template
(idtpl, idtplcfg, name, description, deletable, idlay, idclient, author, created, lastmodified) VALUES
('0', '0', 'EVB-KG', '', '1', '0', '1', 'sysadmin', '2004-09-07 13:31:54', '2004-09-07 13:31:54')<br><br>
[07-Sep-2004 13:32:32] Invalid SQL: lock tables con_sequence write<br><br>
[07-Sep-2004 13:32:32] lock() failed.
[07-Sep-2004 13:32:32] cannot lock con_sequence - has it been created?
[07-Sep-2004 13:33:03] Invalid SQL: lock tables con_sequence write<br><br>
[07-Sep-2004 13:33:03] lock() failed.
[07-Sep-2004 13:33:03] cannot lock con_sequence - has it been created?
[07-Sep-2004 13:33:03] Invalid SQL: INSERT INTO
con_actionlog
SET
idlog = 0,
user_id = '48a365b4ce1e322a55ae9017f3daf0c0',
idclient = 1,
idlang = 1,
idaction = 23,
idcatart = '0',
logtimestamp = '2004-09-07 13:33:03'<br><br>
[07-Sep-2004 13:33:03] Invalid SQL: lock tables con_sequence write<br><br>
[07-Sep-2004 13:33:03] lock() failed.
[07-Sep-2004 13:33:03] cannot lock con_sequence - has it been created?
[07-Sep-2004 13:33:03] Invalid SQL: lock tables con_sequence write<br><br>
[07-Sep-2004 13:33:03] lock() failed.
[07-Sep-2004 13:33:03] cannot lock con_sequence - has it been created?
[07-Sep-2004 13:33:03] Invalid SQL: INSERT INTO con_template_conf
(idtplcfg, idtpl, author) VALUES
('0', '0', 'sysadmin')<br><br>
[07-Sep-2004 13:33:03] Invalid SQL: INSERT INTO con_template
(idtpl, idtplcfg, name, description, deletable, idlay, idclient, author, created, lastmodified) VALUES
('0', '0', 'EVB-KG', '', '1', '0', '1', 'sysadmin', '2004-09-07 13:33:03', '2004-09-07 13:33:03')<br><br>

<--------------------------------------------------------------------


Contenido Upgrade Error Log
-------------------------------------------------------------------->

2004-Sep-Tue 13:25:14: error 1068 (Multiple primary key defined) - Invalid SQL: ALTER TABLE con_template CHANGE COLUMN idtpl idtpl int(10) NOT NULL DEFAULT '0' PRIMARY KEY<br><br>


<--------------------------------------------------------------------


Wie beeinträchtigt das mein System?

kann z.b. keine Module beim Template erstellen auswählen, so wie sie in der Beispiel Installation zu sehen waren.

Danke für die Hilfe.

Gruss Florian
[/code]

[Halchteranerin]

update log kannst Du ignorieren, weniger das errorlog mit lock tables. Wegen moegl. Beeintraechtigungen such im Forum nach lock tables (vieles wird nicht laufen, schaetze ich).

Gruss
Christa

[Jamiz]

Danke habs eben selbst gefunden! immer dieses Poster bevor sie im forum danach suchen!

Habe Grant und Lock Tables in der Db aktiviert, jetzt funktuniert es.

Trotzdem Danke

Gruss Flo

[Halchteranerin]

Habe Grant und Lock Tables in der Db aktiviert, jetzt funktuniert es.

Na, das war die einfache Variante. Die meisten koennen das nicht eben mal so aendern sondern sind auf die Gnade des Providers angewiesen.

Gruss
Christa

[JSommer]

wie ändere ich das?

[RonDog]

Habe Grant und Lock Tables in der Db aktiviert, jetzt funktuniert es.

Ich scheine die gleichen Probleme zu haben. Da ich einen Root-Server habe, kann ich mir das selbst ändern, doch der grosse Crack bin ich da auch nicht, deshalb die Bitte um kurze Anweisung. Danke.

[RonDog]

Denke, das hat sich erledigt:

folgende eingegeben:

Code: Alles auswählen

mysql
>GRANT ALL PRIVILEGES ON *.* TO webx@localhost IDENTIFIED BY 'passwort';

und nun scheint es ohne Fehlermeldungen zu funktionieren...

webx = mein username (/home/htdocs/webx/html/..) und mein Passwort verrate ich nicht