My site went down after the upgrade to 7.5.8

Everything went smooth with the upgrade and after I ran the updatestore script, I can no longer access the site.

Any suggestions? (Did attempt to reinstall the upgrade files with no luck)

Eric Payne

So you just have a blank screen?
If so, I've see this when there is a php version error, but I think you should check the server logs (ask your host if you cannot do this yourself) and that should reveal the issue.
It may be helpful if we knew what version you were updating from.
David

Thanks for the fast reply Dave...I upgraded from 7.4.12

This is the screen I get when I try to login:

Fatal error: Uncaught Error: Call to undefined function mysql_query() in /home/copcars1/public_html/vsadmin/inc/incfunctions.php:1873 Stack trace: #0 /home/copcars1/public_html/vsadmin/inc/incfunctions.php(102): ect_query('SELECT adminEma...') #1 /home/copcars1/public_html/vsadmin/inc/incloginfunctions.php(22): getadminsettings() #2 /home/copcars1/public_html/vsadmin/login.php(17): include('/home/copcars1/...') #3 {main} thrown in /home/copcars1/public_html/vsadmin/inc/incfunctions.php on line 1873

Eric Payne

Hi, a forum search for the following "Call to undefined function mysql_query" reveals quite a few others with this issue and most often it's the version of PHP that is the issue andyou need to make some adjustments to a few files - mainly the db_conn"open.php filecheck this thread for details https://www.ecommercetemplates.com/support/topic.asp?TOPIC_ID=107737

Let us know how you get along.

David

Here's the response I received from my host:

It looks like the MySQLi extension in stalled and enabled.
I tried moving you from MYsql 5.6 to 7.4 and then 8.1 with the same errors.

Here is the error in the log file:

[15-May-2023 21:44:43 UTC] PHP Fatal error: Uncaught Error: Call to undefined function mysql_query() in /home/copcars1/public_html/vsadmin/inc/languagefile.php:19
Stack trace:
#0 /home/copcars1/public_html/vsadmin/inc/languagefile.php(31): lfect_query('SELECT storelan...')
#1 /home/copcars1/public_html/index.php(6): include('/home/copcars1/...')
#2 {main}
thrown in /home/copcars1/public_html/vsadmin/inc/languagefile.php on line 19


Eric Payne

Host is missing the point. As was stated above, you need to update the content of db_conn_open.php in accordance with the directions here: https://www.ecommercetemplates.com/support/topic.asp?TOPIC_ID=107737 and possibly modify includes.php if your cart is really old. It's all laid out there in that first post and should get you up and running again

Peter


Professional ecommerce web hosting services
Shared hosting Windows & Linux | Dedicated servers | Domains | SSL
Ecommerce Templates specialists since 2003
https://servelink.com

The includes.php file did not need editing

I modified the db_conn_open.php exactly as described in TOPIC_ID=107737

The site is still down and showing

This page isn’t workingwww.cop-cars.com is currently unable to handle this request.
HTTP ERROR 500

It also won't allow me to run the updatestore.php script

Eric Payne

My host reset my database connection and the site is up and running now.

Thanks again for the help!

Eric Payne

We had a similar problem when upgrading from 7.4.12 to 7.5.8, except the error we get is "Parse error: syntax error, unexpected '?' in C:\home\brandonmeats.com\wwwroot\vsadmin\inc\incfunctions.php on line 320".

When we go to that line, it reads "$xmlStr=$xmlStr ?? '';" and when we remove on of the ?, we just get a bunch more errors.

For what it is worth, the line above 320 reads "function createNodeList($xmlStr){"

Any ideas? We ran the upgrade twice, but the results were the same.

Tim Gorski

I have also confirmed that the includes.php and db_conn_open.php are formatted correctly per TOPIC_ID=107737 below.

Tim Gorski

Hi Tim
My apologies for this but the latest PHP language releases require checking for NULL values in a lot of cases that were not necessary previously, and in fixing that we used an operator that only appeared in PHP 7. If I were you what I would do is update the PHP version on the server to 7.0+ but also I've added a fix to the incfunctions.php file using a way to detect NULL's that should work on all versions. The fix is in the updater.

Vince

Click Here for Shopping Cart Software
Click Here to sign up for our newsletter
Click Here for the latest updater