[RESOLVED] Database Error

[Siddharth Rout]

Hi

If you click on Search~~>Advanced Search

And Type the following in the order it is written below

Search by User Name: koolsid
Search by Keyword : Code

and press "Enter"

I get the following screen... Sometimes it gives me the SQL Error...

Works if I change the "keyword"

[Nightwalker83]

Maybe the database crashes because there are too many entries including the word "code".

[Siddharth Rout]

Did it happen with you as well?

[Nightwalker83]

Did it happen with you as well?

Yes, however, this is the first time I noticed it! The last time I used the search function to search for the term "code" (a couple of weeks ago) that error didn't occur.

[RobDog888]

Its probably a bug as it doesnt matter who or what other criteria you place in the search box, only need to search by "code". Its not tied to a particular member or such or even the advanced search. Its any search. ie: dropdown toolbar search too.

On other versions of vB it works fine. So it could be specific to this version or something specific to this install of vB.

[Nightwalker83]

Below the above mentioned error:

Database Error Database error
The VBForums database has encountered a problem.
Please try the following:

* Load the page again by clicking the Refresh button in your web browser.
* Open the www.vbforums.com home page, then try to open another page.
* Click the Back button to try another link.

The www.vbforums.com forum technical staff have been notified of the error, though you may contact them if the problem persists.

We apologise for any inconvenience.

Edit:

Is this:

