VirtueMart Forum

VirtueMart 2 + 3 + 4 => Administration & Configuration => Topic started by: screamingfingers on March 30, 2015, 18:38:25 PM

Title: Warning SQL: 00000
Post by: screamingfingers on March 30, 2015, 18:38:25 PM
Hi All,

Ok I purchased a template with Joomla 3.3.1. I have updated to v. 3.4.0.

It had VM 3.0.6.2 but the VM AIO link on the menu bar does not work. I tried to reinstall VM 3.0.6.2 and ext AIO, but all I get is:

Warning

SQL: 00000, ,

Everytime I attempt to add something or make a change I get the same error message.

Can anybody shed some light on this issue?

Thanks,

David
Title: Re: Warning SQL: 00000
Post by: jenkinhill on March 31, 2015, 19:27:52 PM
1. http://forum.virtuemart.net/index.php?topic=127043.msg435441#msg435441
    http://forum.virtuemart.net/index.php?topic=126403.msg436199#msg436199     and others.......

2.  SQL: 00000  is usually indicating that there is no SQL error. Have you got debug turned on somewhere?
Title: Re: Warning SQL: 00000
Post by: screamingfingers on April 01, 2015, 17:21:23 PM
Hi Kelvyn,

thanks for the reply. In global configuration on the system tab, Debug System set to no,  Debug Language set to no. Cache settings disabled.

In virtuemart configuration, Enable debugging messages set to no debug, PHP Developer mode set to no debug.

I only get the error when I am updating a setting in the VM configuration. Then what happens is it gives me a link to go back to the control panel and then I have to go back in to VM again every time I change a setting.

David
Title: Re: Warning SQL: 00000
Post by: screamingfingers on April 01, 2015, 17:45:22 PM
Kelvyn,

Here is the exact message.
Title: Re: Warning SQL: 00000
Post by: GJC Web Design on April 02, 2015, 00:12:02 AM
You'd be better off switching all available debugging on to try and find out more info.. esp Joomla debug which often catches sql syntax errors

Otherwise it is on to tracing the process thru the php files till you find it (or if a fresh install just try another)

But the moral I guess is don't use bundled quickstarts - IMHO they are just so much trouble...

BTW - how can they release an almost up to date VM3.0.6.2 (3rd march)  with an out of date J3.3.1 (circa Sept 2014) ?
Title: Re: Warning SQL: 00000
Post by: Milbo on September 13, 2016, 15:59:28 PM
The problem here is the PDO driver, just use mysqli
Title: Re: Warning SQL: 00000
Post by: razor7 on December 07, 2017, 15:52:10 PM
Cool! I can confirm that the issue is solved by changing the DB driver back to MySQLi (tested in J 3.8.2 and VM 3.2.8 )