satinwoods Posted November 27, 2013 Posted November 27, 2013 I just installed multigeozone and I'm getting this error when I try to edit it in the admin section Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, resource given in /home/satinn5/public_html/strutfashion.ca/includes/modules/shipping/mzmt.php on line 196 Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, resource given in /home/satinn5/public_html/strutfashion.ca/includes/modules/shipping/mzmt.php on line 196 Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, resource given in /home/satinn5/public_html/strutfashion.ca/includes/modules/shipping/mzmt.php on line 196 line 196 is while ($zone_class = mysqli_fetch_assoc($zone_class_query)) { Thoughts? Quote
♥toyicebear Posted December 5, 2013 Posted December 5, 2013 Use the latest version (file) from http://addons.oscommerce.com/info/8136 Quote Basics for osC 2.2 Design - Basics for Design V2.3+ - Seo & Sef Url's - Meta Tags for Your osC Shop - Steps to prevent Fraud... - MS3 and Team News... - SEO, Meta Tags, SEF Urls and osCommerce - Commercial Support Inquiries - OSC 2.3+ How To To see what more i can do for you check out my profile [click here]
satinwoods Posted December 5, 2013 Author Posted December 5, 2013 Use the latest version (file) from http://addons.oscommerce.com/info/8136 @@toyicebear I am using that file. Still doesn't work. I re-installed it to make sure and nothing changed. :( Quote
♥toyicebear Posted December 6, 2013 Posted December 6, 2013 change to: while ($zone_class = tep_db_fetch_array($zone_class_query)) { Quote Basics for osC 2.2 Design - Basics for Design V2.3+ - Seo & Sef Url's - Meta Tags for Your osC Shop - Steps to prevent Fraud... - MS3 and Team News... - SEO, Meta Tags, SEF Urls and osCommerce - Commercial Support Inquiries - OSC 2.3+ How To To see what more i can do for you check out my profile [click here]
satinwoods Posted December 6, 2013 Author Posted December 6, 2013 @@toyicebear Nice, that fixed it! Thanks! Now it won't load all the areas, here's what the sql looks like Full texts geo_zone_id geo_zone_name geo_zone_description last_modified date_added Edit Edit Copy Copy Delete Delete 3 15% Rate NULL 2013-08-21 13:09:15 Edit Edit Copy Copy Delete Delete 4 14% Rate NULL 2013-08-21 13:09:24 Edit Edit Copy Copy Delete Delete 5 13% Rate NULL 2013-08-21 13:09:33 Edit Edit Copy Copy Delete Delete 6 5% Rate NULL 2013-08-21 13:09:43 Edit Edit Copy Copy Delete Delete 7 No Tax Out Side Canada 2013-10-07 08:37:21 2013-10-07 08:32:20 Edit Edit Copy Copy Delete Delete 8 Shp: United States: 48 United States: Continental 48 states NULL 2013-11-20 13:11:01 Edit Edit Copy Copy Delete Delete 9 Shp: United States: 48 United States: Continental 48 states NULL 2013-11-21 14:00:17 It shows the double States in the drop down and the "rest of the world". No idea why the rest isn't working. Quote
♥kymation Posted December 6, 2013 Posted December 6, 2013 Change mysqli_fetch_assoc to tep_db_fetch_array (three places). Testing now.... I really want to rewrite this thing. Somebody please stop me. Regards Jim GLWalker and joli1811 2 Quote See my profile for a list of my addons and ways to get support.
♥joli1811 Posted December 7, 2013 Posted December 7, 2013 Hi Jim, No chance know what you are like when you get started :P going to need this soon hahah Regards Joli Quote To improve is to change; to be perfect is to change often.
♥kymation Posted December 7, 2013 Posted December 7, 2013 Almost finished. It's down to testing and debugging now. Regards JIm Quote See my profile for a list of my addons and ways to get support.
♥kymation Posted December 7, 2013 Posted December 7, 2013 And done. This has been tested on my development box (Apache 2.2.22, PHP 5.4.6, MySQL 5.5.34) but that doesn't mean it'll work on everyone's system. Please get a copy and help me test. For those of you who have used this before, there are a few changes: All settings are in the module. The previous version's settings in Admin >> Configuration are no longer needed/used. You don't need to edit the language file -- everything is in the module. This is a two-step install. Install the module, then edit and enter the number of Geo Zones and the number of Tables. Click Save and the form fields for the tables will show up and can be edited. All three files have been updated, so you need to upload all three. Please post here with any questions, bug, code, feature requests ... you know the drill. Regards Jim Quote See my profile for a list of my addons and ways to get support.
Mort-lemur Posted December 7, 2013 Posted December 7, 2013 @@kymation Hi Jim - Typical ! just a couple of days after I install the old version you bring out a new one :) Is it possible to update to this or will I need to un-install then re-install the files / database changes?? Thanks Quote Now running on a fully modded, Mobile Friendly 2.3.4 Store with the Excellent MTS installed - See my profile for the mods installed ..... So much thanks for all the help given along the way by forum members.
♥kymation Posted December 7, 2013 Posted December 7, 2013 You will need to uninstall and then upload and install the new module. This one is quite different from the older versions. Remember, this module is not well tested yet, so please test thoroughly before you go on with your installs. Regards Jim Quote See my profile for a list of my addons and ways to get support.
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.