Ajax error after upgrade

gnurob:

Did you try the ā€œsolutionā€ that mkrawczyk explain?

It ā€™ s not an official workaround but I think it can help temporaly

I did but it didnā€™t help. Everything after 0 => ā€˜SecurityGroupsā€™ didnā€™t exist, when this problem appeared, and now that it does (several repairs and R2 beta upgrade later), removing it had no effect. Removing the addAjaxBannedModules is the same as moving the modules to enabled under the Admin page. Doing so recreates the AJAX error, which I can only remove by disabling them.

In order to get AJAX working, it was necessary to first shift reload the non-AJAX version, and shift reload the re-enabled AJAX version. For each module.

With that temporary solution (the AJAX errors reappeared a few times, cause unknown), I left AJAX disabled for now.

So, the big problem is the missing panels under the detail view (like History, for example).

Thanks!

With respect to the missing subpanels. It looks like the script starts executing, but not much in the way of an error. The closing BODY and HTML tags are missing.

Activities, History, Documents, Contacts, Opportunities, Campaigns, Leads, Member Organizations, Cases, Products and Services Purchased, Bugs, Projects, Security Groups, and the footer are missing.

<span id="date_entered" class="sugar_field">01/06/2016 20:11 by Last,  First</span>
</td>
</tr>
</table>
<script type="text/javascript">SUGAR.util.doWhen("typeof initPanel == 'function'", function() { initPanel(3, 'expanded'); }); </script>
</div>
</div>
</div>
</form>
<script>SUGAR.util.doWhen("document.getElementById('form') != null",
        function(){SUGAR.util.buildAccessKeyLabels();});
</script><script type="text/javascript" src="include/InlineEditing/inlineEditing.js"></script>
<script type="text/javascript" src="modules/Favorites/favorites.js"></script>

