Author |
|
Freezer Newbie
![Newbie](forum_images/1_star_rating.gif)
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
![AfterLogic Support](forum_images/5_star_rating.gif)
Joined: 24 June 2008 Location: United States
Online Status: Offline Posts: 6082
|
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
![Newbie](forum_images/1_star_rating.gif)
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
![Newbie](forum_images/1_star_rating.gif)
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
![AfterLogic Support](forum_images/5_star_rating.gif)
Joined: 24 June 2008 Location: United States
Online Status: Offline Posts: 6082
|
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
![Newbie](forum_images/1_star_rating.gif)
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
![AfterLogic Support](forum_images/5_star_rating.gif)
Joined: 24 June 2008 Location: United States
Online Status: Offline Posts: 6082
|
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
![Newbie](forum_images/1_star_rating.gif)
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 |
|
|