AJEXA create campaign fails...

[skeeby]

SugarOS 4.5.1e with latest AJEXA 2.0.0 module installed.

Everything was working well with creating, customizing and launching campaings until yesterday...

Now when i create a campaign from a template (for example Send a newsletter), i am able to save the new campaign, but it doesn't appear in the campaigns list anymore... Moreover, when i want to configure the send email settings tab of this campaign, all i get is this :

Retrieving record by id ap_send_document_detail:884698e0-3bbb-012d-b5ac-46e6881eb6fe found Query Failed:SELECT ap_send_document_detail.* FROM ap_send_document_detail WHERE ap_send_document_detail.id = '884698e0-3bbb-012d-b5ac-46e6881eb6fe' AND ap_send_document_detail.deleted=0 LIMIT 0,1::MySQL error 1054: Unknown column 'ap_send_document_detail.deleted' in 'where clause'

I have no idea what it means.

Last but not least, when i go in the admin panel and click on server diagnostics, all i get after 20 seconds is a blank screen.

Anyone has an idea what may go wrong here ?

Thanks for help

[skeeby]

omg, i tried to uninstall the ajexa module, and upload it again, now the system campaign templates have disappeared in the Choose campaign template tab...

[skeeby]

I'm comin a little bit closer...

i found out that for some reason "ap_campaign_template" and "ap_campaign_template_task" MYD tables where empty... i replaced them with the original tables and now the standard templates appear again in the "Create campaign" tab...
And i am also able to save the campaign and have it listed...

BUT... once i click on the campaign name to open it, it displays with no problem, but the field "template" is empty (it shouldn't be)... So when i go on "News Letter Send Details", i get the error mentioned above :

Retrieving record by id ap_send_document_detail:3c13d625-2324-6bf0-5f93-46e6c22db6ba found Query Failed:SELECT ap_send_document_detail.* FROM ap_send_document_detail WHERE ap_send_document_detail.id = '3c13d625-2324-6bf0-5f93-46e6c22db6ba' AND ap_send_document_detail.deleted=0 LIMIT 0,1::MySQL error 1054: Unknown column 'ap_send_document_detail.deleted' in 'where clause'

Some AJEXA specialist out there ?

[skeeby]

Damn, i checked in phpmyadmin the table "ap_send_document_detail", which indeed has no column named "ap_send_document_detail.deleted" !!!

omg heeeelp

[skeeby]

I'm jumpin out the window...cya guys

[ajexa]

This is a bug in Ajexa 2.0.0 when it is on Linux. The 'deleted' field is missing in the table ap_send_document_detail. To fix this, please do the following:

1. Open Sugar\modules\CampaignTaskSendDoc\vardefs.php file.

2. Add
'deleted' => array (
'name' => 'deleted',
'vname' => 'deleted',
'type' => 'bool',
'required' => true,
'reportable'=>false,
),

3. Save the file

4. Go to Admin > Repair > Repair Database and Execute SQL.

Also be aware that you need to install and configure Ajexa Java server on Tomcat which is mentioned in the readme file. The complete ajexa project is in sourceforge.net.

Once you install and configure the Java server, you need to configure the tomcat web application URL in Admin>Ajexa Settings. Afterwards the diagnostic screen will work.

Hope it helps.