Mysql Errors on 1.51
Posted: Tue Apr 01, 2014 12:53 pm
Hi,
I am getting these mysql errors on all my sites after upgrading to 1.51 Build 201402241258, it seems there is a column that does not exists, am listing what I get in script messages of a few sites:
2014-03-28 01:35:13: Uncaught exception 'Exception' with message 'Mysql error:: 1054 (Unknown column '38390http' in 'where clause') (db_link) in query SELECT thumb_id, group_id, current_index, current_shows, current_clicks, current_points, total_shows FROM rot_gallery_stats <br> WHERE current_shows > '2000' <br> AND thumb_id IN (16135,20451,9462,19450,19848,18580,20935,18973,39681,41569,40862,41322,41360,38522,38390,29866,5812,4780,6359,6316,4847,6783,4997,6333,35133,28574,39166,27808,41174,4
1169,25238,41545,36072,40079,40498,39548,39762,36524,36045,41537,35659,35760,22831,35795,38542,19822,41562,35890,15167,41002,37720,39486,41549,35258,39519,30718,26258,
20051,41485,24539,30180,28747,35368,19449,30060,23543,28727,37397,17141,38209,15504,20657,18375,41615,17546,16882,38311,38870,17426,20874,19868,16411,32325,9676,17587,
17899,19244,17414,18874,33382,41593,11946,28061,38083,16909,34373,20373,18398,20342,17858,9398,16380,36466,37349,16886,32564,38416,10477,16047,41586,41275,20364,40097,
15962,18942,15964,37008,30963,37750,1994 in /home/freetams/public_html/scj/includes/db_modules/mysql.php
2014-03-27 11:04:18: Uncaught exception 'Exception' with message '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 'com,63818,42401,60753,79137,26808,55110,79013,60031)' at line 1) (ext_db_link) in query SELECT id, gallery_md5 FROM rot_galleries WHERE id IN
(70144,54565,52586,48017,48926,78735,62423,65182,79091,78818,21970,72947,77636,78433,79000,43058,75925,64637,35416,37087,44028,41092,39967,43648,41973,72290,21666,7041
5,44054.com,63818,42401,60753,79137,26808,55110,79013,60031). (arabsex4u.net) ' in /home/arabsex4/public_html/scj/includes/db_modules/mysql.php:62<br> Stack trace:<br>
#0 /home/arabsex4/public_html/scj/includes/db_modules/mysql.php(75): db_error('SELECT id, gall...', 1064, 'You have an err...', 'ext_db_link')<br> #1 /home/arabsex4/public_html/scj/bin/rot.php(0): db_query()<br> #2 /home/arabsex4/public_html/scj/bin/rot.php(0): process_clicks()<br> #3 {main}<br> thrown in /home/arabsex4/public_html/scj/includes/db_modules/mysql.php
2014-03-26 00:45:12: Uncaught exception 'Exception' with message 'Mysql error:: 1054 (Unknown column '15105urlhttp' in 'where clause') (db_link) in query SELECT thumb_id, group_id, current_index, current_shows, current_clicks, current_points, total_shows FROM rot_gallery_stats <br> WHERE current_shows > '500' <br> AND thumb_id IN (7863,4256,7696,6979,6631,4266,4760,6630,39719,41362,41106,40263,39716,39530,38491,41697,41553,19714,16404,30364,36551,36016,41285,16259,20487,20353,26447,15411,29469,
7473,17543,30654,15105,33248,41725,41217,40677,15301,19821,41388,41709,20898,18971,41503,35737,41743,15466,27087,41544,30033,41693,25472,15412,18706,16798,15910,35722
,19457,19732,17478,41657,41710,19719,19249,20127,41125,24528,15528,41531,18698,40905,38169,19723,20572,17033,15009,16794,20911,17613,40503,16225,16572,17928,19389,4170
5,20845,20890,19737,19621,33687,17685,15133,18567,24384,18164,16900,16618,15600,15074,14728,14965,16362,17176,33775,17514,14800,40024,5681,41664,18814,20328,19160,7069
,35008,5993,41470,29924,14960,41641,18 in /home/itb4/public_html/html/scj/includes/db_modules/mysql.php
How do I make sure these errors don't Happen.
Regards,
I am getting these mysql errors on all my sites after upgrading to 1.51 Build 201402241258, it seems there is a column that does not exists, am listing what I get in script messages of a few sites:
2014-03-28 01:35:13: Uncaught exception 'Exception' with message 'Mysql error:: 1054 (Unknown column '38390http' in 'where clause') (db_link) in query SELECT thumb_id, group_id, current_index, current_shows, current_clicks, current_points, total_shows FROM rot_gallery_stats <br> WHERE current_shows > '2000' <br> AND thumb_id IN (16135,20451,9462,19450,19848,18580,20935,18973,39681,41569,40862,41322,41360,38522,38390,29866,5812,4780,6359,6316,4847,6783,4997,6333,35133,28574,39166,27808,41174,4
1169,25238,41545,36072,40079,40498,39548,39762,36524,36045,41537,35659,35760,22831,35795,38542,19822,41562,35890,15167,41002,37720,39486,41549,35258,39519,30718,26258,
20051,41485,24539,30180,28747,35368,19449,30060,23543,28727,37397,17141,38209,15504,20657,18375,41615,17546,16882,38311,38870,17426,20874,19868,16411,32325,9676,17587,
17899,19244,17414,18874,33382,41593,11946,28061,38083,16909,34373,20373,18398,20342,17858,9398,16380,36466,37349,16886,32564,38416,10477,16047,41586,41275,20364,40097,
15962,18942,15964,37008,30963,37750,1994 in /home/freetams/public_html/scj/includes/db_modules/mysql.php
2014-03-27 11:04:18: Uncaught exception 'Exception' with message '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 'com,63818,42401,60753,79137,26808,55110,79013,60031)' at line 1) (ext_db_link) in query SELECT id, gallery_md5 FROM rot_galleries WHERE id IN
(70144,54565,52586,48017,48926,78735,62423,65182,79091,78818,21970,72947,77636,78433,79000,43058,75925,64637,35416,37087,44028,41092,39967,43648,41973,72290,21666,7041
5,44054.com,63818,42401,60753,79137,26808,55110,79013,60031). (arabsex4u.net) ' in /home/arabsex4/public_html/scj/includes/db_modules/mysql.php:62<br> Stack trace:<br>
#0 /home/arabsex4/public_html/scj/includes/db_modules/mysql.php(75): db_error('SELECT id, gall...', 1064, 'You have an err...', 'ext_db_link')<br> #1 /home/arabsex4/public_html/scj/bin/rot.php(0): db_query()<br> #2 /home/arabsex4/public_html/scj/bin/rot.php(0): process_clicks()<br> #3 {main}<br> thrown in /home/arabsex4/public_html/scj/includes/db_modules/mysql.php
2014-03-26 00:45:12: Uncaught exception 'Exception' with message 'Mysql error:: 1054 (Unknown column '15105urlhttp' in 'where clause') (db_link) in query SELECT thumb_id, group_id, current_index, current_shows, current_clicks, current_points, total_shows FROM rot_gallery_stats <br> WHERE current_shows > '500' <br> AND thumb_id IN (7863,4256,7696,6979,6631,4266,4760,6630,39719,41362,41106,40263,39716,39530,38491,41697,41553,19714,16404,30364,36551,36016,41285,16259,20487,20353,26447,15411,29469,
7473,17543,30654,15105,33248,41725,41217,40677,15301,19821,41388,41709,20898,18971,41503,35737,41743,15466,27087,41544,30033,41693,25472,15412,18706,16798,15910,35722
,19457,19732,17478,41657,41710,19719,19249,20127,41125,24528,15528,41531,18698,40905,38169,19723,20572,17033,15009,16794,20911,17613,40503,16225,16572,17928,19389,4170
5,20845,20890,19737,19621,33687,17685,15133,18567,24384,18164,16900,16618,15600,15074,14728,14965,16362,17176,33775,17514,14800,40024,5681,41664,18814,20328,19160,7069
,35008,5993,41470,29924,14960,41641,18 in /home/itb4/public_html/html/scj/includes/db_modules/mysql.php
How do I make sure these errors don't Happen.
Regards,