Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

MultiGeoZone giving error


satinwoods

Recommended Posts

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?

Link to comment
Share on other sites

change to:

while ($zone_class = tep_db_fetch_array($zone_class_query)) {
Link to comment
Share on other sites

@@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.

Link to comment
Share on other sites

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:

  1. All settings are in the module. The previous version's settings in Admin >> Configuration are no longer needed/used.
  2. You don't need to edit the language file -- everything is in the module.
  3. 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.
  4. 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

See my profile for a list of my addons and ways to get support.

Link to comment
Share on other sites

@@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

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.

Link to comment
Share on other sites

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

See my profile for a list of my addons and ways to get support.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...