v3 Updates

CAUTION!

With ANY update to SuperSalon, be sure to check both the system capabilities of the PC size AND the size of the database. If the database is too large (over 500 MB), and the system specs are sub-par, the update will most likely not be possible on that machine!!

Update Procedure

Step 1: Backup Data

1. Close SuperSalon

2. Go to C:\Super Salon\Mysql\Data

3. Copy the SSPOS folder. Paste into Backup folder on Desktop

4. Check C:\Super Salon\ for an “Active Charge” or “Pc-Charge” folder

5. If you find one back it up to the same desktop folder.

Step 2: Download Update Files

• https://ioffice.supersalon.com/update/Old_Updates/v5_prepatch.exe

• https://ioffice.supersalon.com/update/Old_Updates/SuperSalon-5.5.26.4-18125.exe

• https://ioffice.supersalon.com/update/Old_Updates/update_php516.exe

• https://ioffice.supersalon.com/update/Old_Updates/firefox2_0_0_3.exe

Step 3: Update PHP

1. Run the update_php516.exe update.

2. Stop Apache and Mysql

3. Go to C:\SuperSalon\ssproject and run the php516 file.

4. Start Apache and Mysql.

5. Go to C:\SuperSalon\Apache\conf and open the httpd.conf file in notepad

6. Ctrl+F search for ScriptAlias /php/ “c:/SuperSalon/php5/”

7. Change the line so that it reads ScriptAlias /php/ “c:/SuperSalon/php516/” close and save.

8. Stop then Start Apache and Mysql.

9. Check the version by going to http://localhost/scripts/phpinfo.php and verify that the version running is 5.1.6

Step 4: Update Firefox

1. Run the firefox2-0-0-3.exe file

2. If all goes well it should ask you if you want to import any settings when you open SuperSalon again. Select No.

3. It will ask you if you want to make firefox your default browser. Select Yes.

4. OPEN SS After Every patch to let the scripts run, once complete close SS and run next patch

Step 5: Run Pre Patches and Scripts

1. Run the v5_prepatch.exe

2. Run the 5.5.26.4 patch and wait for it to complete the update process

3. Once 5.5.26.4 is up and running, run the 5.6.1.x (or latest) update

Step 6: Clean-Up

1. Remove install files from desktop

2. CHANGE ADMIN VERSION AND UPDATE FILE. Seriously, miss this step and Support will not be happy. Back patching is not fun to fix.

3. Clear the Mozilla cache

4. Run DB checkers

5. Re-Register Software / Set Owner Password

Step 7: Software Changes

There are a lot of changes to the system that come along with v5. Here is a checklist of items you need to work on with the customer.

• Tax Setup: The tax system has changed. Make sure the proper settings are entered

• Wait time: Old systems(lets face it, you’re updating from v3, you’re using an older system) have a hard time with wait time calcs.

• Permissions: Lots of new permissions have been added to the system. Make sure they are set accordingly.

• The Padlock: Review with the customer how the password save feature works. Adjust settings to their liking.

• Appointments: The Appointment system received a huge overhaul. Train accordingly.

• IOffice: Lots of new features will be available to the owner now on ioffice for this store.

Possible Errors while Running the 5.5.26.4 Update

If you look in the original error, it had to do with a failed in clause — (psuedo code) SELECT WHERE id IN (1,2,3,4,). The error being the final comma.

With the knowledge of the SuperSalon database, you can see that its querying the sales table (sale, transaction, ticket, etc) and the only field that would contain that type of data would be the other field in the transaction table.

Using the given saleID, query for all transactions in the transaction table with the corresponding id. Then, the offending data can be found and corrected (removed the trailing comma). This or a similar fix can be performed when the error message appears. There is no need to reload the v3 db, correct the data, then re-update.