So, you’re pulling your hair out. You’re creating a new Magento theme, you have cacheing turned off or you’ve deleted your cache, it’s all working perfectly expect for SOME products and only on the single product page lisitng.

Turns out Magento hard-coded some old theme values into the database, so you will need to do the following:

  • Go to the table catalog_product_entity_varchar using phpmyadmin
  • Search for default/oldthemename
  • Select all the fields in your results, click edit
  • Now change the text ‘default/oldthemename’ to ‘default/newthemename’

Voila it wasn’t the cache at all, and the products should now appear with the new theme applied!


I just spent a while figuring out how to re-create the Magento shopping cart on my own server for testing/tweaking before upload, so the below might help anyone else!

General setup and database

  • Download the contents of the database by exporting as an sql file from the remote server
  • Create local database and import the sql file to create your tables
  • Under the ‘var’ folder, delete ‘cache’ and ‘session’ folders entirely
  • To hook up system with your local database, edit the file found at app>etc>local.xml (I recommend saving a copy of the remote file as local_remoteserver.xml for your own records)

Clean Url’s

  • If clean urls have been set up, but are not working on your server, try editing the htaccess file.

Your Rewrite rule may look like this:

RewriteRule ^(.*)$ /index.php?q=$1 [L,QSA]

Edit it to read:

RewriteRule ^(.*)$ /subfolder/index.php?q=$1 [L,QSA]


If it looks like this:

RewriteRule .* index.php [L]

Edit it to read

RewriteRule .* /subfolder/index.php [L]

Admin login problems

403 error page

Edit cookie settings at app>code>core>Mage>Core>Model>Session>Abstract>Varien.php

Change this:


To this:


Helpful page at

PHP memory limit error

Check your .htaccess file, and uncomment:

# php_value memory_limit xM
# php_value memory_limit xM
# php_value max_execution_time x

The same as above, just a hash symbol and space before the line, ignore the x I just don’t know the original values! By un-commenting this you avoid conflicts with your local php.ini file.

PHP Curl error

Using xammp, just uncomment the line




Located at xampp\apache\bin\php.ini, and then restart the Apache service.

Helpful page at


← Older Newer →

Back to Top

Random Web Design Testimonials

“I worked with Hilary for a time and during that period I found her to be extremely helpful and articulate. Her work was of highest standard and I was also able to observe how she interacted with her clients. While providing a top class service she maintained friendly and helpful services with them, listened to what they wanted and made appropriate suggestions. Hilary also assisted me with my work and provides services to the local community at large. I have no hesitation in recommending Hilary for any work.”

Andrea Harte - Undergraduate at University of Limerick

January 21, 2011, Andrea worked directly with Hilary at Proximo Web Design