by AppJetty

Recover deleted data from CRM with Trash Bin for SuiteCRM. It restores data from different modules that you or your users have deleted. SuiteCRM Trash Bin stores all types of deleted records from your CRM. If you ever need to retrive deleted data, you can do so easily from the Trash Bin.

Includes a 30 day guarantee
Try it Now

#1794 - Broke the Add Dashlet and we cannot convert leads anymore !!!!

Closed Bug? created by genepoc a year ago

Honestly, do not touch this add-on.

Wasted two days to correct the curruption this add-on has created

  1. genepoc member avatar

    genepoc

    a year ago

    Here are my logs. Although I have uninstalled the plugin, the Add Dashlet now works except we can't convert Leads into anything !

    Fri Mar 1 09:14:13 2019 [755376][-none-][FATAL] A language key does not found: [ERR_FIELD_FROM_IS_NOT_SET]
    Fri Mar 1 09:14:13 2019 [755376][-none-][FATAL] A language key does not found: [ERR_FIELD_FROMNAME_IS_NOT_SET]
    Fri Mar 1 09:14:13 2019 [755376][-none-][FATAL] A language key does not found: [ERR_FIELD_FROM_NAME_IS_NOT_SET]
    Fri Mar 1 09:14:13 2019 [755376][-none-][FATAL] A language key does not found: [ERR_FIELD_FROM_ADDR_NAME_IS_EMPTY]
    Fri Mar 1 09:55:45 2019 [855283][1][FATAL] Mysqli_query failed.
    Fri Mar 1 09:55:45 2019 [855283][1][FATAL] Query Failed: SELECT rt.* FROM meetings_users rt inner join meetings m1 on rt.meeting_id = m1.id inner join users m2 on rt.user_id = m2.id AND m2.id = '1' WHERE (m1.date_modified > '2019-02-28 21:47:31' AND m1.date_modified <= '2019-03-01 14:55:44' AND 'm1'.deleted = 0) OR ('m1'.date_modified > '2019-02-28 21:47:31' AND 'm1'.date_modified <= '2019-03-01 14:55:44' AND 'm1'.deleted = 1) AND m2.id = '1' LIMIT 0,500: MySQL error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '.deleted = 0) OR ('m1'.date_modified > '2019-02-28 21:47:31' AND 'm1'.date_modif' at line 1
    Fri Mar 1 10:12:22 2019 [899131][2a01d31b-cb4d-c1a3-6a29-5c141fbb61f1][FATAL] Mysqli_query failed.
    Fri Mar 1 10:12:22 2019 [899131][2a01d31b-cb4d-c1a3-6a29-5c141fbb61f1][FATAL] Query Failed: SELECT rt.* FROM meetings_users rt inner join meetings m1 on rt.meeting_id = m1.id inner join users m2 on rt.user_id = m2.id AND m2.id = '2a01d31b-cb4d-c1a3-6a29-5c141fbb61f1' WHERE (m1.date_modified > '0001-01-01 00:00:00' AND m1.date_modified <= '2019-03-01 15:12:22' AND 'm1'.deleted = 0) AND m2.id = '2a01d31b-cb4d-c1a3-6a29-5c141fbb61f1' LIMIT 0,1000: MySQL error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '.deleted = 0) AND m2.id = '2a01d31b-cb4d-c1a3-6a29-5c141fbb61f1' LIMIT 0,1000' at line 1
    Fri Mar 1 10:12:27 2019 [899268][2a01d31b-cb4d-c1a3-6a29-5c141fbb61f1][FATAL] Mysqli_query failed.
    Fri Mar 1 10:12:27 2019 [899268][2a01d31b-cb4d-c1a3-6a29-5c141fbb61f1][FATAL] Query Failed: SELECT rt.* FROM contacts_users rt inner join contacts m1 on rt.contact_id = m1.id inner join users m2 on rt.user_id = m2.id AND m2.id = '2a01d31b-cb4d-c1a3-6a29-5c141fbb61f1' WHERE (m1.date_modified > '0001-01-01 00:00:00' AND m1.date_modified <= '2019-03-01 15:12:27' AND 'm1'.deleted = 0) AND m2.id = '2a01d31b-cb4d-c1a3-6a29-5c141fbb61f1' LIMIT 0,1000: MySQL error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '.deleted = 0) AND m2.id = '2a01d31b-cb4d-c1a3-6a29-5c141fbb61f1' LIMIT 0,1000' at line 1
    Fri Mar 1 10:48:02 2019 [980419][a987b7ad-8636-fe4d-6490-5c585eaf74ac][FATAL] Mysqli_query failed.
    Fri Mar 1 10:48:02 2019 [980419][a987b7ad-8636-fe4d-6490-5c585eaf74ac][FATAL] Query Failed: ALTER TABLE calls DROP reason_deleted: MySQL error 1091: Can't DROP COLUMN reason_deleted; check that it exists
    Fri Mar 1 10:48:02 2019 [980419][a987b7ad-8636-fe4d-6490-5c585eaf74ac][FATAL] Mysqli_query failed.
    Fri Mar 1 10:48:02 2019 [980419][a987b7ad-8636-fe4d-6490-5c585eaf74ac][FATAL] Query Failed: ALTER TABLE calls DROP reason_restored: MySQL error 1091: Can't DROP COLUMN reason_restored; check that it exists
    Fri Mar 1 10:48:02 2019 [980419][a987b7ad-8636-fe4d-6490-5c585eaf74ac][FATAL] Mysqli_query failed.
    Fri Mar 1 10:48:02 2019 [980419][a987b7ad-8636-fe4d-6490-5c585eaf74ac][FATAL] Query Failed: ALTER TABLE meetings DROP reason_deleted: MySQL error 1091: Can't DROP COLUMN reason_deleted; check that it exists
    Fri Mar 1 10:48:02 2019 [980419][a987b7ad-8636-fe4d-6490-5c585eaf74ac][FATAL] Mysqli_query failed.
    Fri Mar 1 10:48:02 2019 [980419][a987b7ad-8636-fe4d-6490-5c585eaf74ac][FATAL] Query Failed: ALTER TABLE meetings DROP reason_restored: MySQL error 1091: Can't DROP COLUMN reason_restored; check that it exists
    Fri Mar 1 10:48:02 2019 [980419][a987b7ad-8636-fe4d-6490-5c585eaf74ac][FATAL] Mysqli_query failed.
    Fri Mar 1 10:48:02 2019 [980419][a987b7ad-8636-fe4d-6490-5c585eaf74ac][FATAL] Query Failed: ALTER TABLE email_templates DROP reason_deleted: MySQL error 1091: Can't DROP COLUMN reason_deleted; check that it exists
    Fri Mar 1 10:48:02 2019 [980419][a987b7ad-8636-fe4d-6490-5c585eaf74ac][FATAL] Mysqli_query failed.
    Fri Mar 1 10:48:02 2019 [980419][a987b7ad-8636-fe4d-6490-5c585eaf74ac][FATAL] Query Failed: ALTER TABLE email_templates DROP reason_restored: MySQL error 1091: Can't DROP COLUMN reason_restored; check that it exists
    Fri Mar 1 10:48:02 2019 [980419][a987b7ad-8636-fe4d-6490-5c585eaf74ac][FATAL] Mysqli_query failed.
    Fri Mar 1 10:48:02 2019 [980419][a987b7ad-8636-fe4d-6490-5c585eaf74ac][FATAL] Query Failed: ALTER TABLE campaigns DROP reason_deleted: MySQL error 1091: Can't DROP COLUMN reason_deleted; check that it exists
    Fri Mar 1 10:48:02 2019 [980419][a987b7ad-8636-fe4d-6490-5c585eaf74ac][FATAL] Mysqli_query failed.
    Fri Mar 1 10:48:02 2019 [980419][a987b7ad-8636-fe4d-6490-5c585eaf74ac][FATAL] Query Failed: ALTER TABLE campaigns DROP reason_restored: MySQL error 1091: Can't DROP COLUMN reason_restored; check that it exists
    Fri Mar 1 10:48:02 2019 [980419][a987b7ad-8636-fe4d-6490-5c585eaf74ac][FATAL] Mysqli_query failed.
    Fri Mar 1 10:48:02 2019 [980419][a987b7ad-8636-fe4d-6490-5c585eaf74ac][FATAL] Query Failed: ALTER TABLE prospects DROP reason_deleted: MySQL error 1091: Can't DROP COLUMN reason_deleted; check that it exists
    Fri Mar 1 10:48:02 2019 [980419][a987b7ad-8636-fe4d-6490-5c585eaf74ac][FATAL] Mysqli_query failed.
    Fri Mar 1 10:48:02 2019 [980419][a987b7ad-8636-fe4d-6490-5c585eaf74ac][FATAL] Query Failed: ALTER TABLE prospects DROP reason_restored: MySQL error 1091: Can't DROP COLUMN reason_restored; check that it exists
    Fri Mar 1 10:48:02 2019 [980419][a987b7ad-8636-fe4d-6490-5c585eaf74ac][FATAL] Mysqli_query failed.
    Fri Mar 1 10:48:02 2019 [980419][a987b7ad-8636-fe4d-6490-5c585eaf74ac][FATAL] Query Failed: ALTER TABLE prospect_lists DROP reason_deleted: MySQL error 1091: Can't DROP COLUMN reason_deleted; check that it exists
    Fri Mar 1 10:48:02 2019 [980419][a987b7ad-8636-fe4d-6490-5c585eaf74ac][FATAL] Mysqli_query failed.
    Fri Mar 1 10:48:02 2019 [980419][a987b7ad-8636-fe4d-6490-5c585eaf74ac][FATAL] Query Failed: ALTER TABLE prospect_lists DROP reason_restored: MySQL error 1091: Can't DROP COLUMN reason_restored; check that it exists
    Fri Mar 1 10:48:02 2019 [980419][a987b7ad-8636-fe4d-6490-5c585eaf74ac][FATAL] Mysqli_query failed.
    Fri Mar 1 10:48:02 2019 [980419][a987b7ad-8636-fe4d-6490-5c585eaf74ac][FATAL] Query Failed: ALTER TABLE documents DROP reason_deleted: MySQL error 1091: Can't DROP COLUMN reason_deleted; check that it exists
    Fri Mar 1 10:48:02 2019 [980419][a987b7ad-8636-fe4d-6490-5c585eaf74ac][FATAL] Mysqli_query failed.
    Fri Mar 1 10:48:02 2019 [980419][a987b7ad-8636-fe4d-6490-5c585eaf74ac][FATAL] Query Failed: ALTER TABLE documents DROP reason_restored: MySQL error 1091: Can't DROP COLUMN reason_restored; check that it exists
    Fri Mar 1 10:48:02 2019 [980419][a987b7ad-8636-fe4d-6490-5c585eaf74ac][FATAL] Mysqli_query failed.
    Fri Mar 1 10:48:02 2019 [980419][a987b7ad-8636-fe4d-6490-5c585eaf74ac][FATAL] Query Failed: ALTER TABLE cases DROP reason_deleted: MySQL error 1091: Can't DROP COLUMN reason_deleted; check that it exists
    Fri Mar 1 10:48:02 2019 [980419][a987b7ad-8636-fe4d-6490-5c585eaf74ac][FATAL] Mysqli_query failed.
    Fri Mar 1 10:48:02 2019 [980419][a987b7ad-8636-fe4d-6490-5c585eaf74ac][FATAL] Query Failed: ALTER TABLE cases DROP reason_restored: MySQL error 1091: Can't DROP COLUMN reason_restored; check that it exists
    Fri Mar 1 10:48:02 2019 [980419][a987b7ad-8636-fe4d-6490-5c585eaf74ac][FATAL] Mysqli_query failed.
    Fri Mar 1 10:48:02 2019 [980419][a987b7ad-8636-fe4d-6490-5c585eaf74ac][FATAL] Query Failed: ALTER TABLE project DROP reason_deleted: MySQL error 1091: Can't DROP COLUMN reason_deleted; check that it exists
    Fri Mar 1 10:48:02 2019 [980419][a987b7ad-8636-fe4d-6490-5c585eaf74ac][FATAL] Mysqli_query failed.
    Fri Mar 1 10:48:02 2019 [980419][a987b7ad-8636-fe4d-6490-5c585eaf74ac][FATAL] Query Failed: ALTER TABLE project DROP reason_restored: MySQL error 1091: Can't DROP COLUMN reason_restored; check that it exists
    Fri Mar 1 10:48:02 2019 [980419][a987b7ad-8636-fe4d-6490-5c585eaf74ac][FATAL] Mysqli_query failed.
    Fri Mar 1 10:48:02 2019 [980419][a987b7ad-8636-fe4d-6490-5c585eaf74ac][FATAL] Query Failed: ALTER TABLE bugs DROP reason_deleted: MySQL error 1091: Can't DROP COLUMN reason_deleted; check that it exists
    Fri Mar 1 10:48:02 2019 [980419][a987b7ad-8636-fe4d-6490-5c585eaf74ac][FATAL] Mysqli_query failed.
    Fri Mar 1 10:48:02 2019 [980419][a987b7ad-8636-fe4d-6490-5c585eaf74ac][FATAL] Query Failed: ALTER TABLE bugs DROP reason_restored: MySQL error 1091: Can't DROP COLUMN reason_restored; check that it exists
    Fri Mar 1 10:48:02 2019 [980419][a987b7ad-8636-fe4d-6490-5c585eaf74ac][FATAL] Mysqli_query failed.
    Fri Mar 1 10:48:02 2019 [980419][a987b7ad-8636-fe4d-6490-5c585eaf74ac][FATAL] Query Failed: ALTER TABLE aobh_businesshours DROP reason_deleted: MySQL error 1091: Can't DROP COLUMN reason_deleted; check that it exists
    Fri Mar 1 10:48:02 2019 [980419][a987b7ad-8636-fe4d-6490-5c585eaf74ac][FATAL] Mysqli_query failed.
    Fri Mar 1 10:48:02 2019 [980419][a987b7ad-8636-fe4d-6490-5c585eaf74ac][FATAL] Query Failed: ALTER TABLE aobh_businesshours DROP reason_restored: MySQL error 1091: Can't DROP COLUMN reason_restored; check that it exists
    Fri Mar 1 10:48:02 2019 [980419][a987b7ad-8636-fe4d-6490-5c585eaf74ac][FATAL] Mysqli_query failed.
    Fri Mar 1 10:48:02 2019 [980419][a987b7ad-8636-fe4d-6490-5c585eaf74ac][FATAL] Query Failed: ALTER TABLE am_projecttemplates DROP reason_deleted: MySQL error 1091: Can't DROP COLUMN reason_deleted; check that it exists
    Fri Mar 1 10:48:02 2019 [980419][a987b7ad-8636-fe4d-6490-5c585eaf74ac][FATAL] Mysqli_query failed.
    Fri Mar 1 10:48:02 2019 [980419][a987b7ad-8636-fe4d-6490-5c585eaf74ac][FATAL] Query Failed: ALTER TABLE am_projecttemplates DROP reason_restored: MySQL error 1091: Can't DROP COLUMN reason_restored; check that it exists
    Fri Mar 1 10:48:02 2019 [980419][a987b7ad-8636-fe4d-6490-5c585eaf74ac][FATAL] Mysqli_query failed.
    Fri Mar 1 10:48:02 2019 [980419][a987b7ad-8636-fe4d-6490-5c585eaf74ac][FATAL] Query Failed: ALTER TABLE aok_knowledge_base_categories DROP reason_deleted: MySQL error 1091: Can't DROP COLUMN reason_deleted; check that it exists
    Fri Mar 1 10:48:02 2019 [980419][a987b7ad-8636-fe4d-6490-5c585eaf74ac][FATAL] Mysqli_query failed.
    Fri Mar 1 10:48:02 2019 [980419][a987b7ad-8636-fe4d-6490-5c585eaf74ac][FATAL] Query Failed: ALTER TABLE aok_knowledge_base_categories DROP reason_restored: MySQL error 1091: Can't DROP COLUMN reason_restored; check that it exists
    Fri Mar 1 10:48:02 2019 [980419][a987b7ad-8636-fe4d-6490-5c585eaf74ac][FATAL] Mysqli_query failed.
    Fri Mar 1 10:48:02 2019 [980419][a987b7ad-8636-fe4d-6490-5c585eaf74ac][FATAL] Query Failed: ALTER TABLE aok_knowledgebase DROP reason_deleted: MySQL error 1091: Can't DROP COLUMN reason_deleted; check that it exists
    Fri Mar 1 10:48:02 2019 [980419][a987b7ad-8636-fe4d-6490-5c585eaf74ac][FATAL] Mysqli_query failed.
    Fri Mar 1 10:48:02 2019 [980419][a987b7ad-8636-fe4d-6490-5c585eaf74ac][FATAL] Query Failed: ALTER TABLE aok_knowledgebase DROP reason_restored: MySQL error 1091: Can't DROP COLUMN reason_restored; check that it exists
    Fri Mar 1 10:48:02 2019 [980419][a987b7ad-8636-fe4d-6490-5c585eaf74ac][FATAL] Mysqli_query failed.
    Fri Mar 1 10:48:02 2019 [980419][a987b7ad-8636-fe4d-6490-5c585eaf74ac][FATAL] Query Failed: ALTER TABLE fp_events DROP reason_deleted: MySQL error 1091: Can't DROP COLUMN reason_deleted; check that it exists
    Fri Mar 1 10:48:02 2019 [980419][a987b7ad-8636-fe4d-6490-5c585eaf74ac][FATAL] Mysqli_query failed.
    Fri Mar 1 10:48:02 2019 [980419][a987b7ad-8636-fe4d-6490-5c585eaf74ac][FATAL] Query Failed: ALTER TABLE fp_events DROP reason_restored: MySQL error 1091: Can't DROP COLUMN reason_restored; check that it exists
    Fri Mar 1 10:48:02 2019 [980419][a987b7ad-8636-fe4d-6490-5c585eaf74ac][FATAL] Mysqli_query failed.
    Fri Mar 1 10:48:02 2019 [980419][a987b7ad-8636-fe4d-6490-5c585eaf74ac][FATAL] Query Failed: ALTER TABLE fp_event_locations DROP reason_deleted: MySQL error 1091: Can't DROP COLUMN reason_deleted; check that it exists
    Fri Mar 1 10:48:02 2019 [980419][a987b7ad-8636-fe4d-6490-5c585eaf74ac][FATAL] Mysqli_query failed.
    Fri Mar 1 10:48:02 2019 [980419][a987b7ad-8636-fe4d-6490-5c585eaf74ac][FATAL] Query Failed: ALTER TABLE fp_event_locations DROP reason_restored: MySQL error 1091: Can't DROP COLUMN reason_restored; check that it exists
    Fri Mar 1 10:48:03 2019 [980419][a987b7ad-8636-fe4d-6490-5c585eaf74ac][FATAL] Mysqli_query failed.
    Fri Mar 1 10:48:03 2019 [980419][a987b7ad-8636-fe4d-6490-5c585eaf74ac][FATAL] Query Failed: ALTER TABLE aos_contracts DROP reason_deleted: MySQL error 1091: Can't DROP COLUMN reason_deleted; check that it exists
    Fri Mar 1 10:48:03 2019 [980419][a987b7ad-8636-fe4d-6490-5c585eaf74ac][FATAL] Mysqli_query failed.
    Fri Mar 1 10:48:03 2019 [980419][a987b7ad-8636-fe4d-6490-5c585eaf74ac][FATAL] Query Failed: ALTER TABLE aos_contracts DROP reason_restored: MySQL error 1091: Can't DROP COLUMN reason_restored; check that it exists
    Fri Mar 1 10:48:03 2019 [980419][a987b7ad-8636-fe4d-6490-5c585eaf74ac][FATAL] Mysqli_query failed.
    Fri Mar 1 10:48:03 2019 [980419][a987b7ad-8636-fe4d-6490-5c585eaf74ac][FATAL] Query Failed: ALTER TABLE aos_invoices DROP reason_deleted: MySQL error 1091: Can't DROP COLUMN reason_deleted; check that it exists
    Fri Mar 1 10:48:03 2019 [980419][a987b7ad-8636-fe4d-6490-5c585eaf74ac][FATAL] Mysqli_query failed.
    Fri Mar 1 10:48:03 2019 [980419][a987b7ad-8636-fe4d-6490-5c585eaf74ac][FATAL] Query Failed: ALTER TABLE aos_invoices DROP reason_restored: MySQL error 1091: Can't DROP COLUMN reason_restored; check that it exists
    Fri Mar 1 10:48:03 2019 [980419][a987b7ad-8636-fe4d-6490-5c585eaf74ac][FATAL] Mysqli_query failed.
    Fri Mar 1 10:48:03 2019 [980419][a987b7ad-8636-fe4d-6490-5c585eaf74ac][FATAL] Query Failed: ALTER TABLE aos_pdf_templates DROP reason_deleted: MySQL error 1091: Can't DROP COLUMN reason_deleted; check that it exists
    Fri Mar 1 10:48:03 2019 [980419][a987b7ad-8636-fe4d-6490-5c585eaf74ac][FATAL] Mysqli_query failed.
    Fri Mar 1 10:48:03 2019 [980419][a987b7ad-8636-fe4d-6490-5c585eaf74ac][FATAL] Query Failed: ALTER TABLE aos_pdf_templates DROP reason_restored: MySQL error 1091: Can't DROP COLUMN reason_restored; check that it exists
    Fri Mar 1 10:48:03 2019 [980419][a987b7ad-8636-fe4d-6490-5c585eaf74ac][FATAL] Mysqli_query failed.
    Fri Mar 1 10:48:03 2019 [980419][a987b7ad-8636-fe4d-6490-5c585eaf74ac][FATAL] Query Failed: ALTER TABLE aos_product_categories DROP reason_deleted: MySQL error 1091: Can't DROP COLUMN reason_deleted; check that it exists
    Fri Mar 1 10:48:03 2019 [980419][a987b7ad-8636-fe4d-6490-5c585eaf74ac][FATAL] Mysqli_query failed.
    Fri Mar 1 10:48:03 2019 [980419][a987b7ad-8636-fe4d-6490-5c585eaf74ac][FATAL] Query Failed: ALTER TABLE aos_product_categories DROP reason_restored: MySQL error 1091: Can't DROP COLUMN reason_restored; check that it exists
    Fri Mar 1 10:48:03 2019 [980419][a987b7ad-8636-fe4d-6490-5c585eaf74ac][FATAL] Mysqli_query failed.
    Fri Mar 1 10:48:03 2019 [980419][a987b7ad-8636-fe4d-6490-5c585eaf74ac][FATAL] Query Failed: ALTER TABLE aos_products DROP reason_deleted: MySQL error 1091: Can't DROP COLUMN reason_deleted; check that it exists
    Fri Mar 1 10:48:03 2019 [980419][a987b7ad-8636-fe4d-6490-5c585eaf74ac][FATAL] Mysqli_query failed.
    Fri Mar 1 10:48:03 2019 [980419][a987b7ad-8636-fe4d-6490-5c585eaf74ac][FATAL] Query Failed: ALTER TABLE aos_products DROP reason_restored: MySQL error 1091: Can't DROP COLUMN reason_restored; check that it exists
    Fri Mar 1 10:48:03 2019 [980419][a987b7ad-8636-fe4d-6490-5c585eaf74ac][FATAL] Mysqli_query failed.
    Fri Mar 1 10:48:03 2019 [980419][a987b7ad-8636-fe4d-6490-5c585eaf74ac][FATAL] Query Failed: ALTER TABLE aos_quotes DROP reason_deleted: MySQL error 1091: Can't DROP COLUMN reason_deleted; check that it exists
    Fri Mar 1 10:48:03 2019 [980419][a987b7ad-8636-fe4d-6490-5c585eaf74ac][FATAL] Mysqli_query failed.
    Fri Mar 1 10:48:03 2019 [980419][a987b7ad-8636-fe4d-6490-5c585eaf74ac][FATAL] Query Failed: ALTER TABLE aos_quotes DROP reason_restored: MySQL error 1091: Can't DROP COLUMN reason_restored; check that it exists
    Fri Mar 1 10:48:03 2019 [980419][a987b7ad-8636-fe4d-6490-5c585eaf74ac][FATAL] Mysqli_query failed.
    Fri Mar 1 10:48:03 2019 [980419][a987b7ad-8636-fe4d-6490-5c585eaf74ac][FATAL] Query Failed: ALTER TABLE jjwg_maps DROP reason_deleted: MySQL error 1091: Can't DROP COLUMN reason_deleted; check that it exists
    Fri Mar 1 10:48:03 2019 [980419][a987b7ad-8636-fe4d-6490-5c585eaf74ac][FATAL] Mysqli_query failed.
    Fri Mar 1 10:48:03 2019 [980419][a987b7ad-8636-fe4d-6490-5c585eaf74ac][FATAL] Query Failed: ALTER TABLE jjwg_maps DROP reason_restored: MySQL error 1091: Can't DROP COLUMN reason_restored; check that it exists
    Fri Mar 1 10:48:03 2019 [980419][a987b7ad-8636-fe4d-6490-5c585eaf74ac][FATAL] Mysqli_query failed.
    Fri Mar 1 10:48:03 2019 [980419][a987b7ad-8636-fe4d-6490-5c585eaf74ac][FATAL] Query Failed: ALTER TABLE jjwg_markers DROP reason_deleted: MySQL error 1091: Can't DROP COLUMN reason_deleted; check that it exists
    Fri Mar 1 10:48:03 2019 [980419][a987b7ad-8636-fe4d-6490-5c585eaf74ac][FATAL] Mysqli_query failed.
    Fri Mar 1 10:48:03 2019 [980419][a987b7ad-8636-fe4d-6490-5c585eaf74ac][FATAL] Query Failed: ALTER TABLE jjwg_markers DROP reason_restored: MySQL error 1091: Can't DROP COLUMN reason_restored; check that it exists
    Fri Mar 1 10:48:03 2019 [980419][a987b7ad-8636-fe4d-6490-5c585eaf74ac][FATAL] Mysqli_query failed.
    Fri Mar 1 10:48:03 2019 [980419][a987b7ad-8636-fe4d-6490-5c585eaf74ac][FATAL] Query Failed: ALTER TABLE jjwg_areas DROP reason_deleted: MySQL error 1091: Can't DROP COLUMN reason_deleted; check that it exists
    Fri Mar 1 10:48:03 2019 [980419][a987b7ad-8636-fe4d-6490-5c585eaf74ac][FATAL] Mysqli_query failed.
    Fri Mar 1 10:48:03 2019 [980419][a987b7ad-8636-fe4d-6490-5c585eaf74ac][FATAL] Query Failed: ALTER TABLE jjwg_areas DROP reason_restored: MySQL error 1091: Can't DROP COLUMN reason_restored; check that it exists
    Fri Mar 1 10:48:03 2019 [980419][a987b7ad-8636-fe4d-6490-5c585eaf74ac][FATAL] Mysqli_query failed.
    Fri Mar 1 10:48:03 2019 [980419][a987b7ad-8636-fe4d-6490-5c585eaf74ac][FATAL] Query Failed: ALTER TABLE jjwg_address_cache DROP reason_deleted: MySQL error 1091: Can't DROP COLUMN reason_deleted; check that it exists
    Fri Mar 1 10:48:03 2019 [980419][a987b7ad-8636-fe4d-6490-5c585eaf74ac][FATAL] Mysqli_query failed.
    Fri Mar 1 10:48:03 2019 [980419][a987b7ad-8636-fe4d-6490-5c585eaf74ac][FATAL] Query Failed: ALTER TABLE jjwg_address_cache DROP reason_restored: MySQL error 1091: Can't DROP COLUMN reason_restored; check that it exists
    Fri Mar 1 10:48:03 2019 [980419][a987b7ad-8636-fe4d-6490-5c585eaf74ac][FATAL] Mysqli_query failed.
    Fri Mar 1 10:48:03 2019 [980419][a987b7ad-8636-fe4d-6490-5c585eaf74ac][FATAL] Query Failed: ALTER TABLE surveys DROP reason_deleted: MySQL error 1091: Can't DROP COLUMN reason_deleted; check that it exists
    Fri Mar 1 10:48:03 2019 [980419][a987b7ad-8636-fe4d-6490-5c585eaf74ac][FATAL] Mysqli_query failed.
    Fri Mar 1 10:48:03 2019 [980419][a987b7ad-8636-fe4d-6490-5c585eaf74ac][FATAL] Query Failed: ALTER TABLE surveys DROP reason_restored: MySQL error 1091: Can't DROP COLUMN reason_restored; check that it exists
    Fri Mar 1 10:55:43 2019 [997924][1][FATAL] Mysqli_query failed.
    Fri Mar 1 10:55:43 2019 [997924][1][FATAL] Query Failed: SELECT rt.* FROM meetings_users rt inner join meetings m1 on rt.meeting_id = m1.id inner join users m2 on rt.user_id = m2.id AND m2.id = '1' WHERE (m1.date_modified > '2019-03-01 14:55:44' AND m1.date_modified <= '2019-03-01 15:55:42' AND 'm1'.deleted = 0) OR ('m1'.date_modified > '2019-03-01 14:55:44' AND 'm1'.date_modified <= '2019-03-01 15:55:42' AND 'm1'.deleted = 1) AND m2.id = '1' LIMIT 0,500: MySQL error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '.deleted = 0) OR ('m1'.date_modified > '2019-03-01 14:55:44' AND 'm1'.date_modif' at line 1
    Fri Mar 1 11:01:58 2019 [1011703][a987b7ad-8636-fe4d-6490-5c585eaf74ac][FATAL] error loading relationship project_resource
    Fri Mar 1 11:01:58 2019 [1011703][a987b7ad-8636-fe4d-6490-5c585eaf74ac][FATAL] error loading relationship am_projecttemplates_resources

  2. genepoc member avatar

    genepoc

    a year ago

    You can close this issue, I found a solution to fix everything. Go in the following folder www.yourdomain.com/custom    rename your "modules" folder to "modulesBAK" jsut to make sure you have to restore it. Create a new folder "modules", do a Quick and Rebuild, this will fix everything

    • genepoc member avatar

      genepoc

      a year ago

      In fact I just realized that I had to selectively copy back some files from the custom modules wherever changes were made. To correct the original available "Actions" dropdown menus go into the Leads file and remove from the "metadata" folder the detailviewdefs.php file.

  3. Biztech member avatar

    AppJetty Provider

    a year ago

    Hello There,

    Greetings for the day!

    We are glad to read that the issue is been resolved by doing a Quick repair & Rebuild.

    If you need any assistance/information regarding the plugin, please feel free to approach us anytime.

    Also, you can contact us at support@appjetty.com

    Hope this helps! Let us know in case of any concern.

    Kind Regards,
    AppJetty.

This case is public. Please leave out any sensitive information such as URLs, passwords, etc.
Saving Comment Saving Comment...