mySQL Error 1064 When Using Search

[GraphicW]

I get the following error message when I attempt to use the search function of Vbulletin:

Database error in vBulletin 3.0.7:

Invalid SQL: 
			SELECT threadid AS itemid, forumid,
			IF(postuserid = 1, 'self', 'other') AS starter
			FROM thread AS thread
			LEFT JOIN deletionlog AS delthread ON(delthread.primaryid = thread.threadid AND delthread.type = 'thread')
			WHERE threadid IN(17038, 17066, 17008, 16522, 17005, 16950, 16917, 11458, 16926, 13305, 16513, 16893, 1893, 1381, 16812, 14755, 16628, 15048, 1572, 16622, 16537, 16549, 16417, 16081, 15311, 16462, 9100, 16239, 15137, 16428, 13057, 15909, 16292, 16422, 16296, 16373, 16376, 16201, 16126, 15621, 7256, 1023, 16017, 15827, 14375, 14654, 15839, 15647, 15464, 15184, 15663, 15237, 15175, 15575, 12785, 15515, 15452, 15117, 15107, 15384, 8377, 15105, 11054, 15124, 15263, 15194, 15179, 12700, 15130, 13921, 14749, 14725, 14914, 14831, 14520, 14690, 14630, 14350, 14193, 14364, 14428, 14381, 14237, 14384, 14349, 11394, 11989, 13027, 14091, 13784, 14023, 13816, 13783, 13941, 13909, 10937, 13786, 13777, 13233, 13330, 13702, 13707, 13620, 10325, 13564, 13306, 13421, 13510, 13554, 13395, 13418, 13378, 13277, 11958, 12486, 13293, 12610, 12621, 13169, 12625, 11994, 13115, 13204, 2397, 9629, 11599, 12585, 12008, 12731, 12797, 10947, 12402, 6023, 8602, 12595, 12432, 4164, 12193, 12420, 6213, 7468, 12334, 12258, 12185, 6620, 12004, 9970, 11663, 11835, 11814, 11478, 11602, 10948, 11196, 11272, 8326, 11076, 10743, 11073, 11124, 11167, 11057, 10920, 10960, 10854, 10421, 10272, 10301, 10147, 9736, 9984, 9976, 9829, 9239, 9690, 9510, 9561, 9777, 8205, 9426, 4950, 9512, 9308, 9421, 9384, 9322, 9344, 9188, 8265, 7229, 9154, 8381, 6234, 8665, 8748, 7980, 8554, 8571, 5254, 8439, 8514, 8268, 8462, 7610, 8318, 8012, 8204, 8116, 8140, 7940, 7978, 4834, 7928, 7447, 7407, 6191, 7081, 7634, 3385, 6227, 7195, 7514, 6999, 7123, 7141, 6989, 6775, 6724, 6859, 5985, 6734, 6607, 6586, 6533, 6486, 6422, 6515, 5511, 6373, 6328, 4078, 6247, 5851, 5292, 6127, 5786, 6078, 5750, 5855, 5779, 5698, 5620, 4413, 5424, 2374, 5062, 4870, 5305, 4888, 4889, 4946, 4616, 5105, 5136, 4040, 5106, 4838, 4393, 4449, 4989, 4958, 4903, 4932, 4893, 4858, 4856, 4415, 4475, 4672, 4741, 4693, 3467, 4720, 4490, 4615, 4383, 4546, 4368, 4518, 4239, 2534, 4324, 4148, 4067, 4029, 4129, 4190, 4184, 4229, 4125, 1614, 2421, 4163, 3404, 3895, 3850, 3497, 3463, 3875, 3835, 3716, 3490, 3643, 3427, 3595, 3494, 3526, 517, 3064, 2707, 3292, 1513, 1414, 3263, 2640, 3170, 2916, 1044, 3005, 2848, 2740, 2753, 2212, 2699, 2648, 2069, 2371, 2376, 2334, 2394, 2391, 2380, 1740, 2232, 1903, 2132, 1673, 2078, 2063, 2066, 1892, 1937, 1646, 1139, 1891, 1889, 450, 1677, 1789, 1722, 1029, 1676, 1632, 1686, 1647, 1655, 1634, 1559, 1510, 1577, 1563, 1240, 1387, 1319, 536, 1320, 945, 1134, 1234, 347, 529, 71, 534, 95, 83, 667, 672, 653, 679, 992, 636, 851, 841, 638, 611, 625, 619, 1027, 905, 742)
			AND delthread.primaryid IS NULL
			AND thread.open <> 10
			AND thread.visible = 1
			AND thread.postuserid NOT IN (61.68.164.116)
		
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 '.164.116)' at line 9

mysql error number: 1064

I have the following hacks installed:

VBadvanced cmps
Webtemplates
VBjournal 1.0.0
Cinq's Article Hack
VBadvanced Gallery
IB Pro Arcade
Rules Hack

The problem started shortly after installing the VBadvanced Gallery, however, it was not immediate. I have reverted Vbulletin files installed during the VBadvanced Gallery mod to their state before the install. This does not fix the problem.

I appreciate any help I can get. I do not know enough about MySQL error messages to understand what they mean. Hopefully I can find the source of it. Thanks once again.

[Zachery]

Originally Posted by GraphicW

I get the following error message when I attempt to use the search function of Vbulletin:

Database error in vBulletin 3.0.7:

