shipping rates no longer work

[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

[evilonion]

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.

[evilonion]

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

[RodG]

It would appear that was relating to 'ssu' which is no longer supported

There is/was *nothing* in the log file that you posted that suggested that this was involved in any way. I acknowledge that it may have been further down in the log file (these can get quite large, and we don't need to see them all), but wasn't my 1st piece of advice:

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

You have somehow managed to skip the error reported by 'session.php' error and gone of on a wild tangent with something that may or may not have been something that needed to be fixed separately from any previous fixes. If you wish to have any hope of a recovery you must work in precise *logical* steps. If you can't do that, then give up all recovery attempts now. It will be quicker to re-install a fresh system (keeping your existing database of course).

but also seo urls which i have now installed.

BIG MISTAKE. You should fix the problems you already have before adding more stuff that can only make matters worse.

Shipping still doesnt display though.

I'm a wee bit surprised much of anything at all is working really. The sessions.php file (and the files that *it* loads, eg, query_factory.php) are essential for the store to function.

It is also for this reason you shouldn't go messing with things hoping to stumble across a fix. I fear that your store is in a very precarious state at the moment and that it could be reading some files from /public_html/2013update/includes/functions/sessions.php and some from /public_html/includes/functions/sessions.php, or any one of an infinite number of other variants/possibilities.

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

Yeah. Just delete them. New ones will be create is/when further errors occur.

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.

This could be a matter of the shipping not being enabled in the modules->order_total settings.

Anyway, so exactly where are we up to now? From the way I'm reading things, I'm not sure exactly what you've done, but it now all seems to be working correctly (other than the final total addition?). If this isn't correct, please supply a copy of the first few entries and any 'new' error logs and we'll continue the debugging from there.

Cheers
Rod