Earlier when mirroring a Zen Cart online store for a customer to work on some custom modifications for him I ran into an error when attempting to visit the site in a web browser. The issue relates to Rewrite rules in the .htaccess file which I was able to easily track down by viewing the…
I always forget specific MySQL syntax including creating a MySQL user and granting that user specific access only via localhost to a specific database. So when I install Zen Cart I always end up looking how to do this via the MySQL documentation. Below are simple instructions on how to create a MySQL database using…
A client of mine contacted me earlier because he was unable to add products to his Zen Cart store. I recently installed a couple modules for him and was thinking that the issue may be related to one of the modules however this did not end up being the case. After some investigation I was…
A couple days ago I installed the Zen Cart Simple SEO URL add on for a client of mine. The SSU Zen Cart admin page was blank after following the instructions attempting to trigger the final installation steps by visiting a specific page in the Zen Cart admin. It appears I missed reading the “requirements”…
I was hired to install some ZenCart plugins recently one of which included the Simple SEO URL add on. The installation was fairly easy besides a dependency that was missing which I will describe in a future email. After the installation was complete I got excited when I was ready to test but was let…
The error in the title causes all pages on a ZenCart installation to display this followed by a SQL select statement. The error is related to the Ultimate SEO URL’s ZenCart addon. The issue could be caused by one of two things which are the SEO URL cache is corrupted for some reason or the…
When upgrading ZenCart it is easy to miss certain files during the merge process of the upgrade. There are numerous directories that are easy to look over but two directories to note include the includes/modules/YOUR_TEMPLATE/ and includes/languages/english/YOUR_TEMPLATE directories. It is easy to overlook files that may have been modified in either of these locations. The…
I have been doing some work on a ZenCart store based in the UK. The default currency is pounds and in various places the pound symbol was showing as an HTML entity instead of the actual pound symbol. To resolve this issue simply change the HTML entity to the actual symbol. Pound HTML Entities: £…
During verifying some upgrades I had made to a ZenCart store I ran into some issues during checkout with a couple accounts. The issue was that my browser would get caught in a redirect loop after I added contents to my shopping cart and then attempted to checkout. At first I thought the issue may…