shipping rates no longer work

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

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

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 :?

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

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

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.95,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.00,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.95,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.00,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?

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

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?

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

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

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

evilonion:

[CODE][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

This looks like you have one or more 'corrupted' files. The error above is the 1st error you'll need to take care of, which may or may not take care of the errors that follow (these things have a cascading effect).

You'll need to work through the error messages one at a time 'cos you may have more than one problem.

Cheers
Rod

the first one would be my error as i was trying to comment out some of the template parts like twitter etc.
i have removed the code i added so that should work now.

As for the second im not sure how to fix that?

this is the error:

[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

and this is the code for that part:

  function _sess_write($key, $val) {
    global $db;
    if (!is_object($db)) {
      //PHP 5.2.0 bug workaround ...
      if (!class_exists('queryFactory')) require('includes/classes/db/' .DB_TYPE . '/query_factory.php');
      $db = new queryFactory();
      $db->connect(DB_SERVER, DB_SERVER_USERNAME, DB_SERVER_PASSWORD, DB_DATABASE, USE_PCONNECT, false);
    }
    $val = base64_encode($val);

ok it wouldnt be too much hassle for me to build this site again.
I can create a completely new, empty database and link the site to it...
This 'should' solve the issues as the database would be clean...

Is there a way for me to move all the customer and order information over though?
The main thing for me is to move this data across as there are over 5000 current customers and orders that i would need to keep.

Things like the added ezpages etc i would just have to manually recreate.

evilonion:

this is the error:

PHP Warning: require(includes/classes/db/mysql/query_factory.php) * No such file or directory *

Question#1. Do you have a file called "query_factory.php" in the folder called "includes/classes/db/mysql/query_factory.php"

If not, where is it, and why isn't it where it should be? Didn't get uploaded perhaps?

If this file does exist, what are its file permissions?

The code snippet you gave was from the file that is trying to load the missing file (/includes/functions/sessions.php is fine. query_factory.php is the missing/unreadable one).

Cheers
Rod

evilonion:

ok it wouldnt be too much hassle for me to build this site again.
I can create a completely new, empty database and link the site to it...
This 'should' solve the issues as the database would be clean..

This is assuming that your problem is with the database contents. There is no reason to make this assumption, but plenty of reasons to think that the database is probably ok.

IF you do what you are proposing, what I expect is that you will have the exact same problems, but now they'll be compounded by having an empty database.
That's if you are lucky. If you are unlucky you'll just kill the site stone dead.

evilonion:

Is there a way for me to move all the customer and order information over though?
The main thing for me is to move this data across as there are over 5000 current customers and orders that i would need to keep.

I always suggest people learn how to use phpmyadmin (or similar SQL admin tool) for this. You shouldn't need it though, unless this reply comes too late.

On the other hand, you did backup your database before performing your update, didn't you? If not, do it now before doing anything else. This is your lifeboat to ensure that even if things go drastically wrong you can easily recover.

evilonion:

Things like the added ezpages etc i would just have to manually recreate.

If these also aren't currently working then perhaps there are missing files for those too?

All evidence so far suggests that something went amiss with your update, and not all files have been uploaded (or not uploaded into the correct places).

Take a close look at the file paths as well as the file names in the error messages. There may be subtle differences between what should be, and what is.

Cheers
Rod

Thanks rod.
I havent deleted anything yet. The main site is still live as its a very busy fabric shop.
I'm doing all this in a replicated database with a new store in a renamed folder. That way i can get it running 100% then just rename the folder and the config files.

I'll take a look for the factory.php file. I dont even know what that is tbh...

i have just checked and the file is there...
its permissions are 644

It would appear that was relating to 'ssu' which is no longer supported but also seo urls which i have now installed.
Shipping still doesnt display though.

Is there a way to refresh the logs? Or will it only create new logs if different errors are created?

edit:
with shipping estimator added to the cart you can click a button and see how much postage should cost... it doesnt add it to the overall cart though.

just to add another update, i have tried using the old factory.php file from 1.3.9 but it still doesnt work.
win merge shows the files as being almost the same, just slightly different in places.

is there a way of taking this section along with the database back to standard?
I dont know how to repair this part :/

evilonion:

i have just checked and the file is there...
its permissions are 644

Refresh my memory. What file are you/we referring too, and in what location are you finding it? (yes, I know I can look back at the previous posts to see what was written, but what I want/need to know is what you are actually looking at.

It's not that I doubt you, but as I suggested, subtle changes can make big differences.

/public_html/2013update/includes/functions/sessions.php
is not the same as
/public_html/includes/functions/sessions.php I want you to 'convince' me that the file you "have just checked and the file is there" is the same one I say should be there, and that you aren't referring to the other one, which could also 'be there'. If you find 'its there' in both folders then we have a real problem.

Cheers
Rod