Hi all, I've put my SugarCrm database up on a DNS Sever in the web. I'm using phpMyAdmin 2.5.3 to manage the tables that are in the website. At fist everythig seems to be ok, but when I try to create something, like a new campaign, sugar sugar shows the next select error:

Error running count query for Campaign List: Query Failed SELECT count(*) FROM prospect_lists INNER JOIN prospect_list_campaigns ON (prospect_lists.id=prospect_list_campaigns.prospec t_list_id AND prospect_list_campaigns.campaign_id='dcc39201-cac0-61cd-7913-4524bc842993') where ( prospect_list_campaigns.deleted=0 AND prospect_lists.deleted=0) AND prospect_lists.deleted=0 )::MySQL error 1064: You have an error in your SQL syntax near '( SELECT count(*) FROM prospect_lists INNER JOIN prospect_list_campaigns ON (pr' at line 1

Do somebody know why??

Thank's.