Contact Info Not Loading on Click

Product Support
1

Just updated to 2.9 from a relatively fresh installation.



When clicking on a contact in the Contacts screeen getting the following console error:

Code:
libraries.js?v88e9533f:673 GET https://marketing.searchtreatment.com/s/contacts/view/11?_=1500214004902&mauticUserLastActive=1&mauticLastNotificationId= 500 (Internal Server Error) libraries.js?v88e9533f:673

Has anyone else run into this and/or have a solution?
2

Just updated to 2.9 from a relatively fresh installation.

When clicking on a contact in the Contacts screeen getting the following console error:

libraries.js?v88e9533f:673 GET https://marketing.searchtreatment.com/s/contacts/view/11?_=1500214004902&mauticUserLastActive=1&mauticLastNotificationId= 500 (Internal Server Error) libraries.js?v88e9533f:673

Has anyone else run into this and/or have a solution?

3

See server logs on why that 500 occurs

D.

4

Here is the error log:

[2017-07-17 08:34:01] mautic.CRITICAL: Uncaught PHP Exception DoctrineDBALExceptionTableNotFoundException: "An exception occurred while executing 'SELECT * FROM lead_event_log lel WHERE (lel.lead_id = ?) AND (lel.bundle = ?) AND (lel.object = ?) ORDER BY lel.date_added DESC LIMIT 25' with params [19, "lead", "import"]:  SQLSTATE[42S02]: Base table or view not found: 1146 Table 'searchtreatmentmarketing.lead_event_log' doesn't exist" at /home/dh_stk7bj/marketing.searchtreatment.com/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 53 {"exception":"[object] (Doctrine\DBAL\Exception\TableNotFoundException(code: 0): An exception occurred while executing 'SELECT * FROM lead_event_log lel WHERE (lel.lead_id = ?) AND (lel.bundle = ?) AND (lel.object = ?) ORDER BY lel.date_added DESC LIMIT 25' with params [19, "lead", "import"]:nnSQLSTATE[42S02]: Base table or view not found: 1146 Table 'searchtreatmentmarketing.lead_event_log' doesn't exist at /home/dh_stk7bj/marketing.searchtreatment.com/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:53, Doctrine\DBAL\Driver\PDOException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'searchtreatmentmarketing.lead_event_log' doesn't exist at /home/dh_stk7bj/marketing.searchtreatment.com/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:93, PDOException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'searchtreatmentmarketing.lead_event_log' doesn't exist at /home/dh_stk7bj/marketing.searchtreatment.com/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:91)"} []
5

I’m getting the problem of clicking on a contact but no response too.

I resolved mine by going through a database update schema from section 4 on John’s note at this site: https://johnlinhart.com/blog/uh-oh-mautic-upgrade-was-not-successful

I can now click on contacts and see their details.

6

@Avocation thank you!!!

It was a rather simple fix…from your link:
“The easiest is to look at [your-mautic-url]/s/update/schema to see in what state your database is and to see if it applies the schema update…”

I just went to https://[my-mautic-url]/s/update/schema and after a while, there was this message:
Database schema has been updated.
Then, I was able to open my contact.

So, it looks like something in the update process did not complete fully and going to the URL above fixed the issue.

7

+1 to nepatriot’s reply based on John Linhart’s blog post. Running the s/update/schema URL updated my installation. I can now see contact history again after the v2.9 update.