Error MessageSQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'WHERE id = '5'' at line 1 FileC:\xampp\htdocs\test\app\models\PDODb.php On Line 1864 Stack Trace1 C:\xampp\htdocs\test\app\models\PDODb.php(1864): PDOStatement->execute() 2 C:\xampp\htdocs\test\app\controllers\UsersController.php(185): PDODb->update('users', Array) 3 C:\xampp\htdocs\test\system\Router.php(205): UsersController->edit('5') 4 C:\xampp\htdocs\test\system\Router.php(94): Router->run('users/edit/5/') 5 C:\xampp\htdocs\test\index.php(100): Router->init()
I received the above error while trying to edit a user after implementing authentication / roles and permissions and user record management. I'm logged in as admin and have rights to edit users.
Even after removing authentication and I try to edit a user I still get the error.
Any suggestions. Is it a bug?
This brand is dying itself by not responding to people questions. If the question is user's mistake, support will reply instantly within a day. If the question is related to product's bug (a few as i know well..), they never ever get back even for months-years.
This brand is dying itself by not responding to people questions. If the question is user's mistake, support will reply instantly within a day. If the question is related to product's bug (a few as i know well..), they never ever get back even for months-years.
I have the same issue cant change to another database. also connection settings from development station may differ from production.
Same here. The database string cant be changed anymore for the deve-stage PPM file. If we plan to migrate to another server, the project need to redo from scratch. Team. Kindly work on it. This is not professional man.
If a real professional developer work on this PHPRAD system, sure will feel it like a Honey-Dipped-MangoSeed. Can eat the top layer only & the inner part is not edible. :-)))))
Because the developed project file is like... " Its Like That One"... :-)
Hi, 1. PHPRAD project > enable >Authentication 2. Assign DB tables 3. Allow users to register 4. Set Audit Trail Log > FILE 5. Registration page > Password field > set as PASSWORD & MD5 hashing 6. Do a test user registration. 7. The audit trail log file will show the password in plain text. 8. Actually the PHPRAD is work very well. Im ok to exclude this USERS ADD page from audit log settings. Just the password field is in plain text (only on AUDIT TRAIL FILE) and need attention on that part for security measure..
And finally, Im just a favourable user of this PHPRAD. I wondered about this issue, and seeking your valuable advise. Kindly reply to the forum members as -- what is the scenario, how to reproduce the issue etc.,..-- instead of using some laymen term replies like "Please verify before you post something like this."
Hi Emman, Any updates? sometimes, Silence is considered as acceptance.
Hopes some other public forum members could verify this issue themselves too. Because if this is actual case, the PHPRAD deve team have to work on this matter too.
Track issues, Ask questions, Make suggestions,Report a bug
