Creating a new mailing list gives this error

Jona · 10th May 2012, 15:40

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        : http://www.domain.com/admincp/vbmail.php?do=mailinglist
Referrer      : http://www.domain.com/admincp/vbmail.php?do=mailinglist
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).

Belazor · 10th May 2012, 15:44

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.

Jona · 10th May 2012, 15:46

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?

Belazor · 10th May 2012, 15:48

You'll need to run those queries in either phpMyAdmin or the Execute SQL Query bit in the AdminCP.

Jona · 10th May 2012, 15:49

All 3 of them? Do I run them after I have vBMail installed & enabled, or should I run them first, and then enable vBMail?

Belazor · 10th May 2012, 15:54

It doesn't matter which order you do it in, but it needs to be installed =p

Jona · 10th May 2012, 16:05

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.

vBulletin 5 Mods & Upgrades

Go Custom With Dragonbyte-tech

Become one of our happy customers

Serving some of your favourite companies

Want to test our full range of products?

DragonByte Tech Is Hiring!

Join In Our Feedback Surveys

View Issue Info: Creating a new mailing list gives this error

User Tag List

Thread: Creating a new mailing list gives this error

Forum: vBMail Lite Support

LinkBack

Thread Tools

Display

Creating a new mailing list gives this error

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions