Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Recommended Posts

Posted

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?

Posted

change to:

while ($zone_class = tep_db_fetch_array($zone_class_query)) {
Posted

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

Posted

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

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

Posted

Hi Jim,

 

No chance know what you are like when you get started :P

 

going to need this soon hahah

 

Regards

Joli

To improve is to change; to be perfect is to change often.

 

Posted

Almost finished. It's down to testing and debugging now.

 

Regards

JIm

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

Posted

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.

Posted

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

Posted

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.

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.

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