Hallo,
ich habe eben das Problem, dass ich eine eigene Basiskonfiguration für eine neue SNOM Firmware erstellen wollte. Dazu habe ich die Standard Konfig. kopiert und wollte dann einige Werte löschen (Bspw. show_xml_pickup). Beim Speichern erhalte ich folgenden Fehler:
TRC040733
SQL Fehler
DELETE FROM "067familysetting" WHERE "067familysetting"."067fam_id"=?
array(1) {
[0]=>
int(729)
}
exception 'ex_sqlException' with message '23503; 7; FEHLER: Aktualisieren oder Löschen in Tabelle »067familysetting« verletzt Fremdschlüssel-Constraint »067typ_id2« von Tabelle »067068fambas«
DETAIL: Auf Schlüssel (067fam_id)=(729) wird noch aus Tabelle »067068fambas« verwiesen.' in /TARGET/SHARE/var/www/mobydickcmd/cmn/class/sql/ex_simpleSql.php:242
Stack trace:
#0 /TARGET/SHARE/var/www/mobydickcmd/cmn/class/sql/ex_simpleSql.php(514): ex_simpleSql->executeStatement(Object(PDOStatement), Array)
#1 /TARGET/SHARE/var/www/mobydickcmd/cmn/class/sql/ex_simpleSql.php(996): ex_simpleSql->deleteSql('067familysettin...', Array)
#2 /TARGET/SHARE/var/www/mobydickcmd/cmn/class/sql/ex_sqlDao.php(95): ex_simpleSql->deleteByPk('067familysettin...', 729)
#3 /TARGET/SHARE/var/www/mobydickcmd/module/device/mod_device.php(187): ex_sqlDao->deleteByPk(729)
#4 [internal function]: mod_device->deleteFamilySetting(729)
#5 /TARGET/SHARE/var/www/mobydickcmd/cmn/class/module/ex_moduleCallInterceptor.php(167): call_user_func_array(Array, Array)
#6 /TARGET/SHARE/var/www/mobydickcmd/module/device/controller/ctl040733_settings.php(33): ex_moduleCallInterceptor->__call('deleteFamilySet...', Array)
#7 /TARGET/SHARE/var/www/mobydickcmd/module/device/controller/ctl040733_settings.php(33): ex_moduleCallInterceptor->deleteFamilySetting(729)
#8 /TARGET/SHARE/var/www/mobydickcmd/cmn/class/mvc/controller/tab/ex_tableTabController.php(84): ctl040733_settings->deleteRecord(Array, Object(ex_defaultRequest), Object(ex_messageHandler), 'submitUpdate')
#9 /TARGET/SHARE/var/www/mobydickcmd/cmn/class/mvc/controller/ex_tabbedFormController.php(153): ex_tableTabController->onSuccess(Object(ex_defaultRequest), Object(ex_messageHandler), 'submitUpdate')
#10 /TARGET/SHARE/var/www/mobydickcmd/cmn/class/mvc/controller/ex_tabbedFormController.php(127): ex_tabbedFormController->validateAndSave(Object(ex_defaultRequest))
#11 /TARGET/SHARE/var/www/mobydickcmd/cmn/class/mvc/controller/ex_multiActionController.php(36): ex_tabbedFormController->onSubmitUpdate(Object(ex_defaultRequest))
#12 /TARGET/SHARE/var/www/mobydickcmd/cmn/class/mvc/ex_frontController.php(162): ex_multiActionController->handleRequest(Object(ex_defaultRequest))
#13 /TARGET/SHARE/var/www/mobydickcmd/cmn/class/mvc/ex_frontController.php(97): ex_frontController->handleRequestInternal('040733', Object(ex_defaultRequest))
#14 /TARGET/SHARE/var/www/mobydickcmd/cmn/layout/box_trc.inc.php(36): ex_frontController->handleRequest('040733', Object(ex_defaultRequest))
#15 /TARGET/SHARE/var/www/mobydickcmd/cmn/inc/ex_sess-yes.inc.php(25): unknown()
#16 /TARGET/SHARE/var/www/mobydickcmd/index.php(122): unknown()
#17 {main}