Region Tables 1.0.0 Released!

[treewoman]

Thanks for the help. Next problem - I am shipping heavy items. When I ran the test (and have done this many times) for the shipping weights, I find the items are calculating very incorrectly.

For example, an item that weighs 104 lbs is displaying 3 x 34.67 lbs and adding three shippings together.

Any ideas what I'm doing wrong?

Thanks again.

[conor]

Hi Treewoman.

Strange name! :)

You must have set up your Zen Cart store with a maximum shipping weight of 34.67lbs... you can change the maximum weight you can ship using the admin (Configuration > Shipping/Packaging).

Hopefully that's you sorted now!

All the best...

Conor

[treewoman]

Ok, it helped out a lot!

(By the way, the treewoman nickname is because we grow Christmas trees, my husband is nicknamed the treeman and so they started calling me the treewoman. Not that strange...well...maybe a little...)

Thanks again for the help!

[Fred9V]

Totally off topic but treeman in the province of Quebec is the name of a drinking game!

[fepb]

Hi, great module. I think this one may be the solution to something I've been grappling with for some time. But I am getting the following errors which at first I thought had to do with the SEO URLs contribution. I removed the SEO URLs contribution and received the same errors minus the ones for /includes/classes/seo.url.php

Warning: Variable passed to each() is not an array or object in /hsphere/local/home/frangade/frangadesigns.com/store_test/includes/classes/db/mysql/query_factory.php on line 114

Warning: session_start(): Cannot send session cache limiter - headers already sent (output started at /hsphere/local/home/frangade/frangadesigns.com/store_test/includes/classes/db/mysql/query_factory.php:114) in /hsphere/local/home/frangade/frangadesigns.com/store_test/includes/functions/sessions.php on line 108

Warning: Cannot modify header information - headers already sent by (output started at /hsphere/local/home/frangade/frangadesigns.com/store_test/includes/classes/db/mysql/query_factory.php:114) in /hsphere/local/home/frangade/frangadesigns.com/store_test/includes/classes/seo.url.php on line 1247

Warning: Cannot modify header information - headers already sent by (output started at /hsphere/local/home/frangade/frangadesigns.com/store_test/includes/classes/db/mysql/query_factory.php:114) in /hsphere/local/home/frangade/frangadesigns.com/store_test/includes/classes/seo.url.php on line 1248

Warning: Cannot modify header information - headers already sent by (output started at /hsphere/local/home/frangade/frangadesigns.com/store_test/includes/classes/db/mysql/query_factory.php:114) in /hsphere/local/home/frangade/frangadesigns.com/store_test/includes/init_includes/init_templates.php on line 78

Warning: Cannot modify header information - headers already sent by (output started at /hsphere/local/home/frangade/frangadesigns.com/store_test/includes/classes/db/mysql/query_factory.php:114) in /hsphere/local/home/frangade/frangadesigns.com/store_test/includes/classes/seo.url.php on line 1247

Warning: Cannot modify header information - headers already sent by (output started at /hsphere/local/home/frangade/frangadesigns.com/store_test/includes/classes/db/mysql/query_factory.php:114) in /hsphere/local/home/frangade/frangadesigns.com/store_test/includes/classes/seo.url.php on line 1248

And the main page gets this:
1064 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 'EXPECTED_PRODUCTS_SORT limit MAX_DISPLAY_UPCOMING_PRODUCT' at line 7
in:
[select p.products_id, pd.products_name, products_date_available as date_expected from products p, products_description pd where p.products_id = pd.products_id and p.products_status = 1 and pd.language_id = '1' and p.products_date_available >=20070713 order by EXPECTED_PRODUCTS_FIELD EXPECTED_PRODUCTS_SORT limit MAX_DISPLAY_UPCOMING_PRODUCTS]

Thanks!

[Peekay]

Can you say what is your PHP version?, MySQL version? and whether you have PHP register_globals 'on' or 'off'? This info will help the developer provide an answer to your issues. The SQL error sounds like a MySQL version conflict to me, but the 'headers sent' error is often caused by a badly edited or corrupt PHP file.

Plus... yesterday was Friday the 13th

[fepb]

Hi, thanks. Here is my server/version info I got from my admin:
Server OS: Linux 2.6.19.2-UP
Database: MySQL 4.1.20-max-log
Server Date: 07/13/2007 20:14:38
Database Date: 07/13/2007 20:14:38
Server Up Time: 8:14pm up 15 days, 8:06, 0 users, load average: 1.39, 2.12, 2.16
PHP Version: 4.3.11 (Zend: 1.3.0)
HTTP Server: Apache

My register globals is:
php_flag register_globals 0
[FONT=Verdana](I think that means off, right? Sorry, I'm still new at this)

... and it's still Friday the 13th on this side of the ocean ...


[/FONT]

[conor]

Hi,

But I am getting the following errors

Those errors normally occur because your database isn't refreshing its cache of Zen Cart configuration options.

This is a bug in Zen Cart and/or your MySQL server when SQL caching is enabled.

I'm not sure why it occurs, that is, I'm not sure why ZC/MySQL doesn't flush the configuration cache but you can fix this by either manually emptying the Zen Cart cache table yourself or making the following change:

in includes/configure.php change your SQL_CACHE_METHOD to:

define('SQL_CACHE_METHOD', 'none');

Hope that helps!

All the best...

Conor

[fepb]

Hi Conor,

Thanks a bunch, that did the trick! Now I can use your great module which is exactly what I've been looking for. Thanks again!

[mattys]

Hi

If I can get this module working it will be great!

I have successfully loaded module and set up two regions, for UK.

The first region is for free shipping to postcodes GB:EX31-35, so ex31, ex32, ex33, ex34 and ex35 addresses get free shipping. When i add a product to cart and begin to check out and Estimate Shipping it does say 0.00 for rate, great, but under the 'Available Shipping Methods' bit it says:

Local Delivery (Personal Delivery (within 10km): Free if Order Total Over £50, £1.50 if Under (1 x 1.00Kg(s)))

I can't remember setting anything up for it to say this. Anyone any ideas?

The same thing occurs for Region two, but it says 'Local Delivery (Personal Delivery (within 75km): Free if Order Total Over £50, £4.50 if Under (1 x 1.00Kg(s)))'??

Please note that for Region 2 I have set up just 1 post code, for test purposes, but is a catch all GB:SM - to test i just use a bogus postcode, e.g 'sm33 2el'.


It also seems to be calculating the incorrect shipping fee, which is £1.22 - I don't have a a £1.22 fee set up!? My table rates for this postcode are as follows:

1:2.30,5:4.99,20:5.95,21:6.25,22:6.55,23:6.80,24:7.10,25:7.40,26:7.70,27:8.00,28 :8.30,29:8.70,30:9.00,31:9.30,32:9.60,33:9.90,34:10.20,35:10.50,36:10.80,37:11.1 0,38:11.40,39:11.70,40:12.00,41:12.30,42:12.60,43:12.90,44:13.10,45:13.40,46:13. 70,47:14.00,48:14.30,49:14.60,50:14.90

The product i am testing it on has a weight of 1, so, should cost £2.30, but doesn't seem to be doig this?

Help would be very much appreciated