sql syntax error on subscribing users
| Project: | OG promote |
| Version: | 5.x-1.0 |
| Component: | Code |
| Category: | support request |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | closed |
Jump to:
I use OG promote to give users of a certain group access to create more content types. When I add a person to the group I get the following:
user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '1 WHERE cid = 'menu:3424'' at line 1 query: DELETE FROM 1 WHERE cid = 'menu:3424' in htdocs/includes/database.mysql.inc on line 172.
Reading about the Caching issue in an earlier version I verified that the user menu is cleared through Clear_all_cache. The symptoms are the following:
The user does acquire the new role, yet when clicking on one of the new content types under Create Content, he would get access denied. This is the case when caching is turned off or on.
Any help would be greatly appreciated.

#1
wow my bad. I thought the patch had taken effect, but when I reviewed the clear cache code in the module it was untouched, even after running the path. I replaced the two lines referenced in the patch manually and look there it worked. :)