Question Problem with VBForms

Status
Not open for further replies.

Henk Keuris

Customer
When I create a thread with the forms activated, it gives a db error

Database error in vBulletin 4.2.2:

Invalid SQL:
INSERT INTO vb_dbtech_dbforms_entry
(categoryid, questions, item, age, warranty, packaging, condition, location, reason, shipping, collection, price, link, dateline, responses)
VALUES
(2, 'a:11:{i:2;s:9:"test item";i:3;s:7:"2 years";i:4;s:4:"nope";i:5;s:4:"nope";i:6;s:4:"nope";i:7;s:4:"nope";i:8;s:4:"nope";i:9;s:4:"nope";i:10;s:4:"nope";i:11;s:4:"nope";i:12;s:4:"nope";}', 'test item', '2 years', 'nope', 'nope', 'nope', 'nope', 'nope', 'nope', 'nope', 'nope', 'nope', 1428500615, 'a:2:{i:0;a:4:{s:6:"userid";i:1;s:6:"postid";i:666340;s:12:"responsetype";s:4:"user";s:8:"dateline";i:1428500615;}i:1;a:4:{s:6:"userid";i:1;s:6:"postid";i:666340;s:12:"responsetype";s:7:"manager";s:8:"dateline";i:1428500615;}}');

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'condition, location, reason, shipping, collection, price, link, dateline, respon' at line 2
Error Number : 1064
Request Date : Wednesday, April 8th 2015 @ 03:43:35 PM
Error Date : Wednesday, April 8th 2015 @ 03:43:35 PM
Script : Carbonite.co.za - Free South African Tech Classifieds
Referrer : Carbonite.co.za - Free South African Tech Classifieds
IP Address : 105.208.130.147
Username : Firestar
Classname : vB_Database
MySQL Version : 5.5.36-cll

Any ideas?
 
"condition" is a reserved MySQL keyword. Please delete that question and use a different varname when re-creating it :)
 
As this ticket has received no further replies, I'll close it.

If you have any further questions or issues, please feel free to create a new ticket. Thanks!
 
Status
Not open for further replies.

Legacy DragonByte vBForms

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