Big Royal Mail 3.0

[brittainmark]

New version submitted for price and international format changes.

[devus]

Thanks Mark, you are a star.

I thought this came in tomorrow, judging by the farce at the Post Office today it would have been better coming in on April Fool's day!

[globalmemory]

Hello,

I've updated this mod but now I'm getting the following error:

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 ':aa43608fdf8a423584cc0ac9397f7045) AND po.products_options_name = "Minimum Deliv' at line 1
in:
[SELECT ifnull(max(pov.products_options_values_sort_order), 0) as postage_attribute FROM zen_products_options_values pov INNER JOIN zen_products_attributes pa ON pov.products_options_values_id = pa.options_values_id INNER JOIN zen_products_options po ON po.products_options_id = pa.options_id WHERE pa.products_id IN (1032:aa43608fdf8a423584cc0ac9397f7045) AND po.products_options_name = "Minimum Delivery Method:"]

Can anyone help please?

[devus]

I just upgraded from 3.1.0 following the upgrade instructions but all I get when checking out or clicking "Estimate Shipping" is -

WARNING: An Error occurred, please refresh the page and try again.

[03-Apr-2014 12:51:25 Europe/London] PHP Fatal error: 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 ':93665ce0472894a1b520fc80489dc238) AND po.products_options_name = "Minimum Deliv' at line 1 :: SELECT ifnull(max(pov.products_options_values_sort_order), 0) as postage_attribute FROM products_options_values pov INNER JOIN products_attributes pa ON pov.products_options_values_id = pa.options_values_id INNER JOIN products_options po ON po.products_options_id = pa.options_id WHERE pa.products_id IN (1606:93665ce0472894a1b520fc80489dc238) AND po.products_options_name = "Minimum Delivery Method:" in /var/www/vhosts/devus.com/httpdocs/zen15/includes/classes/db/mysql/query_factory.php on line 120

[devus]

I note that the instructions say to upload BigRoyalMail_V3.2.1/images/* but there are no images in the zip file.

[globalmemory]

install3.2 sql file seems to contain a syntax error and therefore cannot be installed until it's corrected?

[devus]

Just speculating here but the error mentions a product option called 'minimum deliv'

The README.htm for a fresh installation talks about setting the minimum delivery method via Catalog>Categories/Products> but having followed the UPGRADE.htm instructions I don't see anything about minimum delivery on the product options.

I've searched via developers toolkit for some of the code fragments in the error above and they only occur in /includes/modules/shipping/BigRoyalMail/quote.php so I tend to think the error is in this file.

[globalmemory]

clearly this latest update has not been thoroughly tested.

[devus]

I tried to call Mark via his website but no answer so I left a message asking him to have a look here when he had time.

I compared the quote.php with previous versions and they are the same, so it may not be that.

Can't wait any longer so I am having our site restored from backup.

[brittainmark]

Hello,

I've updated this mod but now I'm getting the following error:

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 ':aa43608fdf8a423584cc0ac9397f7045) AND po.products_options_name = "Minimum Deliv' at line 1
in:
[SELECT ifnull(max(pov.products_options_values_sort_order), 0) as postage_attribute FROM zen_products_options_values pov INNER JOIN zen_products_attributes pa ON pov.products_options_values_id = pa.options_values_id INNER JOIN zen_products_options po ON po.products_options_id = pa.options_id WHERE pa.products_id IN (1032:aa43608fdf8a423584cc0ac9397f7045) AND po.products_options_name = "Minimum Delivery Method:"]

Can anyone help please?

Sorry I have been away. Just got back. It looks like you have not run the SQL Script install3.2.sql this is necessary for the latest version. I'll check the install instructions to see if that is ok. seems to be there.