Target Lists can not be viewed in 5.2?

[russkey]

Hi,

Target Lists are not shown. Steps to reproduce:

1. Click Campaigns
2. Click Target Lists - expect to see the existing Target Lists, but the page comes back empty.

There are no errors or warnings in the log during this operation.

The Target Lists are still accessible through Campaign -> select your campaign -> in Campaign Target List section. click Select, then a pop-up windows is displayed with existing Target Lists.

Any ideas or hints?

Many thanks!

[malcolmh]

Hi,

Just checked in our system, targets are being listed

[russkey]

Hi Malcolm,

We have no problem with viewing Targets, but can not view the "Target Lists".

Could you please confirm that you can view the "Target Lists" on you system?

Thanks!

[sugarcane]

Hi russkey,

We have no problems viewing the target lists in the target list List view within the campaigns module.

[andopes]

Hi russkey

Take a look at the error log of your web server (apache / iis).
Check if there is any error message at the tail of the file.
Are you sure there are Target Lists in your SugarCRM database?

Edit the file include/ListView/ListViewData.php and add the line:

 echo "<LI>$main_query</LI>"; 
  

Just after the line:

 $main_query = $ret_array['select'] . $params['custom_select'] . $ret_array['from'] . $params['custom_from'] . $ret_array['where'] . $params['custom_where'] . $ret_array['order_by'] . $params['custom_order_by']; 
  

Try to access the Target List again, you will see a SQL query above ListView.
Copy this one and execute in the phpMyAdmin or any other SQL client.
If it returns an error message let us know both SQL query and error message.

Kind regards

[russkey]

Hi Andre,

Thank you for your help.

I have added the line
echo "<LI>$main_query</LI>";
in the /include/ListView/ListViewData.php as you have suggested, I can see the query displayed on the web page when I click on "Targets" shortcut or on "Campaigns" shortcut, but there is no printout (at all) when I click on the "Target Lists" shortcut.

But the Target Lists do exist in the database, here is the proof: when I go to Campaigns and select one, then inside the campaign scroll to the Target Lists and click Select button, the pop-up window is displayed, where I can see this query (the echo line you have suggested):

SELECT prospect_lists.* FROM prospect_lists where prospect_lists.deleted=0 ORDER BY prospect_lists.name asc

and I see 12 (twelve) target lists displayed in this window, so I skip the test with the command-line SQL query.

Also, I have done this: the log is in DEBUG mode, and I click on "Target Lists" shortcut, this is what I get in the log file:

