Błąd w module: Raport aktywności
Błąd występuje zawsze po zaznaczeniu opcji Pliki.
who=1
type=256
message=mysqlt error: [1052: Column 'created_by' in where clause is ambiguous] in EXECUTE("SELECT COUNT(*) FROM (SELECT uaf.id AS id,uaf.created_on AS edited_on,uaf.created_by AS edited_by, ual.local AS r_id, '' AS tab, 'file' AS action FROM utils_attachment_file uaf INNER JOIN utils_attachment_data_1 ua ON uaf.attach_id=ua.id INNER JOIN utils_attachment_local ual ON ua.id=ual.attachment WHERE original!='' AND (ual.local LIKE CONCAT('premium_multiple_addresses/','%') OR ual.local LIKE CONCAT('premium_payments_agent/','%') OR ual.local LIKE CONCAT('crm_assets/','%') OR ual.local LIKE CONCAT('company/','%') OR ual.local LIKE CONCAT('contact/','%') OR ual.local LIKE CONCAT('rc_accounts/','%') OR ual.local LIKE CONCAT('rc_multiple_emails/','%') OR ual.local LIKE CONCAT('rc_mail_threads/','%') OR ual.local LIKE CONCAT('rc_mails/','%') OR ual.local LIKE CONCAT('rc_mails_assoc/','%') OR ual.local LIKE CONCAT('crm_meeting/','%') OR ual.local LIKE CONCAT('utils_attachment/','%') OR ual.local LIKE CONCAT('premium_salesopportunity/','%') OR ual.local LIKE CONCAT('premium_payments/','%') OR ual.local LIKE CONCAT('phonecall/','%') OR ual.local LIKE CONCAT('premium_projects/','%') OR ual.local LIKE CONCAT('premium_roundcube_custom_addon/','%') OR ual.local LIKE CONCAT('task/','%') OR ual.local LIKE CONCAT('data_tax_rates/','%') OR ual.local LIKE CONCAT('premium_tickets/','%') OR ual.local LIKE CONCAT('premium_tickets_testing/','%')) AND created_by = 4 AND uaf.created_on >= '2014-09-01' AND uaf.created_on <= '2014-09-15 23:59:59' UNION SELECT id, edited_on, edited_by, premium_multiple_addresses_id as r_id, 'premium_multiple_addresses' as tab, 'edit' as action FROM premium_multiple_addresses_edit_history eh LEFT JOIN premium_multiple_addresses_edit_history_data ehd ON ehd.edit_id=eh.id WHERE edited_by = 4 AND edited_on >= '2014-09-01' AND edited_on <= '2014-09-15 23:59:59' UNION SELECT id, edited_on, edited_by, premium_payments_agent_id as r_id, 'premium_payments_agent' as tab, 'edit' as action FROM premium_payments_agent_edit_history eh LEFT JOIN premium_payments_agent_edit_history_data ehd ON ehd.edit_id=eh.id WHERE edited_by = 4 AND edited_on >= '2014-09-01' AND edited_on <= '2014-09-15 23:59:59' UNION SELECT id, edited_on, edited_by, crm_assets_id as r_id, 'crm_assets' as tab, 'edit' as action FROM crm_assets_edit_history eh LEFT JOIN crm_assets_edit_history_data ehd ON ehd.edit_id=eh.id WHERE edited_by = 4 AND edited_on >= '2014-09-01' AND edited_on <= '2014-09-15 23:59:59' UNION SELECT id, edited_on, edited_by, company_id as r_id, 'company' as tab, 'edit' as action FROM company_edit_history eh LEFT JOIN company_edit_history_data ehd ON ehd.edit_id=eh.id WHERE edited_by = 4 AND edited_on >= '2014-09-01' AND edited_on <= '2014-09-15 23:59:59' UNION SELECT id, edited_on, edited_by, contact_id as r_id, 'contact' as tab, 'edit' as action FROM contact_edit_history eh LEFT JOIN contact_edit_history_data ehd ON ehd.edit_id=eh.id WHERE edited_by = 4 AND edited_on >= '2014-09-01' AND edited_on <= '2014-09-15 23:59:59' UNION SELECT id, edited_on, edited_by, rc_accounts_id as r_id, 'rc_accounts' as tab, 'edit' as action FROM rc_accounts_edit_history eh LEFT JOIN rc_accounts_edit_history_data ehd ON ehd.edit_id=eh.id WHERE edited_by = 4 AND edited_on >= '2014-09-01' AND edited_on <= '2014-09-15 23:59:59' UNION SELECT id, edited_on, edited_by, rc_multiple_emails_id as r_id, 'rc_multiple_emails' as tab, 'edit' as action FROM rc_multiple_emails_edit_history eh LEFT JOIN rc_multiple_emails_edit_history_data ehd ON ehd.edit_id=eh.id WHERE edited_by = 4 AND edited_on >= '2014-09-01' AND edited_on <= '2014-09-15 23:59:59' UNION SELECT id, edited_on, edited_by, rc_mail_threads_id as r_id, 'rc_mail_threads' as tab, 'edit' as action FROM rc_mail_threads_edit_history eh LEFT JOIN rc_mail_threads_edit_history_data ehd ON ehd.edit_id=eh.id WHERE edited_by = 4 AND edited_on >= '2014-09-01' AND edited_on <= '2014-09-15 23:59:59' UNION SELECT id, edited_on, edited_by, rc_mails_id as r_id, 'rc_mails' as tab, 'edit' as action FROM rc_mails_edit_history eh LEFT JOIN rc_mails_edit_history_data ehd ON ehd.edit_id=eh.id WHERE edited_by = 4 AND edited_on >= '2014-09-01' AND edited_on <= '2014-09-15 23:59:59' UNION SELECT id, edited_on, edited_by, rc_mails_assoc_id as r_id, 'rc_mails_assoc' as tab, 'edit' as action FROM rc_mails_assoc_edit_history eh LEFT JOIN rc_mails_assoc_edit_history_data ehd ON ehd.edit_id=eh.id WHERE edited_by = 4 AND edited_on >= '2014-09-01' AND edited_on <= '2014-09-15 23:59:59' UNION SELECT id, edited_on, edited_by, crm_meeting_id as r_id, 'crm_meeting' as tab, 'edit' as action FROM crm_meeting_edit_history eh LEFT JOIN crm_meeting_edit_history_data ehd ON ehd.edit_id=eh.id WHERE edited_by = 4 AND edited_on >= '2014-09-01' AND edited_on <= '2014-09-15 23:59:59' UNION SELECT id, edited_on, edited_by, utils_attachment_id as r_id, 'utils_attachment' as tab, 'edit' as action FROM utils_attachment_edit_history eh LEFT JOIN utils_attachment_edit_history_data ehd ON ehd.edit_id=eh.id WHERE edited_by = 4 AND edited_on >= '2014-09-01' AND edited_on <= '2014-09-15 23:59:59' UNION SELECT id, edited_on, edited_by, premium_salesopportunity_id as r_id, 'premium_salesopportunity' as tab, 'edit' as action FROM premium_salesopportunity_edit_history eh LEFT JOIN premium_salesopportunity_edit_history_data ehd ON ehd.edit_id=eh.id WHERE edited_by = 4 AND edited_on >= '2014-09-01' AND edited_on <= '2014-09-15 23:59:59' UNION SELECT id, edited_on, edited_by, premium_payments_id as r_id, 'premium_payments' as tab, 'edit' as action FROM premium_payments_edit_history eh LEFT JOIN premium_payments_edit_history_data ehd ON ehd.edit_id=eh.id WHERE edited_by = 4 AND edited_on >= '2014-09-01' AND edited_on <= '2014-09-15 23:59:59' UNION SELECT id, edited_on, edited_by, phonecall_id as r_id, 'phonecall' as tab, 'edit' as action FROM phonecall_edit_history eh LEFT JOIN phonecall_edit_history_data ehd ON ehd.edit_id=eh.id WHERE edited_by = 4 AND edited_on >= '2014-09-01' AND edited_on <= '2014-09-15 23:59:59' UNION SELECT id, edited_on, edited_by, premium_projects_id as r_id, 'premium_projects' as tab, 'edit' as action FROM premium_projects_edit_history eh LEFT JOIN premium_projects_edit_history_data ehd ON ehd.edit_id=eh.id WHERE edited_by = 4 AND edited_on >= '2014-09-01' AND edited_on <= '2014-09-15 23:59:59' UNION SELECT id, edited_on, edited_by, premium_roundcube_custom_addon_id as r_id, 'premium_roundcube_custom_addon' as tab, 'edit' as action FROM premium_roundcube_custom_addon_edit_history eh LEFT JOIN premium_roundcube_custom_addon_edit_history_data ehd ON ehd.edit_id=eh.id WHERE edited_by = 4 AND edited_on >= '2014-09-01' AND edited_on <= '2014-09-15 23:59:59' UNION SELECT id, edited_on, edited_by, task_id as r_id, 'task' as tab, 'edit' as action FROM task_edit_history eh LEFT JOIN task_edit_history_data ehd ON ehd.edit_id=eh.id WHERE edited_by = 4 AND edited_on >= '2014-09-01' AND edited_on <= '2014-09-15 23:59:59' UNION SELECT id, edited_on, edited_by, data_tax_rates_id as r_id, 'data_tax_rates' as tab, 'edit' as action FROM data_tax_rates_edit_history eh LEFT JOIN data_tax_rates_edit_history_data ehd ON ehd.edit_id=eh.id WHERE edited_by = 4 AND edited_on >= '2014-09-01' AND edited_on <= '2014-09-15 23:59:59' UNION SELECT id, edited_on, edited_by, premium_tickets_id as r_id, 'premium_tickets' as tab, 'edit' as action FROM premium_tickets_edit_history eh LEFT JOIN premium_tickets_edit_history_data ehd ON ehd.edit_id=eh.id WHERE edited_by = 4 AND edited_on >= '2014-09-01' AND edited_on <= '2014-09-15 23:59:59' UNION SELECT id, edited_on, edited_by, premium_tickets_testing_id as r_id, 'premium_tickets_testing' as tab, 'edit' as action FROM premium_tickets_testing_edit_history eh LEFT JOIN premium_tickets_testing_edit_history_data ehd ON ehd.edit_id=eh.id WHERE edited_by = 4 AND edited_on >= '2014-09-01' AND edited_on <= '2014-09-15 23:59:59' UNION SELECT 0 AS id, created_on AS edited_on, created_by AS edited_by, id as r_id, 'premium_multiple_addresses' as tab, 'create' as action FROM premium_multiple_addresses_data_1 WHERE created_by = 4 AND created_on >= '2014-09-01' AND created_on <= '2014-09-15 23:59:59' UNION SELECT 0 AS id, created_on AS edited_on, created_by AS edited_by, id as r_id, 'premium_payments_agent' as tab, 'create' as action FROM premium_payments_agent_data_1 WHERE created_by = 4 AND created_on >= '2014-09-01' AND created_on <= '2014-09-15 23:59:59' UNION SELECT 0 AS id, created_on AS edited_on, created_by AS edited_by, id as r_id, 'crm_assets' as tab, 'create' as action FROM crm_assets_data_1 WHERE created_by = 4 AND created_on >= '2014-09-01' AND created_on <= '2014-09-15 23:59:59' UNION SELECT 0 AS id, created_on AS edited_on, created_by AS edited_by, id as r_id, 'company' as tab, 'create' as action FROM company_data_1 WHERE created_by = 4 AND created_on >= '2014-09-01' AND created_on <= '2014-09-15 23:59:59' UNION SELECT 0 AS id, created_on AS edited_on, created_by AS edited_by, id as r_id, 'contact' as tab, 'create' as action FROM contact_data_1 WHERE created_by = 4 AND created_on >= '2014-09-01' AND created_on <= '2014-09-15 23:59:59' UNION SELECT 0 AS id, created_on AS edited_on, created_by AS edited_by, id as r_id, 'rc_accounts' as tab, 'create' as action FROM rc_accounts_data_1 WHERE created_by = 4 AND created_on >= '2014-09-01' AND created_on <= '2014-09-15 23:59:59' UNION SELECT 0 AS id, created_on AS edited_on, created_by AS edited_by, id as r_id, 'rc_multiple_emails' as tab, 'create' as action FROM rc_multiple_emails_data_1 WHERE created_by = 4 AND created_on >= '2014-09-01' AND created_on <= '2014-09-15 23:59:59' UNION SELECT 0 AS id, created_on AS edited_on, created_by AS edited_by, id as r_id, 'rc_mail_threads' as tab, 'create' as action FROM rc_mail_threads_data_1 WHERE created_by = 4 AND created_on >= '2014-09-01' AND created_on <= '2014-09-15 23:59:59' UNION SELECT 0 AS id, created_on AS edited_on, created_by AS edited_by, id as r_id, 'rc_mails' as tab, 'create' as action FROM rc_mails_data_1 WHERE created_by = 4 AND created_on >= '2014-09-01' AND created_on <= '2014-09-15 23:59:59' UNION SELECT 0 AS id, created_on AS edited_on, created_by AS edited_by, id as r_id, 'rc_mails_assoc' as tab, 'create' as action FROM rc_mails_assoc_data_1 WHERE created_by = 4 AND created_on >= '2014-09-01' AND created_on <= '2014-09-15 23:59:59' UNION SELECT 0 AS id, created_on AS edited_on, created_by AS edited_by, id as r_id, 'crm_meeting' as tab, 'create' as action FROM crm_meeting_data_1 WHERE created_by = 4 AND created_on >= '2014-09-01' AND created_on <= '2014-09-15 23:59:59' UNION SELECT 0 AS id, created_on AS edited_on, created_by AS edited_by, id as r_id, 'utils_attachment' as tab, 'create' as action FROM utils_attachment_data_1 WHERE created_by = 4 AND created_on >= '2014-09-01' AND created_on <= '2014-09-15 23:59:59' UNION SELECT 0 AS id, created_on AS edited_on, created_by AS edited_by, id as r_id, 'premium_salesopportunity' as tab, 'create' as action FROM premium_salesopportunity_data_1 WHERE created_by = 4 AND created_on >= '2014-09-01' AND created_on <= '2014-09-15 23:59:59' UNION SELECT 0 AS id, created_on AS edited_on, created_by AS edited_by, id as r_id, 'premium_payments' as tab, 'create' as action FROM premium_payments_data_1 WHERE created_by = 4 AND created_on >= '2014-09-01' AND created_on <= '2014-09-15 23:59:59' UNION SELECT 0 AS id, created_on AS edited_on, created_by AS edited_by, id as r_id, 'phonecall' as tab, 'create' as action FROM phonecall_data_1 WHERE created_by = 4 AND created_on >= '2014-09-01' AND created_on <= '2014-09-15 23:59:59' UNION SELECT 0 AS id, created_on AS edited_on, created_by AS edited_by, id as r_id, 'premium_projects' as tab, 'create' as action FROM premium_projects_data_1 WHERE created_by = 4 AND created_on >= '2014-09-01' AND created_on <= '2014-09-15 23:59:59' UNION SELECT 0 AS id, created_on AS edited_on, created_by AS edited_by, id as r_id, 'premium_roundcube_custom_addon' as tab, 'create' as action FROM premium_roundcube_custom_addon_data_1 WHERE created_by = 4 AND created_on >= '2014-09-01' AND created_on <= '2014-09-15 23:59:59' UNION SELECT 0 AS id, created_on AS edited_on, created_by AS edited_by, id as r_id, 'task' as tab, 'create' as action FROM task_data_1 WHERE created_by = 4 AND created_on >= '2014-09-01' AND created_on <= '2014-09-15 23:59:59' UNION SELECT 0 AS id, created_on AS edited_on, created_by AS edited_by, id as r_id, 'data_tax_rates' as tab, 'create' as action FROM data_tax_rates_data_1 WHERE created_by = 4 AND created_on >= '2014-09-01' AND created_on <= '2014-09-15 23:59:59' UNION SELECT 0 AS id, created_on AS edited_on, created_by AS edited_by, id as r_id, 'premium_tickets' as tab, 'create' as action FROM premium_tickets_data_1 WHERE created_by = 4 AND created_on >= '2014-09-01' AND created_on <= '2014-09-15 23:59:59' UNION SELECT 0 AS id, created_on AS edited_on, created_by AS edited_by, id as r_id, 'premium_tickets_testing' as tab, 'create' as action FROM premium_tickets_testing_data_1 WHERE created_by = 4 AND created_on >= '2014-09-01' AND created_on <= '2014-09-15 23:59:59') AS tmp LIMIT 1")
error file=/home/floeusa/public_html/crm/libs/adodb/adodb-errorhandler.inc.php
error line=77
Pełny listing:
http://www.datafilehost.com/d/2c957223
