500 Server Error after seemingly good installation

I’ve been able to get SuiteCRM running locally using MAMP, but now I’m trying to deploy it to my Linux hosting. From everything I’m seeing I’m not having any serious issues doing an install. There are no issues that show up on the pre-installation view. When the installation is done the database has been populated with tables. But at the end /suitecrm/ and /suitecrm/install.php give me a 500 Server Error.

I’m using SuiteCRM 7.10.8.

cat /proc/version
Linux version 3.10.0-693.11.6.1.ELK.el6.x86_64 (root@bluerock1.bluehost.com) (gcc version 4.8.2 20140120 (Red Hat 4.8.2-15) (GCC) ) #1 SMP Tue Jan 23 10:30:30 MST 2018

Pre-installlation Output


System Environment
PHP Version 7.0.31
XML Parsing OK
MB Strings Module OK
Writable SuiteCRM Configuration File (config.php) OK
Writeable Custom Directory OK
Writable Modules Sub-Directories and Files OK
Writable Upload Directory OK
Writable Data Sub-Directories OK
Writable Cache Sub-Directories OK
PHP Memory Limit OK (256M)
ZLIB Compression Module OK
ZIP Handling Module OK
PCRE Library OK
IMAP Module OK
cURL Module OK
Upload File Size OK
Sprite Support OK
PHP allows to use stream (upload://) OK
Location of your PHP configuration file (php.ini): /opt/php70/lib/php.ini

I’m not seeing anything from my hosting’s error logs that isn’t in these files below.

suitecrm.log


Mon Sep 17 09:51:37 2018 [906322][1][FATAL] ERROR: rmdir_recursive(): argument cache/themes/SuiteP/modules is not a file or a dir.

install.log


2018-09-17 14:46:10...installerHook: Info: custom/install/install_hooks.php not present, no custom hooks to execute
2018-09-17 14:46:35...Begin System Check Process *************
2018-09-17 14:46:36...XML Parsing Support Found
2018-09-17 14:46:36...MBString Support Found
2018-09-17 14:46:36...ZIP Support Found
2018-09-17 14:46:36.../custom directory and subdirectory check passed
2018-09-17 14:46:36...cache directory and subdirectory check passed
2018-09-17 14:46:36.../module  directory and subdirectory check passed
2018-09-17 14:46:36.../upload directory check passed
2018-09-17 14:46:36.../zip check passed
2018-09-17 14:46:36...PCRE version check passed
2018-09-17 14:46:36...installerHook: Info: custom/install/install_hooks.php not present, no custom hooks to execute
2018-09-17 14:46:36...php.ini location found. /opt/php70/lib/php.ini
2018-09-17 14:46:36...Outputting HTML for System check
2018-09-17 14:46:36...No Errors were found *************
2018-09-17 14:46:41...installerHook: Info: custom/install/install_hooks.php not present, no custom hooks to execute
2018-09-17 14:47:09...installerHook: Info: custom/install/install_hooks.php not present, no custom hooks to execute
2018-09-17 14:51:22...Begin DB Check Process *************
2018-09-17 14:51:22...testing with mysql:mysqli
2018-09-17 14:51:22...Basic form info is valid, continuing Process.
2018-09-17 14:51:22...Testing user account...
2018-09-17 14:51:22...Connection made using  host: localhost:3306, usr: admin
2018-09-17 14:51:22...SUCCESS:: no errors detected!
2018-09-17 14:51:22...End DB Check Process *************
2018-09-17 14:51:22...installerHook: Info: custom/install/install_hooks.php not present, no custom hooks to execute
2018-09-17 14:51:22...calling handleSugarConfig()
2018-09-17 14:51:22...calling handleHtaccess()
2018-09-17 14:51:22...calling handleDbCreateDatabase()
2018-09-17 14:51:24...looping through all the Beans and create their tables
2018-09-17 14:51:24...processing table acl_actions
2018-09-17 14:51:24...creating table acl_actions
2018-09-17 14:51:24...creating Relationship Meta for ACLAction
2018-09-17 14:51:24...processing table acl_roles
2018-09-17 14:51:24...creating table acl_roles
2018-09-17 14:51:24...creating Relationship Meta for ACLRole
2018-09-17 14:51:24...processing table relationships
2018-09-17 14:51:24...creating table relationships
2018-09-17 14:51:24...creating Relationship Meta for Relationship
2018-09-17 14:51:24...processing table leads
2018-09-17 14:51:25...creating table leads
2018-09-17 14:51:25...creating Relationship Meta for Lead
2018-09-17 14:51:25...processing table cases
2018-09-17 14:51:25...creating table cases
2018-09-17 14:51:25...creating Relationship Meta for Case
2018-09-17 14:51:25...processing table bugs
2018-09-17 14:51:25...creating table bugs
2018-09-17 14:51:25...creating Relationship Meta for Bug
2018-09-17 14:51:25...processing table users
2018-09-17 14:51:25...creating table users
2018-09-17 14:51:25...creating Relationship Meta for User
2018-09-17 14:51:25...processing table campaign_log
2018-09-17 14:51:25...creating table campaign_log
2018-09-17 14:51:25...creating Relationship Meta for CampaignLog
2018-09-17 14:51:25...processing table project
2018-09-17 14:51:25...creating table project
2018-09-17 14:51:25...creating Relationship Meta for Project
2018-09-17 14:51:25...processing table project_task
2018-09-17 14:51:25...creating table project_task
2018-09-17 14:51:25...creating Relationship Meta for ProjectTask
2018-09-17 14:51:25...processing table campaigns
2018-09-17 14:51:26...creating table campaigns
2018-09-17 14:51:26...creating Relationship Meta for Campaign
2018-09-17 14:51:26...processing table prospect_lists
2018-09-17 14:51:26...creating table prospect_lists
2018-09-17 14:51:26...creating Relationship Meta for ProspectList
2018-09-17 14:51:26...processing table prospects
2018-09-17 14:51:26...creating table prospects
2018-09-17 14:51:26...creating Relationship Meta for Prospect
2018-09-17 14:51:26...processing table email_marketing
2018-09-17 14:51:26...creating table email_marketing
2018-09-17 14:51:26...creating Relationship Meta for EmailMarketing
2018-09-17 14:51:26...processing table campaign_trkrs
2018-09-17 14:51:26...creating table campaign_trkrs
2018-09-17 14:51:26...creating Relationship Meta for CampaignTracker
2018-09-17 14:51:26...processing table releases
2018-09-17 14:51:26...creating table releases
2018-09-17 14:51:26...creating Relationship Meta for Release
2018-09-17 14:51:26...processing table emailman
2018-09-17 14:51:26...creating table emailman
2018-09-17 14:51:26...creating Relationship Meta for EmailMan
2018-09-17 14:51:26...processing table schedulers
2018-09-17 14:51:26...creating table schedulers
2018-09-17 14:51:26...creating Relationship Meta for Scheduler
2018-09-17 14:51:26...processing table job_queue
2018-09-17 14:51:26...creating table job_queue
2018-09-17 14:51:26...creating Relationship Meta for SchedulersJob
2018-09-17 14:51:26...processing table contacts
2018-09-17 14:51:26...creating table contacts
2018-09-17 14:51:26...creating Relationship Meta for Contact
2018-09-17 14:51:26...processing table accounts
2018-09-17 14:51:26...creating table accounts
2018-09-17 14:51:26...creating Relationship Meta for Account
2018-09-17 14:51:26...processing table opportunities
2018-09-17 14:51:26...creating table opportunities
2018-09-17 14:51:26...creating Relationship Meta for Opportunity
2018-09-17 14:51:26...processing table email_templates
2018-09-17 14:51:26...creating table email_templates
2018-09-17 14:51:26...creating Relationship Meta for EmailTemplate
2018-09-17 14:51:26...processing table notes
2018-09-17 14:51:27...creating table notes
2018-09-17 14:51:27...creating Relationship Meta for Note
2018-09-17 14:51:27...processing table calls
2018-09-17 14:51:27...creating table calls
2018-09-17 14:51:27...creating Relationship Meta for Call
2018-09-17 14:51:27...processing table emails
2018-09-17 14:51:27...creating table emails
2018-09-17 14:51:27...creating Relationship Meta for Email
2018-09-17 14:51:27...processing table meetings
2018-09-17 14:51:27...creating table meetings
2018-09-17 14:51:27...creating Relationship Meta for Meeting
2018-09-17 14:51:27...processing table tasks
2018-09-17 14:51:27...creating table tasks
2018-09-17 14:51:27...creating Relationship Meta for Task
2018-09-17 14:51:27...processing table users
2018-09-17 14:51:27...processing table users
2018-09-17 14:51:27...processing table currencies
2018-09-17 14:51:27...creating table currencies
2018-09-17 14:51:27...creating Relationship Meta for Currency
2018-09-17 14:51:27...processing table tracker
2018-09-17 14:51:27...creating table tracker
2018-09-17 14:51:27...creating Relationship Meta for Tracker
2018-09-17 14:51:27...processing table import_maps
2018-09-17 14:51:27...creating table import_maps
2018-09-17 14:51:27...creating Relationship Meta for ImportMap
2018-09-17 14:51:27...processing table users_last_import
2018-09-17 14:51:27...creating table users_last_import
2018-09-17 14:51:27...creating Relationship Meta for UsersLastImport
2018-09-17 14:51:27...processing table config
2018-09-17 14:51:27...creating table config
2018-09-17 14:51:27...creating Relationship Meta for Administration
2018-09-17 14:51:27...processing table upgrade_history
2018-09-17 14:51:27...creating table upgrade_history
2018-09-17 14:51:27...creating Relationship Meta for UpgradeHistory
2018-09-17 14:51:27...processing table vcals
2018-09-17 14:51:27...creating table vcals
2018-09-17 14:51:27...creating Relationship Meta for vCal
2018-09-17 14:51:27...processing table alerts
2018-09-17 14:51:27...creating table alerts
2018-09-17 14:51:27...creating Relationship Meta for Alert
2018-09-17 14:51:27...processing table roles
2018-09-17 14:51:27...creating table roles
2018-09-17 14:51:27...creating Relationship Meta for Role
2018-09-17 14:51:27...processing table documents
2018-09-17 14:51:27...creating table documents
2018-09-17 14:51:27...creating Relationship Meta for Document
2018-09-17 14:51:27...processing table document_revisions
2018-09-17 14:51:27...creating table document_revisions
2018-09-17 14:51:27...creating Relationship Meta for DocumentRevision
2018-09-17 14:51:27...processing table fields_meta_data
2018-09-17 14:51:27...creating table fields_meta_data
2018-09-17 14:51:27...creating Relationship Meta for FieldsMetaData
2018-09-17 14:51:28...processing table inbound_email
2018-09-17 14:51:28...creating table inbound_email
2018-09-17 14:51:28...creating Relationship Meta for InboundEmail
2018-09-17 14:51:28...processing table saved_search
2018-09-17 14:51:28...creating table saved_search
2018-09-17 14:51:28...creating Relationship Meta for SavedSearch
2018-09-17 14:51:28...processing table user_preferences
2018-09-17 14:51:28...creating table user_preferences
2018-09-17 14:51:28...creating Relationship Meta for UserPreference
2018-09-17 14:51:28...processing table 
2018-09-17 14:51:28...processing table email_addresses
2018-09-17 14:51:28...creating table email_addresses
2018-09-17 14:51:28...creating Relationship Meta for EmailAddress
2018-09-17 14:51:28...processing table emails_text
2018-09-17 14:51:28...creating table emails_text
2018-09-17 14:51:28...creating Relationship Meta for EmailText
2018-09-17 14:51:28...processing table spots
2018-09-17 14:51:28...creating table spots
2018-09-17 14:51:28...creating Relationship Meta for Spots
2018-09-17 14:51:28...processing table aobh_businesshours
2018-09-17 14:51:28...creating table aobh_businesshours
2018-09-17 14:51:28...creating Relationship Meta for AOBH_BusinessHours
2018-09-17 14:51:28...processing table sugarfeed
2018-09-17 14:51:28...creating table sugarfeed
2018-09-17 14:51:28...creating Relationship Meta for SugarFeed
2018-09-17 14:51:28...processing table eapm
2018-09-17 14:51:28...creating table eapm
2018-09-17 14:51:28...creating Relationship Meta for EAPM
2018-09-17 14:51:28...processing table oauth_consumer
2018-09-17 14:51:28...creating table oauth_consumer
2018-09-17 14:51:28...creating Relationship Meta for OAuthKey
2018-09-17 14:51:28...processing table oauth_tokens
2018-09-17 14:51:28...creating table oauth_tokens
2018-09-17 14:51:28...creating Relationship Meta for OAuthToken
2018-09-17 14:51:28...processing table am_projecttemplates
2018-09-17 14:51:28...creating table am_projecttemplates
2018-09-17 14:51:28...creating Relationship Meta for AM_ProjectTemplates
2018-09-17 14:51:28...processing table am_tasktemplates
2018-09-17 14:51:28...creating table am_tasktemplates
2018-09-17 14:51:28...creating Relationship Meta for AM_TaskTemplates
2018-09-17 14:51:28...processing table favorites
2018-09-17 14:51:28...creating table favorites
2018-09-17 14:51:28...creating Relationship Meta for Favorites
2018-09-17 14:51:28...processing table aok_knowledge_base_categories
2018-09-17 14:51:28...creating table aok_knowledge_base_categories
2018-09-17 14:51:28...creating Relationship Meta for AOK_Knowledge_Base_Categories
2018-09-17 14:51:28...processing table aok_knowledgebase
2018-09-17 14:51:28...creating table aok_knowledgebase
2018-09-17 14:51:28...creating Relationship Meta for AOK_KnowledgeBase
2018-09-17 14:51:28...processing table reminders
2018-09-17 14:51:28...creating table reminders
2018-09-17 14:51:28...creating Relationship Meta for Reminder
2018-09-17 14:51:28...processing table reminders_invitees
2018-09-17 14:51:28...creating table reminders_invitees
2018-09-17 14:51:28...creating Relationship Meta for Reminder_Invitee
2018-09-17 14:51:29...processing table fp_events
2018-09-17 14:51:29...creating table fp_events
2018-09-17 14:51:29...creating Relationship Meta for FP_events
2018-09-17 14:51:29...processing table fp_event_locations
2018-09-17 14:51:29...creating table fp_event_locations
2018-09-17 14:51:29...creating Relationship Meta for FP_Event_Locations
2018-09-17 14:51:29...processing table aod_indexevent
2018-09-17 14:51:29...creating table aod_indexevent
2018-09-17 14:51:29...creating Relationship Meta for AOD_IndexEvent
2018-09-17 14:51:29...processing table aod_index
2018-09-17 14:51:29...creating table aod_index
2018-09-17 14:51:29...creating Relationship Meta for AOD_Index
2018-09-17 14:51:29...processing table aop_case_events
2018-09-17 14:51:29...creating table aop_case_events
2018-09-17 14:51:29...creating Relationship Meta for AOP_Case_Events
2018-09-17 14:51:29...processing table aop_case_updates
2018-09-17 14:51:29...creating table aop_case_updates
2018-09-17 14:51:29...creating Relationship Meta for AOP_Case_Updates
2018-09-17 14:51:29...processing table aor_reports
2018-09-17 14:51:29...creating table aor_reports
2018-09-17 14:51:29...creating Relationship Meta for AOR_Report
2018-09-17 14:51:29...processing table aor_fields
2018-09-17 14:51:29...creating table aor_fields
2018-09-17 14:51:29...creating Relationship Meta for AOR_Field
2018-09-17 14:51:29...processing table aor_charts
2018-09-17 14:51:29...creating table aor_charts
2018-09-17 14:51:29...creating Relationship Meta for AOR_Chart
2018-09-17 14:51:29...processing table aor_conditions
2018-09-17 14:51:29...creating table aor_conditions
2018-09-17 14:51:29...creating Relationship Meta for AOR_Condition
2018-09-17 14:51:29...processing table aor_scheduled_reports
2018-09-17 14:51:29...creating table aor_scheduled_reports
2018-09-17 14:51:29...creating Relationship Meta for AOR_Scheduled_Reports
2018-09-17 14:51:29...processing table aos_contracts
2018-09-17 14:51:29...creating table aos_contracts
2018-09-17 14:51:29...creating Relationship Meta for AOS_Contracts
2018-09-17 14:51:29...processing table aos_invoices
2018-09-17 14:51:29...creating table aos_invoices
2018-09-17 14:51:29...creating Relationship Meta for AOS_Invoices
2018-09-17 14:51:30...processing table aos_pdf_templates
2018-09-17 14:51:30...creating table aos_pdf_templates
2018-09-17 14:51:30...creating Relationship Meta for AOS_PDF_Templates
2018-09-17 14:51:30...processing table aos_product_categories
2018-09-17 14:51:30...creating table aos_product_categories
2018-09-17 14:51:30...creating Relationship Meta for AOS_Product_Categories
2018-09-17 14:51:30...processing table aos_products
2018-09-17 14:51:30...creating table aos_products
2018-09-17 14:51:30...creating Relationship Meta for AOS_Products
2018-09-17 14:51:30...processing table aos_products_quotes
2018-09-17 14:51:30...creating table aos_products_quotes
2018-09-17 14:51:30...creating Relationship Meta for AOS_Products_Quotes
2018-09-17 14:51:30...processing table aos_line_item_groups
2018-09-17 14:51:30...creating table aos_line_item_groups
2018-09-17 14:51:30...creating Relationship Meta for AOS_Line_Item_Groups
2018-09-17 14:51:30...processing table aos_quotes
2018-09-17 14:51:30...creating table aos_quotes
2018-09-17 14:51:30...creating Relationship Meta for AOS_Quotes
2018-09-17 14:51:30...processing table aow_actions
2018-09-17 14:51:30...creating table aow_actions
2018-09-17 14:51:30...creating Relationship Meta for AOW_Action
2018-09-17 14:51:30...processing table aow_workflow
2018-09-17 14:51:30...creating table aow_workflow
2018-09-17 14:51:30...creating Relationship Meta for AOW_WorkFlow
2018-09-17 14:51:30...processing table aow_processed
2018-09-17 14:51:30...creating table aow_processed
2018-09-17 14:51:30...creating Relationship Meta for AOW_Processed
2018-09-17 14:51:30...processing table aow_conditions
2018-09-17 14:51:30...creating table aow_conditions
2018-09-17 14:51:30...creating Relationship Meta for AOW_Condition
2018-09-17 14:51:30...processing table jjwg_maps
2018-09-17 14:51:30...creating table jjwg_maps
2018-09-17 14:51:30...creating Relationship Meta for jjwg_Maps
2018-09-17 14:51:30...processing table jjwg_markers
2018-09-17 14:51:30...creating table jjwg_markers
2018-09-17 14:51:30...creating Relationship Meta for jjwg_Markers
2018-09-17 14:51:30...processing table jjwg_areas
2018-09-17 14:51:31...creating table jjwg_areas
2018-09-17 14:51:31...creating Relationship Meta for jjwg_Areas
2018-09-17 14:51:31...processing table jjwg_address_cache
2018-09-17 14:51:31...creating table jjwg_address_cache
2018-09-17 14:51:31...creating Relationship Meta for jjwg_Address_Cache
2018-09-17 14:51:31...processing table calls_reschedule
2018-09-17 14:51:31...creating table calls_reschedule
2018-09-17 14:51:31...creating Relationship Meta for Calls_Reschedule
2018-09-17 14:51:31...processing table securitygroups
2018-09-17 14:51:31...creating table securitygroups
2018-09-17 14:51:31...creating Relationship Meta for SecurityGroup
2018-09-17 14:51:31...processing table outbound_email
2018-09-17 14:51:31...creating table outbound_email
2018-09-17 14:51:31...creating Relationship Meta for OutboundEmailAccounts
2018-09-17 14:51:31...processing table templatesectionline
2018-09-17 14:51:31...creating table templatesectionline
2018-09-17 14:51:31...creating Relationship Meta for TemplateSectionLine
2018-09-17 14:51:31...processing table oauth2tokens
2018-09-17 14:51:31...creating table oauth2tokens
2018-09-17 14:51:31...creating Relationship Meta for OAuth2Tokens
2018-09-17 14:51:31...processing table oauth2clients
2018-09-17 14:51:31...creating table oauth2clients
2018-09-17 14:51:31...creating Relationship Meta for OAuth2Clients
2018-09-17 14:51:31...processing table surveyresponses
2018-09-17 14:51:31...creating table surveyresponses
2018-09-17 14:51:31...creating Relationship Meta for SurveyResponses
2018-09-17 14:51:31...processing table surveys
2018-09-17 14:51:32...creating table surveys
2018-09-17 14:51:32...creating Relationship Meta for Surveys
2018-09-17 14:51:32...processing table surveyquestionresponses
2018-09-17 14:51:32...creating table surveyquestionresponses
2018-09-17 14:51:32...creating Relationship Meta for SurveyQuestionResponses
2018-09-17 14:51:32...processing table surveyquestions
2018-09-17 14:51:32...creating table surveyquestions
2018-09-17 14:51:32...creating Relationship Meta for SurveyQuestions
2018-09-17 14:51:32...processing table surveyquestionoptions
2018-09-17 14:51:32...creating table surveyquestionoptions
2018-09-17 14:51:32...creating Relationship Meta for SurveyQuestionOptions
2018-09-17 14:51:33...Begin creating Defaults
2018-09-17 14:51:33...insert defaults into config table
2018-09-17 14:51:33...Creating default users
2018-09-17 14:51:33...Creating default scheduler jobs
2018-09-17 14:51:33...Enable SugarFeeds
2018-09-17 14:51:33...Installation has completed *********
2018-09-17 14:51:37...populating the db with seed data
2018-09-17 14:51:37...Save configuration settings..
2018-09-17 14:51:37...save locale
2018-09-17 14:51:37...new Administration
2018-09-17 14:51:37...retrieveSettings
2018-09-17 14:51:37...AdminWizard OFF
2018-09-17 14:51:37...saveConfig
2018-09-17 14:51:37...new Configurator
2018-09-17 14:51:37...populateFromPost
2018-09-17 14:51:37...handleOverride
2018-09-17 14:51:37...addCronAllowedUser
2018-09-17 14:51:37...saveConfig
2018-09-17 14:51:37...new Currency
2018-09-17 14:51:37...retrieve
2018-09-17 14:51:37...DBG: save currency
2018-09-17 14:51:37...Save user settings..
2018-09-17 14:51:37...DBG: SugarThemeRegistry::getDefault
2018-09-17 14:51:37...DBG: require modules/Users/Save.php

error_log

[17-Sep-2018 09:51:33 America/Chicago] PHP Warning:  in_array() expects parameter 2 to be array, null given in /home2/public_html/suitecrm/install/performSetup.php on line 505
[17-Sep-2018 /09:51:33 America/Chicago] PHP Warning:  in_array() expects parameter 2 to be array, null given in /home2/public_html/suitecrm/install/performSetup.php on line 505
[17-Sep-2018 09:51:33 America/Chicago] PHP Warning:  in_array() expects parameter 2 to be array, null given in /home2/public_html/suitecrm/install/performSetup.php on line 505
[17-Sep-2018 09:51:33 America/Chicago] PHP Warning:  in_array() expects parameter 2 to be array, null given in /home2/public_html/suitecrm/install/performSetup.php on line 505
[17-Sep-2018 09:51:33 America/Chicago] PHP Warning:  in_array() expects parameter 2 to be array, null given in /home2/public_html/suitecrm/install/performSetup.php on line 505

Would really appreciate any help you can offer to get me heading in the right direction. Thank you!

That is strange that you aren’t getting any fatals in your error_log.

In the config.php able to change the error logging to DEBUG? Perhaps that could give you more insight where it keels over if your php ini isn’t spitting out appropriate logging.

Thanks for the response! I wiped the directory and database and started over. The config.php file doesn’t get generated until the installation is in progress. However, after it was generated I changed ‘level’ => ‘fatal’ to ‘level’ => ‘debug’ under ‘logger’. I’m not seeing any changes in the error_log or suitecrm.log files when I request /suitecrm/ or /suitecrm/install.php. Still getting 500 error.

Have you set file permissions correctly before starting the install script?

If you don’t do it the way it has to be done you install will most likely fail.

Try applying:
https://github.com/amariussi/chperms

Then run the install script. Better if you delete everyting before so that you have a completely clean installation folder.

1 Like

The warning at line 113 is normal because config_override.php gets created by the install script.

Since you tried a new version (7.10.9) has come out. It corrects some bugs which may affect the install script.

Can you try with the latest version and let us know what happens?

Remember to apply chperms.php before and after the install.

1 Like

That worked! Must have been something that got cleaned up in that release. Thank you very much for your help!

Just completed uipgrade from 7.9 to 7.10.9 and after completing without errors i get “500 Internal Server Error” The upgradewizad completed:
Wed, 17 Oct 2018 15:16:03 -0700 [UpgradeWizard] - at unlinkUWTempFiles()
Wed, 17 Oct 2018 15:17:01 -0700 [UpgradeWizard] - finished!
Wed, 17 Oct 2018 15:17:01 -0700 [UpgradeWizard] - Cleaning up the session. Goodbye.
Wed, 17 Oct 2018 15:17:01 -0700 [UpgradeWizard] - resetting $_SESSION

Suitecrm.log has a mysql error:

Wed Oct 17 15:50:02 2018 [3055][6daf2cf4-f619-57bd-07aa-568d1bd8c647][FATAL] Qu
ery Failed: SELECT opportunities.id AS id FROM opportunities WHERE opportunitie
s.sales_stage = ‘Resquest_Quote’ AND opportunities.date_modified > DATE_ADD(oppo
rtunities., INTERVAL ) AND opportunities.date_modified > ‘2017-03-30 05:22:13’
AND opportunities.date_entered <> opportunities.date_modified AND NOT EXISTS (S
ELECT * FROM aow_processed WHERE aow_processed.aow_workflow_id=‘11c6c258-0784-86
3c-0ddb-58dc96a746a2’ AND aow_processed.parent_id=opportunities.id AND aow_proce
ssed.status = ‘Complete’ AND aow_processed.deleted = 0) AND opportunities.deleted = 0 : 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 ’ INTERVAL ) AND opportunities.date_modified > ‘2017-03-30 05:22:13’ AND opport’ at line 1
Wed Oct 17 15:50:02 2018 [3055][1][DEPRECATED] Formatting correction: SchedulersJobs->date_entered had formatting automatically corrected. This will be removed in the future, please upgrade your external code
Wed Oct 17 15:50:02 2018 [3055][1][DEPRECATED] Formatting correction: SchedulersJobs->date_modified had formatting automatically corrected. This will be removed in the future, please upgrade your external code
:
httpd error found:

