Link to home
Start Free TrialLog in
Avatar of RDurish
RDurishFlag for United States of America

asked on

Windows IIS6 - AWStats (Advanced Web Statistics) via Plesk

My server statistics stopped updating all of a sudden the other day.  Even if I manually run the statistics.exe in parallels or manually start the scheduled plesk task the stats do not update at all.

I looked in the logs and see a couple of errors from the statistics.exe:
1.
Can't query SELECT s.id, s.dom_id, s.sys_user_type, s.name, s.displayName, s.server_id, u.login, a.password, s.coldfusion, s.ssi, s.ssi_html, s.php, s.php_handler_type, s.php_version, s.cgi, s.perl, s.python, s.asp, s.asp_dot_net, s.managed_runtime_version, s.miva, s.fp, s.fp_enable, s.fp_no_index, s.htype, s.www_root, s.webstat FROM ( subdomains s INNER JOIN sys_users u ON u.id = s.sys_user_id ) LEFT OUTER JOIN accounts a ON a.id = u.account_id WHERE (s.dom_id = 2): MySQLDatabaseProvider error 1054:Unknown column 's.sys_user_type' in 'field list'
   at (MySQLDatabaseProvider::query line 284)
   at ipolitics360.com: configure AWStats.conf(statistics::LogForAWStats::configure line 2667)
   at Unable to peocess web statistics for domainipolitics360.com(statistics::runWebLogAnalyser line 3114)
Execute file name: C:\Program Files\Parallels\Plesk\admin\bin\statistics.exe

2.
C Exception: 3221225477
   at get shared instance of PleskSrvClient(PleskSrvClient::getInstance line 257)
   at Unable to finish web modules(statistics::start line 1131)
Execute file name: C:\Program Files\Parallels\Plesk\admin\bin\statistics.exe

3.
C Exception: 3221225477
   at get shared instance of PleskSrvClient(PleskSrvClient::getInstance line 257)
   at Calculate mail traffic(statistics::processMailTraffic line 876)
Execute file name: C:\Program Files\Parallels\Plesk\admin\bin\statistics.exe

4.
Cannot find notification by ID 4
   at (PSADatabase::getNotification line 2608)
   at NotifyClientExpiration(statistics::start line 1259)
Execute file name: C:\Program Files\Parallels\Plesk\admin\bin\statistics.exe

I'm stumped and my host has been trying to fix it for days and basically gave up.

Please help!
ASKER CERTIFIED SOLUTION
Avatar of meverest
meverest
Flag of Australia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Please check if Awstat is configure to run in schedule task , Check it :
Please follow these steps-

# Login to Plesk
# Click Server
# Click Scheduled tasks
# Click Add New task
# Make sure "Switched on" is checked
# In the Description specify "Statistics calculation" (without quotes)
# In "Scheduler notification" specify the email address where you want to receive notification about this task
# In "Path to executable file *" specify - "C:\Program Files\SWsoft\Plesk\admin\bin\statistics.exe" (without quotes) Replace "C" drive with plesk installed location
# Next specify how often do you want to run this scheduled tasks
# Click Ok
Avatar of RDurish

ASKER

@Meverest: IIS was the best category I could find when posting, since there is no Plesk category.  I'm trying to work with plesk but am having trouble because I don't own the license the hosting company does so I have been fighting to get the correct information to even be able to post for support.

@pcsmitpra: Yes this scheduled task is running everyday at 1:15am and it always throws the 3 errors posted above.
Avatar of RDurish

ASKER

*Sorry, the 4 errors posted above