Forumlar / Cotonti / Support / Help with0.9.6 install

PDO error

CorpQuid
#32306 2011-12-28 04:04

Hey sorry for the delay in getting back to you, I got side tracked with going to a web site that gave me the win 7 2012 trojan... I got it all removed now. But just to let you guys know make sure your java is up to date. There is a vulnerability that injects itself in an advertisement banner through a java script.

Ok anyways back to the issue at hand, I set the following and strangly it removed the duplicate line from the page but I still get the the below error.

$cfg['cache'] = FALSE;   // Enable data caching
$cfg['cache_drv'] = '';   // Cache driver name to use on your server (if available)
        // Possible values: APC, eAccelerator, Memcache, Xcache
$cfg['xtpl_cache'] = TRUE;  // Enable XTemplate structure disk cache. Should be TRUE on production sites
$cfg['html_cleanup'] = FALSE; // Wipe extra spaces and breaks from HTML to get smaller footprint

 

Title of your site
2011-12-28 04:01

Fatal error: SQL error 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.

#0  cot_diefatal(SQL error 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.) called at [/home/mysite/public_html/system/database.php:449]
#1  CotDB->query(SELECT * FROM cot_core
		WHERE ct_state = 1 AND ct_lock = 0) called at [/home/mysite/public_html/system/common.php:212]
#2  require_once(/home/mysite/public_html/system/common.php) called at [/home/mysite/public_html/index.php:37]

 

Added 23 minutes later:

I just want to up date you as to what is displayed when setting the config value to both true and false

 This is with $cfg['cache'] = TRUE;

Title of your site
2011-12-28 04:25

Fatal error: SQL error 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.

#0  cot_diefatal(SQL error 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.) called at [/home/mysite/public_html/system/database.php:449]
#1  CotDB->query(SELECT * FROM cot_core
		WHERE ct_state = 1 AND ct_lock = 0) called at [/home/mysite/public_html/system/common.php:212]
#2  require_once(/home/mysite/public_html/system/common.php) called at [/home/mysite/public_html/index.php:37]

Title of your site
2011-12-28 04:25

Fatal error: SQL error 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.

#0  cot_diefatal(SQL error 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.) called at [/home/mysite/public_html/system/database.php:449]
#1  CotDB->query(INSERT INTO cot_cache (c_name, c_realm, c_expire, c_value) VALUES ('cot_cache_bindings', 'system', 0, 'a:0:{}'),('cot_plugins', 'system', 0, 'N;'),('cot_plugins_active', 'system', 0, 'a:0:{}') ON DUPLICATE KEY UPDATE c_value=VALUES(c_value), c_expire=VALUES(c_expire)) called at [/home/mysite/public_html/system/cache.php:651]
#2  MySQL_cache->flush() called at [/home/mysite/public_html/system/functions.php:909]
#3  cot_shutdown() called at [(null):0]




Here it is with $cfg['cache'] = FALSE; 



Title of your site
2011-12-28 04:29

Fatal error: SQL error 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.

#0  cot_diefatal(SQL error 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.) called at [/home/mysite/public_html/system/database.php:449]
#1  CotDB->query(SELECT * FROM cot_core
		WHERE ct_state = 1 AND ct_lock = 0) called at [/home/mysite/public_html/system/common.php:212]
#2  require_once(/home/mysite/public_html/system/common.php) called at [/home/mysite/public_html/index.php:37]
Bu gönderi CorpQuid tarafından düzenlendi (2011-12-28 04:28, 13 yıllar önce)