SmartCJ Support Forum

Posted: **Wed Oct 16, 2013 7:56 pm**

Не отображаются галлеры в админке, хотя в базе есть!!

Error log

19.46  insert into rot_galleries (gallery_md5, file_md5, sponsor_id, thumb_url, custom_var1, custom_var2, custom_var3, type, rgroup, content, content_type, alt, description, duration, date, activation_date, priority, status, gallery_slug) values ('9e1f75a5296120520799cc674df41aba', '', '0', '/scj/thumbs/0/054.jpg', '', '', '', '0', '0', '124', '0', '', '', '0', '1381952770', '2013-10-16 19:46:10', '54', '1', ''):: :

MYSQL ERROR:

Code: Select all

2013-10-16 18:46:11 : Mysql error: 1052 (Column 'alt' in field list is ambiguous) in query SELECT id, gallery_slug, g.gallery_md5,  sponsor_id,  url, source_url, rot_content_id, embed_template, thumb_url, embed_code, 
					flv_url, flv_size_x, flv_size_y, flv_thumb_url, tags,  type, rgroup, content, content_type, 
					duration, date, activation_date, casts, clicks, rating, priority, crop_profile_id, status,
                    alt, description, custom_var1, custom_var2, custom_var3
					FROM rot_galleries as g
					JOIN rot_gallery_info as gi ON gi.gallery_md5 = g.gallery_md5
					JOIN rot_gallery_data as gd ON gd.gallery_md5 = g.gallery_md5
					WHERE id IN (202,54,155,213,86,255,183,173,47,120,256,199,197,36,194,203,254,225,249,253,262,192,217,19,84,195,261,73,94,198,259,236,119,38,35,242,239,20,241,246,238,6,206,182,244,117,247,24,212,85,79,64,226,221,8,137,59,83,200,96,103,204,172,67,70,92,168,50,214,4,143,46,26,189,52,227,118,77,71,234,75,44,40,18,116,125,32,62,74,180,42,181,186,107,235,131,5,60,113,51,27,205,229,65,87,17,231,158,135,34,142,7,63,179,69,151,149,57,97,21,220,101,222,165,141,140,100,162,89,163,248,243)  
2013-10-16 18:46:11 : Mysql error: 1054 (Unknown column 'gallery_slug' in 'field list') in query update rot_galleries set gallery_md5 = '9e1f75a5296120520799cc674df41aba', file_md5 = '', sponsor_id = '0', thumb_url = '/scj/thumbs/0/202.jpg', custom_var1 = '', custom_var2 = '', custom_var3 = '', type = '0', rgroup = '0', content = '125', content_type = '0', alt = '', description = '', duration = '0', date = '1381949171', activation_date = '2013-10-16 18:46:11', priority = '202', status = '1', gallery_slug = '' where  gallery_md5 = '9e1f75a5296120520799cc674df41aba'  
2013-10-16 18:53:10 : Mysql error: 1052 (Column 'url' in field list is ambiguous) in query SELECT id, gallery_slug, g.gallery_md5,  sponsor_id,  url, source_url, rot_content_id, embed_template, thumb_url, embed_code, 
					flv_url, flv_size_x, flv_size_y, flv_thumb_url, tags,  type, rgroup, content, content_type, 
					duration, date, activation_date, casts, clicks, rating, priority, crop_profile_id, status,
                    alt, description, custom_var1, custom_var2, custom_var3
					FROM rot_galleries as g
					JOIN rot_gallery_info as gi ON gi.gallery_md5 = g.gallery_md5
					JOIN rot_gallery_data as gd ON gd.gallery_md5 = g.gallery_md5
					WHERE id IN (202,54,155,213,86,255,183,120,173,47,256,199,194,203,225,197,249,254,19,36,253,217,262,192,261,73,198,84,20,241,239,259,236,195,94,35,38,247,242,119,238,182,246,6,244,24,206,117,137,79,85,64,59,200,181,212,70,8,168,103,226,96,143,204,186,221,234,67,118,172,42,75,113,83,92,26,62,149,4,116,231,32,214,77,52,51,50,74,40,107,44,179,131,189,21,205,17,71,46,235,7,227,65,18,125,87,5,229,60,180,89,135,27,142,34,97,141,158,140,63,165,69,57,151,100,162,126,248,222,220,101,163)  
2013-10-16 19:08:11 : Mysql error: 1052 (Column 'alt' in field list is ambiguous) in query SELECT id, gallery_slug, g.gallery_md5,  sponsor_id,  url, source_url, rot_content_id, embed_template, thumb_url, embed_code, 
					flv_url, flv_size_x, flv_size_y, flv_thumb_url, tags,  type, rgroup, content, content_type, 
					duration, date, activation_date, casts, clicks, rating, priority, crop_profile_id, status,
                    alt, description, custom_var1, custom_var2, custom_var3
					FROM rot_galleries as g
					JOIN rot_gallery_info as gi ON gi.gallery_md5 = g.gallery_md5
					JOIN rot_gallery_data as gd ON gd.gallery_md5 = g.gallery_md5
					WHERE id IN (202,54,155,213,86,255,183,120,173,47,256,199,194,203,225,197,249,254,19,36,253,217,262,192,261,73,198,84,20,241,239,259,236,195,94,35,38,247,242,119,238,182,246,6,244,24,206,117,137,79,85,64,59,200,181,212,70,8,168,103,226,96,143,204,186,221,234,67,118,172,42,75,113,83,92,26,62,149,4,116,231,32,214,77,52,51,50,74,40,107,44,179,131,189,21,205,17,71,46,235,7,227,65,18,125,87,5,229,60,180,89,135,27,142,34,97,141,158,140,63,165,69,57,151,100,162,126,248,222,220,101,163)  
