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

Reply

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

Children

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