Call to a member function rowCount() on a non-object ... /DbPDO.php on line 198

[FRANK ROTHER]

Hello,

 

since (07/04/2015) the upgrade from 1.6.0.11 to 1.6.1.0 I have the following fatal error PHP from my Apache log on the server: 

PHP Fatal error: Call to a member function rowCount() on a non-object in /var/www/htdocs/my-solution/public/classes/db/DbPDO.php on line 198, referer: http://www.nature-sens.com/soins-du-corps/245-lait-vegetal-hydratant-bio.html

I have no idea about ! I am not a developer.

Anybody could help ?

Thank you.

Frank.

[InfoValis]

Hi

I have a same problem on my shop https://www.infovalis.com/

 

Fatal error: Call to a member function rowCount() on a non-object in /***/***/***/infovalis.com/httpdocs/classes/db/DbPDO.php on line 206

 

when I want to print invoice

Hi

I have a same problem on my shop https://www.infovalis.com/

 

Fatal error: Call to a member function rowCount() on a non-object in /***/***/***/infovalis.com/httpdocs/classes/db/DbPDO.php on line 206

 

when I want to print invoice

 

[tuk66]

Does the error appear for all orders or just some?

[InfoValis]

@tuk66 for all orders

I see this message when I try to download invoice on the front office but I can see the invoice on the backoffice, I didn't have any message

[tuk66]

I think it can cause a module or a patch. PM me if you want to fix it.

[elettroitaly]

today i have same problem! but yesterda works fine!!! i don change anything!

 

Call to a member function rowCount() on a non-object  in /web/htdocs/............................./home/classes/db/DbPDO.php on line 206

 

please help!!!!

[doekia]

Be extremly cautious to only provide the most uninformative part of your error message. That so much fun to guess every thing.

 

Answer is: you get a fatal error at ligne 206 of the DbPDO.php file.

[tuk66]

This kind of random database issues is likely hosting related (memory, timeout).

[elettroitaly]

solved, aruba server had disable mysql database write permission

now is all ok

[carlos.creados]

It happens to me too, every time I save data (Prestashop 1.6.1.4 running in WAMP with PHP 5.5.12).
I've fixed the problem changing the file classes/SmartyCustom.php on line 297:
 

Db::getInstance()->execute($sql, false);
return true; //It prevents execution of problematic code

return Db::getInstance()->Affected_Rows();

Isn't elegant, but it's working

Edited February 5, 2016 by carlos.creados (see edit history)

[doekia]

Sounds like you are abusing of a fix for something that is not having any bug at all.

If you have to apply such a fix, it means the underlying query blows-up.

 

Most probable cause your table ps_smarty_lazy_cache does not exists or is totally corrupted.

 

Fix THE TABLE and return the code to the original.

[carlos.creados]

Ok, that's right. The table ps_smarty_lazy_cache didn't exist.

Thanks for your reply!

[doekia]

your are welcome

[jacky perrin]

Bonjour

 

 

Je suis sous la version 1.61.6  Hébergé chez LWS et je retrouve régulièrement ce message dans les log Serveur:

 

[Fri Jun 24 15:16:56.813016 2016] [:error] [pid 27544] [client 82.127.208.193:46397] FastCGI: server "/var/www/clients/client1/web8/cgi-bin/php5-fcgi-*-80-lingerie-miss-femme-fatale.com" stderr: PHP message: PHP Fatal error: Call to a member function rowCount() on a non-object in /var/www/clients/client1/web8/web/classes/db/DbPDO.php on line 208, referer: (Url fiche produits exemple:) http://www.lingerie-miss-femme-fatale.com/271-chaussures  mais qui concerne d'autre url produits de façon aléatoire et non fixe ..

Cette erreur semble empêcher la ou les pages concernées  de se charger et   sont déclarée  "inaccessible pour l'instant " ...! 

 

quelqu'un peut'il m'aider 

 

Par avance Merci

 

J.Perrin

[doekia]

Soit ta base de données est corrompue (inconsistante), soit le serveur SQL part en RTT dès qu'il y a un peu de sollicitation (log serveur: "désolé j'ai piscine...")

 

 

PS: Il faut abandonner ces hébergeurs à la petite semaine - tout juste bon pour la galerie de photos de vacances de tata Lulu.

[a-d-g]

It happens to me too, every time I save data (Prestashop 1.6.1.4 running in WAMP with PHP 5.5.12).

I've fixed the problem changing the file classes/SmartyCustom.php on line 297:

 

Db::getInstance()->execute($sql, false);
return true; //It prevents execution of problematic code

return Db::getInstance()->Affected_Rows();

Isn't elegant, but it's working

 

It's more simple, you only have to clear smarty cache, and everything will go right again.

[doekia]

@salvavidal

Why bother spending time to make such a ridiculous answer. Never clearing the cache will fix missing table in the schema. Read the issue, the diverses responses prior reponding

[abdullacm]

try to add missing column / tables with correct mysql user (the user that is configured in prestashop settings.inc.php)