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

Wh1sper

Member
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?
 

Till

Administrator
Erstell einfach mal eine Spalte mit namen gender als varchar 255 in der tabelle client mit phpmyadmin.
 

Wh1sper

Member
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
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
 

Wh1sper

Member
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