Status
Not open for further replies.

hero70411

New member
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
 
Could you please edit the issue and use the correct URL for your live forum? Thanks :)
 
Here is colums in table vbshop_item, plz help me !
sql.png
 

Attachments

  • sql.png
    sql.png
    228.9 KB · Views: 4
Try running this:
Code:
ALTER TABLE dbtech_vbshop_item ADD onlygiftable ENUM('0','1') NOT NULL DEFAULT '0'
 
Status
Not open for further replies.

Legacy vBShop

vBulletin 3.8.x vBulletin 4.x.x
Seller
DragonByte Technologies
Release date
Last update
Total downloads
1,260
Customer rating
0.00 star(s) 0 ratings
Back
Top