[FATAL] Invalid object name 'tracker_sessions'

[Tayler]

Hi Guys

Running Sugar CE 5.1 on Windows Server 2008 IIS7 with MSSQL as DB

I get the following error in my sugarcrm.log file repeatedly


[2184][1][FATAL] Invalid object name 'tracker_sessions'.: UPDATE tracker_sessions set active = 0 where date_end < CONVERT(varchar(20),'2008-09-19 01:58:39',120)

Also my inbound email is not working at all... I created a cron.bat file that calls php.exe -f < cron.php as per the instructions, however the Scheduler is not reporting the job as having run successfully.

Also it appears as if the job is constantly running as the status says IN PROGRESS

But no emails.

Is this related to the tracker_sessions error?

CHeers

Robin

[crazymikey]

I noticed the same repeated error in my 'sugarcrm.log' file. I was able to fix this error by modifying my .bat file called by the scheduler to call php-cgi.exe instead of php.exe:

cd "C:\Program Files\sugarcrm-5.1.0b\htdocs\sugarcrm\"
"C:\Program Files\sugarcrm-5.1.0b\php\php-cgi.exe" -f cron.php

Hope this helps,
- Mike