Database failure. Please refer to sugarcrm.log for details.

👨‍💻 Development Help
1

Hi there!

I’ve a problem, when i try to update one history registry, when i make click on save button,
the system throws me thie error! > Database failure. Please refer to sugarcrm.log for details.

Somebody know how could i fix this :S Im new in suiteCRM.

2

I’m not sure what exactly you mean by history registry, but if you let me know what it says in your log file I might be able to work out what the issue is. The log file is typically called suitecrm.log and can be found in the root of your Suite CRM directory.

Also if you’ve made any customisations it may be worth running a repair and rebuild from the admin and executing any database queries it asks you to run.

3

Hi!! thank’s for anwer!

oh yeah mi log file say’s just this, >

Mon Oct 17 04:00:01 2016 [7613][-none-][DEBUG] current_language is: en_us
Mon Oct 17 04:00:01 2016 [7613][-none-][DEBUG] Found cache backend SugarCacheMemcache
Mon Oct 17 04:00:01 2016 [7613][-none-][DEBUG] Found cache backend SugarCacheAPC
Mon Oct 17 04:00:01 2016 [7613][-none-][DEBUG] Using cache backend SugarCacheAPC, since 940 is less than 1000
Mon Oct 17 04:00:01 2016 [7613][-none-][DEBUG] Found cache backend SugarCacheMemory
Mon Oct 17 04:00:01 2016 [7613][-none-][DEBUG] Found cache backend SugarCacheFile
Mon Oct 17 04:00:01 2016 [7613][-none-][DEBUG] Found cache backend SugarCacheWincache
Mon Oct 17 04:00:01 2016 [7613][-none-][DEBUG] Found cache backend SugarCacheZend
Mon Oct 17 04:00:01 2016 [7613][-none-][DEBUG] Found cache backend SugarCacheMemcached
Mon Oct 17 04:00:01 2016 [7613][-none-][DEBUG] Found cache backend SugarCachesMash
Mon Oct 17 04:00:01 2016 [7613][-none-][DEBUG] Found cache backend SugarCacheRedis
Mon Oct 17 04:00:01 2016 [7613][-none-][INFO] Found language file: en_us.lang.php
Mon Oct 17 04:00:01 2016 [7613][-none-][INFO] Found extended language file: en_us.lang.ext.php
Mon Oct 17 04:00:02 2016 [7613][-none-][INFO] Found custom language file: en_us.lang.php
Mon Oct 17 04:00:02 2016 [7613][-none-][INFO] Query:SELECT id, name, symbol, conversion_rate FROM currencies WHERE status = ‘Active’ and deleted = 0
Mon Oct 17 04:00:02 2016 [7613][-none-][INFO] Query Execution Time:8.6069107055664E-5
Mon Oct 17 04:00:02 2016 [7613][-none-][INFO] Query:SELECT category, name, value FROM config
Mon Oct 17 04:00:02 2016 [7613][-none-][INFO] Query Execution Time:0.00025177001953125
Mon Oct 17 04:00:02 2016 [7613][-none-][INFO] Query:SELECT id FROM outbound_email WHERE type = ‘system’
Mon Oct 17 04:00:02 2016 [7613][-none-][INFO] Query Execution Time:9.3936920166016E-5
Mon Oct 17 04:00:02 2016 [7613][-none-][INFO] Query:SELECT * FROM outbound_email WHERE id = ‘316445db-abf6-261e-9194-5508bec37692’
Mon Oct 17 04:00:02 2016 [7613][-none-][INFO] Query Execution Time:5.793571472168E-5
Mon Oct 17 04:00:02 2016 [7613][-none-][DEBUG] Hook called: ::after_entry_point
Mon Oct 17 04:00:02 2016 [7613][-none-][DEBUG] Including module specific hook file for custom/modules
Mon Oct 17 04:00:02 2016 [7613][-none-][DEBUG] Including Ext hook file for custom/application

Mon Oct 17 04:00:02 2016 [7613][-none-][INFO] Query Execution Time:0.020923137664795
Mon Oct 17 04:00:02 2016 [7613][-none-][DEBUG] Hook called: ::server_round_trip
Mon Oct 17 04:00:02 2016 [7613][-none-][DEBUG] Calling MySQLi::disconnect()
Mon Oct 17 04:00:02 2016 [7613][-none-][ERROR] File cache/themes/SuiteR/pathCache.php cannot be written to

17’th of this month started this problem #Database failure. Please refer to sugarcrm.log#

What could i do?

4

The only error listed in the log relates to permissions rather than the database. Can you make sure all the files in the CRM are owned by the user Apache runs as. Also run the following two commands from inside yoru SuiteCRM directory to make sure permissions are correct:

sudo chmod -R 755 .
sudo chmod -R 775 cache custom modules themes data upload config_override.php

1 Like