Campaigns and removal of PowerProspecting

[hubdigital]

Campaigns are definitely giving me grief.
I spent half a day on this yesterday and actually ended up breaking it more.

I understand the process of sending a campaign and can set them up no problems.
The problem however is that when I send the campaign from the admin section it is sent, and the view status is telling that it is sent, however I never get the email from any of the campaigns.

I have tried every combination of sending campaigns and 'normal' email for that matter, and I can always send email, yet never send a campaign.

In frustration I decided to remove power prospecting and give that a go, that was a mistake it seems.

I now get the following error whenever I try to add leads or contacts to a target list.

Error retrieving ProspectList list: Query Failed: SELECT contacts.id , contacts.first_name , contacts.last_name , CONCAT(IFNULL(contacts.first_name,''),' ',IFNULL(contacts.last_name,'')) as name , jt0.name account_name, contacts.email1 , contacts.phone_work , contacts.assigned_user_id , 'contacts' panel_name FROM contacts AND jt0.deleted=0 where contacts.deleted=0 ORDER BY name asc LIMIT 0,10::MySQL error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND jt0.deleted=0 where contacts.deleted=0 ORDER BY name asc LIMIT 0,10' at line 1


So I re-installed power prospecting and still get the same thing.

Fists step first, is there any way that anyone can assist me in getting sugarcrm back to the way that it was before the error?

Some info:

rpath install of 4.2
upgraded to the latest 4.2.1b

cheers

[sacramentojoe]

Campaigns are definitely giving me grief.
I spent half a day on this yesterday and actually ended up breaking it more.

I understand the process of sending a campaign and can set them up no problems.
The problem however is that when I send the campaign from the admin section it is sent, and the view status is telling that it is sent, however I never get the email from any of the campaigns.

I have tried every combination of sending campaigns and 'normal' email for that matter, and I can always send email, yet never send a campaign.

In frustration I decided to remove power prospecting and give that a go, that was a mistake it seems.

I now get the following error whenever I try to add leads or contacts to a target list.

Error retrieving ProspectList list: Query Failed: SELECT contacts.id , contacts.first_name , contacts.last_name , CONCAT(IFNULL(contacts.first_name,''),' ',IFNULL(contacts.last_name,'')) as name , jt0.name account_name, contacts.email1 , contacts.phone_work , contacts.assigned_user_id , 'contacts' panel_name FROM contacts AND jt0.deleted=0 where contacts.deleted=0 ORDER BY name asc LIMIT 0,10::MySQL error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND jt0.deleted=0 where contacts.deleted=0 ORDER BY name asc LIMIT 0,10' at line 1


So I re-installed power prospecting and still get the same thing.

Fists step first, is there any way that anyone can assist me in getting sugarcrm back to the way that it was before the error?

Some info:

rpath install of 4.2
upgraded to the latest 4.2.1b

cheers

Looks like there is an error in the sql statement.
Form what I can see it's around,
contacts' pane_name from line.
contacts appears to have quotes around it and the panel_name isn't tied to anything.
make it read contacts.panel_name and I bet it will work.