VM 3.0.12 : config error 0 SQL: 00000 on Save : mysql PDO Bug

Started by Studio 42, December 23, 2015, 23:59:04 PM

Previous topic - Next topic

Studio 42

Hi all,
First time i see this,
  when i try to save vm config, a have
QuoteERROR  0 SQL: 00000, ,
.
All are updated for 2 days from VM 2.6 + Joomla 2.5 to Vm 3.0.12 + Joomla 3.4.7

All other components work, without any problem and other VM edit and save too !

Some had already this?

Thanks,
Patrick

Studio 42

#1
HI,
I reply to myself and this can help other having same problem.
THe query used by Virtuemart to save the config is not compatible with mysql PDO.
Solution, change db type from mysql PDO > mysql in Joomla config.

Linux with PHP   5.3.29, mySql 5.6.26,Joomla! 3.4.8, VM 3.0.12

welrachid

Can you change from mysql to PDO afterwards? or will it fail on every VM config save with PDO?
Best regards,
Wel

Studio 42

You can change from PDO to mysql after, this don't break the shop, but the config sql query (and perhaps another queries) is not mysql PDO compliant.

Milbo

Should I fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

Studio 42

Quote from: Milbo on January 04, 2016, 13:06:39 PM
The question is, why it is not PDO complaint?
perhaps : VirtueMartModelConfig function getCreateConfigTableQuery query or language table creation query ?
I know that the only i have do, is switching from mysql PDO to mysql and all work correctly since.
This need test, to check and i don't have lust to play with my customer server ;)

radosc

Hello
I would like to brush up this topic.

I get many warnings on my server (libraries/joomla/database/driver/mysqli.php on line 219\nPHP message: PHP Warning:  mysqli_close(): Couldn't fetch mysqli)
so to solve this problem I switched to MySql (PDO). Everything works well but Virtuemart in menu "Tax & Calculation Rule". When I want to save a rule then I get error 0000 and server slowes down dramaticly (dedicated very powerfull).

Is any solution of this issue?

Joomla! 3.7.5
VM 3.22
PHP    7.0.22
MySql 5.5.36

thank you
Radek

Studio 42

do not use mysqli but mysql, mysqli  is deprecated in PHP7 and perhaps it solve your problem too

Milbo

Uhm, I cannot find anything that mysqli is deprecated in php7.
Should I fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

StefanSTS

http://php.net/manual/en/mysql.php

Depending on the version of PHP, there are either two or three PHP APIs for accessing the MySQL database. PHP 5 users can choose between the deprecated mysql extension, mysqli, or PDO_MySQL. PHP 7 removes the mysql extension, leaving only the latter two options.
--
Stefan Schumacher
www.jooglies.com - VirtueMart Invoice Layouts

Please use only stable versions with even numbers for your live shop! Use Alpha versions only if you know what risk you are taking.

AH

Not sure what studio42 is meaning by his statement.

QuoteIf you are using MySQL versions 4.1.3 or later it is strongly recommended that you use the mysqli extension instead.

http://php.net/manual/en/mysqli.overview.php

To me it looks like MYSQL extension is being deprecated

Regards
A

Joomla 3.10.11
php 8.0

StefanSTS

Quote from: radosc on August 22, 2017, 20:14:40 PM
I get many warnings on my server (libraries/joomla/database/driver/mysqli.php on line 219\nPHP message: PHP Warning:  mysqli_close(): Couldn't fetch mysqli)
(dedicated very powerfull).

Is any solution of this issue?

What happens on a not so powerful XAMPP or another providers server?
Sounds like your server is having some issues.

Stefan
--
Stefan Schumacher
www.jooglies.com - VirtueMart Invoice Layouts

Please use only stable versions with even numbers for your live shop! Use Alpha versions only if you know what risk you are taking.

Studio 42


Milbo

Should I fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

radosc

Quote from: StefanSTS on August 23, 2017, 10:20:20 AM
Quote from: radosc on August 22, 2017, 20:14:40 PM
I get many warnings on my server (libraries/joomla/database/driver/mysqli.php on line 219\nPHP message: PHP Warning:  mysqli_close(): Couldn't fetch mysqli)
(dedicated very powerfull).

Is any solution of this issue?

What happens on a not so powerful XAMPP or another providers server?
Sounds like your server is having some issues.

Stefan

I think server is OK. many administrators and hours they spent to optimalize my server which is working OK. It might be a problem with any plugin but I can't find it. The problem is only with driver MySqli. On Mysql (PDO) it works perfectly. Only when I edit a rule in (taxes & rules) after saving it there is MySql error appears.