Mysql 8
-
libra-team
- Posts: 185
- Joined: Tue Nov 27, 2012 11:13 am
Re: Mysql 8
есть такой сервер. там с мускул 8 отсутствуют название таблиц в базе в мейтенс меню. также я не могу вывести релейиед тумбы по current_item_groups_intersection - связано это или нет, не знаю, но на странице ошибка с хедерами и куками. сейчас с телефона, ошибку не воспроизведу. на других серверах работает.
Re: Mysql 8
ок, дайте знать плз когда можно будет узнать какая конкретно ошибка
Don't forget to run script update
-
libra-team
- Posts: 185
- Joined: Tue Nov 27, 2012 11:13 am
Re: Mysql 8
Sorry, there was an error. Please, reload page in a minute. Warning: Cannot modify header information - headers already sent by (output started at .../tube/index.php:652) in .../includes/libs/Cookie.class.php on line 44
-
libra-team
- Posts: 185
- Joined: Tue Nov 27, 2012 11:13 am
Re: Mysql 8
2019-12-13 19:06:30:#0 .../includes/db_modules/mysql.php(160): db_error('SELECT gs.gal...', 1055, 'Expression #2 o...', 'db_link')
#1 .../includes/libs/tpl_tags.php(4816): db_query('SELECT gs.gal...', 'db_link')
#2 .../includes/libs/tpl_tags.php(2940): rot_get_item_execute_query('SELECT gs.gal...', Array, Array)
#3 .../includes/libs/tpl_functions.php(1844): rot_get_items(Array, 0, Array)
#4 .../tube/index.php(589): rot_create_page('content_page', 0, Array, Array, Array)
#5 .../cgi/out.php(1590): unknown()
#6 .../cgi/out.php(1088): my_location('content', false)
#7 {main}
Mysql error:: 1055 (Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'hindivideox_tcms.gs.thumb_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by) (db_link) in query SELECT gs.gallery_id, gs.thumb_id, gi.sponsor_id, gi.content_count, gi.content_type, gs.total_shows, gs.total_clicks, gs.total_ctr, gt.thumb_url, gd.*, gi.content_count, gi.crop_profile_id, gs.activation_date, gi.added_date, gi.duration, gi.url, gi.gallery_total_shows, gi.sponsor_id, gi.source_url, gi.custom_gallery , count(distinct gs.group_id) as shared_tags FROM rot_gallery_stats1 as gs JOIN rot_gallery_info as gi on gi.gallery_id = gs.gallery_id
JOIN rot_gallery_data1 as gd on gd.gallery_id = gs.gallery_id
JOIN rot_thumbs as gt on gt.thumb_id = gs.thumb_id
WHERE 1 = 1 AND gs.group_id IN (select group_id from rot_gallery_stats1 where group_id != 0 and gallery_id = 22688 )
AND gi.gallery_id != 22688 AND gi.gallery_status = 'active' AND gi.gallery_type = 0 and gs.best_thumb = 'yes' GROUP BY gi.gallery_id ORDER BY shared_tags DESC, gs.total_ctr LIMIT 0, 11# queryitems.
#1 .../includes/libs/tpl_tags.php(4816): db_query('SELECT gs.gal...', 'db_link')
#2 .../includes/libs/tpl_tags.php(2940): rot_get_item_execute_query('SELECT gs.gal...', Array, Array)
#3 .../includes/libs/tpl_functions.php(1844): rot_get_items(Array, 0, Array)
#4 .../tube/index.php(589): rot_create_page('content_page', 0, Array, Array, Array)
#5 .../cgi/out.php(1590): unknown()
#6 .../cgi/out.php(1088): my_location('content', false)
#7 {main}
Mysql error:: 1055 (Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'hindivideox_tcms.gs.thumb_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by) (db_link) in query SELECT gs.gallery_id, gs.thumb_id, gi.sponsor_id, gi.content_count, gi.content_type, gs.total_shows, gs.total_clicks, gs.total_ctr, gt.thumb_url, gd.*, gi.content_count, gi.crop_profile_id, gs.activation_date, gi.added_date, gi.duration, gi.url, gi.gallery_total_shows, gi.sponsor_id, gi.source_url, gi.custom_gallery , count(distinct gs.group_id) as shared_tags FROM rot_gallery_stats1 as gs JOIN rot_gallery_info as gi on gi.gallery_id = gs.gallery_id
JOIN rot_gallery_data1 as gd on gd.gallery_id = gs.gallery_id
JOIN rot_thumbs as gt on gt.thumb_id = gs.thumb_id
WHERE 1 = 1 AND gs.group_id IN (select group_id from rot_gallery_stats1 where group_id != 0 and gallery_id = 22688 )
AND gi.gallery_id != 22688 AND gi.gallery_status = 'active' AND gi.gallery_type = 0 and gs.best_thumb = 'yes' GROUP BY gi.gallery_id ORDER BY shared_tags DESC, gs.total_ctr LIMIT 0, 11# queryitems.
Re: Mysql 8
да, не повторяется проблема на 7м ..
скиньте плз шел или ПМА
скиньте плз шел или ПМА
Don't forget to run script update