Tue Dec 30 12:50:21 2008 [32039][-none-][INFO] Connect:Resource id #89
Tue Dec 30 12:50:21 2008 [32039][-none-][INFO] Query:SELECT id, name, symbol, conversion_rate FROM currencies WHERE status = 'Active' and deleted = 0
Tue Dec 30 12:50:21 2008 [32039][-none-][INFO] Query Execution Time:0.000106811523438
Tue Dec 30 12:50:21 2008 [32039][-none-][INFO] Query:SELECT category, name, value FROM config
Tue Dec 30 12:50:21 2008 [32039][-none-][INFO] Query Execution Time:0.000123977661133
Tue Dec 30 12:50:21 2008 [32039][-none-][INFO] Query:SELECT id FROM outbound_email WHERE type = 'system'
Tue Dec 30 12:50:21 2008 [32039][-none-][INFO] Query Execution Time:8.48770141602E-5
Tue Dec 30 12:50:21 2008 [32039][-none-][INFO] Query:SELECT * FROM outbound_email WHERE id = '4bc63c56-d78f-5c3b-c12d-4884678370ee'
Tue Dec 30 12:50:21 2008 [32039][-none-][INFO] Query Execution Time:9.51290130615E-5
Tue Dec 30 12:50:21 2008 [32039][-none-][DEBUG] We have an authenticated user id: 1
Tue Dec 30 12:50:21 2008 [32039][-none-][DEBUG] Retrieve User : SELECT users.* FROM users WHERE users.id = '1' AND users.deleted=0
Tue Dec 30 12:50:21 2008 [32039][-none-][DEBUG] Limit Query:SELECT users.* FROM users WHERE users.id = '1' AND users.deleted=0 Start: 0 count: 1
Tue Dec 30 12:50:21 2008 [32039][-none-][INFO] Query:SELECT users.* FROM users WHERE users.id = '1' AND users.deleted=0 LIMIT 0,1
Tue Dec 30 12:50:21 2008 [32039][-none-][INFO] Query Execution Time:0.000153779983521
Tue Dec 30 12:50:21 2008 [32039][1][INFO] Query:SELECT u1.first_name, u1.last_name from users u1, users u2 where u1.id = u2.reports_to_id AND u2.id = '1' and u1.deleted=0
Tue Dec 30 12:50:21 2008 [32039][1][INFO] Query Execution Time:0.000104904174805
Tue Dec 30 12:50:21 2008 [32039][1][DEBUG] additional detail query results:
Tue Dec 30 12:50:21 2008 [32039][1][DEBUG] SugarBean.load_relationships, Loading relationship (reports_to_id).
Tue Dec 30 12:50:21 2008 [32039][1][INFO] Query:SELECT ea.*, ear.* FROM email_addresses ea
LEFT JOIN email_addr_bean_rel ear ON ea.id = ear.email_address_id
WHERE ear.bean_module = 'Users'
AND ear.bean_id = '1'
AND ear.deleted = 0
ORDER BY ear.reply_to_address, ear.primary_address DESC
Tue Dec 30 12:50:21 2008 [32039][1][INFO] Query Execution Time:0.0001220703125
Tue Dec 30 12:50:21 2008 [32039][1][DEBUG] Current user is: admin
Tue Dec 30 12:50:21 2008 [32039][1][DEBUG] Current user is: admin
Tue Dec 30 12:50:21 2008 [32039][1][DEBUG] setting cookie ck_login_id_20 to 1
Tue Dec 30 12:50:21 2008 [32039][1][DEBUG] setting cookie ck_login_theme_20 to Sugar
Tue Dec 30 12:50:21 2008 [32039][1][DEBUG] setting cookie ck_login_language_20 to en_us
Tue Dec 30 12:50:21 2008 [32039][1][DEBUG] Limit Query:SELECT distinct item_id AS item_id, id, item_summary, module_name, monitor_id, date_modified FROM tracker WHERE user_id = '1' AND visible = 1 ORDER BY date_modified DESC Start: 0 count: 10
Tue Dec 30 12:50:21 2008 [32039][1][INFO] Query:SELECT distinct item_id AS item_id, id, item_summary, module_name, monitor_id, date_modified FROM tracker WHERE user_id = '1' AND visible = 1 ORDER BY date_modified DESC LIMIT 0,10
Tue Dec 30 12:50:21 2008 [32039][1][INFO] Query Execution Time:0.00641012191772
Tue Dec 30 12:50:21 2008 [32039][1][DEBUG] current_language is: en_us
Tue Dec 30 12:50:21 2008 [32039][1][INFO] Query:SELECT count(*) as the_count FROM config WHERE category='info' AND name='sugar_version' AND value = '5.2.0'
Tue Dec 30 12:50:21 2008 [32039][1][INFO] Query Execution Time:0.000116109848022
Tue Dec 30 12:50:21 2008 [32039][1][INFO] Query:SELECT category, name, value FROM config
Tue Dec 30 12:50:21 2008 [32039][1][INFO] Query Execution Time:0.000128030776978
Tue Dec 30 12:50:21 2008 [32039][1][INFO] Query:SELECT id FROM outbound_email WHERE type = 'system'
Tue Dec 30 12:50:21 2008 [32039][1][INFO] Query Execution Time:8.10623168945E-5
Tue Dec 30 12:50:21 2008 [32039][1][INFO] Query:SELECT * FROM outbound_email WHERE id = '4bc63c56-d78f-5c3b-c12d-4884678370ee'
Tue Dec 30 12:50:21 2008 [32039][1][INFO] Query Execution Time:9.48905944824E-5
Tue Dec 30 12:50:21 2008 [32039][1][DEBUG] Performing action: action_listview MODULE: ProspectLists
Tue Dec 30 12:50:21 2008 [32039][1][INFO] Query:INSERT INTO tracker (monitor_id,user_id,module_name,date_modified,acti on,session_id ) VALUES ( '57c12fb1-12e4-54fd-8f6f-495a5fef18e6','1','ProspectLists','2008-12-30 17:50:21','index','d9ef431b7c3162759adb9ccb0d18d05 a')
Tue Dec 30 12:50:21 2008 [32039][1][INFO] Query Execution Time:0.000548124313354
Tue Dec 30 12:50:21 2008 [32039][1][INFO] Query:SELECT placement,name,id,url from iframes WHERE deleted=0 AND status=1 AND (placement='tab' OR placement='all') AND (type='global' OR (type='personal' AND created_by='1')) ORDER BY iframes.name
Tue Dec 30 12:50:21 2008 [32039][1][INFO] Query Execution Time:0.000115156173706
Tue Dec 30 12:50:21 2008 [32039][1][INFO] Query:SELECT item_id, item_summary, module_name, id FROM tracker WHERE id = (SELECT MAX(id) as id FROM tracker WHERE user_id = '1' AND visible = 1)
Tue Dec 30 12:50:21 2008 [32039][1][INFO] Query Execution Time:0.000463008880615
Tue Dec 30 12:50:21 2008 [32039][1][INFO] Tracker: retrieving 10 items


