The website that I am maintaining was not loading. I traced it back to a PHP error with my cart files so I applied the updater to 7.5.7 PHP version from 7.0. After running the installer and adding the necessary files I cam still not able to get the site to load. www.mettlerelectronics.com

PHP Fatal error: Uncaught Error: Call to a member function fetch_assoc() on bool in /home/[user]/public_html/vsadmin/inc/incfunctions.php:1747

Any thoughts on how to fix this?

More error code:

Stack trace:
#0 /home/[user]/public_html/vsadmin/inc/incfunctions.php(61): ect_fetch_assoc(false)
#1 /home/[user]/public_html/vsadmin/inc/incloginfunctions.php(22): getadminsettings()
#2 /home/[user]/public_html/vsadmin/admin.php(15): include('/home/mettelec1...')
#3 {main}
thrown in /home/[user]/public_html/vsadmin/inc/incfunctions.php on line 1747

Hi, did you remember to run the updatestore.php script in your browser?

Thanks,
David

Hi David,

Yes I did run the update. Ran it a second time just in case it didn’t take on the first run.
When I login to the backend it shows the updated version. Still getting php errors when looking at the logs.

Hi bpike
If the fetch_assoc function isn't available it's likely that the mySQLi extension has not been enabled in PHP. Can you check that with your host? Quite possibly the PHP version on the server was changed but that essential extension was not enabled.

Vince

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

Thanks Vince. It appears to be working this morning. I'll run a test order. Not sure if a reboot of the server overnight did it or not. I did not do anything.

Turns out we modified a function in the incfunctions.php file to check if the value was not bool before passing it to the fetch_assoc function.

[code]function ect_fetch_assoc($ectres)
{
return (!is_bool($ectres) && @$GLOBALS['ectdatabase'] ? $ectres->fetch_assoc() : mysql_fetch_assoc($ectres));
}[/code]

Will this affect anything else?

I don't think any boolean values would be sent to that function so I'm not sure it would have any effect anyway.

Vince

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

Hi Vince,

My host responded with this:

"Please be advised that Mysqli Support is enabled according to the phpinfo page. You can verify that yourself at https://www.mettlerelectronics.com/phpinfo.php."

Thoughts?

Hi bpike, I thought the site was working... Is that not the case?

quote:

---

It appears to be working this morning. I'll run a test order. Not sure if a reboot of the server overnight did it or not. I did not do anything.

---

David

It is. I wanted to let Vince know the MySQLi was enabled. Not sure if it was a server reboot or the custom code we added.

Brian, you may wish to check out this Forum Topic: Which PHP Extensions should you have enabled?

When you upgrade the PHP Version in cPanel, the catch is that the default set of PHP Extensions enabled are not always adequate to run Ecommerce Templates.
When I updated to PHP VERSION 8.2, I needed to activate nd_mysqli

Gary

Thanks Gary. I'll take a look.