Bug #485
Admin Staff Edit fails if site is configured with a different DB Prefix
Status: | Closed | Start date: | 29 Sep 2015 | |
---|---|---|---|---|
Priority: | Normal | Due date: | ||
Assignee: | % 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
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