Note that there are no errors in the log, and also there is no query for prospect_lists.

I feel that the "Target Lists" shortcut does not do where it is supposed to do.

Any suggestions?

Thanks!

[russkey]

Hello again,

I think I have found the reason why "Target Lists" shortcut does not work.

I have enabled PHP error logs and saw a fatal error trying to access the file

modules/ProspectLists/metadata/listviewdefs.php

which does not exist in my 5.2 installation. I have also checked in the backup of 5.0.0f, the file is not there either.

Also, the file modules/ProspectLists/metadata/searchdefs.php does not exist, but is needed.

Could someone please check if these files exist on your system?

I suspect that users who had earlier versions of SugarCRM (4.x) might have these files, but my system started from 5.0.0f and upgraded to 5.2, maybe these files were missing in the 5.0 installer?

If these files do exist, could you please post the files (just the php code).

Thanks!

[kbrill]

What modules do you have loaded in the "Module Loader". I am betting you have something that is not 5.2 compatible.

[russkey]

Hi,

I have no extensions installed, only the standard SugarCRM 5.2 stuff.

There are no items listed in the Administration Module Loader.

Could you please confirm that the "Target Lists" shortcut under Campaigns works on your system, and if it does, do you have these files in your system:

modules/ProspectLists/metadata/listviewdefs.php
and
modules/ProspectLists/metadata/searchdefs.php

If these files are present, could you please let me know if your system is an upgrade starting from 4.* version of SugarCRM or a clean install of version 5.0 or later?

Oh, also if these files are present, could you please post these files?

Thanks a lot!

[kbrill]

Did you have any modules loaded in the past that you uninstalled? Just as a quick test, rename your 'custom' directory to 'custom_old' and then run a 'Quick Repair' (TURN OFF DATABASE REPAIR FIRST). Then see if your targets are working. Get everyone off the system first as this will turn off custom fields. When done rename 'custom_old' back to 'custom' and re run the Quick Repair (again without the database repair checked) and everything will go back to normal.

As with most things it might be wise to back the system up before doing this but as long as you do not run the 'repair database' part of the Quick Repair facility you will be OK.

I am pretty sure I have seeen this issue before and it turnedout to be a 1/2 uninstalled forums module (although it could be any module).