Menu
SuiteCRM dedicated support by SalesAgility
Welcome, Guest
Username: Password: Remember me

TOPIC: (after upgrade) Custom Module "SuperTimesheet" no longer working

(after upgrade) Custom Module "SuperTimesheet" no longer working 1 month 4 weeks ago #72880

  • John - EZS
  • John - EZS's Avatar
  • Offline
  • SuiteCRM Is My Life
  • Posts: 328
  • Thank you received: 31
  • Karma: 6
When saving data from the daily or weeky matrix view (for those who know the module), the site freezes for a while and suitecrm.log shows lots of errors like these:

Sat Oct 13 20:01:27 2018 [30196][7098c295-4ea7-26fe-af1d-4dda14b75350][ERROR] Unable to find relationship accounts_fp_events_1
Sat Oct 13 20:01:27 2018 [30196][7098c295-4ea7-26fe-af1d-4dda14b75350][WARN] accounts_fp_events_1accounts_ida for accounts_fp_events_1 failed to load
Sat Oct 13 20:01:27 2018 [30196][7098c295-4ea7-26fe-af1d-4dda14b75350][ERROR] Unable to find relationship timesheet_created_by
Sat Oct 13 20:01:27 2018 [30196][7098c295-4ea7-26fe-af1d-4dda14b75350][ERROR] Unable to find relationship timesheet_modified_user
Sat Oct 13 20:01:27 2018 [30196][7098c295-4ea7-26fe-af1d-4dda14b75350][ERROR] Unable to find relationship timesheet_assigned_user
Sat Oct 13 20:01:27 2018 [30196][7098c295-4ea7-26fe-af1d-4dda14b75350][ERROR] Unable to find relationship timesheet_projects
Sat Oct 13 20:01:27 2018 [30196][7098c295-4ea7-26fe-af1d-4dda14b75350][ERROR] Unable to find relationship timesheet_accounts
Sat Oct 13 20:01:27 2018 [30196][7098c295-4ea7-26fe-af1d-4dda14b75350][ERROR] Unable to find relationship projecttask_timesheet
Sat Oct 13 20:01:27 2018 [30196][7098c295-4ea7-26fe-af1d-4dda14b75350][ERROR] Unable to find relationship timesheet_created_by
Sat Oct 13 20:01:27 2018 [30196][7098c295-4ea7-26fe-af1d-4dda14b75350][WARN] created_by_link for timesheet_created_by failed to load
Sat Oct 13 20:01:27 2018 [30196][7098c295-4ea7-26fe-af1d-4dda14b75350][FATAL] error loading relationship created_by_link
Sat Oct 13 20:01:27 2018 [30196][7098c295-4ea7-26fe-af1d-4dda14b75350][ERROR] Unable to find relationship timesheet_modified_user
Sat Oct 13 20:01:27 2018 [30196][7098c295-4ea7-26fe-af1d-4dda14b75350][WARN] modified_user_link for timesheet_modified_user failed to load
Sat Oct 13 20:01:27 2018 [30196][7098c295-4ea7-26fe-af1d-4dda14b75350][FATAL] error loading relationship modified_user_link
Sat Oct 13 20:01:27 2018 [30196][7098c295-4ea7-26fe-af1d-4dda14b75350][ERROR] Unable to find relationship timesheet_assigned_user
Sat Oct 13 20:01:27 2018 [30196][7098c295-4ea7-26fe-af1d-4dda14b75350][WARN] assigned_user_link for timesheet_assigned_user failed to load
Sat Oct 13 20:01:27 2018 [30196][7098c295-4ea7-26fe-af1d-4dda14b75350][FATAL] error loading relationship assigned_user_link
Sat Oct 13 20:01:27 2018 [30196][7098c295-4ea7-26fe-af1d-4dda14b75350][ERROR] Unable to find relationship timesheet_projects
Sat Oct 13 20:01:27 2018 [30196][7098c295-4ea7-26fe-af1d-4dda14b75350][WARN] projects for timesheet_projects failed to load
Sat Oct 13 20:01:27 2018 [30196][7098c295-4ea7-26fe-af1d-4dda14b75350][FATAL] error loading relationship projects
Sat Oct 13 20:01:27 2018 [30196][7098c295-4ea7-26fe-af1d-4dda14b75350][ERROR] Unable to find relationship timesheet_accounts
Sat Oct 13 20:01:27 2018 [30196][7098c295-4ea7-26fe-af1d-4dda14b75350][WARN] accounts for timesheet_accounts failed to load
Sat Oct 13 20:01:27 2018 [30196][7098c295-4ea7-26fe-af1d-4dda14b75350][FATAL] error loading relationship accounts
Sat Oct 13 20:01:27 2018 [30196][7098c295-4ea7-26fe-af1d-4dda14b75350][ERROR] Unable to find relationship projecttask_timesheet
Sat Oct 13 20:01:27 2018 [30196][7098c295-4ea7-26fe-af1d-4dda14b75350][WARN] projecttask for projecttask_timesheet failed to load
Sat Oct 13 20:01:27 2018 [30196][7098c295-4ea7-26fe-af1d-4dda14b75350][FATAL] error loading relationship projecttask

Looks bad to me. Does this look like something that was screwed up by the update procedure? Or is it possible that such a module could no longer be compatible?
The administrator has disabled public write access.

(after upgrade) Custom Module "SuperTimesheet" no longer working 1 month 4 weeks ago #72882

  • John - EZS
  • John - EZS's Avatar
  • Offline
  • SuiteCRM Is My Life
  • Posts: 328
  • Thank you received: 31
  • Karma: 6
After uninstalling (keeping the data tables) and reinstalling the module I lost the error message in suitecrm.log. That's a good start.

I now see this behavior:
I can save a new entry in matrix view once. The page pops right back up after saving. wonderful.

I cannot however save a new entry after that. The second time I try, the page freezes for many minutes.

The more I try to reload the page, the more my mysql processlist fills up with more PIDs in the "Sleep" mode.

Once the page becomes responsive again (a few minutes later). the data I'd entered was actually saved.
So the only issue is the unresponsiveness and mysql opening up these "sleep" processes without anything more happening.

Ideas?
The administrator has disabled public write access.
Time to create page: 0.109 seconds
Powered by Kunena Forum