Error nach Update auf 1.3

justin81

Hi,

nach dem Update kann sich niemand mehr einloggen.
Folgende Meldung kommt:

Database error : Query error: 'UPDATE isys_user_session SET isys_user_session__isys_obj__id ='' WHERE isys_user_session__php_sid='54l1c4g205ec2iqeaplcps7m01';': Cannot add or update a child row: a foreign key constraint fails (idoit_data.isys_user_session, CONSTRAINT isys_user_session_ibfk_2 FOREIGN KEY (isys_user_session__isys_obj__id) REFERENCES isys_obj (isys_obj__id) ON DELETE CASCADE ON UPDA)

Hat jemand ähnliche Probleme?

yoda

Guten Morgen,

auch wir haben das Problem das sich keiner mehr anmelden kann.

In der apache error.log findet sich bei uns folgender Fehler

[Tue Mar 11 09:11:56 2014] [error] [client xxx.xxx.xxx.xxx] PHP Warning:  mysql_real_escape_string(): Access denied for user 'www-data'@'localhost' (using password: NO) in /var/www/idoit/src/classes/components/isys_component_database_mysqli.class.php on line 162, referer: http://xxx.xxx.xxx.xxx/idoit/
[Tue Mar 11 09:11:56 2014] [error] [client xxx.xxx.xxx.xxx] PHP Warning:  mysql_real_escape_string(): A link to the server could not be established in /var/www/idoit/src/classes/components/isys_component_database_mysqli.class.php on line 162, referer: http://xxx.xxx.xxx.xxx/idoit/
[Tue Mar 11 09:11:56 2014] [error] [client xxx.xxx.xxx.xxx] PHP Warning:  mysql_real_escape_string(): Access denied for user 'www-data'@'localhost' (using password: NO) in /var/www/idoit/src/classes/components/isys_component_database_mysqli.class.php on line 162, referer: http://xxx.xxx.xxx.xxx/idoit/
[Tue Mar 11 09:11:56 2014] [error] [client xxx.xxx.xxx.xxx] PHP Warning:  mysql_real_escape_string(): A link to the server could not be established in /var/www/idoit/src/classes/components/isys_component_database_mysqli.class.php on line 162, referer: http://xxx.xxx.xxx.xxx/idoit/
[Tue Mar 11 09:11:56 2014] [error] [client xxx.xxx.xxx.xxx] PHP Warning:  mysql_real_escape_string(): Access denied for user 'www-data'@'localhost' (using password: NO) in /var/www/idoit/src/classes/components/isys_component_database_mysqli.class.php on line 162, referer: http://xxx.xxx.xxx.xxx/idoit/
[Tue Mar 11 09:11:56 2014] [error] [client xxx.xxx.xxx.xxx] PHP Warning:  mysql_real_escape_string(): A link to the server could not be established in /var/www/idoit/src/classes/components/isys_component_database_mysqli.class.php on line 162, referer: http://xxx.xxx.xxx.xxx/idoit/
[Tue Mar 11 09:11:56 2014] [error] [client xxx.xxx.xxx.xxx] PHP Warning:  mysql_real_escape_string(): Access denied for user 'www-data'@'localhost' (using password: NO) in /var/www/idoit/src/classes/components/isys_component_database_mysqli.class.php on line 162, referer: http://xxx.xxx.xxx.xxx/idoit/
[Tue Mar 11 09:11:56 2014] [error] [client xxx.xxx.xxx.xxx] PHP Warning:  mysql_real_escape_string(): A link to the server could not be established in /var/www/idoit/src/classes/components/isys_component_database_mysqli.class.php on line 162, referer: http://xxx.xxx.xxx.xxx/idoit/
[Tue Mar 11 09:11:56 2014] [error] [client xxx.xxx.xxx.xxx] PHP Warning:  mysql_real_escape_string(): Access denied for user 'www-data'@'localhost' (using password: NO) in /var/www/idoit/src/classes/components/isys_component_database_mysqli.class.php on line 162, referer: http://xxx.xxx.xxx.xxx/idoit/
[Tue Mar 11 09:11:56 2014] [error] [client xxx.xxx.xxx.xxx] PHP Warning:  mysql_real_escape_string(): A link to the server could not be established in /var/www/idoit/src/classes/components/isys_component_database_mysqli.class.php on line 162, referer: http://xxx.xxx.xxx.xxx/idoit/
[Tue Mar 11 09:11:56 2014] [error] [client xxx.xxx.xxx.xxx] PHP Warning:  mysql_real_escape_string(): Access denied for user 'www-data'@'localhost' (using password: NO) in /var/www/idoit/src/classes/components/isys_component_database_mysqli.class.php on line 162, referer: http://xxx.xxx.xxx.xxx/idoit/
[Tue Mar 11 09:11:56 2014] [error] [client xxx.xxx.xxx.xxx] PHP Warning:  mysql_real_escape_string(): A link to the server could not be established in /var/www/idoit/src/classes/components/isys_component_database_mysqli.class.php on line 162, referer: http://xxx.xxx.xxx.xxx/idoit/
Waiting for data... (interrupt to abort)

Bei uns kommt allerdings kein Fehler auf der Login Seite nur die Meldung

Login attempt failed. Please try again.

Gruß

yoda

Unser fehler ist behoben.
In der config.inc.php war bei db_type mysqli hinterlegt.
Wohl noch aus unsere open-Installation.
Hab den Wert jetzt auch mysql angepasst und dann ging auch der Login wieder.

Gruß
Yoda

pborowy

@yoda:

Hatte eben den selben Fehler. Danke für den Tipp!