Trying to view documents gives Error 500

šŸ’¬ General Discussion
1

After uploading a document I get an error:

This page isnā€™t working
[my website] is currently unable to handle this request.
HTTP ERROR 500

What am I doing wrong?

2

Youā€™re not telling us your version of OS, PHP, Web server and SuiteCRM.

Youā€™re also not looking in your logs for the relevant information.

Is this a new installation?

3

Ah right. OS is Linux, PHP version is 5.5, webserver I think is Apacheand Suite version is 7.9.9

Itā€™s a brand new installation and suitecrm.log shows the following.

Wed Jan 17 19:08:04 2018 [559521][23b11442-1236-3145-4a1b-5a5f9e77e990][FATAL] Exception handling in /home/executivestrateg/public_html/kevin/portal/include/MVC/Controller/SugarController.php:402
Wed Jan 17 19:08:04 2018 [559521][23b11442-1236-3145-4a1b-5a5f9e77e990][FATAL] Exception in Controller:  SugarFolder::retrieveFoldersForProcessing() Cannot Retrieve Folders - Please check the users inbound email settings.
Wed Jan 17 19:08:04 2018 [559521][23b11442-1236-3145-4a1b-5a5f9e77e990][FATAL] backtrace:
#0 /home/executivestrateg/public_html/kevin/portal/include/SugarFolders/SugarFolders.php(612): SugarFolder->retrieveFoldersForProcessing(Object(User))
#1 /home/executivestrateg/public_html/kevin/portal/modules/Emails/EmailUI.php(2996): SugarFolder->getGroupFoldersForSettings(Object(User))
#2 /home/executivestrateg/public_html/kevin/portal/modules/Emails/EmailUIAjax.php(1323): EmailUI->getShowAccountsOptions(Object(InboundEmail))
#3 /home/executivestrateg/public_html/kevin/portal/include/MVC/View/SugarView.php(791): include_once('/home/executive...')
#4 /home/executivestrateg/public_html/kevin/portal/include/MVC/View/views/view.classic.php(74): SugarView->includeClassicFile('modules/Emails/...')
#5 /home/executivestrateg/public_html/kevin/portal/include/MVC/View/SugarView.php(199): ViewClassic->display()
#6 /home/executivestrateg/public_html/kevin/portal/include/MVC/Controller/SugarController.php(432): SugarView->process()
#7 /home/executivestrateg/public_html/kevin/portal/include/MVC/Controller/SugarController.php(375): SugarController->processView()
#8 /home/executivestrateg/public_html/kevin/portal/include/MVC/SugarApplication.php(105): SugarController->execute()
#9 /home/executivestrateg/public_html/kevin/portal/index.php(52): SugarApplication->execute()
#10 {main}
Wed Jan 17 19:10:40 2018 [568144][1][FATAL] Error: File [modules/Currencies/metadata/detailviewdefs.php] is missing. Unable to create because no corresponding HTML file was found.
Wed Jan 24 13:17:52 2018 [292907][1][FATAL] SugarPHPMailer encountered an error: An outgoing mail server is not configured to send emails. Please configure an outgoing mail server or select an outgoing mail server for the mail account that you are using in Settings >> Mail Account.
Wed Jan 24 13:17:52 2018 [292907][1][FATAL] SugarPHPMailer encountered an error: SMTP connect() failed. https://github.com/PHPMailer/PHPMailer/wiki/Troubleshooting
Wed Jan 24 13:47:30 2018 [398330][1][FATAL] Caught error: stat(): stat failed for upload/import/status_1.csv
Wed Jan 24 13:47:30 2018 [398330][1][FATAL] Caught error: touch(): UploadStream::stream_metadata is not implemented!
Wed Jan 24 13:48:09 2018 [401639][1][FATAL] Caught error: stat(): stat failed for upload/import/status_1.csv
Wed Jan 24 13:48:09 2018 [401639][1][FATAL] Caught error: touch(): UploadStream::stream_metadata is not implemented!
Wed Jan 24 14:06:21 2018 [462932][-none-][FATAL] FAILED LOGIN:attempts[1] - Test
Wed Jan 24 14:40:16 2018 [576184][1][FATAL] Exception handling in /home/executivestrateg/public_html/kevin/portal/include/MVC/Controller/SugarController.php:402
Wed Jan 24 14:40:16 2018 [576184][1][FATAL] Exception in Controller: Subpanel was not defined
Wed Jan 24 14:40:16 2018 [576184][1][FATAL] backtrace:
#0 /home/executivestrateg/public_html/kevin/portal/include/SubPanel/SubPanelViewer.php(61): sugar_die('Subpanel was no...')
#1 /home/executivestrateg/public_html/kevin/portal/include/MVC/Controller/SugarController.php(1081): require_once('/home/executive...')
#2 /home/executivestrateg/public_html/kevin/portal/include/MVC/Controller/SugarController.php(465): SugarController->handleActionMaps()
#3 /home/executivestrateg/public_html/kevin/portal/include/MVC/Controller/SugarController.php(373): SugarController->process()
#4 /home/executivestrateg/public_html/kevin/portal/include/MVC/SugarApplication.php(105): SugarController->execute()
#5 /home/executivestrateg/public_html/kevin/portal/index.php(52): SugarApplication->execute()
#6 {main}
Wed Jan 24 20:11:03 2018 [608379][1][FATAL] IP Address mismatch: SESSION IP: 85.255.236.78 CLIENT IP: 86.169.225.218
Wed Jan 24 22:51:05 2018 [60289][1][FATAL]  Query Failed: DESCRIBE versions: MySQL error 1146: Table 'executiv_suite31.versions' doesn't exist
Wed Jan 24 22:51:05 2018 [60289][1][FATAL]  Query Failed: SHOW INDEX FROM versions: MySQL error 1146: Table 'executiv_suite31.versions' doesn't exist
Wed Jan 24 22:51:05 2018 [60289][1][FATAL]  Query Failed: select * from versions: MySQL error 1146: Table 'executiv_suite31.versions' doesn't exist
Fri Jan 26 00:50:43 2018 [684378][1][FATAL] SUGAREMAILADDRESS: address did not validate [ 96.com ]

