Getting following error in sugarcrm Database failure. Please refer to sugarcrm.log for details.

I am getting the following error on my campaign page, when I checked the error log following MySQL query is causing the issue

Query Failed:(SELECT prospect_lists.id ,  prospect_lists.name ,  prospect_lists.description ,  prospect_lists.list_type ,  prospect_lists.assigned_user_id  ,  'prospectlists' panel_name  FROM prospect_lists  INNER JOIN  prospect_list_campaigns ON prospect_lists.id=prospect_list_campaigns.prospect_list_id AND prospect_list_campaigns.campaign_id='c411d0f1-f5b1-288b-62ab-49ae9e5d7982' AND prospect_list_campaigns.deleted=0

  where prospect_lists.deleted=0) ORDER BY prospect_lists.name asc LIMIT 0,10::: MySQL error 1250: Table 'prospect_lists' from one of the SELECTs cannot be used in global ORDER clause


Sugar crm version - 6.5.26

PHP - 5.6
Mysql - 8.0

can you guys help me to fix the issue

Parents

0 Andre Serrazina 3 months ago

Hello Anoop vt,

I have seen this issue happening for some versions of MySQL.

Sugar 6.5.26 was designed to work with MySQL 5.1 or 5.5 and PHP 5.2 or 5.3.

https://support.sugarcrm.com/Documentation/Unsupported_Versions/Sugar_6.5/

My first approach would be to try if the error happens when running on a "Supported" platform.

I have to add that version 6.5.26 is quite old and you would definitely benefit from migrating your instance to an up-to-date release.
Cancel
Up +2 Down

Reply

Verify Answer

Cancel
0 Björn Canales Pfisterer 3 months ago in reply to Andre Serrazina

I totally agree with Andre Serrazina ! Not only for compatibility reasons but security! Go ahead and update to SugarCRM supported versions or - if you are not able to pay for a product for reasons - an up2date twink of the former community edition that is up2date. Whatever you do, I highly do not recommend to stay on such an outdated version.

Bests

Björn
Cancel
Up 0 Down

Reply

Verify Answer

Cancel
0 Chris Pennington 3 months ago in reply to Björn Canales Pfisterer

Thanks for reinforcing the need to stay on supported versions of Sugar Bjorn. However, I would ask that you do not use the Sugar Community platform to advertise or advocate for our customers to move to competitive solutions. I appreciate your comment was probably well meaning. But I think it simply goes against the grain of a a SugarCRM Community forum.
Cancel
Up +1 Down

Reply

Verify Answer

Cancel

Reply

0 Chris Pennington 3 months ago in reply to Björn Canales Pfisterer

Thanks for reinforcing the need to stay on supported versions of Sugar Bjorn. However, I would ask that you do not use the Sugar Community platform to advertise or advocate for our customers to move to competitive solutions. I appreciate your comment was probably well meaning. But I think it simply goes against the grain of a a SugarCRM Community forum.
Cancel
Up +1 Down

Reply

Verify Answer

Cancel

Children

0 Björn Canales Pfisterer 3 months ago in reply to Chris Pennington

Good point Chris, this was definetely not my intention. Just wanted to help but forgot not everyone here is aware of the abilities of different products compared with Sugar. I removed the link to a specific product as it was not the main point of my advise :-)

Bests

Björn
Cancel
Up 0 Down

Reply

Verify Answer

Cancel