Big Royal Mail 3.0

[adb34]

I am having a nightmare. Using v1.5.5a no template added.

I have load this plugin and I have found the patch. Question is do I need to load 2016Update.sql? I have tried but getting errors.

[19-Sep-2016 20:28:47 Europe/London] Request URI: /office/sqlpatch.php?action=execute, IP address: 109.157.232.207
#1 trigger_error() called at [/homepages/20/d503465712/htdocs/shops/cards/includes/classes/db/mysql/query_factory.php:167]
#2 queryFactory->show_error() called at [/homepages/20/d503465712/htdocs/shops/cards/includes/classes/db/mysql/query_factory.php:139]
#3 queryFactory->set_error() called at [/homepages/20/d503465712/htdocs/shops/cards/includes/classes/db/mysql/query_factory.php:266]
#4 queryFactory->Execute() called at [/homepages/20/d503465712/htdocs/shops/cards/office/sqlpatch.php:304]
#5 executeSql() called at [/homepages/20/d503465712/htdocs/shops/cards/xxxxxx/sqlpatch.php:672]

[19-Sep-2016 20:28:47 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 '"20.00&quot' at line 1 :: /* * Update for Big royal Mail postage rates valid from 29 March 2016 for latest rates visit http://www.royalmail.com * * Assumes weights in Kg costs in GBP. * * created by Mark Brittain. * * Donations via paypal to [email protected] * * N.B. I do not guarantee to update this every year please check the rates with royal mail. * * ***** update descriptions as descritpions.txt***** */ SET @Default_Insurance = "20.00"; ==> (as called by) /homepages/20/d503465712/htdocs/shops/cards/xxxxxx/sqlpatch.php on line 304 <== in /homepages/20/d503465712/htdocs/shops/cards/includes/classes/db/mysql/query_factory.php on line 167

xxxxxx replaces my admin folder.

[brittainmark]

This may be an sql error. Can yo let me now what version of sql and php your are using? I have had issues on a test server with new SQL.

I am having a nightmare. Using v1.5.5a no template added.

I have load this plugin and I have found the patch. Question is do I need to load 2016Update.sql? I have tried but getting errors.

[19-Sep-2016 20:28:47 Europe/London] Request URI: /office/sqlpatch.php?action=execute, IP address: 109.157.232.207
#1 trigger_error() called at [/homepages/20/d503465712/htdocs/shops/cards/includes/classes/db/mysql/query_factory.php:167]
#2 queryFactory->show_error() called at [/homepages/20/d503465712/htdocs/shops/cards/includes/classes/db/mysql/query_factory.php:139]
#3 queryFactory->set_error() called at [/homepages/20/d503465712/htdocs/shops/cards/includes/classes/db/mysql/query_factory.php:266]
#4 queryFactory->Execute() called at [/homepages/20/d503465712/htdocs/shops/cards/office/sqlpatch.php:304]
#5 executeSql() called at [/homepages/20/d503465712/htdocs/shops/cards/xxxxxx/sqlpatch.php:672]

[19-Sep-2016 20:28:47 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 '"20.00"' at line 1 :: /* * Update for Big royal Mail postage rates valid from 29 March 2016 for latest rates visit http://www.royalmail.com * * Assumes weights in Kg costs in GBP. * * created by Mark Brittain. * * Donations via paypal to [email protected] * * N.B. I do not guarantee to update this every year please check the rates with royal mail. * * ***** update descriptions as descritpions.txt***** */ SET @Default_Insurance = "20.00"; ==> (as called by) /homepages/20/d503465712/htdocs/shops/cards/xxxxxx/sqlpatch.php on line 304 <== in /homepages/20/d503465712/htdocs/shops/cards/includes/classes/db/mysql/query_factory.php on line 167

xxxxxx replaces my admin folder.

[brittainmark]

Ok I have manage to reproduce. If you replace all the double quotes (") with single Quotes (') it works fine.

Attached revised scripts. This effected other scripts as well on 1.5.5a. There are still two scripts I need to test. Hopfully these will be all the ones you need.
155aSqlFix.zip

I am having a nightmare. Using v1.5.5a no template added.

I have load this plugin and I have found the patch. Question is do I need to load 2016Update.sql? I have tried but getting errors.

[19-Sep-2016 20:28:47 Europe/London] Request URI: /office/sqlpatch.php?action=execute, IP address: 109.157.232.207
#1 trigger_error() called at [/homepages/20/d503465712/htdocs/shops/cards/includes/classes/db/mysql/query_factory.php:167]
#2 queryFactory->show_error() called at [/homepages/20/d503465712/htdocs/shops/cards/includes/classes/db/mysql/query_factory.php:139]
#3 queryFactory->set_error() called at [/homepages/20/d503465712/htdocs/shops/cards/includes/classes/db/mysql/query_factory.php:266]
#4 queryFactory->Execute() called at [/homepages/20/d503465712/htdocs/shops/cards/office/sqlpatch.php:304]
#5 executeSql() called at [/homepages/20/d503465712/htdocs/shops/cards/xxxxxx/sqlpatch.php:672]

[19-Sep-2016 20:28:47 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 '"20.00"' at line 1 :: /* * Update for Big royal Mail postage rates valid from 29 March 2016 for latest rates visit http://www.royalmail.com * * Assumes weights in Kg costs in GBP. * * created by Mark Brittain. * * Donations via paypal to [email protected] * * N.B. I do not guarantee to update this every year please check the rates with royal mail. * * ***** update descriptions as descritpions.txt***** */ SET @Default_Insurance = "20.00"; ==> (as called by) /homepages/20/d503465712/htdocs/shops/cards/xxxxxx/sqlpatch.php on line 304 <== in /homepages/20/d503465712/htdocs/shops/cards/includes/classes/db/mysql/query_factory.php on line 167

xxxxxx replaces my admin folder.

[adb34]

This may be an sql error. Can yo let me now what version of sql and php your are using? I have had issues on a test server with new SQL.

Sql is 5.5 php as supplied with v1.5.5a

[brittainmark]

Its a change in 1.5.5a see https://www.zen-cart.com/showthread....80#post1318780 above.

Sql is 5.5 php as supplied with v1.5.5a

[brittainmark]

Additionally I think there might be an issue in the quote.php. This can be found in YOUR_SITE\includes\modules\shipping\BigRoyalMail.
To be consistant you need to change (line 69 to 72) from

    $attribute_postage_select = 'SELECT ifnull(max(pov.products_options_values_sort_order), 0) as postage_attribute
            FROM ' . TABLE_PRODUCTS_OPTIONS_VALUES . ' pov INNER JOIN ' . TABLE_PRODUCTS_ATTRIBUTES . ' pa ON pov.products_options_values_id = pa.options_values_id
            INNER JOIN ' . TABLE_PRODUCTS_OPTIONS . ' po ON po.products_options_id = pa.options_id
            WHERE pa.products_id IN (' . $products_list . ') AND po.products_options_name = "Minimum Delivery Method:"'; 

to

    $attribute_postage_select = 'SELECT ifnull(max(pov.products_options_values_sort_order), 0) as postage_attribute
            FROM ' . TABLE_PRODUCTS_OPTIONS_VALUES . ' pov INNER JOIN ' . TABLE_PRODUCTS_ATTRIBUTES . ' pa ON pov.products_options_values_id = pa.options_values_id
            INNER JOIN ' . TABLE_PRODUCTS_OPTIONS . ' po ON po.products_options_id = pa.options_id
            WHERE pa.products_id IN (' . $products_list . ') AND po.products_options_name = \'Minimum Delivery Method:\''; 

I am away for a couple of weeks (so may me slow to respond). I will fully test all this again when I am back on 1.5.5a withe the latest SQL to see if I can find any more issues. Mean time if you do find any other issues please let me know.

Its a change in 1.5.5a see https://www.zen-cart.com/showthread....80#post1318780 above.

[adb34]

Additionally I think there might be an issue in the quote.php. This can be found in YOUR_SITE\includes\modules\shipping\BigRoyalMail.
To be consistant you need to change (line 69 to 72) from

    $attribute_postage_select = 'SELECT ifnull(max(pov.products_options_values_sort_order), 0) as postage_attribute
            FROM ' . TABLE_PRODUCTS_OPTIONS_VALUES . ' pov INNER JOIN ' . TABLE_PRODUCTS_ATTRIBUTES . ' pa ON pov.products_options_values_id = pa.options_values_id
            INNER JOIN ' . TABLE_PRODUCTS_OPTIONS . ' po ON po.products_options_id = pa.options_id
            WHERE pa.products_id IN (' . $products_list . ') AND po.products_options_name = "Minimum Delivery Method:"'; 

to

    $attribute_postage_select = 'SELECT ifnull(max(pov.products_options_values_sort_order), 0) as postage_attribute
            FROM ' . TABLE_PRODUCTS_OPTIONS_VALUES . ' pov INNER JOIN ' . TABLE_PRODUCTS_ATTRIBUTES . ' pa ON pov.products_options_values_id = pa.options_values_id
            INNER JOIN ' . TABLE_PRODUCTS_OPTIONS . ' po ON po.products_options_id = pa.options_id
            WHERE pa.products_id IN (' . $products_list . ') AND po.products_options_name = \'Minimum Delivery Method:\''; 

I am away for a couple of weeks (so may me slow to respond). I will fully test all this again when I am back on 1.5.5a withe the latest SQL to see if I can find any more issues. Mean time if you do find any other issues please let me know.

In installed, in order; InstallFix.sql; zen_Install3.2.sql and then 2016Update.sql

Did not get any errors loading. All is OK so far. I have not tested bought anything yet

[adb34]

In installed, in order; InstallFix.sql; zen_Install3.2.sql and then 2016Update.sql

Did not get any errors loading. All is OK so far. I have not tested bought anything yet

Last bit should have read as 'I have not a 'buy test' anything yet

[adb34]

In installed, in order; InstallFix.sql; zen_Install3.2.sql and then 2016Update.sql

Did not get any errors loading. All is OK so far. I have not tested bought anything yet

Last bit should have read as 'I have not a 'buy test' anything yet

[hairydog]

Is there an update for new postage prices?