Invaild Object Name 'tracker_sessions'

[murdok]

i am getting this error message when i run the batch file for the php.cron

[FATAL] Invalid object name 'tracker_sessions'.: UPDATE tracker_sessions set active = 0 where date_end < CONVERT(varchar(20),'2008-11-14 16:16:06',120)


i am using version 5.1.0b

i can see the emails in the email_cache tableof the database. and the scheduler shows that the job has completed, but i do not receive messages to my folder.

any help would be great

thanks

[kbrill]

Check to see if you have a table in your database called 'tracker_sessions' and if your database use has access to that table.

[mikesparkes]

Exactly the same problems as the above user
No tracker_sessions table even after re-installing
Is there a SQL statement or similar to create this table as I have no idea what columns are needed and what type

Many thanks

Mike

[murdok]

i have the table, how do i know if there is access to that table? everything else seems to be working.

[mikesparkes]

The error appears when the batch file is run and in the sugar log file, I assume if the table is in the database these should disappear and maybe the bounce module will start working.

Do you have a list of columns and data types for the tracker_sessions table?
I can then re-create the tqable and test it

Mike

[mikesparkes]

The error appears when the batch file is run and in the sugar log file, I assume if the table is in the database these should disappear and maybe the bounce module will start working.

Do you have a list of columns and data types for the tracker_sessions table?
I can then re-create the tqable and test it

Mike

[Startrevolution]

Did this ever get fixed? I have the same issue?

[SugarMohan]

This problem exists in version 5.2.0c too.

The log file shows the following error
[FATAL] Invalid object name 'tracker_sessions'.: UPDATE tracker_sessions set active = 0 where date_end < CONVERT(varchar(20),'2009-06-22 16:40:07',120)
[FATAL] SQL Server error: Invalid object name 'tracker_sessions'.

A new installation doesn’t create ‘tracker_sessions’ table.

Any fix available?

SKM