Invalid SQL: 
			SELECT threadid AS itemid, forumid,
			IF(postuserid = 1, 'self', 'other') AS starter
			FROM thread AS thread
			LEFT JOIN deletionlog AS delthread ON(delthread.primaryid = thread.threadid AND delthread.type = 'thread')
			WHERE threadid IN(17038, 17066, 17008, 16522, 17005, 16950, 16917, 11458, 16926, 13305, 16513, 16893, 1893, 1381, 16812, 14755, 16628, 15048, 1572, 16622, 16537, 16549, 16417, 16081, 15311, 16462, 9100, 16239, 15137, 16428, 13057, 15909, 16292, 16422, 16296, 16373, 16376, 16201, 16126, 15621, 7256, 1023, 16017, 15827, 14375, 14654, 15839, 15647, 15464, 15184, 15663, 15237, 15175, 15575, 12785, 15515, 15452, 15117, 15107, 15384, 8377, 15105, 11054, 15124, 15263, 15194, 15179, 12700, 15130, 13921, 14749, 14725, 14914, 14831, 14520, 14690, 14630, 14350, 14193, 14364, 14428, 14381, 14237, 14384, 14349, 11394, 11989, 13027, 14091, 13784, 14023, 13816, 13783, 13941, 13909, 10937, 13786, 13777, 13233, 13330, 13702, 13707, 13620, 10325, 13564, 13306, 13421, 13510, 13554, 13395, 13418, 13378, 13277, 11958, 12486, 13293, 12610, 12621, 13169, 12625, 11994, 13115, 13204, 2397, 9629, 11599, 12585, 12008, 12731, 12797, 10947, 12402, 6023, 8602, 12595, 12432, 4164, 12193, 12420, 6213, 7468, 12334, 12258, 12185, 6620, 12004, 9970, 11663, 11835, 11814, 11478, 11602, 10948, 11196, 11272, 8326, 11076, 10743, 11073, 11124, 11167, 11057, 10920, 10960, 10854, 10421, 10272, 10301, 10147, 9736, 9984, 9976, 9829, 9239, 9690, 9510, 9561, 9777, 8205, 9426, 4950, 9512, 9308, 9421, 9384, 9322, 9344, 9188, 8265, 7229, 9154, 8381, 6234, 8665, 8748, 7980, 8554, 8571, 5254, 8439, 8514, 8268, 8462, 7610, 8318, 8012, 8204, 8116, 8140, 7940, 7978, 4834, 7928, 7447, 7407, 6191, 7081, 7634, 3385, 6227, 7195, 7514, 6999, 7123, 7141, 6989, 6775, 6724, 6859, 5985, 6734, 6607, 6586, 6533, 6486, 6422, 6515, 5511, 6373, 6328, 4078, 6247, 5851, 5292, 6127, 5786, 6078, 5750, 5855, 5779, 5698, 5620, 4413, 5424, 2374, 5062, 4870, 5305, 4888, 4889, 4946, 4616, 5105, 5136, 4040, 5106, 4838, 4393, 4449, 4989, 4958, 4903, 4932, 4893, 4858, 4856, 4415, 4475, 4672, 4741, 4693, 3467, 4720, 4490, 4615, 4383, 4546, 4368, 4518, 4239, 2534, 4324, 4148, 4067, 4029, 4129, 4190, 4184, 4229, 4125, 1614, 2421, 4163, 3404, 3895, 3850, 3497, 3463, 3875, 3835, 3716, 3490, 3643, 3427, 3595, 3494, 3526, 517, 3064, 2707, 3292, 1513, 1414, 3263, 2640, 3170, 2916, 1044, 3005, 2848, 2740, 2753, 2212, 2699, 2648, 2069, 2371, 2376, 2334, 2394, 2391, 2380, 1740, 2232, 1903, 2132, 1673, 2078, 2063, 2066, 1892, 1937, 1646, 1139, 1891, 1889, 450, 1677, 1789, 1722, 1029, 1676, 1632, 1686, 1647, 1655, 1634, 1559, 1510, 1577, 1563, 1240, 1387, 1319, 536, 1320, 945, 1134, 1234, 347, 529, 71, 534, 95, 83, 667, 672, 653, 679, 992, 636, 851, 841, 638, 611, 625, 619, 1027, 905, 742)
			AND delthread.primaryid IS NULL
			AND thread.open <> 10
			AND thread.visible = 1
			AND thread.postuserid NOT IN (61.68.164.116)
		
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 '.164.116)' at line 9

mysql error number: 1064

I have the following hacks installed:

VBadvanced cmps
Webtemplates
VBjournal 1.0.0
Cinq's Article Hack
VBadvanced Gallery
IB Pro Arcade
Rules Hack

The problem started shortly after installing the VBadvanced Gallery, however, it was not immediate. I have reverted Vbulletin files installed during the VBadvanced Gallery mod to their state before the install. This does not fix the problem.

I appreciate any help I can get. I do not know enough about MySQL error messages to understand what they mean. Hopefully I can find the source of it. Thanks once again.

For some reason... you have a userid listed either with "."'s instead of ","'s or... you are using an IP address

[GraphicW]

Originally Posted by Zachery

For some reason... you have a userid listed either with "."'s instead of ","'s or... you are using an IP address

That was a pretty fast response. How would I go about finding the source of the problem? Where should I start to look? Thanks for letting me know the issue at hand. I at least a have a better idea of the issue at hand now.

Thank You Zach. You gave me enough information that I was able to look in my admin panel and find the source of my problem. The problem was in Tachy Goes to Coventry. One of the my admins put .'s after the user id's rather than spaces.