7.4 Favourites - how do you filter listviews?

Bungle · 2 November 2015 20:57

Hi,

I just upgraded to 7.4 - always improving

I can mark a record as a favorite and it shows up correctly in the suitecrm sidebar, however i cant seem to figure out how to filter the listviews.

I have added the ‘My Ffavorites’ field to the search views in studio but the results seem to ignore the field and return the full set of records, and the resulting page seems to clear the ‘My Favourite’ checkbox.

Am i missing something, or is this a bug?
Regards
b

John · 3 November 2015 15:53

Hi,

This works as expected for me on Accounts.

Which module are you trying to filter by favourites on?

Which Search Layout did you add it to?
Ensure that it is added to both the Basic Search and Advanced Search Layouts.

Are there any errors in your suitecrm.log file?
or in the browser’s console when doing this?

Bungle · 5 November 2015 10:28

Hi John,

I was trying it with the Project module. However i have the same issue with accounts .

I’ve added it to both the basic and advanced search layouts and the tickbox shows up correctly, but again it has no effect and the full set of records is returned and the ‘My Favourites’ checkbox is cleared.

There is nothing in the crm log files to indicate an error, or in the browser console.

The ‘My Favourites’ field only appears in the basic and advanced search layouts too - there its not available in edit view or listviews etc?

John · 6 November 2015 13:40

Hi,

Have you made any customizations to the code of your CRM areound the search/listview functionality?

Ensure that you are not clicking “Clear”, the button next to search, at any point during the process as this will clear all search terms.

Could you provide before and after screenshots for clarity’s sake?

You are correct, the “My Favourites” field only appears in the Search layouts. I don’t think that there would be much gained from being able to add it to editviews/listviews, so it’s not part of standard functionality to do so.

danielfv · 9 November 2015 00:19

Hi,

I’m not trying to hijack the thread, I just wanted to let you know that I’m having the same problem.

I added the My Favorites field to both the Basic Search and Advanced Search but when I try to filter using this field it returns all the records. The filter is not applied. It has the same functionality as if I had pressed the “Search” button again.

I’m adding attaching a screenshot.

Thank you

John · 9 November 2015 11:34

Hi,

Did you upgrade to 7.4 from another version, danielfv?
If so, what version did you upgrade from?

Do any errors show in your suitecrm.log, or the browser’s console when attempting to search?

Bungle has stated that he too upgraded to 7.4, so the issue may lie here.

danielfv · 9 November 2015 13:58

Hi,

Yes, I upgraded from 7.3.1.

I want to add that the upgrade didn’t go smoothly, it constantly stopped with error messages saying that it could rename a temp file, the message was: sugar_file_put_contents_atomic() : fatal rename failure.

Something similar as this:

PHP Fatal error: sugar_file_put_contents_atomic() : fatal rename failure '/tmp/temp8lJt8U' -> 'cache/modules/Trackers/Trackervardefs.php' in /var/www/html/suitecrm/include/utils/sugar_file_utils.php on line 195.

To solve this error I had to constantly chown apache:apache -R to the suitecrm directory and reload the upgrade. This is the same reason I never upgraded to 7.3.2, I saw the same messages.

In regards to error messages, in the browser console I only see this message when I load any page but I don’t think it’s related to this problem:

Caught TypeError: Cannot read property 'outerHTML' of undefined(anonymous function) @ inlineEditing.js:44

In suitecrm.log I only see this mention to the favorites table when I run the search Accounts with the My Favorites field selected in the filter:



Mon Nov  9 06:32:08 2015 [6853][c76ab76f-27a0-c3f4-21d9-4b4f30d893a4][INFO] Query:SELECT u1.first_name, u1.last_name from users  u1, users  u2 where u1.id = u2.reports_to_id AND u2.id = 'c76ab76f-27a0-c3f4-21d9-4b4f30d893a4' and u1.deleted=0
Mon Nov  9 06:32:08 2015 [6853][c76ab76f-27a0-c3f4-21d9-4b4f30d893a4][INFO] Query Execution Time:0.00020408630371094
Mon Nov  9 06:32:08 2015 [6853][c76ab76f-27a0-c3f4-21d9-4b4f30d893a4][INFO] Query:SELECT ea.email_address, ea.email_address_caps, ea.invalid_email, ea.opt_out, ea.date_created, ea.date_modified,
                ear.id, ear.email_address_id, ear.bean_id, ear.bean_module, ear.primary_address, ear.reply_to_address, ear.deleted
                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 = 'c76ab76f-27a0-c3f4-21d9-4b4f30d893a4'
                AND ear.deleted = 0
                ORDER BY ear.reply_to_address, ear.primary_address DESC
Mon Nov  9 06:32:08 2015 [6853][c76ab76f-27a0-c3f4-21d9-4b4f30d893a4][INFO] Query Execution Time:0.00050616264343262
Mon Nov  9 06:32:08 2015 [6853][c76ab76f-27a0-c3f4-21d9-4b4f30d893a4][DEBUG] Hook called: Users::after_retrieve
Mon Nov  9 06:32:08 2015 [6853][c76ab76f-27a0-c3f4-21d9-4b4f30d893a4][DEBUG] Current user is: daniel
Mon Nov  9 06:32:08 2015 [6853][c76ab76f-27a0-c3f4-21d9-4b4f30d893a4][DEBUG] Current user is: daniel
Mon Nov  9 06:32:08 2015 [6853][c76ab76f-27a0-c3f4-21d9-4b4f30d893a4][DEBUG] setting cookie ck_login_id_20 to c76ab76f-27a0-c3f4-21d9-4b4f30d893a4
Mon Nov  9 06:32:08 2015 [6853][c76ab76f-27a0-c3f4-21d9-4b4f30d893a4][DEBUG] setting cookie ck_login_language_20 to es_ES
Mon Nov  9 06:32:08 2015 [6853][c76ab76f-27a0-c3f4-21d9-4b4f30d893a4][DEBUG] current_language is: es_ES
Mon Nov  9 06:32:08 2015 [6853][c76ab76f-27a0-c3f4-21d9-4b4f30d893a4][DEBUG] Performing action: action_listview MODULE: Accounts
Mon Nov  9 06:32:08 2015 [6853][c76ab76f-27a0-c3f4-21d9-4b4f30d893a4][INFO] Query:SELECT parent_id, parent_type FROM favorites WHERE assigned_user_id = 'c76ab76f-27a0-c3f4-21d9-4b4f30d893a4' AND deleted = 0 ORDER BY date_entered desc
Mon Nov  9 06:32:08 2015 [6853][c76ab76f-27a0-c3f4-21d9-4b4f30d893a4][INFO] Query Execution Time:0.00045585632324219

