CP-67: Database PDO::MYSQL_ATTR_USE_BUFFERED_QUERY

  • [feedquote='Youtrack','http://trac.i-mscp.net/issue/CP-67']

    Reporter guest (guest) guest (guest)
    Created Jun 6, 2011 9:46:32 PM
    Updated Jan 22, 2015 5:33:49 PM
    Resolved Jan 22, 2015 11:47:01 AM
    Priority Blocker
    Type Bug
    State Fixed
    Assignee Laurent Declercq (nuxwin)
    Subsystem FrontEnd
    Fix versions Unscheduled
    Affected versions Unknown
    Fixed in build Next Build
    Severity Easy

    { Dear admin, An exception with the following message was raised in file /var/www/imscp/gui/include/shared-functions.php (Line: 2024): ================================================================= 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. - Query: SELECT COUNT(`mail_id`) AS `cnt` FROM `mail_users` WHERE `mail_type` RLIKE 'alias_' AND `mail_type` NOT LIKE 'alias_catchall' AND `domain_id` = ? ; AND `mail_acc` != 'abuse' AND `mail_acc` != 'postmaster' AND `mail_acc` != 'webmaster' ; ================================================================= Debug backtrace: --------------- File: /var/www/imscp/gui/include/client-functions.php (Line: 259) Function: exec_query() File: /var/www/imscp/gui/include/client-functions.php (Line: 504) Function: get_domain_running_mail_acc_cnt() File: /var/www/imscp/gui/client/index.php (Line: 397) Function: get_domain_running_props_cnt() Additional information: ---------------------- Http User Agent: Opera/9.80 (Windows NT 6.1; U; en) Presto/2.8.131 Version/11.11 Request Uri: /client/ Http Referer: Remote Addr: Server Addr: ____________________________________________________________ i-MSCP Exception Mail Writer Note: If the same exception is raised several times, this mail will not be re-send before 6 hours. } [/feedquote]