shipping rates no longer work

[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

[RodG]

[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

[evilonion]

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);

[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...

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.

[RodG]

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.

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.

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

[evilonion]

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...

[evilonion]

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

[RodG]

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