Error in 11 SP2R4 upgrade

[aisg]

I ran the wwwinstall.cgi script and it ran for quite a bit and the hung up on the database update. This is on a shared Linux hosting site.
I am upgrading from ShopSite 11 to 11Sp2R4. The system log says:
Timeout waiting for output from CGI script /home/cluster1/data/g/j/a9/cgi-bin/ssinstall11sp2/wwwinstall.cgi
ap_content_length_filter: apr_bucket_read() failed

UPDATING STORE(S)
Updating html directory for store "your store"
HTML Path = /home/cluster1/data/g/j/a9/html
Installing file [media] from [html] in [/home/cluster1/data/g/j/a9/html]...
/bin/tar -xf /home/cluster1/data/g/j/a9/cgi-bin/ssinstall11sp2/html.tar media
done.
Updating data directory for store "your store"
Data Path = /home/cluster1/data/g/j/a9/shopsite-data
Installing file [shopsite_db.default] from [data] in [/home/cluster1/data/g/j/a9/shopsite-data]...
/bin/tar -xf /home/cluster1/data/g/j/a9/cgi-bin/ssinstall11sp2/data.tar shopsite_db.default
done.
Installing file [upgrade_cr.dat] from [data] in [/home/cluster1/data/g/j/a9/shopsite-data]...
/bin/tar -xf /home/cluster1/data/g/j/a9/cgi-bin/ssinstall11sp2/data.tar upgrade_cr.dat
done.
updating database [shopsite_db]...
Update not needed for [shopsite_db]
updating orders database...
updating products database...
updating Quantity Pricing...
............................................................
.....

[Jim]

Sounds like your account doesn't have much CPU time allowed to it or you have a huge database.
Try running the upgrade again, it should skip the parts that it completed so it won't take as long to run as it did the first time.

[aisg]

That log was from the second run. Got stuck in the same place. However, I am able to access everything again. Is there any checks I can do to verify that the upgrade was completely completed? I see new changes in the Back Office and it does say ShopSite® Pro 11 sp2 r4.

How much more should there have been after the database update?

[Jim]

After the lines you posted I see the following.

Code: Select all

        updating database [shopsite_db]...
          Update not needed for [shopsite_db]
       updating orders database...
       updating products database...
       updating Quantity Pricing...
       updating Page Width...
   Installing file [state_zips.dat] from [data] in [/home/jim/11sp2/data/sp2lte]...
    /bin/tar -xf /archive/jim/11sp2/data.tar state_zips.dat
  done.
   Installing file [qbtypes.dat] from [data] in [/home/jim/11sp2/data/sp2lte]...
    /bin/tar -xf /archive/jim/11sp2/data.tar qbtypes.dat
  done.
   Installing file [fedex_eula.dat] from [data] in [/home/jim/11sp2/data/sp2lte]...
    /bin/tar -xf /archive/jim/11sp2/data.tar fedex_eula.dat
  done.
   Installing file [EUvat.dat] from [data] in [/home/jim/11sp2/data/sp2lte]...
    /bin/tar -xf /archive/jim/11sp2/data.tar EUvat.dat
  done.
   Installing file [bo_ui.xml] from [data] in [/home/jim/11sp2/data/sp2lte]...
    /bin/tar -xf /archive/jim/11sp2/data.tar bo_ui.xml
  done.
    Added fields to sbdata.aa
    Added fields to world.aa
/code]
It is hard to say if the upgrade finished and the output didn't come to the screen of if it actually did not complete.
The Quantity Pricing part would have changed any products which had the old quantity pricing format with multiple items in a single field to the new format where things are broken out to individual fields.
I don't remember for sure what the Page width fixes. 
state_zips.dat  would have installed a new version of the zip fields used if you have Tax by Zip Enabled.
qbtypes.dat deals with product information for Quick Books compatibility.
fedex_eula.dat  us a new end user license agreement for FedEx
EUvat.dat  is used if you are using the VAT tax method in the EU.
bo_ui.xml is the menus for the backoffice dropdown navigation. 
  YOu could check and see if the new features are listed in the backoffice navigation dropdown.  For example there should be Merchandising > Product Reviews  with Configure , LIst all, Pending Reviews underneath that option.

I don't remember which new fields were added to sbdata.aa and world.aa, which are the last two things updated.
There is a file in the store's datadirectory called config.aa which contains the last version info.  It should be something like
[code]prev_level: 11
version: 11.2.4
run_level: 11

I'm not sure if that is the last file updated but I think it is. So if the version: in that file has 11.2.4 you are probably safe in saying the update completed.

[aisg]

The VERSION file and world.aa both have 11.2.4 in it so that is encouraging. The VERSION file updated the same time as sbdata.aa and world.aa so things look ok so far. Nothing in the backoffice is having an issue and the Product Review option is there.

Thanks!