Wir haben ein ähnliches (oder dasselbe) Problem nach dem Update. Soweit ich bisher feststellen konnte tritt es auf bei:
- Neuanlage und Bearbeitung von FTP-Konten
- Neuanlage und Bearbeitung von Datenbanken (nicht aber von DB-Benutzern)
- Neuanlage von geschützten Ordnern (kann Bearbeiten nicht testen)
- Neuanlage von geschützten Ordner Benutzern (kann Bearbeiten nicht testen)
- Neuanlage von Shell-Benutzern (kann Bearbeiten nicht testen)
- Neuanlage von CRON-Jobs (kann Bearbeiten nicht testen)
Exemplarisch eine Fehlermeldung (Bearbeiten FTP-Konto):
#0 db->query(SELECT web_domain.domain_id, CONCAT(web_domain.domain, ' :: ', server.server_name) AS parent_domain FROM web_domain, server WHERE web_domain.type = 'vhost' AND web_domain.server_id = server.server_id AND {AUTHSQL::web_domain} ORDER BY web_domain.domain) called at [/usr/local/ispconfig/interface/lib/classes/db_mysql.inc.php:158] #1 db->queryAllRecords(SELECT web_domain.domain_id, CONCAT(web_domain.domain, ' :: ', server.server_name) AS parent_domain FROM web_domain, server WHERE web_domain.type = 'vhost' AND web_domain.server_id = server.server_id AND {AUTHSQL::web_domain} ORDER BY web_domain.domain) called at [/usr/local/ispconfig/interface/lib/classes/tform.inc.php:256] #2 tform->getDatasourceData(Array ([datatype] => INTEGER,[formtype] => SELECT,[default] => ,[datasource] => Array ([type] => SQL,[querystring] => SELECT web_domain.domain_id, CONCAT(web_domain.domain, ' :: ', server.server_name) AS parent_domain FROM web_domain, server WHERE web_domain.type = 'vhost' AND web_domain.server_id = server.server_id AND {AUTHSQL::web_domain} ORDER BY web_domain.domain,[keyfield] => domain_id,[valuefield] => parent_domain),[value] => ), Array ([ftp_user_id] => 9,[server_id] => 1,[parent_domain_id] => 72,[username] => c11ftp_admin,[username_prefix] => c11ftp_,[password] => $1$zCyK/tVA$VN0YU.dmm.eq/Oil7lClN/,[quota_size] => -1,[active] => y)) called at [/usr/local/ispconfig/interface/lib/classes/tform.inc.php:396] #3 tform->getHTML(Array ([ftp_user_id] => 9,[sys_userid] => 1,[sys_groupid] => 12,[sys_perm_user] => riud,[sys_perm_group] => riud,[sys_perm_other] => ,[server_id] => 1,[parent_domain_id] => 72,[username] => c11ftp_admin,[username_prefix] => c11ftp_,[password] => $1$zCyK/tVA$VN0YU.dmm.eq/Oil7lClN/,[quota_size] => -1,[active] => y,[uid] => web72,[gid] => client11,[dir] => /var/www/clients/client11/web72,[quota_files] => -1,[ul_ratio] => -1,[dl_ratio] => -1,[ul_bandwidth] => -1,[dl_bandwidth] => -1), ftp, EDIT) called at [/usr/local/ispconfig/interface/lib/classes/tform_actions.inc.php:576] #4 tform_actions->onShowEdit() called at [/usr/local/ispconfig/interface/lib/classes/tform_actions.inc.php:490] #5 tform_actions->onShow() called at [/usr/local/ispconfig/interface/lib/classes/tform_actions.inc.php:70] #6 tform_actions->onLoad() called at [/usr/local/ispconfig/interface/web/sites/ftp_user_edit.php:210] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '::web_domain} ORDER BY web_domain.domain' at line 1
Fehlermeldungen gab es während des Updates keine.
Danke im Voraus!