
I found a few topics which use the first part of my title, but not the last. This error is occurring when attempting to delete a user and his content. I use Cleantalk on Drupal V 7.89. The last time I update Cleantalk, it ceased to do what it is supposed to do and my site got infested with a lot of spam accounts. On all other users, I am able to delete them just fine. But I have one user that I am not able to delete and when I try, it results in the following error message posted below. Any help in pointing me to where to look is much appreciated.
An AJAX HTTP error occurred. HTTP Result Code: 500 Debugging information follows. Path: /?q=batch&render=overlay&id=4778&op=do_nojs&op=do StatusText: Internal Server Error ResponseText: Uncaught exception thrown in shutdown function.PDOException: SQLSTATE[HY000]: General error: 2014 Cannot execute queries while other unbuffered queries are active. Consider using PDOStatement::fetchAll(). Alternatively, if your code is only ever going to run against mysql, you may enable query buffering by setting the PDO::MYSQL_ATTR_USE_BUFFERED_QUERY attribute.: UPDATE {batch} SET batch=:db_update_placeholder_0 WHERE (bid = :db_condition_placeholder_0) ; Array ( [:db_update_placeholder_0] => a:14:{s:4:"sets";a:2:{i:0;a:13:{s:7:"sandbox";a:0:{}s:7:"results";a:0:{}s:7:"success";b:1;s:5:"start";d:1656896763.105786;s:7:"elapsed";i:0;s:5:"title";s:18:"Cancelling account";s:12:"init_message";s:24:"Initializing.<br/>&nbsp;";s:16:"progress_message";s:29:"Completed @current of @total.";s:13:"error_message";s:22:"An error has occurred.";s:3:"css";a:0:{}s:5:"total";i:0;s:5:"count";i:0;s:5:"queue";a:2:{s:4:"name";s:19:"drupal_batch:4778:0";s:5:"class";s:10:"BatchQueue";}}i:1;a:13:{s:7:"sandbox";a:0:{}s:7:"results";a:0:{}s:7:"success";b:0;s:5:"start";d:1656896763.106175;s:7:"elapsed";i:0;s:5:"title";s:23:"Cancelling user account";s:12:"init_message";s:24:"Initializing.<br/>&nbsp;";s:16:"progress_message";s:29:"Completed @current of @total.";s:13:"error_message";s:22:"An error has occurred.";s:3:"css";a:0:{}s:5:"total";i:1;s:5:"count";i:1;s:5:"queue";a:2:{s:4:"name";s:19:"drupal_batch:4778:1";s:5:"class";s:10:"BatchQueue";}}}s:16:"has_form_submits";b:0;s:10:"form_state";a:3:{s:10:"programmed";b:0;s:7:"rebuild";b:0;s:8:"redirect";s:12:"admin/people";}s:11:"progressive";b:1;s:11:"current_set";i:1;s:3:"url";s:5:"batch";s:11:"url_options";a:1:{s:5:"query";a:3:{s:6:"render";s:7:"overlay";s:2:"id";s:4:"4778";s:2:"op";s:7:"do_nojs";}}s:10:"source_url";s:12:"admin/people";s:8:"redirect";N;s:5:"theme";s:5:"seven";s:17:"redirect_callback";s:11:"drupal_goto";s:2:"id";s:4:"4778";s:13:"error_message";s:85:"Please continue to <a href="/?q=batch&amp;id=4778&amp;op=finished">the error page</a>";s:7:"running";b:1;} [:db_condition_placeholder_0] => 4778 ) in _batch_shutdown() (line 495 of /var/www/vhosts/afreecountry.com/httpdocs/includes/batch.inc).
Comments
How is this account different
How is this account different from others? You can try running cron and after try again.
It is not different
This was someone who signed up months back and replied to the activation email like anyone else did. I have not altered any settings for this user. The only thing that is different is the volume of posts he made over the course of a few months when I was not paying attention. For some reason, cleantalk was not sending queries to the cleantalk servers. The use of cleantalk on the site is why I do not concern myself so much with keeping an eye on the site. I spent some time deleting his individual posts, but there are apparently hundreds of them. I am thinking that it could be the volume of posts that need to be deleted that is causing the problem, but I do not know how to confirm that.
Your can install the Views
You can try the folloeing Drush command:
Also, you can install the Views Bulk Operations module and create a view to display the nodes authored by this user. After that you can delete them using Views Bulk Operations.