I’m attaching my favorites table to this post.

I’m also attaching the whole suitecrm.log contents when I run the Search on My Favorites on Accounts.

Thank you

John · 9 November 2015 16:08

Hi,
It’s likely that the following settings in your php.ini file weren’t high enough, which can cause issues such as “fatal rename failure.”
We usually recommend doing the following changes to your php.ini before an upgrade:
Set post_max_size to at least 60MB
Set upload_max_filesize settings to at least 60MB
Set max_input_time to a large number
Set memory_limit to 256MB
Restart your Apache Service.

We also recommend setting these permissions on your instance:
sudo chown -R apache:apache .
sudo chmod -R 755 .
sudo chmod -R 775 cache custom modules themes data upload config_override.php

And, in your config.php file for your CRM, find the lines:
‘default_permissions’ =>
array (
‘dir_mode’ => ,
‘file_mode’ => ,
‘user’ => ‘’,
‘group’ => ‘’,
),

You should replace these values with:
‘default_permissions’ =>
array (
‘dir_mode’ => 1517,
‘file_mode’ => 420,
‘user’ => ‘apache’,
‘group’ => ‘apache’,
),

If you do these changes, Try running a Quick Repair and Rebuild. You can find this in the Admin > Repair menu.
On the screen that appears, scroll to the Bottom and execute any changes that appear.
Continue to run Quick Repair and Rebuilds until no changes appear.

Bungle · 11 November 2015 17:40

Hi,

I had made customisations in some modules, but am getting the same results in every module - even un-customised ones.

I also had installation issues, but only because of permissions. Once permissions had been set the upgrade ran smoothly.

I’m definitely not catching the cancel button.

Ive attached some screen shots. Capture1 - before selecting favourites. Capture 2. faviourites ticked. i click search and then capture 3 is the result.

Nothing in log or in browser window.

rossella · 21 June 2016 16:04

Hello,
I have the same problem, My Favorites does not filter search results. I have upgraded from 7.1.2 to 7.6.4 in 3 steps with no fatal errors.

Does anybody have news on this?

Thanks,
Rossella

sieberta · 24 August 2016 21:24

When I add “My Favorites” to basic search in Accounts or Contacts I can no longer open basic search (the button does nothing). Any thoughts? I haven’t tried any other modules. I’m not sure this is even an option on all modules. I recently upgraded from 7.3.x (didn’t have favorites) to 7.7.2… with no issues to speak of.

sieberta

sieberta · 24 August 2016 21:38

Also, when it does work on my dev system (not sure why) it doesn’t filter the favorites, just like the other posters in here.

sieberta · 25 August 2016 14:17

Additional information… which I guess is in line with what others said in here, I was upgrading from 7.3.1 to 7.7.2. I just started that over on another development instance, and paused at 7.4.4 along the upgrade path to see if favorites were working and then broke. That is not the case.

There is some stuff in the error logs, however the table does exist. I think these showed up during the upgrade, not during my test search, because when I do another test search these aren’t regenerated.


