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 almost 10 years ago
- Status changed from New to Resolved
3.1.2 will have the required update to resolve this issue.
Updated by Gary Mcgrath almost 10 years ago
- Status changed from Resolved to Closed