The email bits can be ignored because I hadnā€™t added it yet.

It would appear that executiv_suite31.versions in the database is missing and it canā€™t find SugarController.php (it is there) permission 644. There is definitely no ā€˜versionsā€™ in executiv_suite31

4

What about modules/Currencies/metadata/detailviewdefs.php, is it there, with nice permissions?

Do you know what you were doing when that error appeared?

5

There is no metadata directory in modules/Currencies/

There is metadata/detailviewdefs.php in every other directory by the look of it, with permissions of 755

6

Itā€™s quite strange to have all these errors for a new installation. I have seen that ā€œversionsā€ error quite a few times here in the forums, but I never understood the root cause - it seems to come and go mysteriously. I think itā€™s a symptom of something else.

I suggest you try from scratch using PHP 7.0 which is much faster and safer, and will provide a new basis for a better installation.

If you want one that works perfectly every time check out my recipe here:

https://suitecrm.com/suitecrm/forum/installation-upgrade-help/11561-installing-on-ubuntu-16-04-1#45976

7

It was installed with softaculous on my server. I will try using php7 then

8

I get the same problem with php7.

Is there supposed to be a setup screen after you install it or do you just sign in and go?

9

I have created a test account with user: test and password: test

http://kevin.executivestrategy.co.uk/portal/

10

Check your php.ini and try to increase

  • upload_max_filesize (I suggest 15MB, for upgrade packages)

and while youā€™re there have a look at these

  • memory_limit (I suggest 512mb if possible)
  • max_execution_time (I suggest 60 seconds)
11

I found this in the log:

[27-Jan-2018 19:32:18 UTC] PHP Fatal error:  Uncaught Error: Call to undefined function mime_content_type() in /home/executivestrateg/public_html/kevin/portal/download.php:180
Stack trace:
#0 /home/executivestrateg/public_html/kevin/portal/include/MVC/Controller/SugarController.php(1014): require_once()
#1 /home/executivestrateg/public_html/kevin/portal/include/MVC/Controller/SugarController.php(465): SugarController->handleEntryPoint()
#2 /home/executivestrateg/public_html/kevin/portal/include/MVC/Controller/SugarController.php(373): SugarController->process()
#3 /home/executivestrateg/public_html/kevin/portal/include/MVC/SugarApplication.php(105): SugarController->execute()
#4 /home/executivestrateg/public_html/kevin/portal/index.php(52): SugarApplication->execute()
#5 {main}
  thrown in /home/executivestrateg/public_html/kevin/portal/download.php on line 180

Line 180 is

$mime_type = mime_content_type($local_location);

Iā€™m uploading a text file, test.txt

12

Thatā€™s a web server / PHP configuration problem.

Try turning on the ā€œfileinfoā€ module. Look for a PHP Modules option in CPanel, if you have one, or if not, turn it on in php.ini

3 Likes
13

I donā€™t have access to my php.ini. Iā€™ll have to ask the hosting provider.

Cheers

14

That worked, Thanks mate. It might be worth sticky-ing this because I have seen others with this problem on google

15

Like say @pgr
Install fileinfo php extension is the solution.

1 Like