SmartCJ Support Forum

Code: Select all

2018-06-27 07:36:02 : Mysql error 144: Table './мой-домен/language' is marked as crashed and last (automatic?) repair failed (INSERT into language (trader, hour, language, num) VALUES ('10.smartcj.sponsor', '425020', 'en', '17'), ('10.smartcj.sponsor', '425020', 'no_lng', '1'), ('spiders', '425020', 'no_lng', '20'), ('трейдер', '425020', 'zh-CN', '1'), ('mobile', '425020', 'zh-CN', '5'), ('mobile', '425020', 'id-ID', '1'), ('1.smartcj.sponsor', '425020', 'no_lng', '4'), ('1.smartcj.sponsor', '425020', 'zh-CN', '3'), ('11.smartcj.sponsor', '425020', 'en', '4'), ('11.smartcj.sponsor', '425020', 'no_lng', '1'), ('6.smartcj.sponsor', '425020', 'zh-CN', '3'), ('6.smartcj.sponsor', '425020', 'no_lng', '14'), ('трейдер3', '425020', 'id-ID', '1'), ('8.smartcj.sponsor', '425020', 'no_lng', '2'), ('трейдер4', '425020', 'en-US', '2'), ('noref', '425020', 'no_lng', '2'), ('noref', '425020', 'ja-JP', '1'), ('трейдер6', '425020', 'zh-CN', '1'), ('bookmarks', '425020', 'ja-JP', '1'), ('bookmarks', '425020', 'no_lng', '1'), ('трейдер5', '425020', 'zh-CN', '2'), ('7.smartcj.sponsor', '425020', 'no_lng', '1'), ('трейдер2', '425020', 'zh-CN', '1') ON DUPLICATE KEY UPDATE num=num + VALUES(num) ) 

Code: Select all

2018-11-10 15:03:20 : Mysql error 3065: Expression #1 of ORDER BY clause is not in SELECT list, references column 'имябазы_scj.rot_gallery_stats1.total_ctr' which is not in SELECT list; this is incompatible with DISTINCT (SELECT DISTINCT(group_id), gallery_id FROM rot_gallery_stats1 WHERE gallery_id IN ('16913','16869','14880','14584','8906','16730','16439','14581','8902','5487','16691','15994','8853','6451','5395','16552','15548','8849','6230','5375','16041','14609','8846','6098','5341','15194','13299','8778','5815','5329','14403','13213','8727','5666','5204','14120','12848','8712','5524','5021','14117','12568','8491','5012','8246','4993','8149','4953','7899','4952','7775','7735','7725','7550','3865','1888','6428','7462','3438','4700','8656','8058','2156','4089','7056','3427','4546','2004','3702','12414','4660','6675','1987','3752','16737','2612','4368','1929','3990','1948','4246','1903','1973','1922','2364','2400','2356','2816','2786','2076','1890','2232','1906','1909','1891','2049','2147','1966','1972','2410','1977','2146','1918','2122','2250','1998','2030','2140','2295','1976','2820','2170','2201','1982','2213','1956','2386','2212') <br> AND group_id != 0 AND best_thumb = 'yes' ORDER BY total_ctr DESC )

Code: Select all

2018-11-11 19:26:26 : Mysql error 1055: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'имя-базы.rot_gallery_stats1.gallery_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by (SELECT DISTINCT(group_id), gallery_id FROM rot_gallery_stats1 WHERE gallery_id IN ('17155','17133','16848','16653','17031','16978','16243','17030','16975','16969','16809','16957','16803','16927','16771','16913','16770','16864','16549','16856','16536','16847','16498','16778','16484','16731','16472','16710','16450','16702','16449','16625','16417','16588','16415','16551','16376','16525','16351','16486','16261','16474','16212','16443','16208','16430','16171','16324','16072','16296','16283','16201','16137','16126','16079','16035','16027','16026','16014','16006','1905','3385','3823','5234','8403','0','6277','1890','16023','3738','5012','1886','13290','4089','5146','1934','3375','3788','2069','3537','12414','1910','1916','2004','2196','1999','2240','2237','2147','1977','2036','2280','2032','1967','2028','2152','2323','1995','2400','2121','2108','2638','2415','1980','2649','2453','2677','1926','2458','1982','1948','2301','2820','2271','1978','2657','2398','1956','2329','2810') <br> AND group_id != 0 AND best_thumb = 'yes' GROUP BY group_id ORDER BY total_ctr DESC )