Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email community@magento.com.

Magento Forum

Page 2 of 5
I am getting alot of SQL errors
 
Jonathan Hedrén
Member
 
Total Posts:  67
Joined:  2007-08-31
Sweden
 

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

 
Magento Community Magento Community
Magento Community
Magento Community
 
Preudomme
Jr. Member
 
Total Posts:  11
Joined:  2007-08-31
 

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

 
Magento Community Magento Community
Magento Community
Magento Community
 
Emperor
Sr. Member
 
Total Posts:  111
Joined:  2007-08-31
 
netcart - 31 August 2007 11:57 AM

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.

 
Magento Community Magento Community
Magento Community
Magento Community
 
iblastoff
Sr. Member
 
Total Posts:  252
Joined:  2007-08-31
 
Emperor - 31 August 2007 12:22 PM

netcart - 31 August 2007 11:57 AM
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…

 
Magento Community Magento Community
Magento Community
Magento Community
 
Emperor
Sr. Member
 
Total Posts:  111
Joined:  2007-08-31
 
iblastoff - 31 August 2007 12:26 PM

Emperor - 31 August 2007 12:22 PM
netcart - 31 August 2007 11:57 AM
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.

 
Magento Community Magento Community
Magento Community
Magento Community
 
Moshe
Magento Team
 
Avatar
Total Posts:  1770
Joined:  2007-08-07
Los Angeles
 

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…

 
Magento Community Magento Community
Magento Community
Magento Community
 
austinstorm
Member
 
Avatar
Total Posts:  31
Joined:  2007-08-31
Moscow, ID
 
Emperor - 31 August 2007 12: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.

 
Magento Community Magento Community
Magento Community
Magento Community
 
Burak
Jr. Member
 
Total Posts:  13
Joined:  2007-08-31
 
FrenchToast - 31 August 2007 12: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..

 
Magento Community Magento Community
Magento Community
Magento Community
 
Tillo
Jr. Member
 
Avatar
Total Posts:  29
Joined:  2007-08-31
 

this link does not work!

 
Magento Community Magento Community
Magento Community
Magento Community
 
Xavier ETCHEBER
Jr. Member
 
Avatar
Total Posts:  4
Joined:  2007-08-31
 

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

 
Magento Community Magento Community
Magento Community
Magento Community
 
Preudomme
Jr. Member
 
Total Posts:  11
Joined:  2007-08-31
 
Moshe - 31 August 2007 01: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?

 
Magento Community Magento Community
Magento Community
Magento Community
 
Tillo
Jr. Member
 
Avatar
Total Posts:  29
Joined:  2007-08-31
 

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…

 
Magento Community Magento Community
Magento Community
Magento Community
 
Xavier ETCHEBER
Jr. Member
 
Avatar
Total Posts:  4
Joined:  2007-08-31
 

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

 
Magento Community Magento Community
Magento Community
Magento Community
 
Tillo
Jr. Member
 
Avatar
Total Posts:  29
Joined:  2007-08-31
 

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

 
Magento Community Magento Community
Magento Community
Magento Community
 
iblastoff
Sr. Member
 
Total Posts:  252
Joined:  2007-08-31
 

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

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top
Page 2 of 5