Hi,
installed vbmail 1.1 beta this morning and got now the following database error by email (it wasn't an action by myself):
Invalid SQL:
SELECT user.userid, user.username
FROM `vb_dbtech_vbmail_message` AS dbtech_vbmail_message
INNER JOIN vb_dbtech_vbmail_user AS user ON(user.email = dbtech_vbmail_message.fromaddress)
WHERE dbtech_vbmail_message.fromaddress != ''
AND dbtech_vbmail_message.bounce = '1'
AND user.dbtech_vbmail_bounceflag = '0'
GROUP BY dbtech_vbmail_message.fromaddress
HAVING COUNT(*) >= 5;
MySQL-Fehler : Table 'orca_vbcms.vb_dbtech_vbmail_user' doesn't exist
Fehler-Nr. : 1146
Fehler-Zeit : Sunday, 17.07.2011 @ 12:46:28
Datum : Sunday, 17.07.2011 @ 12:46:29
Skript : http://www.eisengasse.info/cron.php?rand=1310899587
Referrer : http://www.eisengasse.info/blog_usercp.php?do=editcat
IP-Adresse : *.*.*.*
Benutzername : Unregistriert
Klassenname : vB_Database
MySQL-Version :
It seems that it creates the error with the cron-job. The username (Benutzername) is "unregistered (Unregistriert)".
Ueli
installed vbmail 1.1 beta this morning and got now the following database error by email (it wasn't an action by myself):
Invalid SQL:
SELECT user.userid, user.username
FROM `vb_dbtech_vbmail_message` AS dbtech_vbmail_message
INNER JOIN vb_dbtech_vbmail_user AS user ON(user.email = dbtech_vbmail_message.fromaddress)
WHERE dbtech_vbmail_message.fromaddress != ''
AND dbtech_vbmail_message.bounce = '1'
AND user.dbtech_vbmail_bounceflag = '0'
GROUP BY dbtech_vbmail_message.fromaddress
HAVING COUNT(*) >= 5;
MySQL-Fehler : Table 'orca_vbcms.vb_dbtech_vbmail_user' doesn't exist
Fehler-Nr. : 1146
Fehler-Zeit : Sunday, 17.07.2011 @ 12:46:28
Datum : Sunday, 17.07.2011 @ 12:46:29
Skript : http://www.eisengasse.info/cron.php?rand=1310899587
Referrer : http://www.eisengasse.info/blog_usercp.php?do=editcat
IP-Adresse : *.*.*.*
Benutzername : Unregistriert
Klassenname : vB_Database
MySQL-Version :
It seems that it creates the error with the cron-job. The username (Benutzername) is "unregistered (Unregistriert)".
Ueli