Status
Not open for further replies.

KiwiNeil

Customer
On attempting to set up my first mailing list I got this database error. What do I do to fix the issue?

Thanks in advance!


Database error in vBulletin 4.2.0:

Invalid SQL:
INSERT INTO dbtech_vbmail_mailinglist
(title, description, active, displayorder, ownerid, fromemail, external, permissions)
VALUES
('Mailing List', 'A mailing list that notifies people of wonderous things.', '1', 10, 0, 'forum@myforum.com', '0', 'a:27:{i:4;i:0;i:6;i:94;i:8;i:0;i:28;i:0;i:21;i:0;i:26;i:0;i:37;i:0;i:11;i:0;i:23;i:0;i:9;i:0;i:10;i:0;i:12;i:0;i:7;i:0;i:32;i:0;i:27;i:0;i:38;i:0;i:31;i:0;i:33;i:0;i:2;i:0;i:35;i:0;i:34;i:0;i:5;i:0;i:29;i:0;i:36;i:0;i:1;i:0;i:3;i:0;i:25;i:0;}');

MySQL Error : Unknown column 'external' in 'field list'
Error Number : 1054
Request Date : Saturday, July 14th 2012 @ 02:46:41 PM
Error Date : Saturday, July 14th 2012 @ 02:46:41 PM
Script : http://www.myforum.com/forum/admincp/vbmail.php?do=mailinglist
Referrer : http://www.myforum.com/forum/admincp/vbmail.php?do=mailinglist
IP Address : xx.xxx.xx.xx
Username : Admin1234
Classname : vB_Database
MySQL Version : 5.5.24-percona-sure1-log
 
Certain MySQL configs had issues with the way I added that column.

Code:
alter table dbtech_vbmail_mailinglist add external enum('0', '1') not null default '0'
should fix it :)
 
When I did that I got this database error:

Database error in vBulletin 4.2.0:

Invalid SQL:

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

MySQL Error : Unknown column 'user.dbtech_vbmail_bounceflag' in 'where clause'
Error Number : 1054
Request Date : Saturday, July 14th 2012 @ 03:38:20 PM
Error Date : Saturday, July 14th 2012 @ 03:38:20 PM
Script : http://www.myforum.com/forum/admincp/vbmail.php?do=mailinglist
Referrer : http://www.myforum.com/forum/admincp/vbmail.php?do=mailinglist
IP Address : xx.xxx.xx.xxx
Username : admin1234
Classname : vB_Database
MySQL Version :

and then when it appears the chron job did its work I received notice of another database error. It is:

Database error in vBulletin 4.2.0:

Invalid SQL:

SELECT
user.userid,
user.username,
user.email,
user.usergroupid,
user.membergroupids,
user.infractiongroupid,
user.displaygroupid
FROM `dbtech_vbmail_message` AS dbtech_vbmail_message
INNER JOIN user AS user ON(user.email = dbtech_vbmail_message.fromaddress)
WHERE dbtech_vbmail_message.fromaddress != ''
AND dbtech_vbmail_message.bounce = '1'
AND user.dbtech_vbmail_bounceflag = '0'
GROUP BY dbtech_vbmail_message.fromaddress
HAVING COUNT(*) >= 5;

MySQL Error : Unknown column 'user.dbtech_vbmail_bounceflag' in 'where clause'
Error Number : 1054
Request Date : Saturday, July 14th 2012 @ 03:45:24 PM
Error Date : Saturday, July 14th 2012 @ 03:45:24 PM
Script : http://www.myforum.com/forum/cron.php?rand=1342295123
Referrer : http://www.myforum.com/forum/forum.php
IP Address : xx.xxx.xx.xxx
Username : Unregistered
Classname : vB_Database
MySQL Version :

Is there anything else I should do to fix the issues?
 
Code:
alter table user add dbtech_vbmail_bounceflag enum('0', '1') not null default '0'
 
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