(gelöst)Diverse php Fehler Ausgaben beim Anlegen eines neuen Kunden

#1
Ich habe ISPConfig 3.0.5.4p8 auf Debian Jessie.
Heute wollte einen neuen Kunden anlegen und sehen diese Meldung

Code:
#0 db->query(SELECT assigned_template_id, client_template_id FROM client_template_assigned WHERE client_id = 0) called at [/usr/local/ispconfig/interface/lib/classes/db_mysql.inc.php:211] #1 db->queryAllRecords(SELECT assigned_template_id, client_template_id FROM client_template_assigned WHERE client_id = 0) called at [/usr/local/ispconfig/interface/web/client/client_edit.php:139] #2 page_action->onShowEnd() called at [/usr/local/ispconfig/interface/lib/classes/tform_actions.inc.php:530] #3 tform_actions->onShow() called at [/usr/local/ispconfig/interface/lib/classes/tform_actions.inc.php:70] #4 tform_actions->onLoad() called at [/usr/local/ispconfig/interface/web/client/client_edit.php:592]
Wenn ich dann einen Kunden anlege, kommt das:
Code:
#0 db->query(INSERT INTO `client` (`company_name`, `gender`, `contact_name`, `customer_no`, `username`, `password`, `language`, `usertheme`, `street`, `zip`, `city`, `state`, `country`, `telephone`, `mobile`, `fax`, `email`, `internet`, `icq`, `vat_id`, `company_id`, `bank_account_owner`, `bank_account_number`, `bank_code`, `bank_name`, `bank_account_iban`, `bank_account_swift`, `notes`, `paypal_email`, `locked`, `canceled`, `added_date`, `added_by`, `sys_userid`, `sys_groupid`, `sys_perm_user`, `sys_perm_group`, `sys_perm_other`) VALUES ('', '', 'xyv', 'C1', 'waldi', '$1$zTWQs5U/$5tesipB7kCgvHrXzVnlaa.', 'de', 'default', '', '', '', '', 'DE', '', '', '', '', 'http://', '', '', '', '', '', '', '', '', '', '', '', 'n', 'n', '2016-2-6', 'admin', '1', '1', 'riud', 'riud', '')) called at [/usr/local/ispconfig/interface/lib/classes/tform_actions.inc.php:254] #1 tform_actions->onInsertSave(INSERT INTO `client` (`company_name`, `gender`, `contact_name`, `customer_no`, `username`, `password`, `language`, `usertheme`, `street`, `zip`, `city`, `state`, `country`, `telephone`, `mobile`, `fax`, `email`, `internet`, `icq`, `vat_id`, `company_id`, `bank_account_owner`, `bank_account_number`, `bank_code`, `bank_name`, `bank_account_iban`, `bank_account_swift`, `notes`, `paypal_email`, `locked`, `canceled`, `added_date`, `added_by`, `sys_userid`, `sys_groupid`, `sys_perm_user`, `sys_perm_group`, `sys_perm_other`) VALUES ('', '', 'xyv', 'C1', 'waldi', '$1$zTWQs5U/$5tesipB7kCgvHrXzVnlaa.', 'de', 'default', '', '', '', '', 'DE', '', '', '', '', 'http://', '', '', '', '', '', '', '', '', '', '', '', 'n', 'n', '2016-2-6', 'admin', '1', '1', 'riud', 'riud', '')) called at [/usr/local/ispconfig/interface/lib/classes/tform_actions.inc.php:198] #2 tform_actions->onInsert() called at [/usr/local/ispconfig/interface/lib/classes/tform_actions.inc.php:97] #3 tform_actions->onSubmit() called at [/usr/local/ispconfig/interface/web/client/client_edit.php:121] #4 page_action->onSubmit() called at [/usr/local/ispconfig/interface/lib/classes/tform_actions.inc.php:68] #5 tform_actions->onLoad() called at [/usr/local/ispconfig/interface/web/client/client_edit.php:592] Unknown column 'gender' in 'field list'
Da scheint u.a. die DB nicht auf korrektem Stand zu sein. (gender)
Kann man da ein Update nachfahren, oder andere Ideen?
 
#4
Danke, gemacht. Gleich beim Aufruf von "Kunden hinzufügen" kommt das ->
Code:
#0 db->query(SELECT assigned_template_id, client_template_id FROM client_template_assigned WHERE client_id = 0) called at [/usr/local/ispconfig/interface/lib/classes/db_mysql.inc.php:211] 
#1 db->queryAllRecords(SELECT assigned_template_id, client_template_id FROM client_template_assigned WHERE client_id = 0) called at [/usr/local/ispconfig/interface/web/client/client_edit.php:139] 
#2 page_action->onShowEnd() called at [/usr/local/ispconfig/interface/lib/classes/tform_actions.inc.php:530] 
#3 tform_actions->onShow() called at [/usr/local/ispconfig/interface/lib/classes/tform_actions.inc.php:70] #4 tform_actions->onLoad() called at [/usr/local/ispconfig/interface/web/client/client_edit.php:592]
 

Till

Administrator
#5
Da scheint bei Dir einiges zu fehlen. was Du versuchen kannst ist:

1) DB sichern.
2) Nur Daten (ohne Tabellendefinitionen) aus DB in Datei exportieren.
3) Alle Tabellen löschen.
4) den komplett DB dump (.sql) datei aus dem ispconfig tar.gz, verzeichnis install/sql/ importieren.
5) alle Daten löschen in der DB, also truncate (aber nicht die Tabellen löschen).
6) Die in 2 exportierten Daten wieder importieren
 
#7
Ich habe ungefähr 20 !!! update Scripte für die Datenbank ausgeführt.
Verstehe nicht so richtig, warum die nicht ausgeführt worden.
Egal.
Ich werde beim nächsten Update mal genau darauf achten
 

Werbung

Top