Bug Unknown column 'user.dbtech_vbmail_bounceflag' in 'where clause'

[developr]

I got an error on every cronjob:

Invalid SQL:

	SELECT
		user.userid,
		user.username,
		user.email,
		user.usergroupid,
		user.membergroupids,
		user.infractiongroupid,
		user.displaygroupid
	FROM `dbtech_vbmail_message` AS dbtech_vbmail_message
	INNER JOIN 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  : Unknown column 'user.dbtech_vbmail_bounceflag' in 'where clause'

 

[Pandemikk]

Hello,

If you have access to phpMyAdmin, would you please verify that the column does indeed exist in the user table?

It looks to me as if that column wasn't created for some reason.

 

[developr]

The column "dbtech_vbmail_bounceflag" in table "user" doesn't exist. But there is a column "dbtech_vbmail_bounceflag" in the table "dbtech_vbmail_user".

 

[Fillip H.]

Certain SQL installations have problems creating ENUM columns for reasons I have been unable to determine. Please run the following 2 queries (ignore any errors):

ALTER TABLE user ADD dbtech_vbmail_bounceflag ENUM('0','1') DEFAULT '0'

ALTER TABLE user ADD dbtech_vbmail_defaultkeyword ENUM('0','1') DEFAULT '1'

 

[developr]

It's work.