vb.org Archive - mySQL Error 1064 When Using Search

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)

- - mySQL Error 1064 When Using Search (https://vborg.vbsupport.ru/showthread.php?t=78411)

mySQL Error 1064 When Using Search

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

Code:

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.

Quote:

Originally Posted by GraphicW

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

Code:

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

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

Quote:

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.

X vBulletin 3.8.12 by vBS Debug Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (2)bbcode_code_printable (2)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (3)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02458 seconds Memory Usage 1,739KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (2)bbcode_code_printable (2)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (3)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: