Bug Database Error Upon Installation

[Jem]

Greetings

First of all I am beginning to get a bit worried. This is the second database error I have encountered with a Dragonbyte product. The first was the removal of a key database table upon uninsallation of vbQuiz reported here: http://www.dragonbyte-tech.com/f94/...fter-uninstall-mod-4959/index2.html#post29430

This error was not as critical, but leaves the product inoperable. After install any attempt to create a mailing list returns the following database error:

Database error in vBulletin 4.1.5:

Invalid SQL:
INSERT INTO dbtech_vbmail_mailinglist
(title, description, active, displayorder, ownerid, fromemail, external, permissions, bitfield)
VALUES
('Mailing List', 'A mailing list that notifies people of wonderous things.', '1', 10, 1, 'xxxx@xxx.xxx', '0', 'a:19:{i:29;i:89;i:19;i:65;i:30;i:65;i:16;i:89;i:6;i:89;i:18;i:65;i:47;i:65;i:25;i:89;i:21;i:65;i:37;i:65;i:7;i:65;i:2;i:65;i:28;i:89;i:36;i:65;i:32;i:65;i:20;i:65;i:5;i:89;i:34;i:65;i:46;i:65;}', 1);

MySQL Error : Unknown column 'external' in 'field list'
Error Number : 1054
Request Date : Monday, September 26th 2011 @ 10:25:03 PM
Error Date : Monday, September 26th 2011 @ 10:25:03 PM
Script : http://xxx.xxx.xxx/admincp/vbmail.php?do=mailinglist
Referrer : http://xxx.xxx.xxx/admincp/vbmail.php?do=mailinglist
IP Address : xx.xx.xx.xx
Username : Sadaar
Classname : vB_Database_MySQLi
MySQL Version : 5.5.14

Please advise. Plus, I'm a bit worried as to the integrity of my database with all these errors occurring.....

 

[Fillip H.]

Are you using a non-standard plugin manager? For some reason, your database can't correctly create all columns during the install process, which should worry you as it may leave vBulletin itself in a broken state if this occurs during a vBulletin upgrade.

In either case, run this to patch it for this particular case:

ALTER TABLE dbtech_vbmail_mailinglist ADD external ENUM('0','1') DEFAULT '0'

 

[Jem]

No, I do not use any plugin managers and wonder what is causing these issues. Now, I did recently install a separate instance of phpMyAdmin outside of the PLESK install. Do you think that could have caused an issue?

 

[Fillip H.]

I doubt that... but you say Plesk, are you running a Windows server? If so, I would be 100% unsurprised if it turned out to be a bug in MySQL on Windows

 

[Jem]

No, I've got a CentOS system, just upgraded to 5.7 a couple of days ago. I've also got MySQL, Apache, PHP and xCache all updated to their most recent versions.

hmmm....

 

[Jem]

I may have discovered my problem but so as to not double post and this refers to two separate mods, please read my full response in this thread: http://www.dragonbyte-tech.com/f94/...fter-uninstall-mod-4959/index2.html#post29430

 

[Jem]

I can now create a Mailing List, but to send an email bring the following error:

Database error in vBulletin 4.1.5:

Invalid SQL:

SELECT
user.userid,
user.username,
user.email,
user.usergroupid,
user.membergroupids,
user.salt,
user.dbtech_vbmail_defaultkeyword,
user.options
FROM dbtech_vbmail_subscription AS subscription
LEFT JOIN user AS user USING(userid)
WHERE subscription.subscribed = '1'
AND subscription.mailinglistid = 2
AND user.dbtech_vbmail_bounceflag = '0'
ORDER BY user.userid ASC
LIMIT 0, 500;

MySQL Error : Unknown column 'user.dbtech_vbmail_bounceflag' in 'where clause'
Error Number : 1054
Request Date : Thursday, September 29th 2011 @ 01:50:18 AM
Error Date : Thursday, September 29th 2011 @ 01:50:19 AM
Script : http://xxx.xxx.xxx/vbmail.php?do=ma...ailqueuehash=cf73eef3a6e51f87c262aa27f6c69751
Referrer : http://xxx.xxx.xxx/vbmail.php?templateid=0&s=&do=mailinglists&action=sendmail&mailinglistid=2
IP Address : xx.xx.xx.xx.xx
Username : Sadaar
Classname : vB_Database_MySQLi
MySQL Version : 5.5.14

Note I have bounced email handling turned off.

 

[Fillip H.]

ALTER TABLE user ADD dbtech_vbmail_bounceflag ENUM('0','1') DEFAULT '0'

 

[Jem]

Thank you, that appears to have solved the problem.