Bug SQL field dbtech_vbmail_bounceflag empty

Status
Not open for further replies.

Marv

Customer
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:
7lnmwlez.png


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:
PHP:
UPDATE `vbuser` SET  `dbtech_vbmail_bounceflag` = `0`
- is this the correct query to update the field with 0 ?)
 
Code:
UPDATE vbuser SET dbtech_vbmail_bounceflag = '0' where dbtech_vbmail_bounceflag = ''
would be the correct code I believe :)
 
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!
 
Last edited:
Status
Not open for further replies.

Legacy vBMail

vBulletin 3.8.x vBulletin 4.x.x
Seller
DragonByte Technologies
Release date
Last update
Total downloads
732
Customer rating
0.00 star(s) 0 ratings
Back
Top