Thu Aug 25 06:46:40 2016 [31460][1][FATAL]  Query Failed: SELECT parent_id, parent_type FROM favorites WHERE assigned_user_id = '1' AND deleted = 0 ORDER BY date_entered desc: MySQL error 1146: Table 'aeng_dev3.favorites' doesn't exist
Thu Aug 25 06:47:03 2016 [31475][1][FATAL]  Query Failed: SELECT parent_id, parent_type FROM favorites WHERE assigned_user_id = '1' AND deleted = 0 ORDER BY date_entered desc: MySQL error 1146: Table 'aeng_dev3.favorites' doesn't exist
Thu Aug 25 06:47:05 2016 [31478][1][FATAL]  Query Failed: SELECT parent_id, parent_type FROM favorites WHERE assigned_user_id = '1' AND deleted = 0 ORDER BY date_entered desc: MySQL error 1146: Table 'aeng_dev3.favorites' doesn't exist
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to find relationship reminders_modified_user
Thu Aug 25 06:47:15 2016 [31478][1][FATAL] modified_user_link for reminders_modified_user failed to load

Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to find relationship reminders_created_by
Thu Aug 25 06:47:15 2016 [31478][1][FATAL] created_by_link for reminders_created_by failed to load

Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to find relationship reminders_assigned_user
Thu Aug 25 06:47:15 2016 [31478][1][FATAL] assigned_user_link for reminders_assigned_user failed to load

Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to find relationship reminders_invitees_modified_user
Thu Aug 25 06:47:15 2016 [31478][1][FATAL] modified_user_link for reminders_invitees_modified_user failed to load

Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to find relationship reminders_invitees_created_by
Thu Aug 25 06:47:15 2016 [31478][1][FATAL] created_by_link for reminders_invitees_created_by failed to load

Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to find relationship reminders_invitees_assigned_user
Thu Aug 25 06:47:15 2016 [31478][1][FATAL] assigned_user_link for reminders_invitees_assigned_user failed to load

Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file powered_by_sugarcrm.gif
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file suite_logo.png
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file sugarsales_myarea.png
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file cube_bg.gif
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file install_themes.jpg
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file poweredby_sugarcrm_65.png
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file suitecrm_login.png
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Skipping unsupported image file type (13) for file SugarPlanet.swf
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file sugarcrm_about_logo.gif
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file poweredby_sugarcrm.png
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file sugar_md_open.png
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file sugarcrm_copyright_logo.jpg
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file sugar_wizard_welcome.jpg
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file icon_ConnectorSearchFieldsOver.gif
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file currentTabOff.gif
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file icon_ConnectorMapOver.gif
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file login-bg.png
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file icon_ConnectorSearchFields.gif
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file plug-in_Lotus.png
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file otherTabGreen.gif
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file currentTabBlue.gif
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file plug-in_Word.gif
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file icon_ConnectorConfigOver.gif
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file currentTab.gif
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file otherTabGray.gif
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file otherTabOcher.gif
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file currentTabGray.gif
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file icon_ConnectorEnable.gif
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file SummationWithDetailsOver.gif
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file layout_sprite.png
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Skipping unsupported image file type (17) for file sugar_icon.ico
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file sugar_icon.ico
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file pdf_logo.jpg
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file icon_package.gif
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file pdf_header_logo_company_logo.png
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file sugar-yui-sprites-grey.png
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file otherTab.gif
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file dp-hd.png
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file otherTabRed.gif
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file pdf_header_logo_pdf_header_logo_SugarCRMheader.jpg
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file SummationWithDetails.gif
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file plug-in_Outlook.gif
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file icon_package_create.gif
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file dp-bd-top-menu.png
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file icon_ModuleBuilder.gif
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file RowsAndColumns.gif
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file bar_loader.gif
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file icon_ConnectorConfig.gif
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file pdf_header_logo_SugarCRMheader.jpg
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file currentTabRed.gif
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file MatrixReportOver.gif
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file RowsAndColumnsOver.gif
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file SummationOver.gif
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file icon_DropDownEditor.gif
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file icon_Studio.gif
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file plug-in_Excel.gif
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file line.gif
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file poweredby_sugarcrm_65.png
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file icon_ConnectorMap.gif
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file chartBg.png
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file Summation.gif
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file themePreview.png
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file company_logo.png
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file otherTabBlue.gif
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file icon_new_package.gif
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file currentTabOcher.gif
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file otherTabPurple.gif
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file icon_ConnectorEnableOver.gif
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file pdf_logo_small.jpg
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file currentTabGreen.gif
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file currentTab.png
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file icon_Application.gif
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file icon_SugarPortal.gif
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file MatrixReport.gif
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file currentTabPurple.gif
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file icon_ConnectorSearchFieldsOver.gif
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file currentTabOff.gif
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file icon_ConnectorMapOver.gif
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file icon_ConnectorSearchFields.gif
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file otherTabGreen.gif
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file currentTabBlue.gif
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file icon_ConnectorConfigOver.gif
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file bigsuite.png
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file currentTab.gif
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file otherTabGray.gif
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file otherTabOcher.gif
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file currentTabGray.gif
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file icon_ConnectorEnable.gif
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file icon_package.gif
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file sugar-yui-sprites-grey.png
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file otherTab.gif
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file sugar-yui-sprites.png
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file otherTabRed.gif
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file icon_package_create.gif
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file icon_ModuleBuilder.gif
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file sugar-yui-sprites-purple.png
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file bar_loader.gif
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file bgnoise.png
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file icon_ConnectorConfig.gif
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file currentTabRed.gif
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file sugar-yui-sprites-green.png
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file icon_DropDownEditor.gif
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file icon_Studio.gif
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file line.gif
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file poweredby_sugarcrm_65.png
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file icon_ConnectorMap.gif
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file themePreview.png
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file otherTabBlue.gif
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file icon_new_package.gif
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file sugar-yui-sprites-red.png
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file currentTabOcher.gif
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file otherTabPurple.gif
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file icon_ConnectorEnableOver.gif
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file currentTabGreen.gif
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file icon_Application.gif
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file icon_SugarPortal.gif
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file currentTabPurple.gif
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file icon_ConnectorSearchFieldsOver.gif
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file currentTabOff.gif
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file icon_ConnectorMapOver.gif
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file icon_ConnectorSearchFields.gif
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file SuiteScreen3.png
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file otherTabGreen.gif
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file currentTabBlue.gif
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file icon_ConnectorConfigOver.gif
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file bigsuite.png
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file currentTab.gif
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file otherTabGray.gif
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file otherTabOcher.gif
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file currentTabGray.gif
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file icon_ConnectorEnable.gif
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file SummationWithDetailsOver.gif
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file pdf_logo.jpg
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file icon_package.gif
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file sugar-yui-sprites-grey.png
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file otherTab.gif
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file sugar-yui-sprites.png
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file themes.gif
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file otherTabRed.gif
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file SuiteScreen2.png
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file pdf_header_logo_pdf_header_logo_SugarCRMheader.jpg
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file SummationWithDetails.gif
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file icon_package_create.gif
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file icon_ModuleBuilder.gif
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file sugar-yui-sprites-purple.png
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file RowsAndColumns.gif
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file bar_loader.gif
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file bgnoise.png
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file icon_ConnectorConfig.gif
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file pdf_header_logo_SugarCRMheader.jpg
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file currentTabRed.gif
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file MatrixReportOver.gif
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file RowsAndColumnsOver.gif
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file SummationOver.gif
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file sugar-yui-sprites-green.png
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file SuiteScreen1.png
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file icon_DropDownEditor.gif
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file SuiteScreen4.png
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file icon_Studio.gif
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file line.gif
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file poweredby_sugarcrm_65.png
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file icon_ConnectorMap.gif
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file Summation.gif
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file themePreview.png
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file otherTabBlue.gif
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file icon_new_package.gif
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file sugar-yui-sprites-red.png
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file currentTabOcher.gif
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file otherTabPurple.gif
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file icon_ConnectorEnableOver.gif
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file pdf_logo_small.jpg
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file currentTabGreen.gif
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file icon_Application.gif
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file icon_SugarPortal.gif
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file MatrixReport.gif
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file currentTabPurple.gif
Thu Aug 25 06:47:15 2016 [31478][1][ERROR] Unable to process image file company_logo.png

