Error When I Click the Activities Tab

pmaxx

Greetings;

First, Epesi is awesome! Thanks for your great work!

When a company is selected and the "Activities" tab is clicked, I get this error:
Type: E_WARNING (2)
Message: Illegal string offset 'created_by'
File: /home/mtena/public_html/epesi/modules/Utils/RecordBrowser/RecordBrowserCommon_0.php
Line=1682
error backtrace:
File: /home/mtena/public_html/epesi/modules/Utils/RecordBrowser/RecordBrowserCommon_0.php
line 1682
function called: handle_epesi_error(2, "Illegal string offset 'created_by'", "/home/mtena/public_html/epesi/modules/Utils/RecordBrowser/RecordBrowserCommon_0.php", 1682, Array ("crm_meeting", "45_2012-06-19", "45_2012-06-19"))

File: /home/mtena/public_html/epesi/modules/CRM/Contacts/Activities/Activities_0.php
line 176
function called: get_html_record_info("crm_meeting", "45_2012-06-19")

File: /home/mtena/public_html/epesi/modules/CRM/Contacts/Activities/Activities_0.php
line 63
function called: display_activities(Array (Array (#14), Array (#14), Array (#14), Array (#15), Array (#14), Array (#14), Array (#14), Array (#14)), Array (Array (#14), Array (#14), Array (#14)), Array (Array (#21)))

[PHP core called function]
function called: company_activities(Array (#26), Object (Utils_RecordBrowser))

File: /home/mtena/public_html/epesi/include/module.php
line 793
function called: call_user_func_array(Array (Object (CRM_Contacts_Activities), "company_activities"), Array (Array (#26), Object (Utils_RecordBrowser)))

File: /home/mtena/public_html/epesi/include/module.php
line 713
function called: get_html_of_module(Object (CRM_Contacts_Activities), Array (Array (#26), Object (Utils_RecordBrowser)), "company_activities")

[PHP core called function]
function called: display_module("Object (CRM_Contacts_Activities)", Array (Array (#26), Object (Utils_RecordBrowser)), "company_activities")

File: /home/mtena/public_html/epesi/modules/Utils/TabbedBrowser/TabbedBrowser_0.php
line 115
function called: call_user_func_array(Array (Object (Utils_RecordBrowser), "display_module"), Array ("\"Object (CRM_Contacts_Activities)\"", Array (#2), "company_activities"))

File: /home/mtena/public_html/epesi/modules/Utils/TabbedBrowser/TabbedBrowser_0.php
line 81
function called: display_contents(Array (1, Array (#2), Array (#3), false), 1)

[PHP core called function]
function called: body()

File: /home/mtena/public_html/epesi/include/module.php
line 793
function called: call_user_func_array(Array (Object (Utils_TabbedBrowser), "body"), Array ())

File: /home/mtena/public_html/epesi/include/module.php
line 713
function called: get_html_of_module(Object (Utils_TabbedBrowser), null, null)

File: /home/mtena/public_html/epesi/modules/Utils/RecordBrowser/RecordBrowser_0.php
line 1401
function called: display_module("Object (Utils_TabbedBrowser)")

File: /home/mtena/public_html/epesi/modules/Utils/RecordBrowser/RecordBrowser_0.php
line 1072
function called: view_entry("view", "2", Array (), true)

[PHP core called function]
function called: view_entry_with_REQUEST("view", "2", Array (), true, Array ())

File: /home/mtena/public_html/epesi/include/module.php
line 793
function called: call_user_func_array(Array (Object (Utils_RecordBrowser), "view_entry_with_REQUEST"), Array ("view", "2", Array (#0), true, Array (#0)))

File: /home/mtena/public_html/epesi/include/module.php
line 713
function called: get_html_of_module(Object (Utils_RecordBrowser), Array ("view", "2", Array (#0), true, Array (#0)), "view_entry_with_REQUEST")

File: /home/mtena/public_html/epesi/modules/Base/Box/Box_0.php
line 142
function called: display_module("Object (Utils_RecordBrowser)", Array ("view", "2", Array (#0), true, Array (#0)), "view_entry_with_REQUEST")

File: /home/mtena/public_html/epesi/include/epesi.php
line 213
function called: body()

File: /home/mtena/public_html/epesi/include/epesi.php
line 258
function called: go(Object (Base_Box))

File: /home/mtena/public_html/epesi/process.php
line 32
function called: process("__action_module__=%2FBase_Box%7C0%2FUtils_RecordBrowser%7Cmain_9a1fb3b441e9687c28e95e3b55376d9d%2FUtils_TabbedBrowser%7Crecordbrowser_addons&%2FBase_Box%7C0%2FUtils_RecordBrowser%7Cmain_9a1fb3b441e9687c28e95e3b55376d9d%2FUtils_TabbedBrowser%7Crecordbrowser_addons_page=1", "")

This is only happening with 1 company record, I tested with other company records and it does not throw an error.

Thanks in advance!
Paul

jasiek

Paul,

Here is the problem:
[quote:3ezt2wng]function called: handle_epesi_error(2, "Illegal string offset 'created_by'", "/home/mtena/public_html/epesi/modules/Utils/RecordBrowser/RecordBrowserCommon_0.php", 1682, Array ("crm_meeting", "45_2012-06-19", "45_2012-06-19"))'[/quote:3ezt2wng]

Did you rename or delete any users in users table directly? Can you verify user ID for created_by and cross-reference it against users table?

Use a database/table editor and check table crm_meeting and make sure that all users IDs are valid. This should fix the problem.

Remember - EPESI uses lazy delete. No record should be permanently deleted from the database and direct manipulation on database records can cause such problems.

pmaxx

Thank you so much for your response. I have not deleted any records from the database. I am happy to follow your wise instructions.

I did look at event records in MySQLadmin, but I didn't change anything. Just looking at "created_by" field. I checked event ID #45, and there were no problems with the "created by" field. I clicked the CRM/Events in Epesi, and found the record (ID 45 dated 2012-06-19). It displayed OK, but I still got the error when I clicked the "events" tab from the Company window. So I deleted the event (from inside Epesi). After that, there was no error when clicking the "events" tab from the Company window.

So I re-entered the event info. The error returned. I started changing values in the record to see what was throwing the error. This was a recurring event. When I changed it to recurring = "no" the error went away.

I tested this on another event. Using a different company as the customer, I tried to add a new event with recurring = "every week", and "every year". Both times, I got the error and the record would not save.

Regards,
Paul

ajb

Hi Paul,

I'm glad that you've told us that this issue is related to a recurring event. I was trying to find a reason for this error right after your first forum post, but I couldn't. Now, thanks to your effort, I hope to fix this with attached patch. Please install apply this patch and check that the issue has been fixed.

Regards,
Adam

pmaxx

I installed the patch, and all is well. I tested both with and without a recurrence end date. It worked both times. The record saved, and the there was no error when clicking the "activities" tab in the company window. You guys are awesome, and fast, too!

Thanks for this wonderful software!

Paul

ajb

Thanks for a such kind words 😉

pmaxx

Sorry for the multiple posts;

Will I need to do the patch after upgrading to the latest 1.5.4 rev 11060?

Regards

dmitryf

I checked recurrent events on latest release 11060, it works fine at least on my instance without patch.

ajb

I have checked on the latest release and they didn't 🙂
Dmitryf - add recurrent meeting, assign company, then go to the company record and open Activities tab - and turn on error reporting. E_WARNING is not shown on default settings.

Yes Paul you'll have to apply patch again - sorry we'll wait for couple of days, maybe week or two and I think it will be a time to release again, because we've got at least 2 fixed issues right now(this one and that one) and it would be great to fix time issue on mobile view.

Regards,
Adam

pmaxx

Thanks for the update, Adam!

Regards

Epesi ENS | Epesi Academy | epesi.cloud PaaS | GitHub

Help Me! | Download from SourceForge