Bug SQL field dbtech_vbmail_bounceflag empty

[Marv]

Hi Filip,

we were wondering, why our newsletter only reachs 7% of our users for quite some time now. Today I came across the field dbtech_vbmail_bounceflag in the vbuser table and wondered, why that field was empty for most users:

Q1: Could this be the reason, that we can´t reach most of our users anymore? The timeframe since this occurs would fit with the installation date of vbMail and the bounce handling.

Q2: Would updating that field with 0 unflag all users?

(And before I break something:

UPDATE `vbuser` SET  `dbtech_vbmail_bounceflag` = `0`

- is this the correct query to update the field with 0 ?)

 

[Fillip H.]

UPDATE vbuser SET dbtech_vbmail_bounceflag = '0' where dbtech_vbmail_bounceflag = ''

would be the correct code I believe

 

[Marv]

Sure, with the conditional. We just moved into that server and this is a new sql version (5.5) and seems to have another syntax with the ''.

But great. Hope that solves that issue for me.
Happy new years eve, Filip!