Hi, Just upgraded from 3.0.5.3. When trying to "add new shell user", no form gets opened and I get the following error; PHP Warning: preg_replace_callback() [<a href='function.preg-replace-callback'>function.preg-replace-callback</a>]: Requires argument 2, 'self::table_auth_sql', to be a valid callback in /usr/local/ispconfig/interface/lib/classes/tform.inc.php on line 255 PHP Warning: preg_replace_callback() [<a href='function.preg-replace-callback'>function.preg-replace-callback</a>]: Requires argument 2, 'self::table_auth_sql', to be a valid callback in /usr/local/ispconfig/interface/lib/classes/tform.inc.php on line 255 PHP Fatal error: Call to a member function fetch_assoc() on a non-object in /usr/local/ispconfig/interface/lib/classes/db_mysql.inc.php on line 181 Gr, J
Looking in mysql logging, I see: 59 Query INSERT INTO sys_log (server_id,datalog_id,loglevel,tstamp,message) VALUES (0,0,1,1404227958,'[INTERFACE]: 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) -> mysqli_query 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')
Yes, thats the reason for the problem. php 5.2 does not support the syntax that is used for the preg_replace_callback yet, with php 5.3 and later there is no problem. But I implemented a workaround for compatibility with php 5.1 and 5.2 2 weeks ago. Download this file: http://git.ispconfig.org/ispconfig/ispconfig3/raw/stable-3.0.5/interface/lib/classes/tform.inc.php and copy it to /usr/local/ispconfig/interface/lib/classes/tform.inc.php