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!

Comment!

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]

OR

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:

session_set_cookie_params(
$this->getCookie()->getLifetime(),
$this->getCookie()->getPath()
$this->getCookie()->getDomain(),
$this->getCookie()->isSecure(),
$this->getCookie()->getHttponly(),
);

To this:

session_set_cookie_params(
//$this->getCookie()->getLifetime(),
$this->getCookie()->getPath()
//$this->getCookie()->getDomain(),
//$this->getCookie()->isSecure(),
//$this->getCookie()->getHttponly(),
);

Helpful page at http://amilan.wordpress.com/2009/05/07/can%E2%80%99t-login-to-magento-admin-after-installation/

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

;extension=php_curl.dll

to

extension=php_curl.dll

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

Helpful page at http://stackoverflow.com/questions/1347146/how-to-enable-curl-in-php

Comment!

← Older Newer →

Back to Top

Random Web Design Testimonials

“Hilary is personable and easy to work with. She has helped us over the last 15 years with our website and graphics. Nothing is a problem. She is reliable and trustworthy. We would recommend her.”

Laura Jane Walsh - Manager at Lindas Of Kinsale

February 28, 2014