Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Campaign wizard goes to blank screen at "Target Lists" Step (v7.6.4) #1557

Closed
kyriakoy opened this issue Jun 6, 2016 · 4 comments
Closed
Assignees
Labels
Type:Bug Bugs within the core SuiteCRM codebase

Comments

@kyriakoy
Copy link

kyriakoy commented Jun 6, 2016

Apply to versions 7.6.3 and 7.6.4.
When I open the new Campaign wizard, If I click on Target List or Campaign Header, the screen goes blank.

Repported also here from other people:
https://suitecrm.com/forum/suitecrm-7-0-discussion/9501-7-6-3-campaign-wizard-blank-screen

My Installation:
SuiteCRM 7.6.4/Ubuntu 14.04/ php 5.5.9/ mysql 5.5.49

chown -Rf www-data:www-data crm.website.folder
sudo chown -R www- data:www-data .
chmod 664 config.php
sudo chmod -R 755 .
sudo chmod -R 775 cache custom modules themes data upload config_override.php

@samus-aran
Copy link
Contributor

Hi @kyriakoy What browser are you currently using? Can you try and refreshing your browser's cache?

@samus-aran samus-aran added the Type:Bug Bugs within the core SuiteCRM codebase label Jun 8, 2016
@kyriakoy
Copy link
Author

kyriakoy commented Jun 8, 2016

Hi,

Yes I have multiple times with diffrent computers, connections, browsers etc....

I found that the problem is only with an existing Campaign (created with prior versions). When I refresh the page I show to log the following:
Wed Jun 8 17:22:10 2016 [1027][1][INFO] Query:SELECT campaign_trkrs.* FROM campaign_trkrs WHERE campaign_trkrs.id = '5b480df8-aef7-d5b8-cc45-5470859919c2' AND campaign_trkrs.deleted=0 LIMIT 0,1
Wed Jun 8 17:22:10 2016 [1027][1][INFO] Query Execution Time:3.6954879760742E-5
Wed Jun 8 17:22:10 2016 [1027][1][INFO] Query:SELECT name from campaigns where id = '41c7b4f6-ef1e-eb5d-8ccb-54705d670387'
Wed Jun 8 17:22:10 2016 [1027][1][INFO] Query Execution Time:3.3855438232422E-5
Wed Jun 8 17:22:10 2016 [1027][1][DEBUG] Hook called: CampaignTrackers::after_retrieve
Wed Jun 8 17:22:10 2016 [1027][1][DEBUG] get_full_list: order_by = '' and where = ''
Wed Jun 8 17:22:10 2016 [1027][1][DEBUG] SugarBean[ProspectList].load_relationships, Loading relationship (assigned_user_link).
Wed Jun 8 17:22:10 2016 [1027][1][DEBUG] rebuilding cache for prospectlists
Wed Jun 8 17:22:10 2016 [1027][1][INFO] Query:SELECT * FROM fields_meta_data WHERE custom_module='prospectlists' AND deleted = 0
Wed Jun 8 17:22:10 2016 [1027][1][INFO] Query Execution Time:4.1007995605469E-5
Wed Jun 8 17:22:10 2016 [1027][1][DEBUG] Failed to load vardefs for prospectlists: in linkFieldsForModule

Wed Jun 8 17:22:10 2016 [1027][1][ERROR] Unable to get proper side for link assigned_user_link
Wed Jun 8 17:22:10 2016 [1027][1][ERROR] Unable to get proper side for link assigned_user_link
Wed Jun 8 17:22:10 2016 [1027][1][DEBUG] SugarBean[ProspectList].load_relationships, Loading relationship (modified_user_link).
Wed Jun 8 17:22:10 2016 [1027][1][DEBUG] SugarBean.load_relationships, Error Loading relationship (modified_user_link)
Wed Jun 8 17:22:10 2016 [1027][1][DEBUG] SugarBean[ProspectList].load_relationships, Loading relationship (created_by_link).
Wed Jun 8 17:22:10 2016 [1027][1][DEBUG] SugarBean.load_relationships, Error Loading relationship (created_by_link)

then I search for :

grep -rl "assigned_user_link" ./ |grep "Prospect"

./cache/modules/Prospects/Prospectvardefs.php
./cache/modules/ProspectLists/ProspectListvardefs.php

As you can see exist only at cache. Is this proper ?
I have already Rebuild Cache and Relatiotionships

Permissions are:
sudo chmod -R 775 cache custom modules themes data upload config_override.php

Thank you,
Nikos

@kyriakoy
Copy link
Author

kyriakoy commented Jun 8, 2016

I check it also and with another existing Campaign with the same problem (blank problem) and in sugarcrm.log I didn't found the previews error
But one additional debuging with Firebug shows Internal Error 500 and apache log shows:

http://mycrm.com/index.php?action=WizardMarketing&module=Campaigns&return_module=Campaigns&return_action=WizardHome&return_id=41c7b4f6-ef1e-eb5d-8ccb-54705d670387&campaign_id=41c7b4f6-ef1e-eb5d-8ccb-54705d670387&jump=3&show_wizard_marketing=1&marketing_id=5cd80d11-1ccc-6f20-c929-547081d44cdb&record=5cd80d11-1ccc-6f20-c929-547081d44cdb&campaign_type=Email
[Wed Jun 08 18:43:02.338239 2016] [:error] [pid 4736] [client 62.169.208.109:2024] PHP Fatal error: Call to a member function get_entry_count() on a non-object in /var/www/mycrm.com/modules/Campaigns/WizardNewsletter.php on line 480, referer: http://mycrm.com/index.php?action=WizardMarketing&module=Campaigns&return_module=Campaigns&return_action=WizardHome&return_id=41c7b4f6-ef1e-eb5d-8ccb-54705d670387&campaign_id=41c7b4f6-ef1e-eb5d-8ccb-54705d670387&jump=3&show_wizard_marketing=1&marketing_id=5cd80d11-1ccc-6f20-c929-547081d44cdb&record=5cd80d11-1ccc-6f20-c929-547081d44cdb&campaign_type=Email

Maybe this can help

@kyriakoy
Copy link
Author

Thank you for the update
I confirm that is working

samus-aran added a commit that referenced this issue Jun 15, 2016
Fixed #1557 - don't try to show deleted target lists
isleshocky77 pushed a commit to isleshocky77/SuiteCRM that referenced this issue Nov 3, 2017
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Type:Bug Bugs within the core SuiteCRM codebase
Projects
None yet
Development

No branches or pull requests

3 participants