Earlier I was working on a Zen Cart site and ran into an issue installing the Ultimate SEO URL add-on. The Ultimate SEO URL add-on creates more SEO(Search Engine Optimization) friendly URL’s for Zen Cart. The site in question already had a previous version of the Ultimate SEO URL add-on installed and once I was finished the front-end of the site was working perfectly with the new SEO friendly URL’s. The problem was when I attempted to login to the admin portion of the Zen Cart site I was receiving a “500 – Internal Server Error” message. Below I have noted information on what was done to troubleshoot the problem as well as how the problem was resolved.
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 down when I got a 500 Internal Server Error back from the Apache web server. The virtual host that the client was using didn’t have Error Logs enabled so I had to enable them and wait until they started archiving. Below is a description of the errors in the Apache Error Logs and how I resolved the issue.
Adding Redmine Project Error: ActiveRecord::StatementInvalid (Mysql::Error: Unknown column projects_count in field list
I was working on a project today for a client and after the initial research I realized that the project actually warranted an entire sub project account in Redmine. The reasoning behind this was even though the project would be using the same Ruby project code as the primary project this specific side project would need to allow access to the tickets for one of our partners. The easiest way to allow the partners accounts access to only a specific set of tickets, their own wiki, etc. would be to generate a sub Redmine project underneath of the primary Redmine project. So obviously the first thing to do was to add the project so I could start configuring it and this is where I ran into the initial issue. I received an internal server error when attempting to add the sub project within Redmine. Below I describe the issue, what I think caused the issue, and the end resolution that allowed me to start adding sub projects within Redmine again.