Bug SQL field dbtech_vbmail_bounceflag empty

Status
Not open for further replies.
Website
http://www.pflegeboard.de
Product version
2.1.0
Forum version
vBulletin 4.2.x
#1
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:
PHP:
UPDATE `vbuser` SET  `dbtech_vbmail_bounceflag` = `0`
- is this the correct query to update the field with 0 ?)
 

Belazor

Staff member
Owner
Developer
Customer
#2
Code:
UPDATE vbuser SET dbtech_vbmail_bounceflag = '0' where dbtech_vbmail_bounceflag = ''
would be the correct code I believe :)
 
#3
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.

vBMail

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