Bug mySQL errors.

Status
Not open for further replies.
Website
http://www.clubsgaming.com/forums
Product version
2.2.5
Forum version
vBulletin 4.2.x
#1
Getting errors on 3 separate forms, they all worked when we set them up but now we cannot see them in the forums we assigned them to and when submitting we are presented with mySQL errors.

Error 1:
Code:
Database error in vBulletin 4.2.3:

Invalid SQL:
INSERT INTO dbtech_dbforms_entry
	(categoryid, questions, DOB, #, GT, Position, Nationality, Team, Previous, dateline, responses)
VALUES
	(4, 'a:7:{i:23;s:1:\"6\";i:29;s:1:\"6\";i:17;s:13:\"Unity Bluefin\";i:25;s:2:\"CB\";i:26;s:8:\"Scottish\";i:27;s:5:\"Unity\";i:28;s:3:\"n/a\";}', '6', '6', 'Unity Bluefin', 'CB', 'Scottish', 'Unity', 'n/a', 1452814545, 'a:2:{i:0;a:4:{s:6:\"userid\";i:1;s:6:\"postid\";i:15667;s:12:\"responsetype\";s:4:\"user\";s:8:\"dateline\";i:1452814545;}i:1;a:4:{s:6:\"userid\";i:1;s:6:\"postid\";i:15667;s:12:\"responsetype\";s:7:\"manager\";s:8:\"dateline\";i:1452814545;}}');

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 'VALUES
	(4, 'a:7:{i:23;s:1:\"6\";i:29;s:1:\"6\";i:17;s:13:\"Unity Bluefin\";i:2' at line 3
Error Number  : 1064
Request Date  : Thursday, January 14th 2016 @ 11:35:45 PM
Error Date    : Thursday, January 14th 2016 @ 11:35:45 PM
Script        : 
Referrer      : 
IP Address    : 
Username      : 
Classname     : vB_Database
MySQL Version : 5.5.46-0+deb7u1
Code:
Database error in vBulletin 4.2.3:

Invalid SQL:
INSERT INTO dbtech_dbforms_entry
	(categoryid, questions, DOB, #, GT, Position, Nationality, Team, Previous, dateline, responses)
VALUES
	(4, 'a:7:{i:23;s:1:\"6\";i:29;s:1:\"6\";i:17;s:13:\"Unity Bluefin\";i:25;s:2:\"CB\";i:26;s:8:\"Scottish\";i:27;s:5:\"Unity\";i:28;s:3:\"n/a\";}', '6', '6', 'Unity Bluefin', 'CB', 'Scottish', 'Unity', 'n/a', 1452814696, 'a:2:{i:0;a:4:{s:6:\"userid\";i:1;s:6:\"postid\";i:15670;s:12:\"responsetype\";s:4:\"user\";s:8:\"dateline\";i:1452814696;}i:1;a:4:{s:6:\"userid\";i:1;s:6:\"postid\";i:15670;s:12:\"responsetype\";s:7:\"manager\";s:8:\"dateline\";i:1452814696;}}');

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 'VALUES
	(4, 'a:7:{i:23;s:1:\"6\";i:29;s:1:\"6\";i:17;s:13:\"Unity Bluefin\";i:2' at line 3
Error Number  : 1064
Request Date  : Thursday, January 14th 2016 @ 11:38:16 PM
Error Date    : Thursday, January 14th 2016 @ 11:38:17 PM
Script        : 
Referrer      : 
IP Address    : 
Username      : 
Classname     : vB_Database
MySQL Version : 5.5.46-0+deb7u1
Code:
Database error in vBulletin 4.2.3:

Invalid SQL:
INSERT INTO dbtech_dbforms_entry
	(categoryid, statusid, questions, Current Gamertag, Age, experience, Pos, secondary, Availability, weaknesses, mic, skype, dateline, responses)
VALUES
	(1, 1, 'a:9:{i:30;s:13:\"Unity Bluefin\";i:7;s:2:\"27\";i:2;s:0:\"\";i:32;s:2:\"CB\";i:8;a:1:{i:0;s:3:\"CDM\";}i:35;s:4:\"Blah\";i:5;s:4:\"Blah\";i:6;s:3:\"Yes\";i:9;s:4:\"blah\";}', 'Unity Bluefin', '27', '', 'CB', 'CDM', 'Blah', 'Blah', 'Yes', 'blah', 1452814797, 'a:2:{i:0;a:4:{s:6:\"userid\";i:1;s:6:\"postid\";i:15673;s:12:\"responsetype\";s:4:\"user\";s:8:\"dateline\";i:1452814797;}i:1;a:4:{s:6:\"userid\";i:1;s:6:\"postid\";i:15673;s:12:\"responsetype\";s:7:\"manager\";s:8:\"dateline\";i:1452814797;}}');

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 'Gamertag, Age, experience, Pos, secondary, Availability, weaknesses, mic, skype,' at line 2
Error Number  : 1064
Request Date  : Thursday, January 14th 2016 @ 11:39:57 PM
Error Date    : Thursday, January 14th 2016 @ 11:39:57 PM
Script        : 
Referrer      : 
IP Address    : 
Username      : 
Classname     : vB_Database
MySQL Version : 5.5.46-0+deb7u1
Thats the 3 errors, each time we post with the forms were getting forums/newthread.php?do=newthread&f=31 on every single error,
 

Belazor

Staff member
Owner
Developer
Customer
#2
Hi there,

This is because some of the question's Varname fields are using unsupported characters. Please use only upper- and lower-case A-Z characters for these fields.

Could you please try erasing these invalid questions and replace them with valid varnames and see if this works for you?

Sorry for the inconvenience :(
 
#3
Hi there,

This is because some of the question's Varname fields are using unsupported characters. Please use only upper- and lower-case A-Z characters for these fields.

Could you please try erasing these invalid questions and replace them with valid varnames and see if this works for you?

Sorry for the inconvenience :(
I had fixed error 1,2 by the time I seen your response, I kinda figured it out as I went along, my fellow admin set it up and had symbols and spaces etc. Its fixed now, apologies for wasting your time.
 

Belazor

Staff member
Owner
Developer
Customer
#4
No problem at all :)

I'll look into adding validation code to the insertion to prevent this from happening in the future.

Thanks!
 
Status
Not open for further replies.

DragonByte vBForms

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