Upgrade issues (Version 11-sp2r3) Error creating [/en-US]!

[b2tech]

Hello,

Recently upgraded my test shopsite installation and it worked fine. Then ran the upgrade on the production site. The permission and directory checks passed. The upgrade started, then ended with an error.

The store is working but the admin back-end is not loading properly. It's like the admin template is not loading the required javascript and css files.

Here's two among a list of many more similar undefined / missing javascript errors in admin section:

Code: Select all

ReferenceError: memorize_menu_configuration is not defined
ReferenceError: set_menu_globals is not defined


Installation error:

Code: Select all

...
  done.
    Added fields to sbdata.aa
   Installing file [prod_search_list.aa] from [data] in [/home/username/ssdata]...
    /bin/tar -xf /home/username/public_html/cgi-bin/data.tar prod_search_list.aa
  done.
    Added fields to world.aa
   Creating [/en-US]...

[mystoreid]   Error creating [/en-US]!

Problem with image path (/en-US)


Re-running the installation completes successfully saying the files were already updated.

Code: Select all

BACKING UP DIRECTORIES...


   Backing up [/home/username/public_html/cgi-bin/sc] to [sc.11.2.3.tar]...

[mystoreid]     - backup file sc.11.2.3.tar already exists, no backup performed.


[mystoreid]   Error 0: Success

   Backing up [/home/username/public_html/cgi-bin/ss] to [ss.11.2.3.tar]...

[mystoreid]     - backup file ss.11.2.3.tar already exists, no backup performed.


[mystoreid]   Error 0: Success

 Backing up data directory for store mystoreid
   Backing up [/home/username/ssdata] to [data.11.2.3.tar]...

[mystoreid]     - backup file data.11.2.3.tar already exists, no backup performed.


[mystoreid]   Error 0: Success

UPDATING SHOPPING CART DIRECTORY
Shopping Cart directory already updated
UPDATING SHOPSITE DIRECTORY
ShopSite directory already updated
UPDATING LANGUAGE PACKS in /home/username/public_html/cgi-bin/ss
Updating en-GB to en-GB
 en-GB found, updating
Updating en-UK to en-GB
Updating en-US...
Updating en-GB...
Updating en-CA...
Updating en-AU...
Updating en-CX...
Updating en-IE...
Updating en-JA...
Updating en-NZ...
Updating en-ZA...
Updating en-EU...
UPDATING STORE(S)
 Updating html directory for store mystoreid
    HTML Path = /home/username/public_html/store
   Installing file [media] from [html] in [/home/username/public_html/store]...
    /bin/tar -xf /home/username/public_html/cgi-bin/html.tar media
  done.
 Updating data directory for store mystoreid
    Data Path = /home/username/ssdata
Data dir /home/username/ssdata already updated.


So... What would need to be done in order to get the admin section working?

Thanks for any input.

[Jim]

What version of ShopSite were you upgrading from?
What was the locale the that store was configured for. ? en-US, en-UK, en-EU etc.
What operating system is the store running on?

The messages that you posted saying that the store was already upgraded were messages about the backup process not the actual upgrade. Were there messages farther down saying that directories were updated?

To rerun the upgrade you will need to remove any "VERSION" file that exist in the following locations.
sc and ss cgi directories, ss/nls directory, store's data directory, shopsite-images directory (and any subdirectories of it). You should then be able to run the upgrade again after renaming the store.bak file in the install directory to store.auth.

Where is your store hosted? Have you checked with them about the upgrade?

[b2tech]

Thanks for the suggestions.

Upgrading from shopsite version 11-sp1r2
Locale is set to en-US
OS: CentOS

I re-ran the upgrade after moving the VERSION files and it completed with the same messages. The admin section still loads with errors.

Update output:

Code: Select all

UPDATING SHOPPING CART DIRECTORY
   Moving old templates...
   mv -f /home/username/public_html/cgi-bin/ss/templates /home/username/public_html/cgi-bin/sc
  done.
   Installing [sccgis] in [/home/username/public_html/cgi-bin/sc]...
    /bin/tar -xf /home/username/public_html/cgi-bin/sccgis.tar
  done.
UPDATING SHOPSITE DIRECTORY
   Installing [sscgis] in [/home/username/public_html/cgi-bin/ss]...
    /bin/tar -xf /home/username/public_html/cgi-bin/sscgis.tar
  done.
UPDATING LANGUAGE PACKS in /home/username/public_html/cgi-bin/ss
Updating en-GB to en-GB
 en-GB found, updating
