Bug MySQL Errors

[Jem]

As with the Achievements mod I am receiving MySQL errors on a fresh install of 4.1.7 pl2


Database error in vBulletin 4.1.7:

Invalid SQL:
INSERT INTO dbtech_vbshop_item
(title, categoryid, description, displayorder, icon, shopicon, giftable, onlygiftable, giftpm, uniqueitem, duration, reconfigure, regift, code, permissions, shop, itemtypeid)
VALUES
('Name Bold', 1, 'Gives your name so BOLDNESS!', 10, '', '', '1', '0', '0', '0', 0, '1', '0', 'a:1:{s:5:\"value\";a:2:{i:0;s:1:\"0\";i:1;s:1:\"1\";}}', 'a:22:{i:28;s:1:\"1\";i:23;s:1:\"1\";i:19;s:1:\"1\";i:24;s:1:\"1\";i:17;s:1:\"1\";i:6;s:1:\"1\";i:18;s:1:\"1\";i:30;s:1:\"1\";i:22;s:1:\"1\";i:21;s:1:\"1\";i:26;s:2:\"-1\";i:7;s:1:\"1\";i:2;s:1:\"1\";i:27;s:1:\"1\";i:25;s:1:\"1\";i:20;s:1:\"1\";i:5;s:1:\"1\";i:13;s:1:\"1\";i:29;s:1:\"1\";i:1;s:1:\"1\";i:3;s:1:\"1\";i:4;s:1:\"1\";}', 0, 'usernamestyle');

MySQL Error : Unknown column 'onlygiftable' in 'field list'
Error Number : 1054
Request Date : Sunday, December 11th 2011 @ 02:16:57 AM
Error Date : Sunday, December 11th 2011 @ 02:16:57 AM
Script : Log in - TTNB - vBulletin Admin Control Panel
Referrer : Log in - TTNB - vBulletin Admin Control Panel
IP Address : 98.226.57.73
Username : Say892
Classname : vB_Database_MySQLi
MySQL Version : 5.5.18-cll


I have regretted upgrading to MySQL 5.5 as a great many mods are broken due to some depreciated values. I hope there is an easy fix via query as there was with the Achievements mod I had a similar problem with.

 

[Ozzy47]

Take a look here and see if that helps, http://www.dragonbyte-tech.com/f67/db-error-when-enabling-every-item-4075/

 

[Jem]

Thank you, that appears to have worked.

Once again I appreciate your prompt and knowledgeable assistance.

 

[Ozzy47]

Not a problem, glad that sorted it for you.