Search The ForumSearch   RegisterRegister  LoginLogin

AfterLogic Aurora

 AfterLogic Forum : AfterLogic Aurora
Subject Topic: Adminpanel - users cannot be deleted Post ReplyPost New Topic
Author
Message << Prev Topic | Next Topic >>
Freezer
Newbie
Newbie


Joined: 26 October 2021
Location: Germany
Online Status: Offline
Posts: 18
Posted: 16 December 2022 at 3:42am | IP Logged Quote Freezer

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 View Freezer's Profile Search for other posts by Freezer
 
Igor
AfterLogic Support
AfterLogic Support


Joined: 24 June 2008
Location: United States
Online Status: Offline
Posts: 6094
Posted: 16 December 2022 at 3:44am | IP Logged Quote Igor

Can you upgrade to the latest 9.6.1 and see if the issue persists? Thanks.

--
Regards,
Igor, Afterlogic Support
Back to Top View Igor's Profile Search for other posts by Igor
 
Freezer
Newbie
Newbie


Joined: 26 October 2021
Location: Germany
Online Status: Offline
Posts: 18
Posted: 21 December 2022 at 7:55am | IP Logged Quote Freezer

I will update and test next week. Christmas stress! :)
Back to Top View Freezer's Profile Search for other posts by Freezer
 
Freezer
Newbie
Newbie


Joined: 26 October 2021
Location: Germany
Online Status: Offline
Posts: 18
Posted: 27 December 2022 at 2:16am | IP Logged Quote Freezer

Hello,

the problem also exists with version 9.6.1

Regards,
Freezer
Back to Top View Freezer's Profile Search for other posts by Freezer
 
Igor
AfterLogic Support
AfterLogic Support


Joined: 24 June 2008
Location: United States
Online Status: Offline
Posts: 6094
Posted: 27 December 2022 at 2:23am | IP Logged Quote Igor

And you did press "Create/Update tables" button in Database Settings screen of admin interface, correct?

--
Regards,
Igor, Afterlogic Support
Back to Top View Igor's Profile Search for other posts by Igor
 
Freezer
Newbie
Newbie


Joined: 26 October 2021
Location: Germany
Online Status: Offline
Posts: 18
Posted: 27 December 2022 at 2:54am | IP Logged Quote Freezer

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 View Freezer's Profile Search for other posts by Freezer
 
Igor
AfterLogic Support
AfterLogic Support


Joined: 24 June 2008
Location: United States
Online Status: Offline
Posts: 6094
Posted: 27 December 2022 at 3:21am | IP Logged Quote Igor

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 View Igor's Profile Search for other posts by Igor
 
Freezer
Newbie
Newbie


Joined: 26 October 2021
Location: Germany
Online Status: Offline
Posts: 18
Posted: 27 December 2022 at 4:14am | IP Logged Quote Freezer

I modified the Api.php and now deleting a user works fine.

Many thanks for your support,
Freezer
Back to Top View Freezer's Profile Search for other posts by Freezer
 

If you wish to post a reply to this topic you must first login
If you are not already registered you must first register

  Post ReplyPost New Topic
Printable version Printable version

Forum Jump

Powered by Web Wiz Forums version 7.9
Copyright ©2001-2004 Web Wiz Guide