Updating en-UK to en-GB
Updating en-US...
Updating en-GB...
Updating en-CA...
Updating en-AU...
Updating en-CX...
Updating en-IE...
Updating en-JA...
Updating en-NZ...
Updating en-ZA...
Updating en-EU...
UPDATING STORE(S)
 Updating html directory for store storeid
    HTML Path = /home/username/public_html/store
   Installing file [media] from [html] in [/home/username/public_html/store]...
    /bin/tar -xf /home/username/public_html/cgi-bin/html.tar media
  done.
 Updating data directory for store storeid
    Data Path = /home/username/ssdata
Data dir /home/username/ssdata already updated.

The update has been completed


To view the latest enhancements in this release go to:


Is there some way to replace or overwrite the files that control the admin interface?

Looking at the source in the admin section:
Test header (upgrade worked)

Code: Select all

<title>Locale</title>
<link rel="stylesheet" href="http://test.example.com/store/shopsite-images/en-US/css/backoffice_new.css?1336598758" type="text/css">
<script type="text/javascript" language="JavaScript" src="http://test.example.com/store/shopsite-images/en-US/javascript/cookies.js?1271356753"></script>
<script type="text/javascript" language="JavaScript" src="http://test.example.com/store/shopsite-images/en-US/javascript/buttons.js?1271356753"></script>
<script type="text/javascript" language="JavaScript" src="http://test.example.com/store/shopsite-images/en-US/javascript/dropdown_menu.js?1299094202"></script>
<script type="text/javascript" language="JavaScript">
var image_backoffice_url = 'http://test.example.com/cgi-bin/ss';
</script>

<script type="text/javascript" language="JavaScript"
 src="http://test.example.com/store/shopsite-images/en-US/javascript/image_picker/select_image.js">
</script>


Live admin header (missing javascripts..)

Code: Select all

<title>Locale</title>
<script type="text/javascript" language="JavaScript">
var image_backoffice_url = 'https://www.example.com/cgi-bin/ss';
</script>

<script type="text/javascript" language="JavaScript"
 src="https://www.example.com/store/shopsite-images/en-US/javascript/image_picker/select_image.js">
</script>


I have been in contact with the host but have not been able to get the admin section working.

[Jim]

I assume that you tweaked what you posted to the forum so references like /home/username/public_html/store and /home/username/ssdata and /home/username/public_html/cgi-bin/sc, etc. have been modified from what was actually on the page by putting "username" in place of the actual value?

This section of the log bothers me.

Code: Select all

    Data Path = /home/username/ssdata
Data dir /home/username/ssdata already updated.


The "already updated" indicates that the VERSION file had not been removed from the store's data directory when the upgrade was rerun.

Since it appears that the styles are not being replaced, it is information in the shopsite-images location that are not being updated. Do you have access to that location by ftp or ssh so you can check the permissions of the files and directories within the shopsite-images location?

I just ran an upgrade on my 11sp2 store and here is what is being done when updating the LANGUAGE PACKS for en-US local.

Code: Select all

Updating en-US...
   Installing file [copylist] from [en-US] in [/home/jim/11sp2/ss/nls/en-US]...
    /bin/tar -xf /archive/jim/11sp2/en-US.tar copylist
  done.
   Installing file [countries.dat] from [en-US] in [/home/jim/11sp2/ss/nls/en-US]...
    /bin/tar -xf /archive/jim/11sp2/en-US.tar countries.dat
  done.
   Installing file [sborder.dat] from [en-US] in [/home/jim/11sp2/ss/nls/en-US]...
    /bin/tar -xf /archive/jim/11sp2/en-US.tar sborder.dat
  done.
   Installing file [sbreceipt.dat] from [en-US] in [/home/jim/11sp2/ss/nls/en-US]...
    /bin/tar -xf /archive/jim/11sp2/en-US.tar sbreceipt.dat
  done.
   Installing file [sbship.dat] from [en-US] in [/home/jim/11sp2/ss/nls/en-US]...
    /bin/tar -xf /archive/jim/11sp2/en-US.tar sbship.dat
  done.
   Installing file [sbthanks.dat] from [en-US] in [/home/jim/11sp2/ss/nls/en-US]...
    /bin/tar -xf /archive/jim/11sp2/en-US.tar sbthanks.dat
  done.
   Installing file [states.dat] from [en-US] in [/home/jim/11sp2/ss/nls/en-US]...
    /bin/tar -xf /archive/jim/11sp2/en-US.tar states.dat
  done.
   Installing file [stoplist.dat] from [en-US] in [/home/jim/11sp2/ss/nls/en-US]...
    /bin/tar -xf /archive/jim/11sp2/en-US.tar stoplist.dat
  done.
   Installing file [ShopSiteMsg.cat] from [en-US] in [/home/jim/11sp2/ss/nls/en-US]...
    /bin/tar -xf /archive/jim/11sp2/en-US.tar ShopSiteMsg.cat
  done.
   Updating en-US/isp.aa
  done.
   Installing [en-US-images] in [/home/jim/11sp2/html/jimsp2/shopsite-images/en-US]...
    /bin/tar -xf /archive/jim/11sp2/en-US-images.tar
  done.
