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 at her Company Proximo Design created a webpage for me at Gourmet Burger Bistro this year. I wanted to get it up and running quickly and I could not have been more satisfied with the speed and quality of her results.
Best of luck in the future Hilary and I look forward to continuing our business relationship.
Michael Condon
Gourmet Burger Bistro

Michael Condon Owner, Gourmet Burger Bistro

October 21, 2014