MySQL error 1146: Table 'sugarcrm.tracker_sessions' doesn't exist

[teldarren]

I am not able to send out emails that are part of a email campaign, i try to force them by logging in as an admin going to the the email queue, and the status says its been attempted and processing.

I did find this error in the sugarcrm log every time i try to send out a campaign email...

[1][ERROR] MySQL error 1146: Table 'sugarcrm.tracker_sessions' doesn't exist

****I am using google apps for IMAP and SMTP and i have no trouble sending or recieving email for any of the users.****

The scheduler is running and the campaign and email jobs are active and i have the scheduler batch file running every 3 minutes via the windows task manager.

--I have successfully created a new email campaign.
start date 01/18/2009
end date 01/25/2009

--I have a target list that just contains a few email addresses.
These are manually entered emails that are not tied to an account or anything.
They are just a few of my own personal email addresses for testing this out.

--I have a email template created with some basic text.

--I have a tracker set
(i think i did this wrong...and i don't fully understand how this needs to work.)
(The documentation i have found thus far is basic and doesn't cover technical details.)

--The system SMTP outgoing settings are accurate, and i have green checkmarks when i run the campaign diagnostic

--I am using the following versions....

Windows 2003 Small Business Server SP2
Sugar Community Edition Version 5.2.0 (Build 5380)
XAMPP 1.70
  - Apache 2.2.11
  - PHP 5.2.8
  - MySQL 5.1.30

Please advise.

Thanks,

Darren

[kbrill]

You could simply add the table like this

CREATE TABLE IF NOT EXISTS `tracker_sessions` (
  `id` int(11) NOT NULL auto_increment,
  `session_id` varchar(36) default NULL,
  `date_start` datetime default NULL,
  `date_end` datetime default NULL,
  `seconds` int(9) default '0',
  `client_ip` varchar(20) default NULL,
  `user_id` varchar(36) default NULL,
  `active` tinyint(1) default '1',
  `round_trips` int(5) default NULL,
  `deleted` tinyint(1) default '0',
  PRIMARY KEY  (`id`),
  KEY `idx_tracker_sessions_s_id` (`session_id`),
  KEY `idx_tracker_sessions_uas_id` (`user_id`,`active`,`session_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

but my guess is that if this table didnt get created then I would think that there are other things that didnt get done. Is this an upgrade or a fresh install.

[teldarren]

It is a brand spankin' new install.

[kbrill]

Then I renew my concern that if that table didn't get created then what else didn't happen. I would seriously think about starting over before you get too much data in there.

[rexavh]

I too saw this error in the log every time a scheduled job runs (not just email campaigns).
It may be a red herring since it seems to be caused by job 9 in the scheduler Update tracker_sessions table. If you make this job inactive the error message disappears from the log.

[teldarren]

Thanks for the advice guys.

Where can i go to find a list of all the tables that are needed in the DB, so when i re-install sugar, i can compare my CRM DB with the "master" list.

Is there a difference when installing on a windows system that already has apache, php, and mysql (xampp) or using the bundled sugar installer that installs apache, php, and mysql for you?

Thanks again,

Darren

[teldarren]

I did a new install of SugarCRM CE 5.2.0, and the tracker session table did not show up. I also uninstalled it and installed SugarCRM CE 5.1.0b, and still no tracker session table.

Now there is a "tracker" table.

Could this just be a bug???? because the default scheduled task was setup to look at the wrong table or a table that does not exist? Could I just change the task to point to the "tracker" table instead? OR, is this update tracker table task even needed?

Also, I am still looking for a master list of all the tables that are required in the DB.

I'm wondering if I should stay at 5.1.0b or go back to 5.2.0.

Thoughts anyone?

Thanks.

[kbrill]

I will look into this tonight and get back to you. Sounds like a bug in CE where some tables were left out or used when they should not have been.

[teldarren]

any updates?

or advice on whether or not i should stay on 5.1.0b or go back to 5.2.0?

[kbrill]

OK, It isnt that there are tables missing, it is that CE has code in it that was only meant for PRO/ENT that references 'tracker_sessions'. Mostly in modules/schedulers/_addJobsHere.php.

I am not sure that is where your issue is coming from but I have entered a bug report for this (#27436).

For now go to admin->schedulers and disable "Update tracker_sessions table" and that should help.