Author Topic: "500 - No valid database connection:" while performing paypal payment  (Read 7316 times)

sotirakis

  • Beginner
  • *
  • Posts: 2
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

ahann87

  • Beginner
  • *
  • Posts: 2
Re: "500 - No valid database connection:" while performing paypal payment
« Reply #1 on: December 23, 2010, 06:03:42 am »
I also have this problem too. Anyone can help? Thanks so much.

androctonvs

  • Beginner
  • *
  • Posts: 8
Re: "500 - No valid database connection:" while performing paypal payment
« Reply #2 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)."

ahann87

  • Beginner
  • *
  • Posts: 2
Re: "500 - No valid database connection:" while performing paypal payment
« Reply #3 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?

gastonfl

  • Beginner
  • *
  • Posts: 14
Re: "500 - No valid database connection:" while performing paypal payment
« Reply #4 on: March 11, 2011, 23:41:43 pm »
Thx for the solution of MYSQLI it only happens when you have joomfish instaled

goretex34

  • Beginner
  • *
  • Posts: 37
    • Zeesl web design · diseño web Zeesl
I had the same problem "500 - No valid database connection:"
I've changed in the main configuration mysql -> mysqli and it works perfectly now!!
------------------------------------
www.Zeesl.com  @Zeesl
www.chartconsulting.net @chartcon
@goretex34

shinygoldshoes

  • Beginner
  • *
  • Posts: 1
    • ShinyGoldShoes: ideas, design, web
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.
Joel Urbina
Creative director
http://www.shinygoldshoes.com