shipping rates no longer work

[evilonion]

I have recently done an install upgrade.

I created a new database and shop in a separate folder.
I then did an sql dump into the new database with the old sites data.

Everything about the site works great, all the info pages, customer accounts, orders, everything is there.
Add products to cart fine, but no shipping is shown.

Zone rate is installed the same as the old site.
The only difference is that the old site has a shipping calculator, i have no idea if this has changed anything in the database compared to 1.5.1 as it was so long ago?

Any ideas how i can repair all the shipping files in the site?
At the moment anyone ordering will get free shipping

[Ajeh]

Go to Modules ... Shipping ... and click on Zone Rates zones ... what do you see in the right hand panel?

[evilonion]

all the same information as the current live site.
shipping is enabled, based on price and all the zones and value amounts are there.

It should be shipping up to £20 is £2.50 etc but nothing happens when you add a product and go to checkout.
If i do the same process on my live 3.9 cart it works fine :?

[Ajeh]

Since I don't know what you have set, could you post it here?

Also, what are your settings in the Configuration ... Shipping/Packaging ...

[evilonion]

yes sorry.
in the live site it has this for shipping handling in admin

Title Value Action
Country of Origin United Kingdom
Postal Code ss13qs
Enter the Maximum Package Weight you will ship 50
Package Tare Small to Medium - added percentage:weight 0:3
Larger packages - added packaging percentage:weight 10:0
Display Number of Boxes and Weight Status 1
Order Free Shipping 0 Weight Status 0
Shipping Estimator Display Settings for Shopping Cart 0
Display Order Comments on Admin Invoice 1
Display Order Comments on Admin Packing Slip 1
Shipping Rates in Cart - No Shipping Behaviour Display zero shipping price
Shipping Rates in Cart - Display Currency Code No
Shipping Rates in Sidebox - Enable false
Shipping Rates in Sidebox - Suppress No
Shipping Rates in Sidebox - Display Currency Code No

the zone rates show green and the following is listed:

Zone Based Rates

Enable Zones Method
True

Calculation Method
Price

Tax Class
--none--

Tax Basis
Shipping

Sort Order
0

Skip Countries, use a comma separated list of the two character ISO country codes


Zone 1 Countries
GB

Zone 1 Shipping Table
20.00:2.85,30.00:2.85,40.00:3.95,65.00:6.95,999:0.00

Zone 1 Handling Fee
0

Handling Per Order or Per Box Zone 1 (when by weight)
Order

Zone 2 Countries
AT,BE,BG,CY,CZ,DK,EE,FI,FR,DE,GR,HU,IE,IT,LV,LT,LU,MT,NL,PL,PT,RO,SK,SI,SE,EL,ES

Zone 2 Shipping Table
20.00:5.25,30.00:6.95,40.00:11.50,65.00:14.95,70.00:16.65,80.00:17.65,90.00:19.9 5,100.00:22.95,150.00:24.95,160.00:26.95,250.00:30.95,999:30.95

Zone 2 Handling Fee
0

Handling Per Order or Per Box Zone 2 (when by weight)
Order

Zone 3 Countries
US,CA,AU,CN,JP,NZ,TW,SA,AE,EG,NO,SG,CH,TR,IL,PR,ZA,BS,BB,BR,VG,TT,TH,SC,QA,PH,PR ,OM,CL,IS,FK,GD,CS,KW,

Zone 3 Shipping Table
20.00:5.50,30.00:7.50,40.00:14.95,65.00:19.95,70.00:22.00,80.00:24.65,90.00:26.0 0,100.00:30.00,150.00:32.60,160.00:34.80,250.00:58.00,999:58.00

Zone 3 Handling Fee
0

Handling Per Order or Per Box Zone 3 (when by weight)
Order

The site that does not show shipping has this in admin shipping/handling:

Title Value Action
Country of Origin United Kingdom
Postal Code ss13qs
Enter the Maximum Package Weight you will ship 50
Package Tare Small to Medium - added percentage:weight 0:3
Larger packages - added packaging percentage:weight 10:0
Display Number of Boxes and Weight Status 1
Order Free Shipping 0 Weight Status 0
Shipping Estimator Display Settings for Shopping Cart 0
Display Order Comments on Admin Invoice 1
Display Order Comments on Admin Packing Slip 1
Shipping Rates in Cart - No Shipping Behaviour Display zero shipping price
Shipping Rates in Cart - Display Currency Code No
Shipping Rates in Sidebox - Enable false
Shipping Rates in Sidebox - Suppress No
Shipping Rates in Sidebox - Display Currency Code No

and in zone rates:

Zone Based Rates

Enable Zones Method
True

Calculation Method
Price

Tax Class
--none--

Tax Basis
Shipping

Sort Order
0

Skip Countries, use a comma separated list of the two character ISO country codes


Zone 1 Countries
GB

Zone 1 Shipping Table
20.00:2.85,30.00:2.85,40.00:3.95,65.00:6.95,999:0.00

Zone 1 Handling Fee
0

Handling Per Order or Per Box Zone 1 (when by weight)
Order

Zone 2 Countries
AT,BE,BG,CY,CZ,DK,EE,FI,FR,DE,GR,HU,IE,IT,LV,LT,LU,MT,NL,PL,PT,RO,SK,SI,SE,EL,ES

