Seite 1 von 1
[CON-1893]: Datenbankverbindung wird nicht richtig überprüft
Verfasst: Mo 20. Jan 2014, 13:16
von jacke
Hallo,
ich hebe einen sporadisch auftrerenden Fehler. Der Fehler ist in den letzten 2 Monaten 3x aufgetreten. Ohne irgend etwas am System zu machen komme ich weder ind Backend noch frontend. Erstelle ich NUR eine Sicherung der DABA - -geht es nach ein par minuten wieder. folgendes steht im errorlog:
Code: Alles auswählen
__construct() called in file class.html.contentelement.php(35)
__construct() called in file class.html.form.php(43)
__construct() called in file class.password.request.php(204)
renderForm() called in file main.loginform.php(98)
include() called in file class.auth.handler.backend.php(46)
displayLoginForm() called in file class.auth.php(237)
_fetchLoginForm() called in file class.auth.php(112)
start() called in file class.registry.php(535)
bootstrap() called in file index.php(32)
[20-Jan-2014 08:59:44 Europe/Berlin] PHP Warning: Database failure: () - /contenido/ next_record called with no query pending.
in /home/www/web503/html/contenido_gemeinde/contenido/includes/functions.general.php on line 1303
[20-Jan-2014 08:59:44 Europe/Berlin] PHP Warning: mysqli_real_escape_string(): invalid object or resource mysqli
in /home/www/web503/html/contenido_gemeinde/contenido/classes/db/class.db.driver.mysqli.php on line 289
[20-Jan-2014 08:59:44 Europe/Berlin] PHP Warning: mysqli_real_escape_string(): invalid object or resource mysqli
in /home/www/web503/html/contenido_gemeinde/contenido/classes/db/class.db.driver.mysqli.php on line 289
[20-Jan-2014 08:59:44 Europe/Berlin] PHP Warning: mysqli_real_escape_string(): invalid object or resource mysqli
in /home/www/web503/html/contenido_gemeinde/contenido/classes/db/class.db.driver.mysqli.php on line 289
[20-Jan-2014 08:59:44 Europe/Berlin] PHP Warning: mysqli_query(): invalid object or resource mysqli
in /home/www/web503/html/contenido_gemeinde/contenido/classes/db/class.db.driver.mysqli.php on line 200
[2014-01-20 08:59:44] Warning: "Database failure: () - /contenido/ SELECT * FROM `` WHERE = ''
" at reportHalt() [class.db.driver.handler.php(977)]
reportHalt() called in file class.db.driver.handler.php(949)
halt() called in file class.db.driver.handler.php(677)
query() called in file class.item.php(130)
loadBy() called in file class.item.php(255)
loadByPrimaryKey() called in file class.client.php(218)
loadByPrimaryKey() called in file class.client.php(185)
__construct() called in file class.effective.setting.php(263)
_getClientInstance() called in file class.effective.setting.php(117)
get() called in file functions.general.php(743)
getEffectiveSetting() called in file class.html.php(129)
__construct() called in file class.html.contentelement.php(35)
__construct() called in file class.html.form.php(43)
__construct() called in file class.password.request.php(204)
renderForm() called in file main.loginform.php(98)
include() called in file class.auth.handler.backend.php(46)
displayLoginForm() called in file class.auth.php(237)
_fetchLoginForm() called in file class.auth.php(112)
start() called in file class.registry.php(535)
bootstrap() called in file index.php(32)
Vielen Dank schon mal!
jacke
Re: Error Page
Verfasst: Mo 20. Jan 2014, 22:45
von xmurrix
Hallo jacke,
welche CONTENIDO Version ist das genau?
Code: Alles auswählen
[2014-01-20 08:59:44] Warning: "Database failure: () - /contenido/ SELECT * FROM `` WHERE = ''
Anscheinend wird CONTENIDO, warum auch immer, nicht korrekt initialisiert, In der SQL-Anweisung fehlt der Tabellenname und auch der Wert in WHERE = ''.
Passiert das etwa, wenn man im Backend die Passwort-Vegessen Funktion verwendet?
Gruß
xmurrix
Re: Error Page
Verfasst: Di 21. Jan 2014, 09:45
von jacke
Hallo xmurrix,
nein, ich denke nicht, dass die Funktion verwendet wurde. Der Fehler tritt immer spotadisch auf. 16.9.2013, 1.10.2019, 20.1.2014. Allerdings habe ich seit gestern auch eine ungewöhnlich falsche Login-Seite. Also könnte der Fehler in die Richtung gehen.
Ich hoffe ihr habt eine Ideeeeeee.
Jacke
Re: Error Page
Verfasst: Di 21. Jan 2014, 21:15
von xmurrix
Sorry, am Bild kann ich nichts merkwürdiges erkennen, das verschobene Layout kann auch am Zoom-Faktor des Browsers liegen.
Gruß
xmurrix
Re: Error Page
Verfasst: Do 23. Jan 2014, 09:50
von jacke
...zoom!
Da hab ich mich aber ganz dumm angestellt.
Danke
Re: Error Page
Verfasst: Mo 17. Feb 2014, 09:03
von jacke
So da ist es wieder.....
Code: Alles auswählen
__construct() called in file class.html.contentelement.php(35)
__construct() called in file class.html.form.php(43)
__construct() called in file class.password.request.php(204)
renderForm() called in file main.loginform.php(98)
include() called in file class.auth.handler.backend.php(46)
displayLoginForm() called in file class.auth.php(237)
_fetchLoginForm() called in file class.auth.php(112)
start() called in file class.registry.php(535)
bootstrap() called in file index.php(32)
[17-Feb-2014 09:00:06 Europe/Berlin] PHP Warning: Database failure: () - /contenido/index.php?contenido=jromklr1o2jkrh9lt5hupft5uni54oje next_record called with no query pending.
in /home/www/web503/html/contenido_gemeinde/contenido/includes/functions.general.php on line 1303
[17-Feb-2014 09:00:06 Europe/Berlin] PHP Warning: mysqli_real_escape_string(): invalid object or resource mysqli
in /home/www/web503/html/contenido_gemeinde/contenido/classes/db/class.db.driver.mysqli.php on line 289
[17-Feb-2014 09:00:06 Europe/Berlin] PHP Warning: mysqli_real_escape_string(): invalid object or resource mysqli
in /home/www/web503/html/contenido_gemeinde/contenido/classes/db/class.db.driver.mysqli.php on line 289
[17-Feb-2014 09:00:06 Europe/Berlin] PHP Warning: mysqli_real_escape_string(): invalid object or resource mysqli
in /home/www/web503/html/contenido_gemeinde/contenido/classes/db/class.db.driver.mysqli.php on line 289
[17-Feb-2014 09:00:06 Europe/Berlin] PHP Warning: mysqli_query(): invalid object or resource mysqli
in /home/www/web503/html/contenido_gemeinde/contenido/classes/db/class.db.driver.mysqli.php on line 200
[2014-02-17 09:00:06] Warning: "Database failure: () - /contenido/index.php?contenido=jromklr1o2jkrh9lt5hupft5uni54oje SELECT * FROM `` WHERE = ''
" at reportHalt() [class.db.driver.handler.php(977)]
reportHalt() called in file class.db.driver.handler.php(949)
halt() called in file class.db.driver.handler.php(677)
query() called in file class.item.php(130)
loadBy() called in file class.item.php(255)
loadByPrimaryKey() called in file class.client.php(218)
loadByPrimaryKey() called in file class.client.php(185)
__construct() called in file class.effective.setting.php(263)
_getClientInstance() called in file class.effective.setting.php(117)
get() called in file functions.general.php(743)
getEffectiveSetting() called in file class.html.php(129)
__construct() called in file class.html.contentelement.php(35)
__construct() called in file class.html.form.php(43)
__construct() called in file class.password.request.php(204)
renderForm() called in file main.loginform.php(98)
include() called in file class.auth.handler.backend.php(46)
displayLoginForm() called in file class.auth.php(237)
_fetchLoginForm() called in file class.auth.php(112)
start() called in file class.registry.php(535)
bootstrap() called in file index.php(32)
[17-Feb-2014 09:00:06 Europe/Berlin] PHP Warning: Database failure: () - /contenido/index.php?contenido=jromklr1o2jkrh9lt5hupft5uni54oje SELECT * FROM `` WHERE = ''
in /home/www/web503/html/contenido_gemeinde/contenido/includes/functions.general.php on line 1303
[2014-02-17 09:00:06] Warning: "Database failure: () - /contenido/index.php?contenido=jromklr1o2jkrh9lt5hupft5uni54oje next_record called with no query pending.
" at reportHalt() [class.db.driver.handler.php(977)]
reportHalt() called in file class.db.driver.handler.php(949)
halt() called in file class.db.driver.handler.php(695)
nextRecord() called in file class.item.php(140)
loadBy() called in file class.item.php(255)
loadByPrimaryKey() called in file class.client.php(218)
loadByPrimaryKey() called in file class.client.php(185)
__construct() called in file class.effective.setting.php(263)
_getClientInstance() called in file class.effective.setting.php(117)
get() called in file functions.general.php(743)
getEffectiveSetting() called in file class.html.php(129)
__construct() called in file class.html.contentelement.php(35)
__construct() called in file class.html.form.php(43)
__construct() called in file class.password.request.php(204)
renderForm() called in file main.loginform.php(98)
include() called in file class.auth.handler.backend.php(46)
displayLoginForm() called in file class.auth.php(237)
_fetchLoginForm() called in file class.auth.php(112)
start() called in file class.registry.php(535)
bootstrap() called in file index.php(32)
[17-Feb-2014 09:00:06 Europe/Berlin] PHP Warning: Database failure: () - /contenido/index.php?contenido=jromklr1o2jkrh9lt5hupft5uni54oje next_record called with no query pending.
in /home/www/web503/html/contenido_gemeinde/contenido/includes/functions.general.php on line 1303
[17-Feb-2014 09:00:06 Europe/Berlin] PHP Warning: mysqli_query(): invalid object or resource mysqli
in /home/www/web503/html/contenido_gemeinde/contenido/classes/db/class.db.driver.mysqli.php on line 200
[2014-02-17 09:00:06] Warning: "Database failure: () - /contenido/index.php?contenido=jromklr1o2jkrh9lt5hupft5uni54oje SELECT * FROM `con_lang`
" at reportHalt() [class.db.driver.handler.php(977)]
reportHalt() called in file class.db.driver.handler.php(949)
halt() called in file class.db.driver.handler.php(677)
query() called in file class.item.collection.php(754)
select() called in file functions.general.php(1513)
sendEncodingHeader() called in file main.loginform.php(104)
include() called in file class.auth.handler.backend.php(46)
displayLoginForm() called in file class.auth.php(237)
_fetchLoginForm() called in file class.auth.php(112)
start() called in file class.registry.php(535)
bootstrap() called in file index.php(32)
[17-Feb-2014 09:00:06 Europe/Berlin] PHP Warning: Database failure: () - /contenido/index.php?contenido=jromklr1o2jkrh9lt5hupft5uni54oje SELECT * FROM `con_lang`
in /home/www/web503/html/contenido_gemeinde/contenido/includes/functions.general.php on line 1303
[2014-02-17 09:00:06] Warning: "Database failure: () - /contenido/index.php?contenido=jromklr1o2jkrh9lt5hupft5uni54oje next_record called with no query pending.
" at reportHalt() [class.db.driver.handler.php(977)]
reportHalt() called in file class.db.driver.handler.php(949)
halt() called in file class.db.driver.handler.php(695)
nextRecord() called in file class.item.collection.php(841)
next() called in file functions.general.php(1514)
sendEncodingHeader() called in file main.loginform.php(104)
include() called in file class.auth.handler.backend.php(46)
displayLoginForm() called in file class.auth.php(237)
_fetchLoginForm() called in file class.auth.php(112)
start() called in file class.registry.php(535)
bootstrap() called in file index.php(32)
[17-Feb-2014 09:00:06 Europe/Berlin] PHP Warning: Database failure: () - /contenido/index.php?contenido=jromklr1o2jkrh9lt5hupft5uni54oje next_record called with no query pending.
in /home/www/web503/html/contenido_gemeinde/contenido/includes/functions.general.php on line 1303
Re: Error Page
Verfasst: Mi 30. Jul 2014, 09:20
von rethus
Ich habe derzeit exakt dasselbe Phänomen beobachtet, als ich via Backend von PHP 5.3 auf 5.5 umgeschaltet habe.
Eine direkte Lösung habe ich momentan dazu nicht, ich versuche das Problem weiter einzugrenzen - oder falls hier jemand einen Tipp geben kann, bin ich natürlich auch dankbar.
Re: Error Page
Verfasst: Mi 30. Jul 2014, 10:39
von rethus
Problem gelöst.
Und "Du, Du, Contenido"
Eine gemutete Methode, bzw. eine oberflächliche If-Abfrage hat die Suche unnötig schwer gemacht.
In der Datei: class.db.driver.mysqli.php Zeile: 76.
Code: Alles auswählen
$dbHandler = @mysqli_init();
if (!$dbHandler) {
$this->_handler->halt('Can not initialize database connection.');
return NULL;
}
Hier wird in der if-Schleife nicht sauber abgefragt. Es wird zwar etwas zurückgegeben, aber nicht der erwartete Handler. Bitte als [BUG] erfassen, und fixen, für künftige Versionen!
Also, php 5.5 wurde bei mir via fastcgi vom Hoster installiert. Der hat es jedoch versäumt, die Konfigeinstellung zum MysqlSocket richtig zu setzen. Default auf dem Server war /var/run/mysqld/mysqld.sock, für fastcgi war es aber auf /tmp/mysqld.sock gesetzt.
Da ich SSH-Zugriff habe, habe ich kurzerhand einfach einen symbolischen Link gesetzt, nun funktioniert es wieder.
Re: [CON-1893]: Datenbankverbindung wird nicht richtig überp
Verfasst: Mi 30. Jul 2014, 12:35
von mischa.holz
Ich habe dafür ein Ticket erstellt:
https://issues.contenido.org/browse/CON-1893
Das sollte in der nächsten Version behoben sein ^.^