Question Database error when Adding New Item in vbshop 2.2.4

[hero70411]

I'm using vb shop 2.2.2 with vb credits 2.0
When I adding new item:


Database error in vBulletin 4.1.9:

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
('An Item', 1, 'A random new item that does fancy things.', 10, '', '', '0', '0', '0', '0', 0, '1', '1', 'a:5:{i:1;a:2:{s:5:\"title\";s:0:\"\";s:8:\"required\";s:1:\"0\";}i:2;a:2:{s:5:\"title\";s:0:\"\";s:8:\"required\";s:1:\"0\";}i:3;a:2:{s:5:\"title\";s:0:\"\";s:8:\"required\";s:1:\"0\";}i:4;a:2:{s:5:\"title\";s:0:\"\";s:8:\"required\";s:1:\"0\";}i:5;a:2:{s:5:\"title\";s:0:\"\";s:8:\"required\";s:1:\"0\";}}', 'a:9:{i:4;s:2:\"-1\";i:6;s:2:\"-1\";i:8;s:2:\"-1\";i:7;s:2:\"-1\";i:2;s:2:\"-1\";i:5;s:2:\"-1\";i:1;s:2:\"-1\";i:3;s:2:\"-1\";i:12;s:2:\"-1\";}', 0, 'custom');

MySQL Error : Unknown column 'onlygiftable' in 'field list'
Error Number : 1054
Request Date : Thursday, January 12th 2012 @ 01:27:21 PM
Error Date : Thursday, January 12th 2012 @ 01:27:21 PM
Script : http://localhost/forum/admincp/vbshop.php?do=item
Referrer : http://localhost/forum/admincp/vbshop.php?do=item
IP Address : 127.0.0.1
Username : hero70411
Classname : vB_Database
MySQL Version : 5.5.16-log

Stack Trace:

#0 vB_Database->halt() called in [path]\includes\class_core.php on line 423
#1 vB_Database->execute_query() called in [path]\includes\class_core.php on line 441
#2 vB_Database->query_write() called in [path]\includes\class_dm.php on line 740
#3 vB_DataManager->db_insert() called in [path]\includes\class_dm.php on line 890
#4 vB_DataManager->save() called in [path]\dbtech\vbshop\actions\admin\item.php on line 462
#5 include_once([path]\dbtech\vbshop\actions\admin\item.php) called in [path]\admincp\vbshop.php on line 84

 

[Fillip H.]

Could you please edit the issue and use the correct URL for your live forum? Thanks

 

[hero70411]

I'm building my forum on localhost :|

 

[hero70411]

Here is colums in table vbshop_item, plz help me !

 

[Fillip H.]

Try running this:

ALTER TABLE dbtech_vbshop_item ADD onlygiftable ENUM('0','1') NOT NULL DEFAULT '0'

 

[hero70411]

Solved ! Thank you !