Hi,
We've integrated a MODx Evolution site with FoxyCart to handle recurring subscriptions. Everything is working fine, apart from one aspect; web user permissions.
The web_group of general 'Registered users' is 2, the web_group of paid subscribers is '4'. That 's fine, document permissions etc are all ok.
When a user subscribes and pays, we insert their user_id and webgroup 4 into the modx_web_groups table. However, sometimes, when that user logs in, this error is displayed:
MODx encountered the following error while attempting to parse the requested resource:
« Execution of a query to the database failed - 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 'AND webuser = 23' at line 1 »
SQL: SELECT id FROM modx_web_groups WHERE webgroup = AND webuser = 23
23 is the correct user for the one logging in, but for some reason the webgroup call is empty.
Does anyone know where this particular call is being made - we suspect it is 'core' somewhere or does anyone have any suggestions as to what we're doing right & wrong with directly editting the users' permissions.
Thanks!