Updating en-GB...

I don't see that in your post, did you just leave it out or did it not happen?

I would try removing all VERSION files again, copying store.bak to store.auth in the install directory, and rerunning the upgrade. There are VERSION files in the following locations:

Code: Select all

./ss/nls/en-US/VERSION
./ss/VERSION
./sc/VERSION
./html/shopsite-images/en-US/VERSION
./data/jimsp2/VERSION

Note that you will need to check what the actual paths to the locations that match your store's info for these files.

[b2tech]

Thanks for the suggestions...

The 'copylist', 'countries.dat' etc were included in the installation after removing the additional VERSION files.
*Except there was no entry for en-US-images:

Code: Select all

Installing [en-US-images] ...


It's still getting the install error. It's not clear where the installer is attempting to create the en-US directory... It shouldn't be in the root. It seems like there's some sort of permission error.. All the 'permission checks' pass. I've set permissions to 777 for cgi-bin/ss/nls/en-US and store/shopsite-images/en-US and their parent directories. But there's still errors creating "/en-US"... Any other suggestions...?

Error:

Code: Select all

   Creating [/en-US]...

[storeid]   Error creating [/en-US]!


Installation output:

Code: Select all

BACKING UP DIRECTORIES...


   Backing up [/home/username/public_html/cgi-bin/sc] to [sc.11.2.3.tar]...

[storeid]     - backup file sc.11.2.3.tar already exists, no backup performed.


[storeid]   Error 0: Success

   Backing up [/home/username/public_html/cgi-bin/ss] to [ss.11.2.3.tar]...

[storeid]     - backup file ss.11.2.3.tar already exists, no backup performed.


[storeid]   Error 0: Success

 Backing up data directory for store storeid
   Backing up [/home/username/ssdata] to [data.11.2.3.tar]...

[storeid]     - backup file data.11.2.3.tar already exists, no backup performed.


[storeid]   Error 0: Success

UPDATING SHOPPING CART DIRECTORY
   Moving old templates...
   mv -f /home/username/public_html/cgi-bin/ss/templates /home/username/public_html/cgi-bin/sc
  done.
   Installing [sccgis] in [/home/username/public_html/cgi-bin/sc]...
    /bin/tar -xf /home/username/public_html/cgi-bin/sccgis.tar
  done.
UPDATING SHOPSITE DIRECTORY
   Installing [sscgis] in [/home/username/public_html/cgi-bin/ss]...
    /bin/tar -xf /home/username/public_html/cgi-bin/sscgis.tar
  done.
UPDATING LANGUAGE PACKS in /home/username/public_html/cgi-bin/ss
Updating en-GB to en-GB
 en-GB found, updating
Updating en-UK to en-GB
Updating en-US...
   Installing file [copylist] from [en-US] in [/home/username/public_html/cgi-bin/ss/nls/en-US]...
    /bin/tar -xf /home/username/public_html/cgi-bin/en-US.tar copylist
  done.
   Installing file [countries.dat] from [en-US] in [/home/username/public_html/cgi-bin/ss/nls/en-US]...
    /bin/tar -xf /home/username/public_html/cgi-bin/en-US.tar countries.dat
  done.
   Installing file [sborder.dat] from [en-US] in [/home/username/public_html/cgi-bin/ss/nls/en-US]...
    /bin/tar -xf /home/username/public_html/cgi-bin/en-US.tar sborder.dat
  done.
   Installing file [sbreceipt.dat] from [en-US] in [/home/username/public_html/cgi-bin/ss/nls/en-US]...
    /bin/tar -xf /home/username/public_html/cgi-bin/en-US.tar sbreceipt.dat
  done.
   Installing file [sbship.dat] from [en-US] in [/home/username/public_html/cgi-bin/ss/nls/en-US]...
    /bin/tar -xf /home/username/public_html/cgi-bin/en-US.tar sbship.dat
  done.
   Installing file [sbthanks.dat] from [en-US] in [/home/username/public_html/cgi-bin/ss/nls/en-US]...
    /bin/tar -xf /home/username/public_html/cgi-bin/en-US.tar sbthanks.dat
  done.
   Installing file [states.dat] from [en-US] in [/home/username/public_html/cgi-bin/ss/nls/en-US]...
    /bin/tar -xf /home/username/public_html/cgi-bin/en-US.tar states.dat
  done.
   Installing file [stoplist.dat] from [en-US] in [/home/username/public_html/cgi-bin/ss/nls/en-US]...
    /bin/tar -xf /home/username/public_html/cgi-bin/en-US.tar stoplist.dat
  done.
   Installing file [ShopSiteMsg.cat] from [en-US] in [/home/username/public_html/cgi-bin/ss/nls/en-US]...
    /bin/tar -xf /home/username/public_html/cgi-bin/en-US.tar ShopSiteMsg.cat
  done.
   Updating en-US/isp.aa
  done.