<!-- Database error in vBulletin 3.8.1: Invalid SQL: SELECT thread.threadid, thread.forumid, post.userid FROM thread AS thread INNER JOIN post AS post ON(thread.threadid = post.threadid ) WHERE post.postid IN(1,2,6,7,10,11,12,14,15,18,21,33,42,50,54,59,60,62,64,71,98,105,113,114,118,154,163,177,190,192,19 4,199,211,213,216,217,221,222,223,224,225,227,228,229,233,240,247,254,262,269,295,299,321,323,324,32 5,342,352,355,359,360,364,380,401,403,405,413,416,424,437,438,443,449,462,467,471,480,482,487,508,51 3,514,519,521,525,532,534,538,539,544,548,549,551,552,555,560,565,568,578,592,600,603,605,621,622,62 3,628,633,642,644,665,668,669,683,684,688,693,699,726,736,746,748,750,767,770,774,776,790,796,799,80 8,820,825,828,829,833,836,838,839,841,847,853,866,874,877,884,904,910,921,927,933,951,975,987,995,99 9,1001,1009,1013,1015,1017,1018,1026,1042,1043,1050,1068,1072,1078,1085,1089,1093,1096,1098,1106,110 8,1118,1128,1138,1151,1182,1185,1187,1204,1205,1213,1215,1217,1219,1228,1232,1235,1236,1242,1244,125 4,1257,1261,1265,1270,1274,1283,1293,1300,1313,1314,1316,1317,1318,1319,1321,1331,1351,1358,1364,137 5,1415,1420,1436,1442,1444,1446,1448,1452,1455,1460,1477,1488,1489,1494,1496,1500,1504,1511,1513,151 5,1516,1524,1543,1546,1549,1550,1552,1556,1557,1558,1562,1564,1574,1578,1582,1585,1586,1588,1593,159 6,1599,1600,1601,1603,1605,1607,1619,1626,1638,1641,1652,1654,1658,1666,1667,1670,1674,1675,1684,169 1,1693,1710,1717,1723,1727,1756,1758,1767,1769,1775,1776,1777,1785,1787,1793,1795,1800,1804,1808,181 0,1811,1812,1828,1835,1848,1856,1861,1863,1864,1880,1889,1902,1904,1907,1909,1910,1911,1919,1924,193 1,1932,1934,1943,1945,1947,1951,1957,1960,1961,1964,1965,1967,1974,1980,1981,1989,1993,1997,1998,199 9,2000,2018,2024,2028,2035,2044,2052,2053,2057,2058,2063,2069,2083,2085,2090,2091,2092,2093,2095,210 7,2108,2109,2111,2113,2119,2122,2128,2130,2131,2138,2149,2152,2161,2165,2169,2172,2176,2182,2184,218 7,2200,2225,2229,2231,2233,2234,2235,2236,2241,2272,2281,2293,2305,2308,2318,2342,2344,2350,2353,236 2,2363,2365,2384,2389,2392,2393,2394,2401,2408,2414,2417,2421,2437,2442,2445,2450,2466,2468,2471,247 4,2480,2484,2486,2488,2491,2503,2510,2514,2520,2522,2533,2545,2546,2547,2548,2550,2554,2556,2564,256 7,2585,2590,2592,2593,2598,2605,2608,2620,2622,2628,2647,2654,2662,2666,2672,2674,2684,2688,2690,270 1,2705,2715,2726,2732,2742,2748,2756,2768,2775,2777,2778,2779,2785,2786,2790,2795,2806,2815,2831,283 4,2837,2847,2854,2855,2856,2858,2862,2871,2884,2886,2889,2891,2894,2902,2906,2908,2917,2919,2923,293 0,2944,2950,2956,2972,2977,2985,2987,2991,2999,3005,3007,3015,3027,3028,3032,3041,3045,3051,3061,306 2,3065,3066,3084,3090,3104,3114,3123,3134,3140,3143,3147,3148,3150,3161,3168,3179,3180,3190,3193,319 8,3200,3202,3206,3207,3218,3224,3226,3236,3238,3250,3254,3256,3261,3265,3268,3274,3275,3276,3291,329 8,3302,3304,3307,3321,3322,3324,3328,3334,3336,3338,3339,3342,3347,3349,3350,3364,3369,3375,3381,338 2,3407,3413,3428,3433,3436,3437,3439,3440,3446,3451,3452,3465,3466,3469,3483,3484,3486,3489,3490,350 1,3513,3519,3521,3543,3547,3555,3571,3583,3595,3599,3657,3669,3676,3682,3685,3690,3695,3696,3705,370 7,3710,3711,3713,3714,3719,3725,3727,3746,3750,3757,3772,3787,3788,3794,3802,3811,3818,3826,3828,383 9,3847,3849,3851,3855,3860,3870,3871,3878,3889,3896,3899,3906,3919,3924,3928,3947,3949,3963,3967,397 0,3971,3973,3974,3997,4005,4006,4007,4009,4011,4023,4032,4033,4042,4050,4062,4075,4078,4081,4082,409 5,4097,4105,4108,4114,4116,4124,4128,4131,4149,4155,4162,4164,4166,4170,4172,4173,4174,4177,4180,418 7,4191,4206,4208,4209,4210,4213,4219,4231,4233,4239,4243,4245,4246,4265,4266,4275,4281,4285,4301,432 7,4328,4330,4332,4334,4336,4343,4348,4349,4352,4362,4363,4366,4369,4379,4381,4385,4393,4398,4416,441 9,4428,4430,4439,4448,4449,4451,4452,4453,4457,4459,4464,4473,4477,4510,4524,4525,4527,4528,4531,453 2,4536,4543,4545,4546,4547,4550,4551,4555,4558,4568,4573,4580,4583,4586,4590,4603,4605,4607,4611,461 2,4624,4625,4626,4630,4638,4640,4642,4645,4668,4676,4679,4681,4684,4686,4700,4701,4709,4710,4714,472 0,4722,4725,4735,4740,4749,4750,4773,4775,4776,4780,4800,4807,4809,4811,4812,4819,4821,4862,4864,486 6,4892,4893,4894,4897,4904,4910,4915,4920,4923,4927,4939,4942,4943,4945,4950,4952,4953,4954,4956,495 8,4961,4973,4978,4983,4995,5009,5011,5012,5019,5029,5031,5038,5040,5056,5063,5066,5079,5081,5084,509 2,5093,5095,5106,5108,5109,5119,5120,5125,5127,5129,5130,5131,5133,5144,5145,5150,5153,5159,5169,517 4,5177,5178,5181,5185,5188,5203,5215,5219,5223,5228,5240,5251,5279,5280,5298,5300,5306,5308,5310,531 1,5313,5330,5333,5334,5335,5338,5342,5343,5355,5361,5362,5363,5369,5373,5376,5377,5379,5382,5389,539 5,5405,5407,5410,5413,5420,5423,5432,5436,5442,5444,5466,5467,5468,5471,5472,5473,5474,5476,5534,553 5,5536,5537,5539,5557,5569,5574,5575,5580,5582,5585,5587,5594,5596,5600,5612,5614,5618,5621,5636,564 1,5644,5646,5649,5654,5655,5657,5673,5677,5684,5688,5695,5702,5706,5712,5713,5716,5722,5725,5744,574 8,5752,5755,5756,5761,5766,5770,5773,5777,5785,5789,5794,5799,5801,5803,5804,5811,5821,5824,5827,582 8,5832,5833,5841,5842,5843,5845,5855,5905,5906,5913,5920,5923,5940,5957,5959,5960,5961,5968,5973,597 6,5984,5986,5987,5991,6013,6027,6063,6070,6080,6081,6082,6088,6114,6115,6119,6122,6127,6129,6130,613 8,6139,6141,6142,6144,6147,6151,6163,6170,6174,6176,6177,6180,6182,6183,6185,6199,6212,6215,6218,621 9,6220,6225,6229,6230,6233,6237,6246,6247,6249,6252,6254,6255,6256,6263,6265,6266,6268,6269,6278,627 9,6280,6282,6283,6287,6288,6291,6292,6293,6295,6296,6299,6302,6323,6331,6335,6340,6341,6343,6345,636 6,6370,6372,6390,6395,6407,6409,6420,6423,6424,6425,6427,6433,6448,6463,6474,6475,6476,6484,6489,649 3,6495,6503,6520,6521,6525,6531,6537,6546,6548,6569,6572,6573,6575,6580,6582,6587,6588,6590,6595,659 7,6612,6614,6615,6623,6624,6629,6635,6645,6647,6654,6659,6662,6680,6696,6700,6707,6710,6716,6722,672 5,6727,6729,6750,6768,6773,6776,6779,6788,6800,6822,6826,6834,6835,6839,6848,6850,6853,6873,6889,690 6,6915,6919,6920,6927,6929,6931,6934,6935,6940,6946,6955,6970,6972,6973,6974,6979,6989,6995,7001,700 3,7015,7021,7023,7031,7034,7035,7036,7037,7039,7043,7069,7070,7071,7085,7088,7089,7092,7094,7095,710 0,7102,7104,7106,7107,7110,7111,7113,7114,7115,7116,7117,7123,7132,7141,7147,7150,7159,7160,7172,717 5,7177,7198,7202,7206,7207,7213,7215,7217,7218,7219,7244,7245,7267,7268,7269,7273,7279,7280,7292,729 6,7301,7304,7313,7323,7326,7328,7336,7338,7339,7347,7354,7355,7357,7358,7359,7360,7366,7367,7368,736 9,7372,7378,7387,7389,7394,7396,7398,7407,7430,7431,7433,7449,7468,7473,7489,7496,7497,7509,7511,751 5,7523,7525,7533,7537,7540,7550,7551,7554,7556,7557,7558,7560,7566,7569,7571,7587,7588,7591,7592,759 6,7598,7610,7611,7618,7624,7625,7628,7641,7645,7647,7650,7651,7656,7664,7666,7677,7678,7684,7687,769 1,7700,7702,7706,7708,7716,7740,7741,7742,7744,7755,7756,7760,7764,7766,7767,7773,7775,7785,7788,779 1,7799,7813,7816,7817,7821,7827,7828,7839,7844,7846,7847,7884,7888,7889,7895,7898,7904,7909,7913,791 8,7949,7970,7971,7972,7980,7981,7983,7986,7987,7988,7990,7992,7993,7994,8001,8007,8010,8023,8026,803 3,8037,8044,8052,8060,8063,8069,8091,8093,8106,8112,8118,8120,8125,8134,8149,8155,8163,8168,8169,817 3,8174,8176,8177,8184,8193,8195,8251,8256,8260,8269,8280,8302,8304,8305,8307,8319,8323,8324,8325,832 6,8332,8337,8359,8360,8367,8368,8376,8377,8385,8394,8409,8419,8421,8428,8429,8440,8442,8443,8445,846 6,8473,8474,8476,8478,8480,8495,8499,8507,8513,8517,8522,8527,8531,8539,8546,8555,8556,8557,8558,856 2,8565,8567,8572,8573,8576,8590,8599,8605,8610,8615,8616,8617,8619,8620,8622,8645,8652,8654,8656,865 8,8662,8663,8664,8666,8668,8675,8682,8692,8693,8694,8696,8702,8703,8705,8709,8710,8711,8724,8728,873 0,8732,8733,8741,8745,8750,8751,8761,8766,8778,8779,8789,8795,8821,8822,8836,8847,8850,8851,8863,886 4,8866,8867,8868,8869,8870,8871,8896,8909,8910,8918,8923,8932,8936,8937,8938,8945,8950,8953,8954,895 5,8956,8957,8965,8977,8979,8981,8984,8992,8998,9000,9002,9010,9035,9036,9040,9045,9058,9062,9063,906 4,9065,9072,9085,9088,9090,9094,9097,9115,9116,9118,9119,9122,9126,9132,9133,9135,9138,9139,9141,914 8,9151,9152,9157,9158,9160,9172,9173,9174,9181,9182,9185,9186,9187,9188,9190,9192,9195,9197,9199,920 0,9201,9202,9203,9205,9211,9222,9223,9225,9230,9231,9232,9234,9235,9245,9247,9289,9294,9304,9319,932 0,9323,9324,9340,9361,9362,9367,9371,9377,9388,9391,9401,9403,9413,9414,9420,9425,9429,9430,9435,943 8,9439,9440,9460,9465,9469,9481,9483,9486,9487,9492,9522,9526,9529,9531,9566,9567,9570,9581,9588,959 3,9595,9596,9601,9603,9606,9608,9615,9616,9617,9619,9626,9633,9640,9646,9654,9655,9666,9670,9672,967 3,9679,9681,9691,9699,9705,9707,9708,9712,9725,9731,9738,9744,11288,11289,11298,11300,11301,11305,11 306,11316,11318,11320,11321,11322,11328,11350,11352,11356,11365,11366,11367,11368,11369,11380,11385, 11387,11399,11403,11404,11418,11425,11459,11461,11485,11487,11488,11492,11494,11507,11509,11515,1152 1,11531,11544,11545,11546,11547,11559,11561,11566,11568,11569,11570,11571,11577,11584,11589,11591,11 592,11593,11615,11620,11626,11627,11634,11635,11646,11650,11652,11656,11657,11661,11662,11667,11684, 11691,11711,11714,11724,11761,11765,11770,11774,11787,11789,11801,11806,11808,11820,11824,11832,1183 8,11854,11857,11861,11871,11872,11880,11882,11885,11914,11927,11931,11933,11934,11945,11947,11955,11 959,11962,11978,11996,11999,12009,12021,12023,12026,12030,12049,12050,12060,12061,12074,12078,12085, 12086,12093,12095,12098,12100,12115,12117,12119,12129,12135,12142,12172,12183,12199

[RobDog888]

Maybe the sql statement is just a bit too long.

[Nightwalker83]

Maybe the sql statement is just a bit too long.

Although, that sql string I pasted above only appears if after the error appears you click reload (in the browser), resend (on the pop box) then stop (in the browser).

[si_the_geek]

This should now be fixed, as the word "code" has been added to the list of words that the search ignores.

[Siddharth Rout]

This should now be fixed, as the word "code" has been added to the list of words that the search ignores.

I have checked it and it is working now.

Thank you.

Sidz