Bug SQL error in 1.1 beta PRO when creating a new mail list

[Badger]

Not sure how to fix this ...

Database error in vBulletin 4.1.3:

Invalid SQL:
INSERT INTO dbtech_vbmail_mailinglist
(title, description, active, displayorder, external, ownerid, fromemail, permissions, bitfield)
VALUES
('Milsurps Newsletter', 'Monthly newsletter updating all members on the site\'s latest features, as well as linking members to some of the best threads and content posted in the last month.', '1', 10, '0', 2, 'webmaster@milsurps.com', 'a:10:{i:6;i:93;i:9;i:69;i:10;i:69;i:20;i:65;i:7;i:69;i:2;i:69;i:17;i:69;i:5;i:69;i:19;i:1;i:16;i:1;}', 16);

MySQL Error : Unknown column 'external' in 'field list'
Error Number : 1054
Request Date : Tuesday, July 19th 2011 @ 08:55:41 AM
Error Date : Tuesday, July 19th 2011 @ 08:55:41 AM
Script : http://www.milsurps.com/admincp/vbmail.php?do=mailinglist
Referrer : http://www.milsurps.com/admincp/vbmail.php?do=mailinglist&action=modify
IP Address : 38.99.162.107
Username : Badger
Classname : vB_Database

 

[Mokonzi]

Try rerunning the upgrade. Does that fix it? (Backup what you have before you do it).

 

[Badger]

Try rerunning the upgrade. Does that fix it? (Backup what you have before you do it).

Re-downloaded and re-installed 1.1 Pro Beta ...

No change ... SQL errors as shown above when adding any new mailing list, even with simple default settings ...

Regards,
Doug

 

[Mokonzi]

I have created a new external list on my test board with no error. What version did you upgrade from?

 

[Badger]

I have created a new external list on my test board with no error. What version did you upgrade from?

I was running vbMail 1.04 Pro (Life License) and I installed with overwrite vbMail Pro 1.1 Beta ....

I'm not a programmer, but the SQL error seems to indicate that there's a field missing, specifically the one that relates to the new feature in 1.1 referencing external mailing lists? I don't use external lists and most likely never will. The field value shown on existing mailing lists is shown as NO. See attached pic. It's new mailing lists that I can't create at all, due to the SQL error. It was working fine in 1.04, as you can see from the pics showing the existing mailing lists I created.

Regards,
Doug

 

[Mokonzi]

I don't use external lists and most likely never will. The field value shown on existing mailing lists is shown as NO.

All old lists are auto 'No' and it's unchangeable once a list has been created. Let me check what SQL might create the table for you, but I'm not sure if that's all you need fixing.

 

[Badger]

All old lists are auto 'No' and it's unchangeable once a list has been created. Let me check what SQL might create the table for you, but I'm not sure if that's all you need fixing.

I don't know how to do that manually, so I would need an XML import capability fix that would handle that automatically for me ...

Thanks ...

Regards,
Doug

 

[Mokonzi]

Ok, try running the SQL command, just replace ***TABLEPREFIX*** with your table prefix.:

ALTER TABLE  `***TABLEPREFIX***_dbtech_vbmail_mailinglist` ADD  `external` ENUM(  '0',  '1' ) NOT NULL DEFAULT  '1'

Make sure you backup before trying this, and then let me know if it works or not.

 

[Mokonzi]

I don't know how to do that manually, so I would need an XML import capability fix that would handle that automatically for me ...

You can run it on Maintenance > Execute SQL Query in the AdminCP

 

[Badger]

You can run it on Maintenance > Execute SQL Query in the AdminCP

I don't know what a table prefix is ....

I think I should wait for a FIX update to the 1.1 beta PRO, so I don't screw up my database...

There must be a bug in the update install going from 1.04 to 1.1 Beta ...

Thanks for your help ...

Regards,
Doug

 

[Fillip H.]

Unfortunately such a fix cannot be provided, because you're already ON v1.1.0

You will have to perform the query as described. The table prefix can be found in your config.php file.

 

[Badger]

Unfortunately such a fix cannot be provided, because you're already ON v1.1.0

You will have to perform the query as described. The table prefix can be found in your config.php file.

Wonderful ....

Can I go back to v1.04 which worked?

I don't think I have any prefix ...

	//	****** DATABASE NAME ******
	//	This is the name of the database where your vBulletin will be located.
	//	This must be created by your webhost.
$config['Database']['dbname'] = 'milsurp';

	//	****** TABLE PREFIX ******
	//	Prefix that your vBulletin tables have in the database.
$config['Database']['tableprefix'] = ' ';

 

[Fillip H.]

Then simply run

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

 

[Badger]

Then simply run

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

Ok, executed that and it shows what you see in the attached screen ...

Tested to ADD a new mailing list and it now seems to work successfully ...

Thanks ...

Regards,
Doug

 

[Ozzy47]

Glad it is all sorted for you now!

 

[Trekkan]

One thing I noticed was his table prefix has a space in it instead of just ''

So... I dunno if that could of had something to do with the overall issue or not.