Status
Not open for further replies.

Jona

New member
When I add a new mailing list, the following SQL error shows up:

Code:
Database error in vBulletin 3.8.7:

Invalid SQL:

			INSERT IGNORE INTO dbtech_vbmail_subscription
				(userid, mailinglistid)
			(
				SELECT userid, 3 AS mailinglistid
				FROM user AS user
				WHERE (
						FIND_IN_SET(2, membergroupids)
						OR usergroupid IN(2)
					)
					AND user.dbtech_vbmail_bounceflag = '0'
			);

MySQL Error   : Unknown column 'user.dbtech_vbmail_bounceflag' in 'where clause'
Error Number  : 1054
Request Date  : Thursday, May 10th 2012 @ 09:32:18 AM
Error Date    : Thursday, May 10th 2012 @ 09:32:18 AM
Script        : [url]http://www.domain.com/admincp/vbmail.php?do=mailinglist[/url]
Referrer      : [url]http://www.domain.com/admincp/vbmail.php?do=mailinglist[/url]
IP Address    : ***.**.**.***
Username      : AdminUsername
Classname     : vB_Database
MySQL Version : 5.5.21-55

Any idea? The mailing list DOES get created, however, nobody is subscribed to it (even after I checked off the 'Default Subscribed' box for several usergroups).
 
Your mysql installation is broken and doesn't like to add ENUM flags apparently.

Code:
ALTER TABLE user ADD dbtech_vbmail_bounceflag ENUM('0','1') DEFAULT '0'
Code:
ALTER TABLE user ADD dbtech_vbmail_defaultkeyword ENUM('0','1') DEFAULT '1'
Code:
ALTER TABLE dbtech_vbmail_mailinglist ADD external ENUM('0','1') DEFAULT '0'

Ignore any errors about existing columns.
 
So what do I do? Keep in mind I have no knowledge of php/mysql. I don't know what those mean.

I don't see how it could've become broken. Maybe I installed a particular plugin that messed up the mysql?
 
You'll need to run those queries in either phpMyAdmin or the Execute SQL Query bit in the AdminCP.
 
All 3 of them? Do I run them after I have vBMail installed & enabled, or should I run them first, and then enable vBMail?
 
First one ran successfully. The other two came back with errors ("#1060 - Duplicate column name 'external'") but I went on my board and tested creating a new mailing list, and it worked fine.
 
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