Tag Archives: fix

Symantec’s CleanWipe Removes AntiVirus

Symantec’s CleanWipe is a tool that is used to prepare or clean a Windows computer before you install Symantec Endpoint Protection, or to completely remove any instance of Syamantec Antivirus. The tool comes as a executable file that unzips its contents into a folder and then runs. The password for this self-extracting executable usually is “symantec” (no quotes, all lower case).If nothing else is working when trying to remove a stuck install of a Symantec Antivirus product, CleanWipe can usually get the job done. CleanWipe…


Read MOre »

Replacing batteries inside an Symmetra Battery Unit

The battery packs on an APC symmetra have a life span of around 5 years, and replacing all of them at once is an expensive proposition. In an attempt to cut costs, I decided to replace the individual batteries that make up each unit. APCs SYBT4 part number refers to a 4 pack of the individual SYBTU1-PLP part, which is a long chassis with a handle at one end and a connector at the other. Each SYBTU1 contains eight individual batteries, and a small circuit…

Read MOre »

MySQL drops leading zeroes from imported US zip codes

After importing a table from a csv import, MySQL drops the leading zero from those codes that contain it. A quick way to fox this is to use a SQL query to update the table. Log into the correct database in phpMyAdmin and open the table in question Choose the SQL option from the tabs at the top Paste the following query in to the box UPDATE table_name SET ZipCode = concat(‘0′,ZipCode) WHERE length(ZipCode) = 4 Modify the statement to fit your situation, including table…

Read MOre »

Interspire logon fails even though password is correct after WWW redirect

Ran into this issue after modifying¬†Interspire Shopping Cart’s¬†main .htaccess file to 301 redirect non-www urls to www.domain.com . A log in to the admin section would fail each time, but using the same password after removing the www redirect would work. The problem is in the shop path variable, it must include the www part of the domain name. There are two points that this can be fixed in, by either editing the spop path under store settings, or by modifying the config.php file in…

Read MOre »

Office For Mac 2011 -Cannot Save Spreadsheet in Excel Problem

Ran into an issue on an install of Office for Mac 2011 recently. When the user attempted to save an excel spreadsheet, they would get an error as follows: – file name or path name does not exist – file is being used by another program – name is the same as another file Unfortunately these error messages were not the case- it was a new file with a unique name, and only Excel was trying to use the document. The solution was simple to…

Read MOre »