We just upgraded a customer to PHP 7.8.7, and now when we get to the estimator page we see:
Missing/Illegal ShipTo/Address/StateProvinceCode
So we disabled the estimator in the includes file and we get the following error on the Shipping Estimator page:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND (stateName='' OR stateAbbrev='')' at line 1
Fatal error: Uncaught Error: Call to a member function fetch_assoc() on bool in C:\home\ehlenbachscheese.com\wwwroot\vsadmin\inc\incfunctions.php:2101 Stack trace: #0 C:\home\ehlenbachscheese.com\wwwroot\vsadmin\inc\inccart.php(1563): ect_fetch_assoc() #1 C:\home\ehlenbachscheese.com\wwwroot\vsadmin\inc\inccart.php(8196): initshippingmethods() #2 C:\home\ehlenbachscheese.com\wwwroot\cart.php(64): include('C:\\home\\ehlenba...') #3 {main} thrown in C:\home\ehlenbachscheese.com\wwwroot\vsadmin\inc\incfunctions.php on line 2101

... making it impossible to complete the order.

Any suggestions?

Tim Gorski

In case it is relevant, they're using MySQL version 5.7.10...

Tim Gorski

Tim, just to confirm, did you reupload all the updater files again to be sure they are applied?


Mike Beebe
President,
DataLinks Software Solutions
www.dlss.ca
Rate Me Here

ASP and PHP mods - www.dlss.ca/products.asp
A Tremendous Home - www.ATremendousHome.com
Cigar Smoke Shop - www.CigarSmokeShop.net

Ok ... reuploading the files seems to have fixed that error.

Thanks, Mike!

Tim Gorski