Mysql Error On all Sites After Upgrading and Tuning Mysql

Post all bugs here
tubeman
Posts: 534
Joined: Sat Mar 02, 2013 11:33 am

Mysql Error On all Sites After Upgrading and Tuning Mysql

Post by tubeman »

Hi,
After I upgraded the scripts and tuned mysql as per your advice I noticed mysql errors in the mysql_error.log of all the sites.I have emailed you logs of 1 site.Here are some of the errors,its too long so keeping it to 3 lines for each error.

Site 1

2013-06-04 16:38:57 : Mysql error: 1062 (Duplicate entry 'process_deleted' for key 1) in query insert into functions_data (name, value) values ('process_deleted', '0')

2013-06-04 16:38:57 : Mysql error: 1062 (Duplicate entry 'empty_tmp_folder' for key 1) in query insert into functions_data (name, value) values ('empty_tmp_folder', '0')

2013-06-09 04:16:47 : 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 = 15827 THEN current_clicks + 1 WHEN thu' at line 1) in query UPDATE LOW_PRIORITY rot_gallery_stats SET current_clicks = CASE WHEN thumb_id = 43180

Site 2

2013-06-10 02:27:16 : Mysql error: 1054 (Unknown column '31365www.google.com' in 'where clause') in query UPDATE LOW_PRIORITY rot_gallery_stats SET total_shows = current_shows + shows0 + shows1 + shows2 + shows3 + shows4 + shows5 + shows6 + shows7 + shows8 + shows9,

2013-06-15 06:57:15 : Mysql error: 1054 (Unknown column '23619http' in 'where clause') in query UPDATE LOW_PRIORITY rot_gallery_stats SET current_clicks = CASE WHEN thumb_id = 23712 THEN current_clicks + 4 WHEN thumb_id = 12036 THEN current_clicks + 1 WHEN thumb_id = 4499 THEN current_clicks + 1 WHEN thumb_id = 28672 THEN current_clicks + 1 WHEN thumb_id = 28963

Site 3

2013-06-13 07:55: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 = 5316 THEN current_clicks + 2 WHEN thum' at line 1) in query UPDATE LOW_PRIORITY rot_gallery_stats SET current_clicks

2013-06-16 00:07:23 : Mysql error: 1054 (Unknown column '4465ree' in 'where clause') in query SELECT id, gallery_md5 FROM rot_galleries WHERE id IN (7289,26502,19622,19579,19580,26029,26218,26004,26063,

These are just a few, similar errors repeated in other sites from dates June 4th - Today.

After asking our admin to check here is what he said:

"I checked mysql on your ds10 server and there are not any errors with any database or table in mysql. The errors you listed all appear to be coding errors in the queries being run on mysql, so i would suggest you contact the developer for assistance.These are invalid queries being passed to mysql."

Could you please let me know how to fix these invalid queries.I have had a big drop in traffic
on all my sites since these errors started coming.

Regards,
admin
Site Admin
Posts: 37197
Joined: Wed Sep 10, 2008 11:43 am

Re: Mysql Error On all Sites After Upgrading and Tuning Mysql

Post by admin »

Hi !
You can run update and it should be fine.
Clean up error file and lemme know if you'll get any new errors there.

Thank you.
Don't forget to run script update
tubeman
Posts: 534
Joined: Sat Mar 02, 2013 11:33 am

Re: Mysql Error On all Sites After Upgrading and Tuning Mysql

Post by tubeman »

Hi,
I re-ran the upgrades on all the sites.And cleaned the error logs as per your advice.So far there are no errors.If any errors come I will inform you.When checking my cron logs I noticed this a lot in the cron logs for all sites:

2013-06-17 15:57 AntiCheat: following IPs was NOT counted (too many hits within short time interval): 66.249.74.173 (24 hits within 20 minutes) <br> (0.040555000305176, 0.0056548118591309)

Looked up the IP and it was googlebot.I have turned off auto cheat system on all websites for now.
Can you please tell me how to not block any Search engine crawlers from the sites as I have seen big drop in google traffic on all my sites since the time I upgraded the script to v1.50

Regards,
tubeman
Posts: 534
Joined: Sat Mar 02, 2013 11:33 am

Re: Mysql Error On all Sites After Upgrading and Tuning Mysql

Post by tubeman »

Hi,
After Upgrading to Build version 201306170843 and cleaning the old error logs I am still
getting these errors:

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

2013-06-18 07:26:16 : Mysql error: 1054 (Unknown column '5398htt' in 'where clause') 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

Please advice how to fix this.

Regards,
tubeman
Posts: 534
Joined: Sat Mar 02, 2013 11:33 am

Re: Mysql Error On all Sites After Upgrading and Tuning Mysql

Post by tubeman »

Hi,
The new errors I posted are showing again in mysql error logs today.How do I fix these? Please help.

Regards,
tubeman
Posts: 534
Joined: Sat Mar 02, 2013 11:33 am

Re: Mysql Error On all Sites After Upgrading and Tuning Mysql

Post by tubeman »

Hi,
This is another mysql error on another site:

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 (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,22461,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,23675,15706,22928,24549,48586,44858,22672,32678,16177,18787,23956,48779,49218,47425,49054,22444,41111,15784,39544,24245,12406,12251,12397,15974,22952,19322,48246,19127,22564,45455,47487,16860,46074,41900,47670,22415,1106,26204,15633f8f95)

Please advice how to fix.

Regards,
admin
Site Admin
Posts: 37197
Joined: Wed Sep 10, 2008 11:43 am

Re: Mysql Error On all Sites After Upgrading and Tuning Mysql

Post by admin »

What build version do you use ?
Don't forget to run script update
tubeman
Posts: 534
Joined: Sat Mar 02, 2013 11:33 am

Re: Mysql Error On all Sites After Upgrading and Tuning Mysql

Post by tubeman »

Hi,
Build 201306170843. Just upgraded 2 days ago again as per your advice.Please let me know how to fix these errors.

Regards,
tubeman
Posts: 534
Joined: Sat Mar 02, 2013 11:33 am

Re: Mysql Error On all Sites After Upgrading and Tuning Mysql

Post by tubeman »

Hi,
The same error as before has appeared again in mysql error logs even after upgrading and cleaning old mysql error logs:

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

Please advice how to fix these queries.

Regards,
admin
Site Admin
Posts: 37197
Joined: Wed Sep 10, 2008 11:43 am

Re: Mysql Error On all Sites After Upgrading and Tuning Mysql

Post by admin »

The query is cut here i think for some reason.
Do you get this error everyday ?
Don't forget to run script update
Post Reply