Bug mySQL errors.

[Hecter]

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:

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

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

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,

 

[Fillip H.]

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

 

[Hecter]

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.

 

[Fillip H.]

No problem at all

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

Thanks!