Cannot insert configuration_key "" because it already exists

Quote:

---

Originally Posted by rbarbour

If you have another similar template installed such as the Responsive Apparel Boutique Template?

Then you will get an error stating:
Error ERROR: Cannot insert configuration_key "" because it already exists

Because you already installed the sql patch when installing the other Responsive Template.

---

Perhaps, but it should say "COLUMN_WIDTH" instead of ""

Quote:

---

Originally Posted by Ajeh

Okay ... this should be fun ...

You know what those settings are now, so I am going to ask you to click on Delete for that record ...

That will remove the record then, go browse the table:
configuration_group

do you have a group for:
Responsive Sheffield Blue Template

If so, what is the value for the:
configuration_group_id

---

Sorry I missed this post yesterday. It must have come in while I was replying to DrByte.

Not to worry about the 'fun'. I'm working in my sandbox, so it is easy for a 'do-over'

Delete which record? The one with the blank configuration_key?

Yes, there is a configuration_group_id for Responsive Sheffield Blue Template: 47
Yes, there is a configuration_group_id for Responsive Apparel Boutique Template: 46

While testing out some sql I got the same error and found the same blank configuration_key as mentioned in post #9
Attachment 13679
configuration_title "Installed Modules".

I do keep copies of all mods done but I cannot find where this entry came from.

Anyway, deleting the record allowed the sql to process completely.

I find that the only place where this text
"Installed Modules. This is automatically updated. No need to edit."
could have come from is not a mod but admin/modules.php:

PHP Code:

---

    $db->Execute("insert into " . TABLE_CONFIGURATION . "
                (configuration_title, configuration_key, configuration_value,
                 configuration_description, configuration_group_id, sort_order, date_added)
                 values ('Installed Modules', '" . zen_db_input($module_key) . "', '" . zen_db_input(implode(';', $installed_modules)) . "',
                         'This is automatically updated. No need to edit.', '6', '0', now())"); 


---

so, I've put it down to some glitch when installing a payment/shipping module.

as this is still occurring, I've stuck this in bug reports:
http://www.zen-cart.com/showthread.p...s-empty-db-key