SmartCJ Support Forum

Code: Select all

Mysql error:: 1264 (Out of range value for column 'total_ctr' at row 1) (ext_db_link) in query UPDATE LOW_PRIORITY rot_gallery_stats2 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 (9574,10215,10238,10266,10267,10268,10434,10467,10481,10506,10517,10536,10543,10562,10572,10573,10591,10601,10990,10996,12409,11000,11010,11012,11068,11073,11088,11136,11143,11146,11150,11164,12439,12855,11206,12752,11215,11219,11238,11241,12604,12782,11290,11299,11503,12544,11592,11909,12033,13396,11096,12089,12484,11835,11227,11760,11024,11013,11324,12038,11344,11927,11930,11167,12116,11467,12077,12796,12061,12454,11660,11972,10257,12069,11094,12364,11646,11374,12002,12126,11870,11757,11287,11075,11943,12870,11614,11273,12031,10275,11345,11804,10633,11420,11304,11832,12083,11524,12767,11921,11373,11489,12147,11746,11349,12304,12146,12098,12073,11449,12379,12469,11160,11243,10985,12394,11950,11050,11850,11816,11350,11547,11038,11191,13416,12618,13434,11539,11411,13407,11824,11522,10956,11857,11331,9585,11426,11342,12015,11336,11213,11900,10527,12707)  . (xxxxx.com) 

Code: Select all

Mysql error:: 1264 (Out of range value for column 'total_ctr' at row 6) (ext_db_link) in query UPDATE LOW_PRIORITY rot_gallery_stats2 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 (15557,16048,16981,42515,43677,51383,57517,74070,101420,103722,120291,116022,121571,121773,121946,125704,14911,134687,74514,127408,4212,41843,111259,39257,119103,44429,111157,40076,116064,105423,116336,32540,40234,48084,126298,134500,129688,57031,29200,121266,100742,123636,64079,127468,111245,75107,57738,73946,123500,126532,76383,105200,74209,106097,121068,134905,129725,83637,106022,74228,120271,101384,48120,96955,130553,118878,52713,124689,127904,78792,112131,112204,116404,7411,109046,116882,19603,68688,130146,29383,116869,37507,20494,44053,110917,87511,17770,105360,122745,77019,129423,12540,28938,122718,119122,100799,47380,27411,65563,135277,74837,17432,52437,123094,59990,17186,28380,125664,64630,40991,60081,123040,42771,15637,74454,130081,17060,75317,111565,67696,133782,124507,135143,112458,57237,75303,111702,62231,50192,50621,107770,44737,80667,130379,107475,32059,80371,111028,133853,101404,135444,71931,59724,6132)  . (xxxx.com)