Site 1 : Mysql errors
2013-06-19 21:58:23 : Mysql error: 1064 (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 'THEN current_clicks + 1 WHEN thumb_id = 28674 THEN current_clicks + 1 WHEN thu' at line 1) in query UPDATE LOW_PRIORITY rot_gallery_stats SET current_clicks = CASE WHEN thumb_id = 26809 THEN current_clicks + 1 WHEN thumb_id = 22431 THEN current_clicks + 2 WHEN thumb_id = 24850 THEN current_clicks + 1 WHEN thumb_id = 28160 THEN current_clicks + 2 WHEN thumb_id = 18742 THEN current_clicks + 2 WHEN thumb_id = 28878 THEN current_clicks + 1 WHEN thumb_id = 9952 THEN current_clicks + 1 WHEN thumb_id = 13837 THEN current_clicks + 2 WHEN thumb_id = 24703 THEN current_clicks + 1 WHEN thumb_id = 13585 THEN current_clicks + 1 WHEN thumb_id = 9174 THEN current_clicks + 1 WHEN thumb_id = 7233 THEN current_clicks + 1 WHEN thumb_id = 24835- THEN current_clicks + 1 WHEN thumb_id = 28674 THEN current_clicks + 1 WHEN thumb_id = 23628 THEN current_clicks + 1 END, current_points = CASE WHEN thumb_id = 26809 THEN current_points + 1000 WHEN thumb_id = 22431 THEN current_points + 2000 WHEN thumb_id = 24850 THEN current_points + 1000 WHEN thumb_id = 28160 THEN current_points + 2000 WHEN thumb_id = 18742 THEN current_points + 2000 WHEN thumb_id = 28878 THEN current_points + 1000 WHEN thumb_id = 9952 THEN current_points + 1000 WHEN thumb_id = 13837 THEN current_points + 2000 WHEN thumb_id = 24703 THEN current_points + 1000 WHEN thumb_id = 13585 THEN current_points + 1000 WHEN thumb_id = 9174 THEN current_points + 1000 WHEN thumb_id = 7233 THEN current_points + 1000 WHEN thumb_id = 24835- THEN current_points + 1000 WHEN thumb_id = 28674 THEN current_points + 1000 WHEN thumb_id = 23628 THEN current_points + 1000 END WHERE thumb_id IN (26809,22431,24850,28160,18742,28878,9952,13837,24703,13585,9174,7233,24835-,28674,23628)
Mysql Error On all Sites After Upgrading and Tuning Mysql
Re: Mysql Error On all Sites After Upgrading and Tuning Mysql
2013-06-19 21:58:23 : Mysql error: 1064 (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 ')' at line 6) in query UPDATE LOW_PRIORITY rot_gallery_stats SET total_shows = current_shows + shows0 + shows1 + shows2 + shows3 + shows4 + shows5 + shows6 + shows7 + shows8 + shows9, total_clicks = current_clicks + clicks0 + clicks1 + clicks2 + clicks3 + clicks4 + clicks5 + clicks6 + clicks7 + clicks8 + clicks9,total_points = current_points + points0 + points1 + points2 + points3 + points4 + points5 + points6 + points7 + points8 + points9,total_ctr = (current_points + points0 + points1 + points2 + points3 + points4 + points5 + points6 + points7 + points8 + points9)/(current_shows + shows0 + shows1 + shows2 + shows3 + shows4 + shows5 + shows6 + shows7 + shows8 + shows9)/1000
Re: Mysql Error On all Sites After Upgrading and Tuning Mysql
WHERE thumb_id IN (28481,29184,23628,20957,4465,8809,29122,13837,9174,21538,5316,13585,18742,7233,9952,12885,27854,24835,23496,21222,22320,24007,28429,20230,14976,27255,11729,12935,23741,23722,22719,24543,23293,20747,26778,28674,28419,23490,13056,29173,28647,26877,18792,26767,20944,20189,6799,12878,28099,24459,23540,28891,18769,27362,24926,22335,25590,25718,24353,9839,4565,27761,23743,24759,27896,22600,26922,28503,7467,22431,28279,4555,24850,27308,26809,5352,26604,7508,25006,24703,26133,4500,27202,25286,10044,25287,28204,6608,29169,4302,23974,29185,8748,12342,7394,18759,9439,25695,26611,13082,26771,13548,23919,25155,4378,5868,22770,20690,18367,13052,13083,8583,5110,29098,28333,13544,24383,6142,24570,29135,28878,24164,4940,22019,28802,20933,28823,23260,25707,6462,19675,6577,21490,9317,7851,20695,26614,24516,27602,23249,29156,8486,7990,20313,7250,21532,22689,21568,7950,7850,26828,28958,8630,6054,23677,7270,4680,13015,27100,8566,8154,19395,13153,5339,13766,5946,13725,16453,7289,24775,20677,9925,7971,7126,28160,24835-)
Re: Mysql Error On all Sites After Upgrading and Tuning Mysql
Site 2:
2013-06-18 07:26:16 : Mysql error: 1054 (Unknown column '5398htt' in 'where clause') in query UPDATE LOW_PRIORITY rot_gallery_stats SET current_clicks = CASE WHEN thumb_id = 27305 THEN current_clicks + 1 WHEN thumb_id = 23712 THEN current_clicks + 2 WHEN thumb_id = 12036 THEN current_clicks + 1 WHEN thumb_id = 29251 THEN current_clicks + 4 WHEN thumb_id = 31365 THEN current_clicks + 1 WHEN thumb_id = 18348 THEN current_clicks + 1 WHEN thumb_id = 26746 THEN current_clicks + 1 WHEN thumb_id = 5398htt THEN current_clicks + 2 WHEN thumb_id = 30307 THEN current_clicks + 1 WHEN thumb_id = 30133 THEN current_clicks + 1 WHEN thumb_id = 26537 THEN current_clicks + 1 WHEN thumb_id = 31722 THEN current_clicks + 1 WHEN thumb_id = 14136 THEN current_clicks + 1 WHEN thumb_id = 17009 THEN current_clicks + 2 WHEN thumb_id = 10956 THEN current_clicks + 1 WHEN thumb_id = 23619 THEN current_clicks + 1 WHEN thumb_id = 28510 THEN current_clicks + 1 END, current_points = CASE WHEN thumb_id = 27305 THEN current_points + 1000 WHEN thumb_id = 23712 THEN current_points + 2000 WHEN thumb_id = 12036 THEN current_points + 1000 WHEN thumb_id = 29251 THEN current_points + 4000 WHEN thumb_id = 31365 THEN current_points + 1000 WHEN thumb_id = 18348 THEN current_points + 1000 WHEN thumb_id = 26746 THEN current_points + 1000 WHEN thumb_id = 5398htt THEN current_points + 2000 WHEN thumb_id = 30307 THEN current_points + 1000 WHEN thumb_id = 30133 THEN current_points + 1000 WHEN thumb_id = 26537 THEN current_points + 1000 WHEN thumb_id = 31722 THEN current_points + 1000 WHEN thumb_id = 14136 THEN current_points + 1000 WHEN thumb_id = 17009 THEN current_points + 2000 WHEN thumb_id = 10956 THEN current_points + 1000 WHEN thumb_id = 23619 THEN current_points + 1000 WHEN thumb_id = 28510 THEN current_points + 1000 END WHERE thumb_id IN
2013-06-18 07:26:16 : Mysql error: 1054 (Unknown column '5398htt' in 'where clause') in query UPDATE LOW_PRIORITY rot_gallery_stats SET current_clicks = CASE WHEN thumb_id = 27305 THEN current_clicks + 1 WHEN thumb_id = 23712 THEN current_clicks + 2 WHEN thumb_id = 12036 THEN current_clicks + 1 WHEN thumb_id = 29251 THEN current_clicks + 4 WHEN thumb_id = 31365 THEN current_clicks + 1 WHEN thumb_id = 18348 THEN current_clicks + 1 WHEN thumb_id = 26746 THEN current_clicks + 1 WHEN thumb_id = 5398htt THEN current_clicks + 2 WHEN thumb_id = 30307 THEN current_clicks + 1 WHEN thumb_id = 30133 THEN current_clicks + 1 WHEN thumb_id = 26537 THEN current_clicks + 1 WHEN thumb_id = 31722 THEN current_clicks + 1 WHEN thumb_id = 14136 THEN current_clicks + 1 WHEN thumb_id = 17009 THEN current_clicks + 2 WHEN thumb_id = 10956 THEN current_clicks + 1 WHEN thumb_id = 23619 THEN current_clicks + 1 WHEN thumb_id = 28510 THEN current_clicks + 1 END, current_points = CASE WHEN thumb_id = 27305 THEN current_points + 1000 WHEN thumb_id = 23712 THEN current_points + 2000 WHEN thumb_id = 12036 THEN current_points + 1000 WHEN thumb_id = 29251 THEN current_points + 4000 WHEN thumb_id = 31365 THEN current_points + 1000 WHEN thumb_id = 18348 THEN current_points + 1000 WHEN thumb_id = 26746 THEN current_points + 1000 WHEN thumb_id = 5398htt THEN current_points + 2000 WHEN thumb_id = 30307 THEN current_points + 1000 WHEN thumb_id = 30133 THEN current_points + 1000 WHEN thumb_id = 26537 THEN current_points + 1000 WHEN thumb_id = 31722 THEN current_points + 1000 WHEN thumb_id = 14136 THEN current_points + 1000 WHEN thumb_id = 17009 THEN current_points + 2000 WHEN thumb_id = 10956 THEN current_points + 1000 WHEN thumb_id = 23619 THEN current_points + 1000 WHEN thumb_id = 28510 THEN current_points + 1000 END WHERE thumb_id IN
Re: Mysql Error On all Sites After Upgrading and Tuning Mysql
(27305,23712,12036,29251,31365,18348,26746,5398htt,30307,30133,26537,31722,14136,17009,10956,23619,28510)
Site 3 :
2013-06-19 01:12:47 : Mysql error: 1054 (Unknown column '15633f8f95' in 'where clause') in query select id, rgroup from rot_galleries where id IN
Site 3 :
2013-06-19 01:12:47 : Mysql error: 1054 (Unknown column '15633f8f95' in 'where clause') in query select id, rgroup from rot_galleries where id IN
Re: Mysql Error On all Sites After Upgrading and Tuning Mysql
(48284,16040,15991,42758,43140,46711,43180,48839,39024,22445,42978,16482,15633,40171,16258,49208,17345,11293,33055,16074,15860,15842,41281,16149,33338,12317,12861,40358,49059,11440,16875,16813,17140,16827,41928,23658,10479,36420,49151,48197,23971,11128,22500,15815,48373,49223,49228,16823,22466,16426,43145,26442,31894,15879,43973,15626,47482,15821,16079,18168,224
61,39204,16585,16380,48939,49203,48748,49188,42918,22432,16343,17469,23341,41934,40613,15737,13161,11370,16964,43640,35595,31265,16709,571,48251,13179,38876,49198,16807,16473,48232,25042,49193,16770,22902,16579,26319,15836,16583,17321,44591,341,2944,15604,15609,16393,21299,48969,9612,46069,45417,17030,41020,23164,40409,44427,16580,33868,11042,43049,41874,43011,2
3675,15706,22928,24549,48586,44858,22672,32678,16177,18787,23956,48779,49218,47425,49054,22444,41111
61,39204,16585,16380,48939,49203,48748,49188,42918,22432,16343,17469,23341,41934,40613,15737,13161,11370,16964,43640,35595,31265,16709,571,48251,13179,38876,49198,16807,16473,48232,25042,49193,16770,22902,16579,26319,15836,16583,17321,44591,341,2944,15604,15609,16393,21299,48969,9612,46069,45417,17030,41020,23164,40409,44427,16580,33868,11042,43049,41874,43011,2
3675,15706,22928,24549,48586,44858,22672,32678,16177,18787,23956,48779,49218,47425,49054,22444,41111
Re: Mysql Error On all Sites After Upgrading and Tuning Mysql
,15784,39544,24245,12406,12251,12397,15974,22952,19322,48246,19127,22564,45455,47487,16860,46074,41900,47670,22415,1106,26204,15633f8f95)
Hi,
Have pasted some of the mysql error logs for 3 sites.Yes these seem to be happening everyday, after cleaning logs and upgrading it took 24 hours for these errors to show up.Please let me know how to proceed with fixing these invalid queries.
Regards,
Hi,
Have pasted some of the mysql error logs for 3 sites.Yes these seem to be happening everyday, after cleaning logs and upgrading it took 24 hours for these errors to show up.Please let me know how to proceed with fixing these invalid queries.
Regards,
Re: Mysql Error On all Sites After Upgrading and Tuning Mysql
Hi,
Still waiting to hear on how to fix these sql queries.
Regards,
Still waiting to hear on how to fix these sql queries.
Regards,
Re: Mysql Error On all Sites After Upgrading and Tuning Mysql
What build do you use now ?
Don't forget to run script update
Re: Mysql Error On all Sites After Upgrading and Tuning Mysql
Hi,
Am using Build 201306190206 now.Even with upgrading 2 times these mysql errors are not going.They show everyday in logs.How do I fix this? Need urgent help to resolve this.
Regards,
Am using Build 201306190206 now.Even with upgrading 2 times these mysql errors are not going.They show everyday in logs.How do I fix this? Need urgent help to resolve this.
Regards,