One of the most frustrating things is installing MySQL and then forgetting what password you set for the root user. This has happened to me on more than one occasion. You can reset the password with the following procedure. (more…)
The SQL Server Single User Mode only permits one connection to a database at a time. Great for testing, but not for deployment. Here is how you can get it out of this state. (more…)
When you backup a database and then later try to restore it, you might get a message that the database is in a restoring state. Here is how you can fix this. (more…)
How to install WordPress from the command line in Linux.
I really enjoy errors in software that occur randomly for no reason. 🙂 One that recently occurred was an installed Adobe application (InDesign) that suddenly failed to start. Reinstalling the software didn’t help. Starting the application would run Adobe Creative Cloud instead where it tried to endlessly validate a software license.
This was fixed by deleting 4 folders:
- C:\Program Files (x86)\Common Files\Adobe\Adobe PCD
- C:\Program Files (x86)\Common Files\Adobe\caps
- C:\Users\[User Name]\AppData\Local\Adobe\OOBE
Once deleted, InDesign was able to run again after I logged into Adobe with my credentials.
When you have hundreds of stores in uStore, making updates on all of them takes a very long time. This doesn’t matter if your paid by the hour, but if your in a hurry and need everything updated quickly, the manual method is not the best solution. For your information, this method is described below. The procedure can take a few minutes to complete. Multiply that by hundreds of stores and you’ll see the problem.
In the uStore admin site,
- Take store offline.
- Open Store Setting -> Set Up Store
- In the Advanced tab, select the Security Option
- Press Save & Place Online
The change can easily be made by modifying a table in the uStore database. This method isn’t recommended by Xerox and I wouldn’t recommend it either to novice database administrators. For experienced users, make a backup of the database before you make any changes. MSSQL doesn’t ask “Are you sure you want to make this change?” when you run SQL queries.
In the uStore database, you will need to modify the Store table. Each store here has an SslOption field which defaults to 0 value (see table below):
|2||Secure Critical Points|
Select which SSL option that you want and run the following SQL command:
UPDATE Store SET SslOption=@SslOption WHERE StatusID=1
UPDATE Store SET SslOption=2 WHERE StatusID=1
This updates all active stores to SSL option: Secure Critical Points
After the SQL query is run, you need to force a cache refresh. The page for this is on your your uStore at (use the IP of your server):
In Cache update, press the Refresh Localization Cache button, Refresh ACL Cache button, and Refresh General Cache button. Not sure if all of these are needed, but I’ve done this and the stores were fine afterwards. If you don’t do a manual cache refresh, this will eventually occur in uStore, but if someone opens a store in the admin site and makes a modification, you may lose the changes your SQL query made.
And that’s it. Again, if your not an experience database administrator, don’t attempt this.