[Old] Royal Mail Modules

I have just installed v1.4 on a fresh install and all seems to work fine, except i cannot add the special delivery next day module in admin.

I get this error:

1136 Column count doesn't match value count at row 1
in:
[insert into configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_ofiguration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Enable Zones Method', 'MODULE_SHIPPING_SPECIALDELIVERY_STATUS', 'True', 'You must enable Zone shipping for this module to work', '6', '0', 'zen_cfg_select_option(array(\'True\', \'False\'), ', now())]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

Ii is the latest verion of Zen, but have also installed the beta UK template by MutalAdvantage.

Hi tonyrobbo,
That's interesting - because it's that service which seems to be causing me the problems I detiled eariler.

At the moment I would suggest version 1.3 is the most "stable" - and perhaps you should use that one instead.

I think Philip might produce an update for us if/when he can.

Regards,
David

Quote:

---

Originally Posted by zigzak

Philip,
"First class packet", "First class recorded signed for packet", and "SpecialDelivery next day".

When I do a test order with a weight of 1.44KG the estimator gives me choices of "1st Class Recorded signed for packet" @ £6.27, and "2nd class large letter" @ £8.30.

---

Pretty sure that's from the crash where it transposed second and first class signed for or something. But it should be an easy fix when I'm up to it.

Quote:

---

Originally Posted by tonyrobbo

I have just installed v1.4 on a fresh install and all seems to work fine, except i cannot add the special delivery next day module in admin.

I get this error:

1136 Column count doesn't match value count at row 1
in:
[insert into configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_ofiguration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Enable Zones Method', 'MODULE_SHIPPING_SPECIALDELIVERY_STATUS', 'True', 'You must enable Zone shipping for this module to work', '6', '0', 'zen_cfg_select_option(array(\'True\', \'False\'), ', now())]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

Ii is the latest verion of Zen, but have also installed the beta UK template by MutalAdvantage.

---

Yep that looks like it's probably another one of those crash problems I experienced. I think that version 1.4 should be declared 1.4-beta, 1.4 may not be fixed anyway since Jim Barrington came up with a great way of solving the way of not displaying the invalid shipping services without needing to modify the templates, so I may skip back to 1.3 and work from there.

TonyRobbo,

There's a bit of unexpected code (ie. mangle-ness) in the database insert in includes/modules/shipping/specialdelivery.php.

Remove the section on line 169:

PHP Code:

---

sort_ofiguration_value, configuration_description, configuration_group_id, 


---

So that line 169 looks like:

PHP Code:

---

     $db->Execute("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Enable Zones Method', 'MODULE_SHIPPING_SPECIALDELIVERY_STATUS', 'True', 'You must enable Zone shipping for this module to work', '6', '0', 'zen_cfg_select_option(array(\'True\', \'False\'), ', now())"); 


---

Yes, '2nd class large letter' does seem to be displaying instead of 'special delivery, next day'. No worries, I'm sure it'll be perfect when it's done :D

Well spotted Pixxi, that fixed it. :D

I must say i was very dissapointed with the shipping side of Zen until this mod.

Thanks bouncingltd

There's another bug throughout the entirety of my module to do with shipping things in numbers of boxes, this is constant throughout every shipping option.

basically it don't work, I've fixed it on one version, and when I am "recovered" I will fix it for the next 14 services.

Philip.

Back again. Here's the beta:

http://bouncing.org/big_royalmail_v1.5-beta.zip

no longer should one have to alter the ZC files tpl_checkout_shipping_default.php and tpl_modules_shipping_estimator.php although a prettier estimator is included if you want to install it. It should now be non-corrupted and thanks to JollyJim who was responsible for pointing me in the direction of a method of removing shipping options without the need to alter templates.

The boxes problem that I introduced has now been solved, although there is still a problem stemming from the way zencart is set up, e.g. you have an item that weighs 2.2 kilos, you have a 2 kilo weight limit on and so zen cart puts one object in two packages. Strange but true, I have 5 lens caps in 7 boxes apparently.

Ignore the version numbers of the files and pretty much all of the instructions as I reverted back to 1.3 and for the beta version, have yet to change things around.

Thank you

Philip.

Thank you Philip, - good to see you back again :smile:

Will take a look tomorrow and see if I can break it ...

Quote:

---

Strange but true, I have 5 lens caps in 7 boxes apparently

---

... things like this happen sometimes ... it's the 'Universe' (allegedly) :unsure:

:smile:

I probably should have mentioned, this does not require a remove and install of each shipping service, just a write over the existing files. And yes I'm back but with a hell of a drug hangover, it's a bugger having to go through withdrawal every couple of weeks.

There's going to have to eventually be a lot of changes to the modules because it has moved so far away from the original, there's some defunct pieces and some things that probably need the order swapping around. I think before this, we'll be addressing the courier zone/ region issue, there will have to be three courier modules to choose from because if one lives in Zone 2, one charges Zone 1 prices for Zone 2, making things a little complex.