Even at INFO level logging, there isnā€™t much to see (besdies maybe num_rows => 0.

Fri Jan  8 00:58:17 2016 [11353][1][DEBUG] process_full_list_query: result is mysqli_result Object
(
    [current_field] => 0
    [field_count] => 22
    [lengths] => 
    [num_rows] => 0
    [type] => 0
)

Fri Jan  8 00:58:17 2016 [11353][1][INFO] Query:SELECT category, name, value FROM config WHERE category = 'tracker'
Fri Jan  8 00:58:17 2016 [11353][1][INFO] Query Execution Time:0.00018000602722168
Fri Jan  8 00:58:17 2016 [11353][1][INFO] Query:SELECT id FROM outbound_email WHERE type = 'system'
Fri Jan  8 00:58:17 2016 [11353][1][INFO] Query Execution Time:0.00017285346984863
Fri Jan  8 00:58:17 2016 [11353][1][INFO] Query:SELECT * FROM outbound_email WHERE id = 'lots_of_hex'
Fri Jan  8 00:58:17 2016 [11353][1][INFO] Query Execution Time:0.00017499923706055
Fri Jan  8 00:58:17 2016 [11353][1][INFO] Query:SELECT category, name, value FROM config WHERE category = 'MySettings'
Fri Jan  8 00:58:17 2016 [11353][1][INFO] Query Execution Time:0.00020790100097656
Fri Jan  8 00:58:17 2016 [11353][1][INFO] Query:SELECT id FROM outbound_email WHERE type = 'system'
Fri Jan  8 00:58:17 2016 [11353][1][INFO] Query Execution Time:0.00017213821411133
Fri Jan  8 00:58:17 2016 [11353][1][INFO] Query:SELECT * FROM outbound_email WHERE id = 'lots_of_hex'
Fri Jan  8 00:58:17 2016 [11353][1][INFO] Query Execution Time:0.00018596649169922
Fri Jan  8 00:58:17 2016 [11353][1][DEBUG] Hook called: ::server_round_trip
Fri Jan  8 00:58:17 2016 [11353][1][DEBUG] Calling MySQLi::disconnect()

By the way, SuiteCRM behavior depends on browser type. I made a test, please take a look (the same settings of SuiteCRM): 1. Iceweasel, 2. Chromium. Perhaps here lies the problem?

1 Like

I tried your suggestions. The problem persists in OSX Firefox, OSX Safari, and iOS Safari.

Hi,

can you debug this problem in firefox by the following steps?

Thanks jansiero,

Iā€™m not qualified to debug this. However, there were a few findings that may be useful to the community.

Firebug caught a ā€œ500 Internal Server Errorā€ and ā€œuncaught exception: AjaxUI error parsing response.ā€

With the 500 error, I found more in the Apache error log:

[Sat Jan 09 11:30:18 2016] [error] [client 127.0.0.1] PHP Catchable fatal error:  Argument 1 passed to Reminder::isDecline() must be an instance of SugarBean, boolean given, called in /Library/WebServer/www_web_server_name/service/modules/Reminders/Reminder.php on line 299 and defined in /Library/WebServer/www_web_server_name/service/modules/Reminders/Reminder.php on line 374, referer: http://www.web_site.name/service/index.php?module=Administration&action=index
[Sat Jan 09 11:30:20 2016] [error] [client 127.0.0.1] PHP Catchable fatal error:  Argument 1 passed to Reminder::isDecline() must be an instance of SugarBean, boolean given, called in /Library/WebServer/www_web_server_name/service/modules/Reminders/Reminder.php on line 299 and defined in /Library/WebServer/www_web_server_name/service/modules/Reminders/Reminder.php on line 374, referer: http://www.web_site.name/service/index.php?action=ajaxui

@gnurob,
is the removal of part of 299 line in /Library/WebServer/www_web_server_name/service/modules/Reminders/Reminder.php does not solve the problem?
(!$checkDecline[strike] || ($checkDecline && !self::isDecline($relatedEvent, BeanFactory::getBean(ā€˜Usersā€™, $current_user->id)))[/strike])
If so, then best to install version 7.4.1 (instead of 7.4.3) - no Reminder.php. I just did and everything works well :slight_smile:

3 Likes

Yes! This fixed the AJAX error, both in create new security role (in which AJAX cannot be disabled), and all the modules under Configure AJAX User Interface. There are no errors, with modules enabled or disabled.

Furthermore, the processing of the Activities, History, Documents, Contacts, Opportunities, Campaigns, Leads, Member Organizations, Cases, Products and Services Purchased, Bugs, Projects, and Security Groups pages are now complete, with all subpanels, all the way to the footer.

This is the subject of an as-yet unassigned bug report:

https://github.com/salesagility/SuiteCRM/issues/776

I can confirm the same behaviour on SuiteCRM 7.4.3, that this was triggered only after testing meeting notifications, and that the behaviour where modules dragged and dropped into the AJAX disabled column refusing to be renabled (appearing instead to be disabled again when the page is navigated back to) is absolutely reproducible.

Serious bug, as it renders the UI unusable.

Cheers,
Dave

Hi everyone,

i had to disable all my modules and i followed mkrawczyk post about modules/Reminders/Reminder.php

I also noticed that after upgrading from 7.1.8 to 7.5.3 (three passages between)
i have to copy all files and folders of jjwg_[ā€¦] modules from my previsious istance or geolocation would point me in the Pacific Ocean, and
i have to copy all images from themes/default/images to custom/themes/default/images or it wont display any markers.
In addiction the favourite star is not showed. (there is, i can click on it)


Any idea about it?

I have the same problem, and I fixed with:

change some things in file php.ini

  • max_execution_time = 600
  • memory_limit = 512M

It was long research and finally, I found the issue.

I migrated the SuiteCRM 7.10.4 from one server to another and realized that ajax doesnā€™t work. Moreover the API as well.

I installed additional php modulse and now everything works fine.

$ sudo apt-get install php-pear php7.0-dev php7.0-zip php7.0-curl php7.0-gd php7.0-mysql php7.0-mcrypt php7.0-xml libapache2-mod-php7.0

I hope it can help you as well.