Magento

Same error with zend core 2.5 :(
Replacing the php_pdo file isent solving either it gives an new error that pdo_mysql wasent installed :S:S:S

Anyone solution?

exception ‘Zend_Db_Adapter_Exception’ with message ‘The mysql driver is not currently installed’ in C:\Apache2\htdocs\host\~neverland\lib\Zend\Db\Adapter\Pdo\Abstract.php:104
Stack trace:
#0 C:\Apache2\htdocs\host\~neverland\lib\Varien\Db\Adapter\Pdo\Mysql.php(76): Zend_Db_Adapter_Pdo_Abstract->_connect()
#1 C:\Apache2\htdocs\host\~neverland\lib\Zend\Db\Adapter\Abstract.php(367): Varien_Db_Adapter_Pdo_Mysql->_connect()
#2 C:\Apache2\htdocs\host\~neverland\lib\Zend\Db\Adapter\Pdo\Abstract.php(206): Zend_Db_Adapter_Abstract->query(’SET NAMES utf8’, Array)
#3 C:\Apache2\htdocs\host\~neverland\app\code\core\Mage\Core\Model\Resource\Type\Db\Pdo\Mysql.php(32): Zend_Db_Adapter_Pdo_Abstract->query(’SET NAMES utf8’)
#4 C:\Apache2\htdocs\host\~neverland\app\code\core\Mage\Core\Model\Resource.php(71): Mage_Core_Model_Resource_Type_Db_Pdo_Mysql->getConnection(Object(Mage_Core_Model_Config_Element))
#5 C:\Apache2\htdocs\host\~neverland\app\code\core\Mage\Core\Model\Mysql4\Abstract.php(240): Mage_Core_Model_Resource->getConnection(’core_read’)
#6 C:\Apache2\htdocs\host\~neverland\app\code\core\Mage\Core\Model\Mysql4\Config.php(47): Mage_Core_Model_Mysql4_Abstract->getConnection(’read’)
#7 C:\Apache2\htdocs\host\~neverland\app\code\core\Mage\Core\Model\Config.php(122): Mage_Core_Model_Mysql4_Config->getChecksum(’config_data,web...’)
#8 C:\Apache2\htdocs\host\~neverland\app\Mage.php(326): Mage_Core_Model_Config->init(NULL)
#9 C:\Apache2\htdocs\host\~neverland\app\Mage.php(349): Mage::init(NULL)
#10 C:\Apache2\htdocs\host\~neverland\index.php(27): Mage::run(’base’)
#11 {main}

Moshe - 31 August 2007 02:36 PM

It seems that PDO behaviour changes drastically when working with different versions of mysql client library.
...if you wish to enable buffered query in PDO, uncomment the line # 71 in lib/Varien/Db/Adapter/Pdo/Mysql.php
As you can see we have played with it too…

I’m getting this error when installing 0.7.148 on XP.  This is installed in parallel with a running 0.6.141 using WAMP (Ap 2.2.6/MySQL 5.0.45/PHP 5.2.5 on XP Pro).  I uncommented line 95 in Mysql.php (my guess at the correct line number in this version) -

but this had no effect.

I’ll check to see if there’s a newer PHP or MySQL version, but any other ideas would help.

GregC

I’ve tried staring over and still can’t get past this error. I have the latest versions of mySQL and PHP, so there’s no hope there.  Anything else I should try?

GregC

johannes80 - 11 September 2007 04:20 AM

Have you tried what “A.Piotrowski (Lento.pl)” said on page 1?

I did, but it’s not working for me.

I dont know but is unable to install locally latest magento version with WAMP
pdo all enable, apache rewrite but not luck

@Dyrer: what is the error message

I downloaded the “php_pdo_mysql.dll” from the unknown source mentioned above, and it works.
However, the size of dll is different from the one provided by php.net.
It’s obvious this patch is not a official one.

I would like to find a solution before I used my live server.

I would like to find a solution before I used my live server.

Are you planning to use Windows box as a live server?

I still get the same problem…

Look at message below.

Thanks.

PDOException Object
(
[message:protected] => 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.
[string:private] =>
[code:protected] => HY000
[file:protected] => C:\xampp\htdocs\magento\lib\Varien\Db\Adapter\Pdo\Mysql.php
[line:protected] => 109
[trace:private] => Array
(
[0] => Array
(
[file] => C:\xampp\htdocs\magento\lib\Varien\Db\Adapter\Pdo\Mysql.php
[line] => 109
[function] => query
[class] => PDO
[type] => ->
[args] => Array
(
[0] =>

DROP TABLE IF EXISTS `core_config_data`;
CREATE TABLE `core_config_data` (
`config_id` int(10) unsigned NOT NULL auto_increment,
`scope` enum(’default’,’websites’,’stores’,’config’) NOT NULL default ‘default’,
`scope_id` int(11) NOT NULL default ‘0’,
`path` varchar(255) NOT NULL default ‘general’,
`value` text NOT NULL,
PRIMARY KEY (`config_id`),
UNIQUE KEY `config_scope` (`scope`,`scope_id`,`path`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `core_email_template`;
CREATE TABLE `core_email_template` (
`template_id` int(7) unsigned NOT NULL auto_increment,
`template_code` varchar(150) default NULL,
`template_text` text,
`template_type` int(3) unsigned default NULL,
`template_subject` varchar(200) default NULL,
`template_sender_name` varchar(200) default NULL,
`template_sender_email` varchar(200) character set latin1 collate latin1_general_ci default NULL,
`added_at` datetime default NULL,
`modified_at` datetime default NULL,
PRIMARY KEY (`template_id`),
UNIQUE KEY `template_code` (`template_code`),
KEY `added_at` (`added_at`),
KEY `modified_at` (`modified_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT=’Email templates’;

insert into `core_email_template`(`template_id`,`template_code`,`template_text`,`template_type`,`template_subject`,`template_sender_name`,`template_sender_email`,`added_at`,`modified_at`) values
(1,’New account (HTML)’,’

I used the php_pdo_mysql.dll file from php.net and it worked with my WAMP Server. This is where I got it from and its in the ext directory like others have said and recommended. I extracted it to C:\wamp\php\ext

Thanks!

http://us.php.net/downloads.php

Windows Binaries

* PHP 5.2.5 zip package [9,713Kb] - 08 November 2007