Ok, I initially tried to define a new style property with a set "Property Type: Scalar with default value:" of a image background into the "Color Pallet", it did not work, so I tried again.. this time with "Property Type: CSS with components:" with the Background and Extra options selected still trying to set it in the Color Pallet area. My new defined style property then disappeared, so I went to the "Styles & Templates > Customized Components" and saw my style property there. I then deleted it to try to define a new style property again, but this time into a new area other than the "Color Pallet" and I ran into the following database error:
The following error occurred: Mysqli statement execute error : Duplicate entry '16-refinedColor' for key 'definition_style_id_property_name' Zend_Db_Statement_Mysqli->_execute() in Zend/Db/Statement.php at line 317 Zend_Db_Statement->execute() in Zend/Db/Adapter/Abstract.php at line 479 Zend_Db_Adapter_Abstract->query() in Zend/Db/Adapter/Abstract.php at line 574 Zend_Db_Adapter_Abstract->insert() in XenForo/DataWriter.php at line 1591 XenForo_DataWriter->_insert() in XenForo/DataWriter.php at line 1580 XenForo_DataWriter->_save() in XenForo/DataWriter.php at line 1381 XenForo_DataWriter->save() in XenForo/Model/StyleProperty.php at line 1390 XenForo_Model_StyleProperty->createOrUpdateStylePropertyDefinition() in XenForo/ControllerAdmin/StylePropertyDefinition.php at line 120 XenForo_ControllerAdmin_StylePropertyDefinition->actionSave() in XenForo/FrontController.php at line 310 XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 132 XenForo_FrontController->run() in /Users/gldtn/Sites/xenforo/admin.php at line 13
Also, where in the database is that key set so I can delete it manually, or can you provide a sql query please?