update to 50 not showing category name

[dakini]

I think i solved the cache problem after i deleted the cache manualy but what about that error?

[admin]

What build do you use ?
Can you repeat that error ?

[dakini]

I use debian6

Here is the error in /var/mail/root

Code: Select all

Content-Type: text/plain; charset=ANSI_X3.4-1968
X-Cron-Env: <SHELL=/bin/sh>
X-Cron-Env: <HOME=/root>
X-Cron-Env: <PATH=/usr/bin:/bin>
X-Cron-Env: <LOGNAME=root>

Mysql error:: 1054 (Unknown column 'A' in 'where clause') (db_link) in query UPDATE LOW_PRIORITY rot_gallery_stats SET current_clicks = CASE WHEN thumb_id = A THEN current_clicks + 1  END,  current_points = CASE  WHEN thumb_id = A THEN current_points + 1000 END WHERE thumb_id IN (A). (xnxx.cat) Mysql error:: 1054 (Unknown column 'A' in 'where clause') (db_link) 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
                WHERE thumb_id IN (115253,46044,75503,125676,83820,126405,93977,70389,117769,42910,95058,93867,80364,122848,84455,42970,75614,83925,103439,125572,125265,117480,122116,33260,58829,59323,63417,82409,86722,45692,48741,83867,84108,122895,31058,125152,31985,62994,93891,113201,65191,66902,86001,114338,98564,81386,116176,61123,117481,45343,104430,61015,118951,126415,94207,93667,103781,61555,33460,35868,73562,32124,92599,43021,70372,62930,46005,75492,81785,95043,94967,126467,117360,48355,100269,31050,32340,120404,68535,124005,83541,51578,114160,125519,104103,68213,103491,63401,103465,82006,75472,116413,19730,121964,35912,121467,59041,119433,86351,125155,106381,74412,116465,103492,124114,30395,117801,96031,125229,123638,113998,123727,113180,78120,123091,24337,58768,99770,96745,96069,68290,72246,63659,75421,35907,84412,58765,58721,75204,75589,113053,81621,114500,78189,120399,83078,115008,36310,83065,35909,82330,76598,63613,82449,119717,82256,24531,83458,80457,82395,77105,126296,83040,72843,51019,119118,35978,82344,82093,66467,80181,59036,58724,93474,56787,78913,119902,82787,84311,48698,38773,45684,51868,31237,108885,35891,87770,120658,82941,82128,85087,123485,83113,78727,78929,26246,116164,120788,114479,117174,50496,120656,106720,51864,82536,48119,84383,82108,93383,74432,58766,92879,83048,103144,56790,99317,30470,86392,113260,56793,30471,81305,75973,35997,83573,110393,52741,84447,125633,123065,75201,61044,62883,56668,68318,32136,35949,82404,84072,83060,83041,81688,35950,120860,56324,45969,A)  . (xnxx.cat) Mysql error:: 1054 (Unknown column 'A' in 'where clause') (db_link) in query SELECT thumb_id, current_index, current_shows, current_clicks, current_points, total_shows FROM rot_gallery_stats
            WHERE current_shows > '2000'
            AND  thumb_id IN (115253,46044,75503,125676,83820,126405,93977,70389,117769,42910,95058,93867,80364,122848,84455,42970,75614,83925,103439,125572,125265,117480,122116,33260,58829,59323,63417,82409,86722,45692,48741,83867,84108,122895,31058,125152,31985,62994,93891,113201,65191,66902,86001,114338,98564,81386,116176,61123,117481,45343,104430,61015,118951,126415,94207,93667,103781,61555,33460,35868,73562,32124,92599,43021,70372,62930,46005,75492,81785,95043,94967,126467,117360,48355,100269,31050,32340,120404,68535,124005,83541,51578,114160,125519,104103,68213,103491,63401,103465,82006,75472,116413,19730,121964,35912,121467,59041,119433,86351,125155,106381,74412,116465,103492,124114,30395,117801,96031,125229,123638,113998,123727,113180,78120,123091,24337,58768,99770,96745,96069,68290,72246,63659,75421,35907,84412,58765,58721,75204,75589,113053,81621,114500,78189,120399,83078,115008,36310,83065,35909,82330,76598,63613,82449,119717,82256,24531,83458,80457,82395,77105,126296,83040,72843,51019,119118,35978,82344,82093,66467,80181,59036,58724,93474,56787,78913,119902,82787,84311,48698,38773,45684,51868,31237,108885,35891,87770,120658,82941,82128,85087,123485,83113,78727,78929,26246,116164,120788,114479,117174,50496,120656,106720,51864,82536,48119,84383,82108,93383,74432,58766,92879,83048,103144,56790,99317,30470,86392,113260,56793,30471,81305,75973,35997,83573,110393,52741,84447,125633,123065,75201,61044,62883,56668,68318,32136,35949,82404,84072,83060,83041,81688,35950,120860,56324,45969,A)  . (xnxx.cat) Mysql error:: 1054 (Unknown column 'A' in 'where clause') (db_link) in query SELECT id, gallery_md5 FROM rot_galleries WHERE id IN (115253,46044,75503,125676,83820,126405,93977,70389,117769,42910,95058,93867,80364,122848,84455,42970,75614,83925,103439,125572,125265,117480,122116,33260,58829,59323,63417,82409,86722,45692,48741,83867,84108,122895,31058,125152,31985,62994,93891,113201,65191,66902,86001,114338,98564,81386,116176,61123,117481,45343,104430,61015,118951,126415,94207,93667,103781,61555,33460,35868,73!
 562,32124,92599,43021,70372,62930,46005,75492,81785,95043,94967,126467,117360,48355,100269,31050,32340,120404,68535,124005,83541,51578,114160,125519,104103,68213,103491,63401,103465,82006,75472,116413,19730,121964,35912,121467,59041,119433,86351,125155,106381,74412,116465,103492,124114,30395,117801,96031,125229,123638,113998,123727,113180,78120,123091,24337,58768,99770,96745,96069,68290,72246,63659,75421,35907,84412,58765,58721,75204,75589,113053,81621,114500,78189,120399,83078,115008,36310,83065,35909,82330,76598,63613,82449,119717,82256,24531,83458,80457,82395,77105,126296,83040,72843,51019,119118,35978,82344,82093,66467,80181,59036,58724,93474,56787,78913,119902,82787,84311,48698,38773,45684,51868,31237,108885,35891,87770,120658,82941,82128,85087,123485,83113,78727,78929,26246,116164,120788,114479,117174,50496,120656,106720,51864,82536,48119,84383,82108,93383,74432,58766,92879,83048,103144,56790,99317,30470,86392,113260,56793,30471,81305,75973,35997,83573,110393,52741,84447,125633,123065,75201,61044,62883,56668,68318,32136,35949,82404,84072,83060,83041,81688,35950,120860,56324,45969,A). (xnxx.cat)

root@s3:/var/www/raw-redtube.com/scj/cache#

[admin]

Can you repeat that error ?

[dakini]

I dont understand, i just pased it on the previous post, What do you mean by repeat?

[admin]

You reposted your message.
Can you repeat the bug? like run it again and it gives you the same error and so on

[dakini]

Im not doing anything,
I think this error occures every time cron runs
And it shows me in ssh as i got an email

[admin]

Do did you try to run it ?