Query:
SELECT COUNT(*) FROM bx_notifications_settings AS ts LEFT JOIN bx_notifications_handlers AS th ON ts.handler_id=th.id LEFT JOIN bx_notifications_settings2users AS tsu ON ts.id=tsu.setting_id WHERE ts.active='1' AND tsu.user_id=3 AND ts.delivery='site' AND ts.type='personal' GROUP BY group
Mysql error:
Column 'group' in group statement is ambiguous
Location:
The error was found in getOne function in the file /home/lgbtqia/public_html/beta/inc/classes/BxDolGrid.php at line 432.
Error when going to notifications settings.
Query: SELECT COUNT(*) FROM
bx_notifications_settings
ASts
LEFT JOINbx_notifications_handlers
ASth
ONts
.handler_id
=th
.id
LEFT JOINbx_notifications_settings2users
AStsu
ONts
.id
=tsu
.setting_id
WHEREts
.active
='1' ANDtsu
.user_id
=3 ANDts
.delivery
='site' ANDts
.type
='personal' GROUP BYgroup
Mysql error: Column 'group' in group statement is ambiguous
Location: The error was found in getOne function in the file /home/lgbtqia/public_html/beta/inc/classes/BxDolGrid.php at line 432.
collation_connection: utf8mb4_unicode_ci
Debug backtrace:
`Array ( [0] => Array ( [file] => /home/lgbtqia/public_html/beta/inc/classes/BxDolDb.php [line] => 1191 [function] => execute [class] => PDOStatement [type] => -> [args] => Array ( [0] => )
)`
Settings:
`array ( 'sys_cron_time' => '1610043781', 'sys_install_time' => '1603633214', 'sys_upgrade_channel' => 'beta', 'sys_revision' => '18', 'sys_eq_time' => '0', 'sys_push_queue_time' => '0', 'sys_ftp_login' => '', 'sys_ftp_password' => '', 'sys_ftp_dir' => '', 'sys_template_cache_image_enable' => '', 'sys_template_cache_image_max_size' => '5', 'sys_email_attachable_email_templates' => 'bx_timeline_send', 'sys_redirect_after_account_added' => 'page.php?i=account-profile-switcher®ister=1', 'sys_redirect_after_email_confirmation' => '', 'sys_editor_default' => 'sys_tinymce', 'sys_captcha_default' => 'sys_recaptcha_new', 'sys_player_default' => 'sys_html5', 'sys_player_default_format' => 'sd', 'sys_live_updates_interval' => '10000', 'sys_tinymce_plugins_mini' => 'autolink,image,link,lists,paste,fullscreen', 'sys_tinymce_toolbar_mini' => 'bold italic underline removeformat | bullist numlist | alignleft aligncenter alignright | blockquote | link unlink image | fullscreen', 'sys_tinymce_plugins_standard' => 'advlist,autolink,autosave,code,hr,image,link,lists,media,paste,fullscreen', 'sys_tinymce_toolbar_standard' => 'undo redo | styleselect | bold italic | alignleft aligncenter alignright alignjustify | bullist numlist outdent indent | link image | fullscreen', 'sys_tinymce_plugins_full' => 'advlist,anchor,autolink,autoresize,autosave,charmap,code,emoticons,hr,image,link,lists,media,nonbreaking,pagebreak,preview,paste,save,searchreplace,table,textcolor,visualblocks,fullscreen', 'sys_tinymce_toolbar_full' => 'undo redo | styleselect | bold italic | alignleft aligncenter alignright alignjustify | bullist numlist outdent indent | link image, preview media | forecolor emoticons | fullscreen', 'sys_search_keyword_min_len' => '1', 'sys_relations' => 'bx_persons_bx_persons', 'enable_gd' => 'on', 'sys_transcoder_queue_storage' => '', 'sys_session_lifetime_in_min' => '129600', 'sys_account_activation_letter' => 'on', 'site_email_html_template_header' => '
'site_email_html_template_footer' => '
', 'sys_site_logo' => '0', 'sys_site_logo_alt' => '0', 'sys_site_icon' => '0', 'sys_site_logo_width' => '240', 'sys_site_logo_height' => '48', 'sys_site_splash_code' => '