Call to undefined function mysql_connect()

[tomrinkes]

Hello,


I have installed 2.0.338.260417 and when I switch from PHP 5.6 to PHP 7.0 I get this problem
Call to undefined function mysql_connect()

It happens when the order is complet and the custumer goes to the paymentprovider.
What can I do?

J3.6.5
VM3

Greetings

Tom Rinkes

[admin]

hello, mysql_* functions are deprecated in php7.

please change your database type either in joomla global config to "mysqli" or modify your configuration.php to

Code: Select all

public $dbtype = 'mysqli';


if any of your 3rd party extension uses the mysql_* functions it will cause this error.

you can use OPC utils to find the extension by search all your server's files. search for "mysql_" in all *.php files.

OR

you can use OPC's fatal catcher plugin to indentify which extension causes this.

best regards, stan

[tomrinkes]

Hello Stan,

the database is mysql already, the problem only accurs what OPC is turn on.
OPC's fatal catcher plugin is turn on but I do not recieve any emails.

Thank you for you help

Greetings,

Tom

[tomrinkes]

What I mean is that the error only accurs when OPC and PHP 7 are on. When OPC is off and PHP 7 is on their is no problem.
OPC works well when I turn on PHP 5.6

[admin]

hello OPC loads your payment + calculation + coupon + shipment + custom field + shopper field plugins and if this function is used by any of them, it will cause an error.

first of all, please identify the file which causes the problem with our fatal catcher. (click install at the OPC Extensions tab + enable in joomla plugins)

generally it's recomended to:
- disable all unused payment + shipping plugins within the joomla plugin manager so they don't get loaded when they are not used (otherwise they do get loaded by joomla plugin system and may cause various problems... )

i did a check in OPC code and the only part using the obsolete function is our "centitrade payment plugin" after the checkout. if you are using this plugin, we are going to release an update.

best regards, stan

[admin]

ok, if the fatal catcher is not capable of sending the emails:
- your site's email may not work at all - pls see if you can send emails from Joomla generally
- update the fatal catcher from the OPC318 as we did a few updates for php7.1

if none of this helps, pls review your "php error log" for this fatal error AND/OR check "fatal catcher error log" if written in /logs directory AND/OR enable Developer error reporting in your Joomla global config to see the error on the screen AND/OR ask your hosting to locate the file which causes the problem via the php error logs.

if none of this helps, you can use OPC utils to full-text-search all your php files for "mysql_" keyword to see which part of the system uses it.

best regards, stan

[tomrinkes]

I have the fatal catcher working.

is this the problem?
Error message data:
8 Undefined index: email in file: /domains/twr-trading.nl/public_html/components/com_onepage/controllers/opc.php line: 5109

[admin]

hello, no - you probably enabled to send notices as well - please disable them as you can receive a few thousands emails in a few minutes and thus your email servers will be blocked within an hour.

if you'd like i can check your site online via FTP and backend, please contact us via email or live chat.

best regards, stan

[tomrinkes]

Hello Stan,

I think I found the problem, it is not with OPC but with the paymentprovider called Ideaal-checkout.
Thank for you help.

Greetings,

Tom

[admin]

hello, you are welcome, best regards, stan