Printable View
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.
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
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...) :smile:
Thanks again for the help!
Totally off topic but treeman in the province of Quebec is the name of a drinking game! :laugh:
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!
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 :blink:
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 :lookaroun ...
:D
[/FONT]
Hi,
Those errors normally occur because your database isn't refreshing its cache of Zen Cart configuration options.Quote:
Originally Posted by fepb
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
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!
:yes:
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