=Login&loginErrorMe ssage=LBL_SESSION_EXPIRED

Some mysql errors should not interfere:

2018-10-17 15:23:05 7fb08bddd700 InnoDB: Error: Fetch of persistent statistics requested for table “suitecrmlive”.“calls” but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead.
2018-10-17 15:24:01 7fb08bddd700 InnoDB: Error: Table “mysql”.“innodb_table_stats” not found.
2018-10-17 15:24:01 7fb08bddd700 InnoDB: Error: Fetch of persistent statistics requested for table “suitecrmlive”.“inbound_email” but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead.
2018-10-17 15:25:01 7fb08bddd700 InnoDB: Error: Table “mysql”.“innodb_table_stats” not found.

Upgrade completed again and then gibve me a 500 Server Error.

The logs show the following:

Thu Oct 25 10:02:02 2018 [24914][6daf2cf4-f619-57bd-07aa-568d1bd8c647][FATAL] Query Failed: SELECT opportunities.id AS id FROM opportunities WHERE opportunities.sales_stage = ‘Resquest_Quote’ AND opportunities.date_modified > DATE_ADD(opportunities., INTERVAL ) AND opportunities.date_modified > ‘2017-03-30 05:22:13’ AND opportunities.date_entered <> opportunities.date_modified AND NOT EXISTS (SELECT * FROM aow_processed WHERE aow_processed.aow_workflow_id=‘11c6c258-0784-863c-0ddb-58dc96a746a2’ AND aow_processed.parent_id=opportunities.id AND aow_processed.status = ‘Complete’ AND aow_processed.deleted = 0) AND opportunities.deleted = 0 : 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 ’ INTERVAL ) AND opportunities.date_modified > ‘2017-03-30 05:22:13’ AND opport’ at line 1