I put logs in debug mode, and see successful queries to the favorites database, but I have no idea if those are due to the sidebar or the actual search.

sieberta

sieberta · 25 August 2016 16:27

Here is the search results on a clean install of SuiteCRM 7.7.2:

Thu Aug 25 09:18:19 2016 [6674][1][DEBUG] Limit Query: SELECT  accounts.id , accounts.assigned_user_id , accounts.name , accounts.billing_address_city , accounts.billing_address_country , accounts.phone_office  , jt0.user_name assigned_user_name , jt0.created_by assigned_user_name_owner  , 'Users' assigned_user_name_mod, accounts.date_entered , accounts.created_by  FROM accounts  LEFT JOIN accounts_cstm ON accounts.id = accounts_cstm.id_c   LEFT JOIN  users jt0 ON accounts.assigned_user_id=jt0.id AND jt0.deleted=0

 AND jt0.deleted=0 where ((accounts.id IN (SELECT favorites.parent_id FROM favorites
			                    WHERE favorites.deleted = 0
			                        and favorites.parent_type = 'Accounts'
			                        and favorites.assigned_user_id = '1'))) AND accounts.deleted=0 ORDER BY accounts.date_entered DESC Start: 0 count: 21

Here are the search results on SuiteCRM 7.7.2 that was multi-step upgraded (without errors) from 7.3.1:


Thu Aug 25 09:22:31 2016 [6987][1][DEBUG] Limit Query: SELECT  accounts.id , accounts.name , accounts.billing_address_city , accounts.billing_address_state , accounts.billing_address_country , accounts.phone_office , accounts.account_type , accounts.industry , accounts.date_modified , accounts.date_entered , accounts.assigned_user_id  FROM accounts  LEFT JOIN accounts_cstm ON accounts.id = accounts_cstm.id_c  where accounts.deleted=0 ORDER BY accounts.date_entered DESC Start: 0 count: 21

I would also point out that “My Favorites” checkbox is unchecked when hitting search.

sieberta · 25 August 2016 21:13

I have opened an “issue/bug” on GitHub: https://github.com/salesagility/SuiteCRM/issues/2048

sieberta · 26 August 2016 10:11

So here are the error logs of an upgrade from 7.3.1 to 7.4.4:

System Check: No Errors
Preflight: No Errors
Next Step (Commit?):
[spoiler]Thu Aug 25 15:01:01 2016 [19023][1][FATAL] Query Failed: SELECT parent_id, parent_type FROM favorites WHERE assigned_user_id = ‘1’ AND deleted = 0 ORDER BY date_entered desc: MySQL error 1146: Table ‘aeng_dev5.favorites’ doesn’t exist[/spoiler]
Next Step:
[spoiler]Thu Aug 25 15:01:28 2016 [19034][1][FATAL] Query Failed: SELECT parent_id, parent_type FROM favorites WHERE assigned_user_id = ‘1’ AND deleted = 0 ORDER BY date_entered desc: MySQL error 1146: Table ‘aeng_dev5.favorites’ doesn’t exist
Thu Aug 25 15:01:37 2016 [19041][1][FATAL] Query Failed: SELECT parent_id, parent_type FROM favorites WHERE assigned_user_id = ‘1’ AND deleted = 0 ORDER BY date_entered desc: MySQL error 1146: Table ‘aeng_dev5.favorites’ doesn’t exist[/spoiler]
Next Step (Confirm?):
[spoiler]Thu Aug 25 15:02:00 2016 [19046][1][FATAL] Query Failed: SELECT parent_id, parent_type FROM favorites WHERE assigned_user_id = ‘1’ AND deleted = 0 ORDER BY date_entered desc: MySQL error 1146: Table ‘aeng_dev5.favorites’ doesn’t exist
Thu Aug 25 15:02:04 2016 [19055][1][FATAL] Query Failed: SELECT parent_id, parent_type FROM favorites WHERE assigned_user_id = ‘1’ AND deleted = 0 ORDER BY date_entered desc: MySQL error 1146: Table ‘aeng_dev5.favorites’ doesn’t exist
[/spoiler]
Next Step (Upgrade Summary):
[spoiler]
Thu Aug 25 15:02:28 2016 [19063][1][FATAL] Query Failed: SELECT parent_id, parent_type FROM favorites WHERE assigned_user_id = ‘1’ AND deleted = 0 ORDER BY date_entered desc: MySQL error 1146: Table ‘aeng_dev5.favorites’ doesn’t exist
Thu Aug 25 15:02:45 2016 [19063][1][ERROR] Unable to find relationship reminders_modified_user
Thu Aug 25 15:02:45 2016 [19063][1][FATAL] modified_user_link for reminders_modified_user failed to load

Thu Aug 25 15:02:45 2016 [19063][1][ERROR] Unable to find relationship reminders_created_by
Thu Aug 25 15:02:45 2016 [19063][1][FATAL] created_by_link for reminders_created_by failed to load

Thu Aug 25 15:02:45 2016 [19063][1][ERROR] Unable to find relationship reminders_assigned_user
Thu Aug 25 15:02:45 2016 [19063][1][FATAL] assigned_user_link for reminders_assigned_user failed to load