Zone 2 Shipping Table
20.00:5.25,30.00:6.95,40.00:11.50,65.00:14.95,70.00:16.65,80.00:17.65,90.00:19.9 5,100.00:22.95,150.00:24.95,160.00:26.95,250.00:30.95,999:30.95

Zone 2 Handling Fee
0

Handling Per Order or Per Box Zone 2 (when by weight)
Order

Zone 3 Countries
US,CA,AU,CN,JP,NZ,TW,SA,AE,EG,NO,SG,CH,TR,IL,PR,ZA,BS,BB,BR,VG,TT,TH,SC,QA,PH,PR ,OM,CL,IS,FK,GD,CS,KW,

Zone 3 Shipping Table
20.00:5.50,30.00:7.50,40.00:14.95,65.00:19.95,70.00:22.00,80.00:24.65,90.00:26.0 0,100.00:30.00,150.00:32.60,160.00:34.80,250.00:58.00,999:58.00

Zone 3 Handling Fee
0

Handling Per Order or Per Box Zone 3 (when by weight)
Order

I've since added the royal mail shipping modules but they dont work either so im assuming there must be something missing between the database talking to the site. I dont know if any previous changes to 1.3 would have made changes to the database, but i would have thought that the upgrade installation should have address any issues or flagged up errors?

[evilonion]

just to add i am running a template, i reverted to the default template and nothing changes so im ruling out anything there.

[Ajeh]

Are you seeing any debug logs in your directory /cache for older versions /logs for v1.5+ ...

If you install the Shipping Module for Flat Rate flat ... does it display?

[evilonion]

flat rate doesnt work either.
none of the options do.
there are debug files, i can paste the latest one in here? (created yesterday)

[Ajeh]

Yes seeing the error generated in the debug log would be helpful ...

[evilonion]

this is the mydebugadm file:

[15-Jun-2013 17:43:24 Europe/London] 

PHP Fatal error:  1062:Duplicate entry 'SRIC_NO_SHIP' for key 2 :: INSERT INTO zen_configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES (NULL, 'Shipping Rates in Cart - No Shipping Behaviour', 'SRIC_NO_SHIP', 'Display zero shipping price', '<br />

Some items such as gift certificates do not require shipping<p />Select what to do in these cases', 7, 50, NULL, now(), NULL, 'zen_cfg_select_option(array(''Display zero shipping price'', ''Display a word'', ''Only display subtotal'', ''Only display total'', ''Only display subtotal and total''), '), (NULL, 'Shipping Rates in Cart - Display Currency Code', 'SRIC_DISPLAY_CURRENCY_CODE', 'No', '<br />

Display the currency code in the cart<p />Useful if installed currencies share the same symbol e.g. USD and CAD', 7, 51, NULL, now(), NULL, 'zen_cfg_select_option(array(''No'', ''Yes, before price'', ''Yes, after price'', ''Yes, before price, for total only'', ''Yes, after price, for total only''), '), (NULL, 'Shipping Rates in Sidebox - Enable', 'SRIC_SIDEBOX', 'false', '<br />

Enable shipping rates in the shopping cart sidebox', 7, 52, NULL, now(), NULL, 'zen_cfg_select_option(array(''true'', ''false''), '), (NULL, 'Shipping Rates in Sidebox - Suppress', 'SRIC_SIDEBOX_SUPPRESS', 'No', '<br />


The sidebox must be suppressed during checkout.<p />Would you like the sidebox suppressed prior to checkout?', 7, 53, NULL, now(), NULL, 'zen_cfg_select_option(array(''No'', ''Yes, shopping cart page onwards'', ''Yes, sign-up/login page onwards''), '), (NULL, 'Shipping Rates in Sidebox - Display Currency Code', 'SRIC_SIDEBOX_DISPLAY_CURRENCY_CODE', 'No', '<br />


Display the currency code in the sidebox<p />Useful if installed currencies share the same symbol e.g. USD and CAD', 7, 54, NULL, now(), NULL, 'zen_cfg_select_option(array(''No'', ''Yes, before price'', ''Yes, after price'', ''Yes, before price, for total only'', ''Yes, after price, for total only''), '); in /home/fireside/public_html/2013update/includes/classes/db/mysql/query_factory.php on line 120
[15-Jun-2013 17:43:24 Europe/London] PHP Fatal error:  Class 'queryFactoryResult' not found in /home/fireside/public_html/2013update/includes/classes/db/mysql/query_factory.php on line 213

and this is the normal debug file

[15-Jun-2013 17:20:52 Europe/London] PHP Parse error:  syntax error, unexpected '<' in /home/fireside/public_html/2013update/includes/languages/english/extra_definitions/elegancer_pink/footer_menu_defines.php on line 50
[15-Jun-2013 17:20:52 Europe/London] PHP Warning:  require(includes/classes/db/mysql/query_factory.php) [<a href='function.require'>function.require</a>]: failed to open stream: No such file or directory in /home/fireside/public_html/2013update/includes/functions/sessions.php on line 54
[15-Jun-2013 17:20:52 Europe/London] PHP Warning:  require(includes/classes/db/mysql/query_factory.php) [<a href='function.require'>function.require</a>]: failed to open stream: No such file or directory in /home/fireside/public_html/2013update/includes/functions/sessions.php on line 54
[15-Jun-2013 17:20:52 Europe/London] PHP Fatal error:  require() [<a href='function.require'>function.require</a>]: Failed opening required 'includes/classes/db/mysql/query_factory.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/fireside/public_html/2013update/includes/functions/sessions.php on line 54