Hi, i get everyday mysql errors, this errormail is about 1 MB big an has to do with search i do not post the whole mail it´s too big but an snapshot :
Database error in vBulletin 2.2.1:
Invalid SQL: SELECT searchid FROM search WHERE showposts='0' AND query=' 1=1 AND NOT (thread.forumid=\'56\' OR thread.forumid=\'63\' OR thread.forumid=\'38\' OR thread.forumid=\'72\' OR thread.forumid=\'73\' OR thread.forumid=\'16\' OR thread.forumid=\'57\' OR thread.forumid=\'50\' OR thread.forumid=\'61\' OR thread.forumid=\'45\' OR thread.forumid=\'60\' OR thread.forumid=\'58\' OR thread.forumid=\'65\' OR thread.forumid=\'64\')' AND postids='405,414,415,417,421,422,423,424,425,426,427,430,431,1168,1170,1502,1503,1504,1506 ,1507,1508,1509,1510,1511,1514,1515,1516,1519,1521,1523,1926,1927,1928,1930,1934,1935,1937 ,1939,1940,1941,1943,1944,1946,1947,1948,1949,1950,1951,1952,1954,1955,1956,1957,2311,2314 ,2315,2316,2666,2667,2668,2669,2670,2672,2783,2785,2787,2788,2789,2790,2792,2793,2794,2798 ,2799,2801,2802,2803,2804,2807,2808,2810,2811,2812,2813,2814,2816,2817,2818,2820,2821,2822 ,2823,2824,2825,2827,2828,2829,2830,2831,2832,2833,2834,2835,2838,2839,2840,2841,2842,2843 ,2844,2845,!
2848,2850,2851,2852,3180,3181,3182,3185,3186,3188,3189,3190,3192,3194,3681,3682,3685,3771, 3772,3773,3774,3775,3776,3777,3778,3779,3900,3903,3905,3906,3912,3916,3918,3919,3920,3921, 3923,3926,3930,3931,3932,3934,3935,3936,3937,3940,3942,3943,3946,3947,3949,3950,3951,4050, 4051,4052,4053,4054,4055,4056,4057,4058,4059,4060,4061,4063,4066,4067,4068,4069,4070,4071, 4072,4073,4074,4075,4076,4077,4078,4079,4080,4081,4082,4083,4084,4085,4086,4087,4089,4090, 4092,4093,4094,4095,4096,4097,4098,4099,4100,4101,4102,4103,4104,4107,4109,4113,4114,4115, 4116,4117,4118,4121,4122,4124,4125,4129,4131,4134,4136,4163,4164,4165,4166,4167,4168,4169, 4483,4484,4485,4487,4489,4490,4491,4493,4497,4500,4501,4504,4507,4508,4511,4514,4517,4518, 4520,4521,4522,4523,4524,4526,4527,4528,4530,4531,4532,4854,4856,4857,4858,4860,4861,4862, 4864,5023,5024,5025,5026,5027,5028,5029,5030,5032,5033,5036,5037,5039,5040,5041,5042,5043, 5046,5049,5050,5051,5052,5053,5054,5055,5056,5057,5058,5059,5060,5061,5062,5063,5064,5065, 5!
066,5069,5070,5071,5072,5073,5075,5076,5077,6505,6507,6509,6510,6511,6512,6514,6516,6520,6 521,6522,6523,6524,6525,6526,6528,6530,6531,6532,6533,6535,6536,6537,6539,6540,6608,6609,6 613,6614,6615,6616,6617,6618,6619,6622,6623,6626,6627,6629,6633,6634,6635,6636,6639,6640,6 813,6816,6817,6818,6819,6822,6826,6830,6831,6833,6839,6840,6842,7469,7470,7780,7782,7786,7 790,7791,7792,7793,7794,7795,7796,7798,7799,7800,7801,7802,7803,7806,7807,7811,8360,8363,8 366,8379,8387,8388,8389,9054,9058,9059,10811,10812,10813,10814,10815,10818,10819,10820,108 21,10822,10824,10825,10826,10827,10828,10832,10833,10834,10836,10837,10838,10839,10842,108 43,10846,10848,10849,10852,10853,11661,11664,11665,11667,11668,11670,11671,11672,11673,116 74,11675,11676,11679,11680,11681,11682,11683,11685,11686,11687,11688,11690,11691,11692,116 94,11697,11698,11700,11702,11703,11704,11705,11707,11709,11711,11712,11714,11716,11717,117 20,11722,11724,11725,11727,11728,11734,11735,11736,11737,11739,11740,11741,11743,11744,117 4!
many lines more like this than,
1142,651143,651144,651146,651147,651148,651151,' AND querystring='ich'
mysql error: MySQL server has gone away
mysql error number: 2006
Date: Wednesday 19th of December 2001 10:00:51 PM
Script: http://www.wbc-board.to/forum/forum/search.php
Referer: http://www.wbc-board.to/forum/search.php?s=
i´m on an dedicated dual PIII 1000 with 1 GB Ram, php 4.06 and newest mysql. I dead make an update of counters and everything but still get this error everyday twice or more. What is the Problem ?
Database error in vBulletin 2.2.1:
Invalid SQL: SELECT searchid FROM search WHERE showposts='0' AND query=' 1=1 AND NOT (thread.forumid=\'56\' OR thread.forumid=\'63\' OR thread.forumid=\'38\' OR thread.forumid=\'72\' OR thread.forumid=\'73\' OR thread.forumid=\'16\' OR thread.forumid=\'57\' OR thread.forumid=\'50\' OR thread.forumid=\'61\' OR thread.forumid=\'45\' OR thread.forumid=\'60\' OR thread.forumid=\'58\' OR thread.forumid=\'65\' OR thread.forumid=\'64\')' AND postids='405,414,415,417,421,422,423,424,425,426,427,430,431,1168,1170,1502,1503,1504,1506 ,1507,1508,1509,1510,1511,1514,1515,1516,1519,1521,1523,1926,1927,1928,1930,1934,1935,1937 ,1939,1940,1941,1943,1944,1946,1947,1948,1949,1950,1951,1952,1954,1955,1956,1957,2311,2314 ,2315,2316,2666,2667,2668,2669,2670,2672,2783,2785,2787,2788,2789,2790,2792,2793,2794,2798 ,2799,2801,2802,2803,2804,2807,2808,2810,2811,2812,2813,2814,2816,2817,2818,2820,2821,2822 ,2823,2824,2825,2827,2828,2829,2830,2831,2832,2833,2834,2835,2838,2839,2840,2841,2842,2843 ,2844,2845,!
2848,2850,2851,2852,3180,3181,3182,3185,3186,3188,3189,3190,3192,3194,3681,3682,3685,3771, 3772,3773,3774,3775,3776,3777,3778,3779,3900,3903,3905,3906,3912,3916,3918,3919,3920,3921, 3923,3926,3930,3931,3932,3934,3935,3936,3937,3940,3942,3943,3946,3947,3949,3950,3951,4050, 4051,4052,4053,4054,4055,4056,4057,4058,4059,4060,4061,4063,4066,4067,4068,4069,4070,4071, 4072,4073,4074,4075,4076,4077,4078,4079,4080,4081,4082,4083,4084,4085,4086,4087,4089,4090, 4092,4093,4094,4095,4096,4097,4098,4099,4100,4101,4102,4103,4104,4107,4109,4113,4114,4115, 4116,4117,4118,4121,4122,4124,4125,4129,4131,4134,4136,4163,4164,4165,4166,4167,4168,4169, 4483,4484,4485,4487,4489,4490,4491,4493,4497,4500,4501,4504,4507,4508,4511,4514,4517,4518, 4520,4521,4522,4523,4524,4526,4527,4528,4530,4531,4532,4854,4856,4857,4858,4860,4861,4862, 4864,5023,5024,5025,5026,5027,5028,5029,5030,5032,5033,5036,5037,5039,5040,5041,5042,5043, 5046,5049,5050,5051,5052,5053,5054,5055,5056,5057,5058,5059,5060,5061,5062,5063,5064,5065, 5!
066,5069,5070,5071,5072,5073,5075,5076,5077,6505,6507,6509,6510,6511,6512,6514,6516,6520,6 521,6522,6523,6524,6525,6526,6528,6530,6531,6532,6533,6535,6536,6537,6539,6540,6608,6609,6 613,6614,6615,6616,6617,6618,6619,6622,6623,6626,6627,6629,6633,6634,6635,6636,6639,6640,6 813,6816,6817,6818,6819,6822,6826,6830,6831,6833,6839,6840,6842,7469,7470,7780,7782,7786,7 790,7791,7792,7793,7794,7795,7796,7798,7799,7800,7801,7802,7803,7806,7807,7811,8360,8363,8 366,8379,8387,8388,8389,9054,9058,9059,10811,10812,10813,10814,10815,10818,10819,10820,108 21,10822,10824,10825,10826,10827,10828,10832,10833,10834,10836,10837,10838,10839,10842,108 43,10846,10848,10849,10852,10853,11661,11664,11665,11667,11668,11670,11671,11672,11673,116 74,11675,11676,11679,11680,11681,11682,11683,11685,11686,11687,11688,11690,11691,11692,116 94,11697,11698,11700,11702,11703,11704,11705,11707,11709,11711,11712,11714,11716,11717,117 20,11722,11724,11725,11727,11728,11734,11735,11736,11737,11739,11740,11741,11743,11744,117 4!
many lines more like this than,
1142,651143,651144,651146,651147,651148,651151,' AND querystring='ich'
mysql error: MySQL server has gone away
mysql error number: 2006
Date: Wednesday 19th of December 2001 10:00:51 PM
Script: http://www.wbc-board.to/forum/forum/search.php
Referer: http://www.wbc-board.to/forum/search.php?s=
i´m on an dedicated dual PIII 1000 with 1 GB Ram, php 4.06 and newest mysql. I dead make an update of counters and everything but still get this error everyday twice or more. What is the Problem ?
Comment