Hello,
I am having a problem trying to delete a user from my application, using the cakephp framework.
This is the error message I receive when trying to delete a user:
Warning (512): SQL Error: 1064: You have an error in your SQL syntax near 'ON (Permission`.`aro_id` = 103 AND `Permission`.`aco_id` = `Aco`.`id) ' at line 1 [CORE/cake/libs/model/datasources/dbo_source.php, line 527]
Here is the full SQL Query:
SELECT Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias`, `Aco`.`lft`, `Aco`.`rght`, `Permission`.`id`, `Permission`.`aro_id`, `Permission`.`aco_id`, `Permission`.`_create`, `Permission`.`_read`, `Permission`.`_update`, `Permission`.`_delete` FROM `acos` AS `Aco` JOIN `aros_acos` AS `Permission` ON (`Permission`.`aro_id` = 103 AND `Permission`.`aco_id` = `Aco`.`id)
The application still deletes the user, but I can't have it stay like this. I've searched for solutions, but come up with nothing. I've looked through the cakephp core files for some clue, still no good luck. I've wondered if I am missing something within my database, but I am unsure.
Any help would be very appreciated.