Thu Aug 25 15:02:45 2016 [19063][1][ERROR] Unable to find relationship reminders_invitees_modified_user
Thu Aug 25 15:02:45 2016 [19063][1][FATAL] modified_user_link for reminders_invitees_modified_user failed to load

Thu Aug 25 15:02:45 2016 [19063][1][ERROR] Unable to find relationship reminders_invitees_created_by
Thu Aug 25 15:02:45 2016 [19063][1][FATAL] created_by_link for reminders_invitees_created_by failed to load

Thu Aug 25 15:02:45 2016 [19063][1][ERROR] Unable to find relationship reminders_invitees_assigned_user
Thu Aug 25 15:02:45 2016 [19063][1][FATAL] assigned_user_link for reminders_invitees_assigned_user failed to load

Thu Aug 25 15:02:45 2016 [19063][1][ERROR] Unable to process image file powered_by_sugarcrm.gif
Thu Aug 25 15:02:45 2016 [19063][1][ERROR] Unable to process image file suite_logo.png
Thu Aug 25 15:02:45 2016 [19063][1][ERROR] Unable to process image file sugarsales_myarea.png
Thu Aug 25 15:02:45 2016 [19063][1][ERROR] Unable to process image file cube_bg.gif
Thu Aug 25 15:02:45 2016 [19063][1][ERROR] Unable to process image file install_themes.jpg
Thu Aug 25 15:02:45 2016 [19063][1][ERROR] Unable to process image file poweredby_sugarcrm_65.png
Thu Aug 25 15:02:45 2016 [19063][1][ERROR] Unable to process image file suitecrm_login.png
Thu Aug 25 15:02:45 2016 [19063][1][ERROR] Skipping unsupported image file type (13) for file SugarPlanet.swf
Thu Aug 25 15:02:45 2016 [19063][1][ERROR] Unable to process image file sugarcrm_about_logo.gif
Thu Aug 25 15:02:45 2016 [19063][1][ERROR] Unable to process image file poweredby_sugarcrm.png
Thu Aug 25 15:02:45 2016 [19063][1][ERROR] Unable to process image file sugar_md_open.png
Thu Aug 25 15:02:45 2016 [19063][1][ERROR] Unable to process image file sugarcrm_copyright_logo.jpg
Thu Aug 25 15:02:45 2016 [19063][1][ERROR] Unable to process image file sugar_wizard_welcome.jpg
Thu Aug 25 15:02:45 2016 [19063][1][ERROR] Unable to process image file icon_ConnectorSearchFieldsOver.gif
Thu Aug 25 15:02:45 2016 [19063][1][ERROR] Unable to process image file currentTabOff.gif
Thu Aug 25 15:02:45 2016 [19063][1][ERROR] Unable to process image file icon_ConnectorMapOver.gif
Thu Aug 25 15:02:45 2016 [19063][1][ERROR] Unable to process image file login-bg.png
Thu Aug 25 15:02:45 2016 [19063][1][ERROR] Unable to process image file icon_ConnectorSearchFields.gif
Thu Aug 25 15:02:45 2016 [19063][1][ERROR] Unable to process image file plug-in_Lotus.png
Thu Aug 25 15:02:45 2016 [19063][1][ERROR] Unable to process image file otherTabGreen.gif
Thu Aug 25 15:02:45 2016 [19063][1][ERROR] Unable to process image file currentTabBlue.gif
Thu Aug 25 15:02:45 2016 [19063][1][ERROR] Unable to process image file plug-in_Word.gif
Thu Aug 25 15:02:45 2016 [19063][1][ERROR] Unable to process image file icon_ConnectorConfigOver.gif
Thu Aug 25 15:02:45 2016 [19063][1][ERROR] Unable to process image file currentTab.gif
Thu Aug 25 15:02:45 2016 [19063][1][ERROR] Unable to process image file otherTabGray.gif
Thu Aug 25 15:02:45 2016 [19063][1][ERROR] Unable to process image file otherTabOcher.gif
Thu Aug 25 15:02:45 2016 [19063][1][ERROR] Unable to process image file currentTabGray.gif
Thu Aug 25 15:02:45 2016 [19063][1][ERROR] Unable to process image file icon_ConnectorEnable.gif
Thu Aug 25 15:02:45 2016 [19063][1][ERROR] Unable to process image file SummationWithDetailsOver.gif
Thu Aug 25 15:02:45 2016 [19063][1][ERROR] Unable to process image file layout_sprite.png
Thu Aug 25 15:02:45 2016 [19063][1][ERROR] Skipping unsupported image file type (17) for file sugar_icon.ico
Thu Aug 25 15:02:45 2016 [19063][1][ERROR] Unable to process image file sugar_icon.ico
Thu Aug 25 15:02:45 2016 [19063][1][ERROR] Unable to process image file pdf_logo.jpg
Thu Aug 25 15:02:45 2016 [19063][1][ERROR] Unable to process image file icon_package.gif
Thu Aug 25 15:02:45 2016 [19063][1][ERROR] Unable to process image file pdf_header_logo_company_logo.png
Thu Aug 25 15:02:45 2016 [19063][1][ERROR] Unable to process image file sugar-yui-sprites-grey.png
Thu Aug 25 15:02:45 2016 [19063][1][ERROR] Unable to process image file otherTab.gif
Thu Aug 25 15:02:45 2016 [19063][1][ERROR] Unable to process image file dp-hd.png
Thu Aug 25 15:02:45 2016 [19063][1][ERROR] Unable to process image file otherTabRed.gif
Thu Aug 25 15:02:45 2016 [19063][1][ERROR] Unable to process image file pdf_header_logo_pdf_header_logo_SugarCRMheader.jpg
Thu Aug 25 15:02:45 2016 [19063][1][ERROR] Unable to process image file SummationWithDetails.gif
Thu Aug 25 15:02:45 2016 [19063][1][ERROR] Unable to process image file plug-in_Outlook.gif
Thu Aug 25 15:02:45 2016 [19063][1][ERROR] Unable to process image file icon_package_create.gif
Thu Aug 25 15:02:45 2016 [19063][1][ERROR] Unable to process image file dp-bd-top-menu.png
Thu Aug 25 15:02:45 2016 [19063][1][ERROR] Unable to process image file icon_ModuleBuilder.gif
Thu Aug 25 15:02:45 2016 [19063][1][ERROR] Unable to process image file RowsAndColumns.gif
Thu Aug 25 15:02:45 2016 [19063][1][ERROR] Unable to process image file bar_loader.gif
Thu Aug 25 15:02:45 2016 [19063][1][ERROR] Unable to process image file icon_ConnectorConfig.gif
Thu Aug 25 15:02:45 2016 [19063][1][ERROR] Unable to process image file pdf_header_logo_SugarCRMheader.jpg
Thu Aug 25 15:02:45 2016 [19063][1][ERROR] Unable to process image file currentTabRed.gif
Thu Aug 25 15:02:45 2016 [19063][1][ERROR] Unable to process image file MatrixReportOver.gif
Thu Aug 25 15:02:45 2016 [19063][1][ERROR] Unable to process image file RowsAndColumnsOver.gif
Thu Aug 25 15:02:45 2016 [19063][1][ERROR] Unable to process image file SummationOver.gif
Thu Aug 25 15:02:45 2016 [19063][1][ERROR] Unable to process image file icon_DropDownEditor.gif
Thu Aug 25 15:02:45 2016 [19063][1][ERROR] Unable to process image file icon_Studio.gif
Thu Aug 25 15:02:45 2016 [19063][1][ERROR] Unable to process image file plug-in_Excel.gif
Thu Aug 25 15:02:45 2016 [19063][1][ERROR] Unable to process image file line.gif
Thu Aug 25 15:02:45 2016 [19063][1][ERROR] Unable to process image file poweredby_sugarcrm_65.png
Thu Aug 25 15:02:45 2016 [19063][1][ERROR] Unable to process image file icon_ConnectorMap.gif
Thu Aug 25 15:02:45 2016 [19063][1][ERROR] Unable to process image file chartBg.png
Thu Aug 25 15:02:45 2016 [19063][1][ERROR] Unable to process image file Summation.gif
Thu Aug 25 15:02:45 2016 [19063][1][ERROR] Unable to process image file themePreview.png
Thu Aug 25 15:02:45 2016 [19063][1][ERROR] Unable to process image file company_logo.png
Thu Aug 25 15:02:45 2016 [19063][1][ERROR] Unable to process image file otherTabBlue.gif
Thu Aug 25 15:02:45 2016 [19063][1][ERROR] Unable to process image file icon_new_package.gif
Thu Aug 25 15:02:45 2016 [19063][1][ERROR] Unable to process image file currentTabOcher.gif
Thu Aug 25 15:02:45 2016 [19063][1][ERROR] Unable to process image file otherTabPurple.gif
Thu Aug 25 15:02:45 2016 [19063][1][ERROR] Unable to process image file icon_ConnectorEnableOver.gif
Thu Aug 25 15:02:45 2016 [19063][1][ERROR] Unable to process image file pdf_logo_small.jpg
Thu Aug 25 15:02:45 2016 [19063][1][ERROR] Unable to process image file currentTabGreen.gif
Thu Aug 25 15:02:45 2016 [19063][1][ERROR] Unable to process image file currentTab.png
Thu Aug 25 15:02:45 2016 [19063][1][ERROR] Unable to process image file icon_Application.gif
Thu Aug 25 15:02:45 2016 [19063][1][ERROR] Unable to process image file icon_SugarPortal.gif
Thu Aug 25 15:02:45 2016 [19063][1][ERROR] Unable to process image file MatrixReport.gif
Thu Aug 25 15:02:45 2016 [19063][1][ERROR] Unable to process image file currentTabPurple.gif
Thu Aug 25 15:02:46 2016 [19063][1][ERROR] Unable to process image file icon_ConnectorSearchFieldsOver.gif
Thu Aug 25 15:02:46 2016 [19063][1][ERROR] Unable to process image file currentTabOff.gif
Thu Aug 25 15:02:46 2016 [19063][1][ERROR] Unable to process image file icon_ConnectorMapOver.gif
Thu Aug 25 15:02:46 2016 [19063][1][ERROR] Unable to process image file icon_ConnectorSearchFields.gif
Thu Aug 25 15:02:46 2016 [19063][1][ERROR] Unable to process image file otherTabGreen.gif
Thu Aug 25 15:02:46 2016 [19063][1][ERROR] Unable to process image file currentTabBlue.gif
Thu Aug 25 15:02:46 2016 [19063][1][ERROR] Unable to process image file icon_ConnectorConfigOver.gif
Thu Aug 25 15:02:46 2016 [19063][1][ERROR] Unable to process image file bigsuite.png
Thu Aug 25 15:02:46 2016 [19063][1][ERROR] Unable to process image file currentTab.gif
Thu Aug 25 15:02:46 2016 [19063][1][ERROR] Unable to process image file otherTabGray.gif
Thu Aug 25 15:02:46 2016 [19063][1][ERROR] Unable to process image file otherTabOcher.gif
Thu Aug 25 15:02:46 2016 [19063][1][ERROR] Unable to process image file currentTabGray.gif
Thu Aug 25 15:02:46 2016 [19063][1][ERROR] Unable to process image file icon_ConnectorEnable.gif
Thu Aug 25 15:02:46 2016 [19063][1][ERROR] Unable to process image file icon_package.gif
Thu Aug 25 15:02:46 2016 [19063][1][ERROR] Unable to process image file sugar-yui-sprites-grey.png
Thu Aug 25 15:02:46 2016 [19063][1][ERROR] Unable to process image file otherTab.gif
Thu Aug 25 15:02:46 2016 [19063][1][ERROR] Unable to process image file sugar-yui-sprites.png
Thu Aug 25 15:02:46 2016 [19063][1][ERROR] Unable to process image file otherTabRed.gif
Thu Aug 25 15:02:46 2016 [19063][1][ERROR] Unable to process image file icon_package_create.gif
Thu Aug 25 15:02:46 2016 [19063][1][ERROR] Unable to process image file icon_ModuleBuilder.gif
Thu Aug 25 15:02:46 2016 [19063][1][ERROR] Unable to process image file sugar-yui-sprites-purple.png
Thu Aug 25 15:02:46 2016 [19063][1][ERROR] Unable to process image file bar_loader.gif
Thu Aug 25 15:02:46 2016 [19063][1][ERROR] Unable to process image file bgnoise.png
Thu Aug 25 15:02:46 2016 [19063][1][ERROR] Unable to process image file icon_ConnectorConfig.gif
Thu Aug 25 15:02:46 2016 [19063][1][ERROR] Unable to process image file currentTabRed.gif
Thu Aug 25 15:02:46 2016 [19063][1][ERROR] Unable to process image file sugar-yui-sprites-green.png
Thu Aug 25 15:02:46 2016 [19063][1][ERROR] Unable to process image file icon_DropDownEditor.gif
Thu Aug 25 15:02:46 2016 [19063][1][ERROR] Unable to process image file icon_Studio.gif
Thu Aug 25 15:02:46 2016 [19063][1][ERROR] Unable to process image file line.gif
Thu Aug 25 15:02:46 2016 [19063][1][ERROR] Unable to process image file poweredby_sugarcrm_65.png
Thu Aug 25 15:02:46 2016 [19063][1][ERROR] Unable to process image file icon_ConnectorMap.gif
Thu Aug 25 15:02:46 2016 [19063][1][ERROR] Unable to process image file themePreview.png
Thu Aug 25 15:02:46 2016 [19063][1][ERROR] Unable to process image file otherTabBlue.gif
Thu Aug 25 15:02:46 2016 [19063][1][ERROR] Unable to process image file icon_new_package.gif
Thu Aug 25 15:02:46 2016 [19063][1][ERROR] Unable to process image file sugar-yui-sprites-red.png
Thu Aug 25 15:02:46 2016 [19063][1][ERROR] Unable to process image file currentTabOcher.gif
Thu Aug 25 15:02:46 2016 [19063][1][ERROR] Unable to process image file otherTabPurple.gif
Thu Aug 25 15:02:46 2016 [19063][1][ERROR] Unable to process image file icon_ConnectorEnableOver.gif
Thu Aug 25 15:02:46 2016 [19063][1][ERROR] Unable to process image file currentTabGreen.gif
Thu Aug 25 15:02:46 2016 [19063][1][ERROR] Unable to process image file icon_Application.gif
Thu Aug 25 15:02:46 2016 [19063][1][ERROR] Unable to process image file icon_SugarPortal.gif
Thu Aug 25 15:02:46 2016 [19063][1][ERROR] Unable to process image file currentTabPurple.gif
Thu Aug 25 15:02:46 2016 [19063][1][ERROR] Unable to process image file icon_ConnectorSearchFieldsOver.gif
Thu Aug 25 15:02:46 2016 [19063][1][ERROR] Unable to process image file currentTabOff.gif
Thu Aug 25 15:02:46 2016 [19063][1][ERROR] Unable to process image file icon_ConnectorMapOver.gif
Thu Aug 25 15:02:46 2016 [19063][1][ERROR] Unable to process image file icon_ConnectorSearchFields.gif
Thu Aug 25 15:02:46 2016 [19063][1][ERROR] Unable to process image file SuiteScreen3.png
Thu Aug 25 15:02:46 2016 [19063][1][ERROR] Unable to process image file otherTabGreen.gif
Thu Aug 25 15:02:46 2016 [19063][1][ERROR] Unable to process image file currentTabBlue.gif
Thu Aug 25 15:02:46 2016 [19063][1][ERROR] Unable to process image file icon_ConnectorConfigOver.gif
Thu Aug 25 15:02:46 2016 [19063][1][ERROR] Unable to process image file bigsuite.png
Thu Aug 25 15:02:46 2016 [19063][1][ERROR] Unable to process image file currentTab.gif
Thu Aug 25 15:02:46 2016 [19063][1][ERROR] Unable to process image file otherTabGray.gif
Thu Aug 25 15:02:46 2016 [19063][1][ERROR] Unable to process image file otherTabOcher.gif
Thu Aug 25 15:02:46 2016 [19063][1][ERROR] Unable to process image file currentTabGray.gif
Thu Aug 25 15:02:46 2016 [19063][1][ERROR] Unable to process image file icon_ConnectorEnable.gif
Thu Aug 25 15:02:46 2016 [19063][1][ERROR] Unable to process image file SummationWithDetailsOver.gif
Thu Aug 25 15:02:46 2016 [19063][1][ERROR] Unable to process image file pdf_logo.jpg
Thu Aug 25 15:02:46 2016 [19063][1][ERROR] Unable to process image file icon_package.gif
Thu Aug 25 15:02:46 2016 [19063][1][ERROR] Unable to process image file sugar-yui-sprites-grey.png
Thu Aug 25 15:02:46 2016 [19063][1][ERROR] Unable to process image file otherTab.gif
Thu Aug 25 15:02:46 2016 [19063][1][ERROR] Unable to process image file sugar-yui-sprites.png
Thu Aug 25 15:02:46 2016 [19063][1][ERROR] Unable to process image file themes.gif
Thu Aug 25 15:02:46 2016 [19063][1][ERROR] Unable to process image file otherTabRed.gif
Thu Aug 25 15:02:46 2016 [19063][1][ERROR] Unable to process image file SuiteScreen2.png
Thu Aug 25 15:02:46 2016 [19063][1][ERROR] Unable to process image file pdf_header_logo_pdf_header_logo_SugarCRMheader.jpg
Thu Aug 25 15:02:46 2016 [19063][1][ERROR] Unable to process image file SummationWithDetails.gif
Thu Aug 25 15:02:46 2016 [19063][1][ERROR] Unable to process image file icon_package_create.gif
Thu Aug 25 15:02:46 2016 [19063][1][ERROR] Unable to process image file icon_ModuleBuilder.gif
Thu Aug 25 15:02:46 2016 [19063][1][ERROR] Unable to process image file sugar-yui-sprites-purple.png
Thu Aug 25 15:02:46 2016 [19063][1][ERROR] Unable to process image file RowsAndColumns.gif
Thu Aug 25 15:02:46 2016 [19063][1][ERROR] Unable to process image file bar_loader.gif
Thu Aug 25 15:02:46 2016 [19063][1][ERROR] Unable to process image file bgnoise.png
Thu Aug 25 15:02:46 2016 [19063][1][ERROR] Unable to process image file icon_ConnectorConfig.gif
Thu Aug 25 15:02:46 2016 [19063][1][ERROR] Unable to process image file pdf_header_logo_SugarCRMheader.jpg
Thu Aug 25 15:02:46 2016 [19063][1][ERROR] Unable to process image file currentTabRed.gif
Thu Aug 25 15:02:46 2016 [19063][1][ERROR] Unable to process image file MatrixReportOver.gif
Thu Aug 25 15:02:46 2016 [19063][1][ERROR] Unable to process image file RowsAndColumnsOver.gif
Thu Aug 25 15:02:46 2016 [19063][1][ERROR] Unable to process image file SummationOver.gif
Thu Aug 25 15:02:46 2016 [19063][1][ERROR] Unable to process image file sugar-yui-sprites-green.png
Thu Aug 25 15:02:46 2016 [19063][1][ERROR] Unable to process image file SuiteScreen1.png
Thu Aug 25 15:02:46 2016 [19063][1][ERROR] Unable to process image file icon_DropDownEditor.gif
Thu Aug 25 15:02:46 2016 [19063][1][ERROR] Unable to process image file SuiteScreen4.png
Thu Aug 25 15:02:46 2016 [19063][1][ERROR] Unable to process image file icon_Studio.gif
Thu Aug 25 15:02:46 2016 [19063][1][ERROR] Unable to process image file line.gif
Thu Aug 25 15:02:46 2016 [19063][1][ERROR] Unable to process image file poweredby_sugarcrm_65.png
Thu Aug 25 15:02:46 2016 [19063][1][ERROR] Unable to process image file icon_ConnectorMap.gif
Thu Aug 25 15:02:46 2016 [19063][1][ERROR] Unable to process image file Summation.gif
Thu Aug 25 15:02:46 2016 [19063][1][ERROR] Unable to process image file themePreview.png
Thu Aug 25 15:02:46 2016 [19063][1][ERROR] Unable to process image file otherTabBlue.gif
Thu Aug 25 15:02:46 2016 [19063][1][ERROR] Unable to process image file icon_new_package.gif
Thu Aug 25 15:02:46 2016 [19063][1][ERROR] Unable to process image file sugar-yui-sprites-red.png
Thu Aug 25 15:02:46 2016 [19063][1][ERROR] Unable to process image file currentTabOcher.gif
Thu Aug 25 15:02:46 2016 [19063][1][ERROR] Unable to process image file otherTabPurple.gif
Thu Aug 25 15:02:46 2016 [19063][1][ERROR] Unable to process image file icon_ConnectorEnableOver.gif
Thu Aug 25 15:02:46 2016 [19063][1][ERROR] Unable to process image file pdf_logo_small.jpg
Thu Aug 25 15:02:46 2016 [19063][1][ERROR] Unable to process image file currentTabGreen.gif
Thu Aug 25 15:02:46 2016 [19063][1][ERROR] Unable to process image file icon_Application.gif
Thu Aug 25 15:02:46 2016 [19063][1][ERROR] Unable to process image file icon_SugarPortal.gif
Thu Aug 25 15:02:46 2016 [19063][1][ERROR] Unable to process image file MatrixReport.gif
Thu Aug 25 15:02:46 2016 [19063][1][ERROR] Unable to process image file currentTabPurple.gif
Thu Aug 25 15:02:46 2016 [19063][1][ERROR] Unable to process image file company_logo.png
[/spoiler]

I’m not sure if I should be concerned about the SQL errors, however, because it seems possible that the code was just ahead of the DB Updates, so when the page loaded, it looked for favorite info for the left column, but the table wasn’t built yet?

sieberta · 26 August 2016 15:58

OK, I finally got to the root of this, but I don’t have a fix yet.

If you have custom fields, and therefore custom SearchFields.php files, they are not updated to include the where_clause information for favorites. That is why some of us had issues and some didn’t.

sieberta

sieberta · 29 August 2016 12:16

OK, so this isn’t related to custom fields, I don’t think, it is related to having had made any changes to the layout of Basic or Advanced search. You can copy the favorites where clause builder from SearchForms in the non-custom module folder to SearchForms in the cutom/modules/[module]/… folder, but I don’t know how sustainable this is.

sieberta

Bungle · 15 January 2018 00:10

1 year - i know, but in case there’s someone else out there like me :-/

This issue is not fixed by an upgrade.

You need to copy the SearchFields.php from the [Module]/Metadata/ folder to custom/[Module]/Metadata/

Or probably a better option is to delete the custom/[Module]/Metadata/SearchFields.php

Many thanks sieberta