I cannot get Suite to respond at this point. I need help…

@ronherman that is known issue (I recognize it by the keyword INTERVAL without any argument, which is wrong SQL), and I think it is solved in 7.10.10, though I am not sure. If it isn’t solved yet, at least I know it has been reported on Github.

I’ve got the same error message 'syntax to use near ’ INTERVAL ’ in the suitecrm.log every minute on different SQL statements. They are all related to workflows using the type ‘date’ in a condition. When I delete the condition, the error won’t come any more but this workflow makes the workflow senseless.

@salchobob and which SuiteCRM version are you running?

Oh, sorry. I forgot.
Version 7.10.10
Sugar Version 6.5.25 (Build 344)

I’ve got the problem on two installations, both where upgraded from earlier versions where those workflows worked.

This is an example from the log:

Wed Nov 21 20:22:05 2018 [5802][1][FATAL] Mysqli_query failed.
Wed Nov 21 20:22:05 2018 [5802][1][FATAL]  Query Failed: SELECT leads.id AS id FROM leads  WHERE leads.date_entered < DATE_ADD(leads., INTERVAL   ) AND NOT EXISTS (SELECT * FROM aow_processed WHERE aow_processed.aow_workflow_id='d8c00c5b-9585-43e4-f5d8-5bf5b0c8fe85' AND aow_processed.parent_id=leads.id AND aow_processed.status = 'Complete' AND aow_processed.deleted = 0) AND leads.deleted = 0 : 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 ' INTERVAL   ) AND NOT EXISTS (SELECT * FROM aow_processed WHERE aow_processed.ao' at line 1

And this is a condition from an example workflow (it does not matter which module is used)

Conditions:
Module Field Operator Type Value
1 Leads Date Created Less Than Date Now - 5 Days

Ok, did a little more research and found out that the problem is known and described here:
https://github.com/salesagility/SuiteCRM/issues/6328

Found it in this thread:
https://suitecrm.com/suitecrm/forum/suitecrm-7-0-discussion/19332-mysqli-query-failed-in-suitecrm-log-scheduled-jobs-related?start=15#72468

and there seems to be a fix:
https://github.com/salesagility/SuiteCRM/pull/6482

I will check this out.

Sorry for coming up here without doing more research before posting on an already known and maybe fixed issue.

1 Like