2013-10-16 19:24:10 : Mysql error: 1052 (Column 'alt' in field list is ambiguous) in query SELECT id, gallery_slug, g.gallery_md5,  sponsor_id,  url, source_url, rot_content_id, embed_template, thumb_url, embed_code, 
					flv_url, flv_size_x, flv_size_y, flv_thumb_url, tags,  type, rgroup, content, content_type, 
					duration, date, activation_date, casts, clicks, rating, priority, crop_profile_id, status,
                    alt, description, custom_var1, custom_var2, custom_var3
					FROM rot_galleries as g
					JOIN rot_gallery_info as gi ON gi.gallery_md5 = g.gallery_md5
					JOIN rot_gallery_data as gd ON gd.gallery_md5 = g.gallery_md5
					WHERE id IN (202,54,155,213,86,255,183,120,173,47,256,199,194,203,197,225,249,254,19,36,253,217,262,192,261,73,198,84,20,241,239,259,236,195,94,35,38,247,242,119,238,182,246,6,244,24,206,117,137,79,85,64,59,200,181,212,70,8,168,103,226,96,143,204,186,221,234,67,118,172,42,75,113,83,92,26,62,149,4,116,231,32,214,77,52,51,50,74,40,107,44,179,131,189,21,205,17,71,46,235,7,227,65,18,125,87,5,229,60,180,89,135,27,142,34,97,141,158,140,63,165,69,57,151,100,162,126,248,222,220,101,243)  
2013-10-16 19:40:11 : Mysql error: 1052 (Column 'alt' in field list is ambiguous) in query SELECT id, gallery_slug, g.gallery_md5,  sponsor_id,  url, source_url, rot_content_id, embed_template, thumb_url, embed_code, 
					flv_url, flv_size_x, flv_size_y, flv_thumb_url, tags,  type, rgroup, content, content_type, 
					duration, date, activation_date, casts, clicks, rating, priority, crop_profile_id, status,
                    alt, description, custom_var1, custom_var2, custom_var3
					FROM rot_galleries as g
					JOIN rot_gallery_info as gi ON gi.gallery_md5 = g.gallery_md5
					JOIN rot_gallery_data as gd ON gd.gallery_md5 = g.gallery_md5
					WHERE id IN (54,155,213,86,255,183,120,173,47,256,199,194,203,197,225,249,254,19,36,253,217,262,192,261,73,198,84,20,241,239,259,236,195,94,35,38,247,242,119,238,182,246,6,244,24,206,117,137,79,85,64,59,200,181,212,70,8,168,103,226,96,143,204,186,221,234,67,118,172,42,75,113,83,92,26,62,149,4,116,231,32,214,77,52,51,50,74,40,107,44,179,131,189,21,205,17,71,46,235,7,227,65,18,125,87,229,60,180,89,135,27,142,34,97,141,158,140,63,165,69,151,57,100,162,126,248,222,220,101,163,243)  
2013-10-16 19:46:10 : Mysql error: 1054 (Unknown column 'gallery_slug' in 'field list') in query insert into rot_galleries (gallery_md5, file_md5, sponsor_id, thumb_url, custom_var1, custom_var2, custom_var3, type, rgroup, content, content_type, alt, description, duration, date, activation_date, priority, status, gallery_slug) values ('9e1f75a5296120520799cc674df41aba', '', '0', '/scj/thumbs/0/054.jpg', '', '', '', '0', '0', '124', '0', '', '', '0', '1381952770', '2013-10-16 19:46:10', '54', '1', '')

Posted: **Wed Oct 16, 2013 8:01 pm**

Видимо где-то проблема была, очень старые апедйты как я понимаю

Я бы рекомендовал

1. очистиить базу
2. залить бекап 43
3. провести по очереди бекапы по одному и обращать внимание на ошибки

Posted: **Wed Oct 16, 2013 8:22 pm**

Please, process all updates before 44

PS: не идет дальше

Posted: **Thu Oct 17, 2013 12:05 am**

какой апдейт пишет сейчас ?

Posted: **Thu Oct 17, 2013 4:45 am**

Posted: **Thu Oct 17, 2013 11:23 am**

Как вы смотрите на вариант сделать экспорт галер
поставить 50
и сделать импорт ?

Posted: **Thu Oct 17, 2013 11:58 am**

Да я так и делал. C нуля установил v50 и вылез баг з галлереями

Posted: **Thu Oct 17, 2013 12:04 pm**

конкретнее

Posted: **Thu Oct 17, 2013 12:15 pm**

Выше писал, что не отобрадались галереии в List Thumbs, хотя в базе они есть.
В начале топика инфа с логов

Posted: **Thu Oct 17, 2013 12:55 pm**

Значит у вас что-то с базой.
Вы пробовали переставить с 0, с удалением всего в базе ?

SmartCJ Support Forum

Update c 43 ->50

Update c 43 ->50

Re: Update c 43 ->50

Re: Update c 43 ->50

Re: Update c 43 ->50

Re: Update c 43 ->50

Re: Update c 43 ->50

Re: Update c 43 ->50

Re: Update c 43 ->50

Re: Update c 43 ->50

Re: Update c 43 ->50