Mysql Error On all Sites After Upgrading and Tuning Mysql
Posted: Sun Jun 16, 2013 11:34 am
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,
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,