VirtueMart Forum

VirtueMart 1.1.x [ Old version - no longer supported ] => Checkout / Order Management VM 1.1 => Topic started by: sotirakis on December 19, 2010, 23:37:21 pm

Title: "500 - No valid database connection:" while performing paypal payment
Post by: sotirakis on December 19, 2010, 23:37:21 pm
Hello everyone.

I'm having a strange problem with vm and paypal.
My setup includes joomla v.1.5.22 and vm v1.1.6.

I have created a paypal account and have set up its IPN settings. I have tested the notify.php script and it also works good.

At my local setup of a website, when I perform a checkout and have selected paypal as the payment menthod, everything is done smoothly and the user is redirected to paypal in order to pay for the products.

At the live site, when paypal is selected as the payment method, at the last step when the user should be redirected to paypal to pay, I get a "500 - No valid database connection:". Even more strangely, there is no text after the "connection:" that would indicate what is the error at the database connection or something else!

I have spent endless hours searching on the forum, trying different things and experimenting with variables.

Do you have any ideas or assumptions what might be wrong with my setup? It probably has to do with the server (www.one.com) but I really can't come up with something that might be causing that error.

Maybe something related with SSL(I have left the default values of vm)? Perhaps some security variables of the server? What should I search for or ask my hosting provider?

Thank you for any ideas that you might provide.

/Sotiris
Title: Re: "500 - No valid database connection:" while performing paypal payment
Post by: ahann87 on December 23, 2010, 06:03:42 am
I also have this problem too. Anyone can help? Thanks so much.
Title: Re: "500 - No valid database connection:" while performing paypal payment
Post by: androctonvs on February 11, 2011, 04:53:33 am
"I have detected this problem yesterday. When changing "mysql" into "mysqli" - in Joomla configuration -> Server tab -> Database Type - the problem was solved also with the new Joomfish version (2.1.5)."
Title: Re: "500 - No valid database connection:" while performing paypal payment
Post by: ahann87 on February 11, 2011, 05:15:34 am
Thanks androctonvs. I have try it & it really work. But is that any effect to database data store?
Title: Re: "500 - No valid database connection:" while performing paypal payment
Post by: gastonfl on March 11, 2011, 23:41:43 pm
Thx for the solution of MYSQLI it only happens when you have joomfish instaled
Title: Re: "500 - No valid database connection:" while performing paypal payment
Post by: goretex34 on May 09, 2011, 18:23:07 pm
I had the same problem "500 - No valid database connection:"
I've changed in the main configuration mysql -> mysqli and it works perfectly now!!
Title: Re: "500 - No valid database connection:" while performing paypal payment
Post by: shinygoldshoes on May 31, 2011, 10:47:09 am
Yep, it is the combination of Virtuemart + Joomfish. The best way to fix it is (as stated above) in the Global Joomla Configuration (Menu: Site > Global Configuration > Server tab) change 'Database type' from mysql to mysqli.
That's all you have to do. It may be best to check in (Menu: Help > System Info > PHP Information tab) and see if the Mysqli module is enabled for PHP, but most modern Linux based Apache servers that can run Joomla should have it enabled.