Hello,
I recently did a fresh install of using the fresh download from the spicecrm repo. However after a successful install, I am not able to login to the app. Found that there are errors in the SpiceDictionaryDomainValidations class when trying to access field validations. However on the data base, the sysdomainfieldvalidationvalues table has 0 records. From what I understand there should be default records in the sysdomainfieldvalidationvalues table.
Has anyone seen this before?
Please let me know if there is a way to force populate these records.
Thank you
What is the exact error thrown in the php error log? or api/spicecrm.log?
The following are the errors logged when I try to access the app.
Also, I did a fresh install again and now its getting stuck at ldap.
2024-07-10 05:36:54 [35064][-none-][FATAL][SQLERROR] Query Failed: SELECT * from ldap_settings where is_active = 1 AND deleted = 0 order by priority: MySQL error 1146: Table ‘spicecrmq.ldap_settings’ doesn’t exist
2024-07-10 05:36:54 [35064][-none-][FATAL][SQLERROR] Query Failed: SELECT * from ldap_settings where is_active = 1 AND deleted = 0 order by priority: MySQL error 1146: Table ‘spicecrmq.ldap_settings’ doesn’t exist
2024-07-10 05:36:54 [35064][-none-][FATAL][SQLERROR] Query Failed: SELECT count() FROM ipaddresses WHERE date_deleted IS NULL AND color=‘b’ AND address = ‘::1’ LIMIT 0,1: MySQL error 1146: Table ‘spicecrmq.ipaddresses’ doesn’t exist
2024-07-10 05:36:54 [35064][-none-][FATAL][SQLERROR] Get One Failed:SELECT count() FROM ipaddresses WHERE date_deleted IS NULL AND color=‘b’ AND address = ‘::1’: MySQL error 1146: Table ‘spicecrmq.ipaddresses’ doesn’t exist
2024-07-10 05:36:54 [35064][1][FATAL][SQLERROR] Query Failed: SELECT * from ldap_settings where is_active = 1 AND deleted = 0 order by priority: MySQL error 1146: Table ‘spicecrmq.ldap_settings’ doesn’t exist
2024-07-10 05:36:54 [35064][1][FATAL][SQLERROR] Query Failed: SELECT * from ldap_settings where is_active = 1 AND deleted = 0 order by priority: MySQL error 1146: Table ‘spicecrmq.ldap_settings’ doesn’t exist
2024-07-10 05:36:55 [35064][-none-][FATAL][SQLERROR] Query Failed: SELECT * from ldap_settings where is_active = 1 AND deleted = 0 order by priority: MySQL error 1146: Table ‘spicecrmq.ldap_settings’ doesn’t exist
2024-07-10 05:36:55 [35064][1][FATAL][SQLERROR] Query Failed: SELECT * from ldap_settings where is_active = 1 AND deleted = 0 order by priority: MySQL error 1146: Table ‘spicecrmq.ldap_settings’ doesn’t exist
2024-07-10 05:36:55 [35064][-none-][FATAL][SQLERROR] Query Failed: SELECT * from ldap_settings where is_active = 1 AND deleted = 0 order by priority: MySQL error 1146: Table ‘spicecrmq.ldap_settings’ doesn’t exist
2024-07-10 05:36:55 [35064][1][FATAL][SQLERROR] Query Failed: SELECT * from ldap_settings where is_active = 1 AND deleted = 0 order by priority: MySQL error 1146: Table ‘spicecrmq.ldap_settings’ doesn’t exist
some tables are not present in the public version. Therefore the errors in the logs but they don’t prevent from login in.
I run an installation today from the master branch, no problem. I could login right away. But I did it on windows.
Please, check server access rights for api/include/SpiceDictionary/system/systemcached.dump
owner should be www-data user