Error nach Update auf 1.3



  • 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?



  • 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ß



  • 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



  • @yoda:

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


 


Datenschutz / Privacy Policy