Error 500 after admin panel login

tmarcinek · 14 November 2024 05:23

HI, I have problem after installation. When I’m log on as admin I have SERVER ERROR

500 INTERNAL SERVER ERROR

The server encountered an unexpected condition that prevented it from fulfilling the request.

I can not use any admin option.

Please, help

my config: php 8.2
suitecrm: 8.7.1

in log file:

Wed Nov 13 20:34:58 2024 [35452][1][SECURITY] OutboundEmail::checkSavePermissions - not logged in - skipping check
Wed Nov 13 20:34:58 2024 [35452][1][FATAL] User update error: Temp User is not retrieved at ID 1, boolean given
Wed Nov 13 20:34:58 2024 [35452][1][FATAL] Email address save error
Wed Nov 13 20:35:01 2024 [35452][1][SECURITY] Invalid ext logger_file_ext : ‘’.
Wed Nov 13 20:35:01 2024 [35452][1][SECURITY] Setting logger_file_ext to ‘.log’.
Wed Nov 13 20:35:01 2024 [35452][1][SECURITY] Setting logger_file_name to ‘’.
Wed Nov 13 20:35:01 2024 [35452][1][SECURITY] Log file extension can’t be blank.
Wed Nov 13 20:35:01 2024 [35452][1][SECURITY] Setting logger_file_name to ‘’.
Wed Nov 13 20:35:01 2024 [35452][1][SECURITY] Log file extension can’t be blank.
Wed Nov 13 20:35:12 2024 [35452][1][FATAL] Email address save error
Wed Nov 13 22:59:56 2024 [43128][1][FATAL] Mysqli_query failed.
Wed Nov 13 22:59:56 2024 [43128][1][FATAL] Query Failed: SELECT opportunities.sales_stage, SUM(opportunities.amount_usdollar) as amount_usdollar FROM opportunities LEFT JOIN opportunities_cstm ON opportunities.id = opportunities_cstm.id_c LEFT JOIN users jt0 ON opportunities.modified_user_id=jt0.id AND jt0.deleted=0

AND jt0.deleted=0 LEFT JOIN users jt1 ON opportunities.created_by=jt1.id AND jt1.deleted=0

AND jt1.deleted=0 LEFT JOIN users jt2 ON opportunities.assigned_user_id=jt2.id AND jt2.deleted=0

AND jt2.deleted=0 LEFT JOIN accounts_opportunities jtl3 ON opportunities.id=jtl3.opportunity_id AND jtl3.deleted=0

LEFT JOIN accounts accounts ON accounts.id=jtl3.account_id AND accounts.deleted=0
AND accounts.deleted=0 LEFT JOIN campaigns jt4 ON opportunities.campaign_id=jt4.id AND jt4.deleted=0

AND jt4.deleted=0 where opportunities.deleted=0 AND opportunities.amount_usdollar is not null AND opportunities.sales_stage is not null GROUP BY opportunities.sales_stage DESC: MySQL error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘DESC’ at line 12
Wed Nov 13 23:00:51 2024 [43128][1][FATAL] SUGAREMAILADDRESS: address did not valid [ ]
Wed Nov 13 23:00:51 2024 [43128][1][FATAL] Invalid Argument: new address should be an array of strings, string given.
Wed Nov 13 23:00:51 2024 [43128][1][FATAL] SUGAREMAILADDRESS: address did not valid [ ]
Wed Nov 13 23:00:51 2024 [43128][1][FATAL] Invalid Argument: new address should be an array of strings, string given.
Wed Nov 13 23:03:08 2024 [43133][1][FATAL] Email address save error
Wed Nov 13 23:12:58 2024 [43128][1][FATAL] Email address save error

abuzarfaris · 14 November 2024 06:21

Hey
Please go to your crm directory /public/legacy index.php

Add these lines around the top of your index.php and save

ini_set('display_errors',1);
ini_set('error_reporting',E_ALL & ~E_DEPRECATED & ~E_STRICT & ~E_NOTICE & ~E_WARNING);

Then try to reopen this page and it should show the error that is occurring on the screen. Please share that error and we can help you further

Regards

Harshad · 14 November 2024 08:26

Curious to know if this change is upgrade safe. Thank you!

abuzarfaris · 14 November 2024 08:30

This change is not upgrade safe and you should not keep it in production instances.
When you face an error especially (500 error). adding these lines temporarily drastically increases the resolution of the error because it shows you on the screen that this is the exact place where the error is occuring

Harshad · 14 November 2024 08:46

Thanks, I learned a trick about setting the ini values in php code. When I don’t have access to php.ini file, this trick will help.

pgr · 14 November 2024 09:22

@tmarcinek try installing with a simpler password (no symbols or strange characters), there is a bug that might be causing trouble with your user creation.

tmarcinek · 14 November 2024 13:08

I’m paste this code, an nothing happend.

I can give you access to my test hosting server, and you can try verify

https://serwer2422390.home.pl/crm/public/#/Login

admin,1111

this is test instance, and will be delete after fixing:)

thx a lot for help!

pgr · 14 November 2024 13:09

Your webroot is wrong, you should never be seeing “public” in your URLs

abuzarfaris · 14 November 2024 13:30

I think there is a very basic mistake in the installation because all of the legacy routes are returning a 500 error
Did you setup the permissions setting up the server

tmarcinek · 14 November 2024 15:18

This server is a external hosting, I have a very limited cpanel. No external domain is connected. During installation I immediately have a wizard from suitecrm only, where I have to enter data for the database etc. I didn’t have much choice.

my legacy folder

…and I running clean instalation…
https://serwer2422390.home.pl/SuiteCRM/public/install.php. ← i can open installator

pgr · 14 November 2024 17:39

Ask your web hosting support how you can set your web root to

https://serwer2422390.home.pl/SuiteCRM/public

I am assuming you’re not running any other websites on that same host.

rsp · 15 November 2024 01:53

Set the required permissions

If you are using the terminal you can do this by running:

find . -type d -not -perm 2755 -exec chmod 2755 {} \;
find . -type f -not -perm 0644 -exec chmod 0644 {} \;
find . ! -user www-data -exec chown www-data:www-data {} \;
chmod +x bin/console

Please have in mind that:

The user and group name (in the above example www-data ) needs to be replaced by the actual system user and group that your webserver runs under. This varies depending on your operating system. Common web server users are as follows:
- www-data (Ubuntu Linux/Apache)
- apache (Linux/Apache)

Clear symfony cache (delete prod/log.txt)

For example,

If you set your web root to:

/var/www/html/suitecrm8/public/

Then .htaccess file at /public/legacy/ folder will be:

RewriteBase /

tmarcinek · 16 November 2024 08:56

HI, thank you for you replay.
but I not help me. My advaneture with suitecrm starting at www homepage configuration, because I using hosting provider. I have no access to console. I puting zip file via ftp and unziping, next open www and tried configuring.

I have one option in my cpanel. I can install CRM from predefined packade, but only 7.12.6 version. I upgrading via admin panel to 7.14 and looks fine (all processes passed)…and next i have “500” on homesite.

pgr · 16 November 2024 10:55

I would really not recommend trying to install and use SuiteCRM without console access. It’s just not that kind of program.

If you search around, there are many hostings with console access, many of them quite affordable, some of them free.