Magento

Replaced php_pdo_mysql.dll as suggested by FrenchToast and now it works. Thank you.

FrenchToast: replacing the dll led to another error -> Call to undefined function…

netcart - 31 August 2007 12:57 PM

Try to add

$this->_connection->setAttribute(PDO::MYSQL_ATTR_USE_BUFFERED_QUERY,true);

in

lib/Zend/Db/Adapter/Pdo/Abstract.php

after line 124

when I open the file in dreamweaver there is no line numbers available.

Give us something better to go on to know where to place your code.

Emperor - 31 August 2007 01:22 PM

netcart - 31 August 2007 12:57 PM

Try to add

$this->_connection->setAttribute(PDO::MYSQL_ATTR_USE_BUFFERED_QUERY,true);

in

lib/Zend/Db/Adapter/Pdo/Abstract.php

after line 124

when I open the file in dreamweaver there is no line numbers available.

Give us something better to go on to know where to place your code.

heres a thought. how about turning on line numbers in dreamweaver…

iblastoff - 31 August 2007 01:26 PM

Emperor - 31 August 2007 01:22 PM

netcart - 31 August 2007 12:57 PM

Try to add

$this->_connection->setAttribute(PDO::MYSQL_ATTR_USE_BUFFERED_QUERY,true);

in

lib/Zend/Db/Adapter/Pdo/Abstract.php

after line 124

when I open the file in dreamweaver there is no line numbers available.

Give us something better to go on to know where to place your code.

heres a thought. how about turning on line numbers in dreamweaver...

sorry about that. I ‘m good now.

It seems that PDO behaviour changes drastically when working with different versions of mysql client library.

We have tried to use only PDO::MYSQL or only mysqli , but that didn’t work well with all kinds of setups.

The most prominent issue we had was multi-statement queries.

On some setups it works smooth with mysqli and on some with PDO.

Also, it looks like mysqli is not ready for named parameters in prepared queries, so the write connection was setup by default to use PDO component.

Also, 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…

Emperor - 31 August 2007 01:22 PM

when I open the file in dreamweaver there is no line numbers available.

Give us something better to go on to know where to place your code.

To turn on line numbers click “View -> Code View Options” and turn on line numbers.

Second, dreamweaver may not be the best tool to edit php. You can try the free “Programmer’s Notepad” which I am currently in favor of.

FrenchToast - 31 August 2007 01:05 PM

I see many people are having this problem (as I did myself). To fix it I replaced my php_pdo_mysql.dll with this one: php_pdo_mysql.dll

This solved my problem..

this link does not work!

The link still works. It solved the PDO problem.
Merci French TOAST ;d

Moshe - 31 August 2007 02:36 PM

It seems that PDO behaviour changes drastically when working with different versions of mysql client library.

We have tried to use only PDO::MYSQL or only mysqli , but that didn’t work well with all kinds of setups.

The most prominent issue we had was multi-statement queries.

On some setups it works smooth with mysqli and on some with PDO.

Also, it looks like mysqli is not ready for named parameters in prepared queries, so the write connection was setup by default to use PDO component.

Also, 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…

Did everything said here, still no luck. When I replace the dll with the one given here, I get another error as:

Fatal error: Call to a member function children() on a non-object in C:\xampp\htdocs\magento\app\code\core\Mage\Core\Model\Config.php on line 655

Also uncommenting the line 71 in the above lib file had no effect at all.

Any ideas?

SORRY, but this link does NOT works form here (Germany):

http : //source.hackthissite.org/wsvn/.../PDO/php_pdo_mysql.dll (without blanks after http)

Oops, we can’t open the web page you requested ...
- Error Unknown - Unknown error with URL

...in all my browsers during any hours. Any ideas? Other download? Send by email? I need it…

I just re-uploaded it here. Is it better ?

million thanks! this download works fine. also magento works now. i’m happy…

can we get a bit more info on this new dll file download? kinda surprised that ppl here aren’t a little bit wary that they’re downloading a random file from sites called hackthissite.org and such