modx revolution
I have set up a login system and altered the core Login code so that it doesn’t send out the verification email, instead it sends an email to the admin to let them know there is a user that needs to be activated. The only problem is that if the user tries to login before they have been activated it deletes the user record from the database, once active the script works fine??
Update: The user record also gets delete if you run forgotten password using the username but not if you use email (although the password does not get changed)
This happens on a local setup on OSX using the latest version of MAMP and also on my web server running PHP Version 5.3.3 and MySQL 4.1.22
I have the following error in my error.log
[2010-08-30 23:56:29] (ERROR @ /Fox/index.php) Could not get table name for class: modAccess
[2010-08-30 23:56:29] (ERROR @ /Fox/index.php) Error 42000 executing statement:
Array
(
[0] => 42000
[1] => 1064
[2] => 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 'AS `modAccess` WHERE `modAccess`.`principal` = 5' at line 1
)