Magento core_config_data not loaded in backend

Guest Author: Rico Neitzel, http://buro71a.de/

I sometimes have the following strange behaviour in Magento:

Config not loaded in Backend

  1. I do have valid config entries in core_config_data Table
  2. The backend in System -> Config doesn't reflect these config values from the table

On further investigation I saw that this usually only applies to the General Tab and the General Section.

My finding was astonishing! There had been a core_config_data Entry with the following data:

ID scope scope_id path value
123 default 0 general NULL

How did that happen?

I'm pretty sure that I accidentally clicked the "Add new row" Button in my SQL-Tool. That prefilled the fields with its (in SQL defined) default values. The main issue here is the default value for the path field: general

What did it do?

When Magento loads the configuration and applies the database config values this NULL value for general will overwrite all general/* settings and so the backend cannot find anything although it's stored in the DB.

How to solve it?

Dead simple: Remove that broken general entry from the core_config_data table and you're fine :-)

Domains, Domains, Domains

I dumped a shop from my customer and imported it to my local system, as you can guess, the local domain is another one. All my domains are like: <customer>.dev.

Where to change domains

Secure/Unsecure Base URL

From core_config_data:

default 0   web/unsecure/base_url   http://customer.dev/
default 0   web/secure/base_url     http://customer.dev/

Check the skin/media/js url although!

default 0   web/unsecure/base_link_url  {{unsecure_base_url}}
default 0   web/unsecure/base_skin_url  {{unsecure_base_url}}skin/
default 0   web/unsecure/base_media_url {{unsecure_base_url}}media/
default 0   web/unsecure/base_js_url    {{unsecure_base_url}}js/
default 0   web/secure/base_link_url    {{secure_base_url}}
default 0   web/secure/base_skin_url    {{secure_base_url}}skin/
default 0   web/secure/base_media_url   {{secure_base_url}}media/
default 0   web/secure/base_js_url      {{secure_base_url}}js/

Cookies

For cookies you should add the domain and the path, to secure your cookie. In your development environment, you can just use these settings:

default 0   web/cookie/cookie_path      NULL
default 0   web/cookie/cookie_domain    NULL