Bug #485

Admin Staff Edit fails if site is configured with a different DB Prefix

Added by Andre Kruger over 9 years ago. Updated about 9 years ago.

Status:Closed Start date:29 Sep 2015
Priority:Normal Due date:
Assignee:Gary Mcgrath % Done:

0%

Category:-
Target version:-

Description

Hi Gary

The code in the "/__apps/customtweaks/hooks/admin_staff_tabs.hook" calls the Database directly. I fixed it on my site to adapt to my sites DB Prefix and now the Admin Staff Edit Option works. My site uses the "swp" DB Prefix.

--- code extract ---
Line 7: $this->Database->Execute("update swstaffloginlog set logindateline=UNIX_TIMESTAMP(SUBTIME,'0 0:15:0')) where staffid=" . $_unlockID . " Order by logindateline desc limit 3");
--- end ---

I guess this line should be using the other classes available to call the prefix and table name. My fixed file attached.

Thanks
Andre

admin_staff_tabs.hook (631 Bytes) Andre Kruger, 09/29/2015 01:28 am

History

Updated by Gary Mcgrath about 9 years ago

  • Status changed from New to Resolved

3.1.2 will have the required update to resolve this issue.

Updated by Gary Mcgrath about 9 years ago

  • Status changed from Resolved to Closed

Also available in: Atom PDF