Updating en-GB...
Updating en-CA...
Updating en-AU...
Updating en-CX...
Updating en-IE...
Updating en-JA...
Updating en-NZ...
Updating en-ZA...
Updating en-EU...
UPDATING STORE(S)
 Updating html directory for store storeid
    HTML Path = /home/username/public_html/store
   Installing file [media] from [html] in [/home/username/public_html/store]...
    /bin/tar -xf /home/username/public_html/cgi-bin/html.tar media
  done.
 Updating data directory for store storeid
    Data Path = /home/username/ssdata
   Installing file [shopsite_db.default] from [data] in [/home/username/ssdata]...
    /bin/tar -xf /home/username/public_html/cgi-bin/data.tar shopsite_db.default
  done.
   Installing file [upgrade_cr.dat] from [data] in [/home/username/ssdata]...
    /bin/tar -xf /home/username/public_html/cgi-bin/data.tar upgrade_cr.dat
  done.
       updating database [shopsite_db]...
          Update not needed for [shopsite_db]
       converting coupon/product links to sql...
       updating orders database...
       updating products database...
       updating Quantity Pricing...
.       updating Page Width...
   Installing file [state_zips.dat] from [data] in [/home/username/ssdata]...
    /bin/tar -xf /home/username/public_html/cgi-bin/data.tar state_zips.dat
  done.
   Installing file [qbtypes.dat] from [data] in [/home/username/ssdata]...
    /bin/tar -xf /home/username/public_html/cgi-bin/data.tar qbtypes.dat
  done.
   Installing file [fedex_eula.dat] from [data] in [/home/username/ssdata]...
    /bin/tar -xf /home/username/public_html/cgi-bin/data.tar fedex_eula.dat
  done.
   Installing file [EUvat.dat] from [data] in [/home/username/ssdata]...
    /bin/tar -xf /home/username/public_html/cgi-bin/data.tar EUvat.dat
  done.
   Installing file [bo_ui.xml] from [data] in [/home/username/ssdata]...
    /bin/tar -xf /home/username/public_html/cgi-bin/data.tar bo_ui.xml
  done.
    Added fields to sbdata.aa
    Added fields to world.aa
   Creating [/en-US]...

[storeid]   Error creating [/en-US]!

Problem with image path (/en-US)

The update has been completed


[Jim]

I wonder if you have an incorrect path configured for the shopsite-images on the Preferences > Hosting services page. Note that it is trying to create a /en-US directory, which indicates it is trying to create it in the root directory. The placement of the error in the log looks odd. At that point on my upgrade the entire upgrade is complete and I don't see anything about updating or creating an en-US directory.

There should be 2 en-US/ directories one is the ss/nls/en-US/. The other is shopsite-images/en-US/ where shopsite-images is probably at the same directory level of your html pages and the media directory.

[loren_d_c]

If there is a wwwinstall.aa file in the directory you are executing the upgrade from, either delete it (it's there for convenience, not really necessary to the upgrade) or edit it to make sure the value of the 'image_dir:' token contains the correct and full path to your store's shopsite-images directory.

Also, check the value of the 'image_dir:' token in the main ShopSite settings file for your store, which is named [your_storeid].aa in the ShopSite CGI directory (usually named 'ss'). This should also contain the correct and full path to your store's shopsite-images directory.

After you have fixed one or both of these settings, delete the VERSION file from the shopsite-images/en-US/ directory (if there is a VERSION file there) and re-run the upgrade.

If you still have the same error when you upgrade then I have no idea where that incorrect path to the en-US directory is coming from. the only thing I could suggest in that case is if you have shell/commandline access to the hosting account would be to take the en-US-images.tar file from the installation files and put it in the shopsite-images/en-US/ directory and manually untar it there.

-Loren

[b2tech]

Ok - the install completed successfully! Thank you Jim and Loren for helping troubleshoot.

For some reason, the "image_dir:" in storeid.aa was blank.

Setting image_dir to /home/username/public_html/shopsite-images, removing wwwinstall.aa and re-running the upgrade worked. The admin section is loading correctly now.