CONTENIDO Forum

Das Diskussionsforum zum Open Source Content Management System
https://forum.contenido.org/

Fehlerreport! Abhilfe?

https://forum.contenido.org/viewtopic.php?f=110&t=5568

Seite 1 von 1

Fehlerreport! Abhilfe?

Verfasst: Di 7. Sep 2004, 14:42
von 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]

Verfasst: Di 7. Sep 2004, 16:11
von 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

!

Verfasst: Di 7. Sep 2004, 16:14
von 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

Re: !

Verfasst: Di 7. Sep 2004, 16:15
von Halchteranerin
Jamiz hat geschrieben: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

Verfasst: Mi 22. Sep 2004, 14:23
von JSommer
wie ändere ich das?

Verfasst: Do 23. Sep 2004, 00:30
von 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.

Verfasst: Do 23. Sep 2004, 01:17
von 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 :roll:
Alle Zeiten sind UTC+01:00
Seite 1 von 1

Powered by phpBB® Forum Software © phpBB Limited

Deutsche Übersetzung durch phpBB.de