| Author |
|
Freezer
Newbie
Joined: 26 October 2021
Location: Germany
Online Status: Offline
Posts: 18
|
| Posted: 16 December 2022 at 3:42am | IP Logged
|
|
|
Hello,
users cannot be deleted directly from the admin panel.
Error message: Clear user error (SQLSTATE[HY000]: General error: 1615 Prepared statement needs to be re-prepared (SQL: delete from `au_contacts_groups` where `IdUser` = xxxx))
Version: 9.4.1.build1-build-a3
Regards,
Freezer
|
| Back to Top |
|
| |
Igor
AfterLogic Support
Joined: 24 June 2008
Location: United States
Online Status: Offline
Posts: 6104
|
| Posted: 16 December 2022 at 3:44am | IP Logged
|
|
|
Can you upgrade to the latest 9.6.1 and see if the issue persists? Thanks.
--
Regards,
Igor, Afterlogic Support
|
| Back to Top |
|
| |
Freezer
Newbie
Joined: 26 October 2021
Location: Germany
Online Status: Offline
Posts: 18
|
| Posted: 21 December 2022 at 7:55am | IP Logged
|
|
|
I will update and test next week. Christmas stress! :)
|
| Back to Top |
|
| |
Freezer
Newbie
Joined: 26 October 2021
Location: Germany
Online Status: Offline
Posts: 18
|
| Posted: 27 December 2022 at 2:16am | IP Logged
|
|
|
Hello,
the problem also exists with version 9.6.1
Regards,
Freezer
|
| Back to Top |
|
| |
Igor
AfterLogic Support
Joined: 24 June 2008
Location: United States
Online Status: Offline
Posts: 6104
|
| Posted: 27 December 2022 at 2:23am | IP Logged
|
|
|
And you did press "Create/Update tables" button in Database Settings screen of admin interface, correct?
--
Regards,
Igor, Afterlogic Support
|
| Back to Top |
|
| |
Freezer
Newbie
Joined: 26 October 2021
Location: Germany
Online Status: Offline
Posts: 18
|
| Posted: 27 December 2022 at 2:54am | IP Logged
|
|
|
I'm not sure if i understand you correctly. For the test i installed a new version (no update). As soon as i want to delete a user in the user menu, the error message appears. Updating the database has no effect.
Regards,
Freezer
|
| Back to Top |
|
| |
Igor
AfterLogic Support
Joined: 24 June 2008
Location: United States
Online Status: Offline
Posts: 6104
|
| Posted: 27 December 2022 at 3:21am | IP Logged
|
|
|
Interesting, never seen such an error before. There's a change the following change will help - in system/Api.php file, locate the following code:
Code:
if ($oPdo)
{
$oPdo->setAttribute(\PDO::ATTR_ERRMODE, \PDO::ERRMODE_EXCEPTION);
$oPdo->setAttribute(\PDO::MYSQL_ATTR_INIT_COMMAND, "SET NAMES utf8");
} |
|
|
and add another attribute there as follows:
Code:
if ($oPdo)
{
$oPdo->setAttribute(\PDO::ATTR_ERRMODE, \PDO::ERRMODE_EXCEPTION);
$oPdo->setAttribute(\PDO::MYSQL_ATTR_INIT_COMMAND, "SET NAMES utf8");
$oPdo->setAttribute(\PDO::ATTR_EMULATE_PREPARES, true);
} |
|
|
Alternately, this discussion thread at StackOverflow advises the following setting:
Code:
| SET GLOBAL table_definition_cache = 1024 |
|
|
Hope it helps.
--
Regards,
Igor, Afterlogic Support
|
| Back to Top |
|
| |
Freezer
Newbie
Joined: 26 October 2021
Location: Germany
Online Status: Offline
Posts: 18
|
| Posted: 27 December 2022 at 4:14am | IP Logged
|
|
|
I modified the Api.php and now deleting a user works fine.
Many thanks for your support,
Freezer
|
| Back to Top |
|
| |
MailBee.NET Objects 
MailBee.NET Queue 
MailBee Objects 
WebMail Pro PHP 
AfterLogic Aurora 
MailSuite Pro for Linux 
Unified Messaging Solution 
Search
Register
Login
Topic: Adminpanel - users cannot be deleted
Privacy policy |
Refund policy