AOR_Reports throws error 500

đź’¬ General Discussion
1

Hi,

I have been trying to troubleshoot this for days and just can’t figure it out. We recently migrated from SugarCRM 6.5 to SuiteCRM and the reports don’t list. I can create reports and access them if I hit the specific url, but I can’t list all the reports. I get an internal server 500 error.

We are running on SuiteCRM 7.6.4

Any help is really appreciated.

2

Internal Error 500 means bad code, do you modified something? check your webserver logs, there must be something

best regards

3

Hi,

Thanks for the reply!

I didn’t modify anything, I have checked all the logs, from the apache error and access logs to the suitecrm.log file and there wasn’t anything.

I did find a strange anomaly though. It seems like the issue is only with my user. When I created a new user I was able to access the reports just fine. Also, my coworkers are able to access it as well. Not sure what could be the issue with my user?

4

check you .htaccess file, do you have it properly configured?

best regards

5

Thanks for your reply!

Here is my .htaccess file:

# BEGIN SUGARCRM RESTRICTIONS
RedirectMatch 403 (?i).*\.log$
RedirectMatch 403 (?i)/+not_imported_.*\.txt
RedirectMatch 403 (?i)/+(soap|cache|xtemplate|data|examples|include|log4php|metadata|modules)/+.*\.(php|tpl)
RedirectMatch 403 (?i)/+emailmandelivery\.php
RedirectMatch 403 (?i)/+upload
RedirectMatch 403 (?i)/+custom/+blowfish
RedirectMatch 403 (?i)/+cache/+diagnostic
RedirectMatch 403 (?i)/+files\.md5$
# END SUGARCRM RESTRICTIONS
<IfModule mod_rewrite.c>
    Options +FollowSymLinks
    RewriteEngine On
    RewriteBase /
    RewriteRule ^cache/jsLanguage/(.._..).js$ index.php?entryPoint=jslang&module=app_strings&lang=$1 [L,QSA]
    RewriteRule ^cache/jsLanguage/(\w*)/(.._..).js$ index.php?entryPoint=jslang&module=$1&lang=$2 [L,QSA]
</IfModule>
<FilesMatch "\.(jpg|png|gif|js|css|ico)$">
        <IfModule mod_headers.c>
                Header set ETag ""
                Header set Cache-Control "max-age=2592000"
                Header set Expires "01 Jan 2112 00:00:00 GMT"
        </IfModule>
</FilesMatch>
<IfModule mod_expires.c>
        ExpiresByType text/css "access plus 1 month"
        ExpiresByType text/javascript "access plus 1 month"
        ExpiresByType application/x-javascript "access plus 1 month"
        ExpiresByType image/gif "access plus 1 month"
        ExpiresByType image/jpg "access plus 1 month"
        ExpiresByType image/png "access plus 1 month"
</IfModule>