...with: 30.01.2012-12:36 - DEBUG - Created awstats statistics with command: /usr/share/awstats/tools/awstats_buildstaticpages.pl -month='1' -year='2012' -update -config='xxxxxx' -lang=en -dir='/var/www/clients/client18/web24/web/stats' -awstatsprog='/usr/share/awstats/wwwroot/cgi-bin/awstats.pl' 30.01.2012-12:36 - WARNING - DB::query(SELECT domain FROM web_domain WHERE (type = 'alias' OR type = 'subdomain') server_id = 4) -> mysql_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 'server_id = 4' at line 1 bizzarely it's only on one server, the rest are fine. Log from that server's update. Code: Mon Jan 30 12:07:40 GMT 2012 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/update.lib.php, Line 38: read in ispconfig3.sql Mon Jan 30 12:08:57 GMT 2012 - [ISPConfig] - /tmp/ispconfig3_install/install/lib/installer_base.lib.php, Line 1401: WARNING: Failed to execute the command adduser apache ispapps Mon Jan 30 12:09:15 GMT 2012 - [ISPConfig] - /tmp/ispconfig3_install/install/dist/lib/fedora.lib.php, Line 691: EXECUTED: cp -rf ../interface /usr/local/ispconfig Mon Jan 30 12:09:16 GMT 2012 - [ISPConfig] - /tmp/ispconfig3_install/install/dist/lib/fedora.lib.php, Line 695: EXECUTED: cp -rf ../server /usr/local/ispconfig Mon Jan 30 12:09:16 GMT 2012 - [ISPConfig] - /tmp/ispconfig3_install/install/dist/lib/fedora.lib.php, Line 820: EXECUTED: chmod -R 750 /usr/local/ispconfig Mon Jan 30 12:09:16 GMT 2012 - [ISPConfig] - /tmp/ispconfig3_install/install/dist/lib/fedora.lib.php, Line 824: EXECUTED: chown -R ispconfig:ispconfig /usr/local/ispconfig Mon Jan 30 12:09:16 GMT 2012 - [ISPConfig] - /tmp/ispconfig3_install/install/dist/lib/fedora.lib.php, Line 861: EXECUTED: usermod -a -G ispconfig apache Mon Jan 30 12:09:16 GMT 2012 - [ISPConfig] - /tmp/ispconfig3_install/install/dist/lib/fedora.lib.php, Line 864: EXECUTED: usermod -a -G ispapps apache Mon Jan 30 12:09:16 GMT 2012 - [ISPConfig] - /tmp/ispconfig3_install/install/dist/lib/fedora.lib.php, Line 883: EXECUTED: chmod +x /usr/local/ispconfig/server/scripts/create_daily_nginx_access_logs.sh /usr/local/ispconfig/server/scripts/create_jailkit_chroot.sh /usr/local/ispconfig/server/scripts/create_jailkit_programs.sh /usr/local/ispconfig/server/scripts/create_jailkit_user.sh /usr/local/ispconfig/server/scripts/ispconfig_update.sh /usr/local/ispconfig/server/scripts/run-getmail.sh /usr/local/ispconfig/server/scripts/update_from_svn.sh /usr/local/ispconfig/server/scripts/update_from_tgz.sh
This has already been fixed in svn stable branch, please see here in the bugtracker: http://bugtracker.ispconfig.org/index.php?do=index&tasks=&project=3&due=65&status[]=
Ahh right. Is it worth finding the update in SVN + patching or just waiting for the update? Whats it affect anyway?
The effect is that the sub- and aliasdomains in awstats statistics are summed up with the main domain instead of listing them as separate domains. So the awstats statistics are working, but the new feature that the aliasdomains are accounted together with the main domain is currently not working as the selection of the aliasdomains fails due to the sql error. I would wait for the 3.0.4.3 release, which should be available next week.
