Our team created for you one of the most innovative CRM systems that supports mainly business processes and allows for customization according to your needs. Be ahead of your competition and implement YetiForce!
While importing Users.csv file to create/merge users, I get administrator error
while checking system.log file, I noticed error, given in bold. SQL query checking data in crmentity table does not have users table values and returns null, hence throw error.
2024-05-05 08:34:35.8816 [info][[yii\db\Command::query]] - SHOW FULL COLUMNS FROM vtiger_import_queue
2024-05-05 08:34:35.8845 [info][[yii\db\Command::query]] - SELECT
kcu.CONSTRAINT_NAME AS constraint_name,
kcu.COLUMN_NAME AS column_name,
kcu.REFERENCED_TABLE_NAME AS referenced_table_name,
kcu.REFERENCED_COLUMN_NAME AS referenced_column_name
FROM information_schema.REFERENTIAL_CONSTRAINTS AS rc
JOIN information_schema.KEY_COLUMN_USAGE AS kcu ON
(
kcu.CONSTRAINT_CATALOG = rc.CONSTRAINT_CATALOG OR
(kcu.CONSTRAINT_CATALOG IS NULL AND rc.CONSTRAINT_CATALOG IS NULL)
) AND
kcu.CONSTRAINT_SCHEMA = rc.CONSTRAINT_SCHEMA AND
kcu.CONSTRAINT_NAME = rc.CONSTRAINT_NAME
WHERE rc.CONSTRAINT_SCHEMA = database() AND kcu.TABLE_SCHEMA = database()
AND rc.TABLE_NAME = 'vtiger_import_queue' AND kcu.TABLE_NAME = 'vtiger_import_queue'
2024-05-05 08:34:35.8874 [info][[yii\db\Command::execute]] - INSERT INTO vtiger_import_queue (userid, tabid, field_mapping, default_values, merge_type, merge_fields, temp_status) VALUES (1, 29, '{\"user_name\":0,\"is_admin\":1,\"first_name\":2,\"last_name\":3,\"roleid\":4,\"status\":5,\"user_password\":6,\"confirm_password\":7,\"super_user\":8,\"email1\":9,\"secondary_email\":10,\"primary_phone\":11,\"emailoptout\":12,\"date_format\":13,\"hour_format\":14,\"time_zone\":15,\"dayoftheweek\":16,\"activity_view\":17,\"defaultactivitytype\":18,\"defaulteventstatus\":19,\"view_date_format\":20,\"reminder_interval\":21,\"othereventduration\":22,\"calendar_all_users_by_default\":23,\"currency_id\":24,\"currency_decimal_separator\":25,\"currency_symbol_placement\":26,\"truncate_trailing_zeros\":27,\"currency_grouping_pattern\":28,\"currency_grouping_separator\":29,\"no_of_currency_decimals\":30,\"start_hour\":31,\"end_hour\":32,\"language\":33,\"rowheight\":34,\"leftpanelhide\":35,\"default_record_view\":36,\"theme\":37,\"login_method\":38,\"force_password_change\":39,\"internal_mailer\":40,\"sync_carddav\":41,\"sync_caldav\":42,\"default_search_override\":43,\"default_search_operator\":44,\"available\":45,\"auto_assign\":46,\"records_limit\":47,\"reports_to_id\":48,\"is_owner\":49}', '[]', 3, '[\"user_name\"]', 0)
2024-05-05 08:34:35.8887 [info][[yii\db\Command::query]] - SELECT FROM vtiger_import_queue WHERE (tabid=29) AND (userid=1) LIMIT 1
2024-05-05 08:34:35.8893 [info][[yii\db\Command::query]] - SELECT FROM vtiger_import_locks WHERE tabid=29 LIMIT 1
2024-05-05 08:34:35.8895 [info][[yii\db\Command::query]] - SHOW FULL COLUMNS FROM vtiger_import_locks
2024-05-05 08:34:35.8904 [info][[yii\db\Command::query]] - SELECT
kcu.CONSTRAINT_NAME AS constraint_name,
kcu.COLUMN_NAME AS column_name,
kcu.REFERENCED_TABLE_NAME AS referenced_table_name,
kcu.REFERENCED_COLUMN_NAME AS referenced_column_name
FROM information_schema.REFERENTIAL_CONSTRAINTS AS rc
JOIN information_schema.KEY_COLUMN_USAGE AS kcu ON
(
kcu.CONSTRAINT_CATALOG = rc.CONSTRAINT_CATALOG OR
(kcu.CONSTRAINT_CATALOG IS NULL AND rc.CONSTRAINT_CATALOG IS NULL)
) AND
kcu.CONSTRAINT_SCHEMA = rc.CONSTRAINT_SCHEMA AND
kcu.CONSTRAINT_NAME = rc.CONSTRAINT_NAME
WHERE rc.CONSTRAINT_SCHEMA = database() AND kcu.TABLE_SCHEMA = database()
AND rc.TABLE_NAME = 'vtiger_import_locks' AND kcu.TABLE_NAME = 'vtiger_import_locks'
2024-05-05 08:34:35.8926 [info][[yii\db\Command::execute]] - INSERT INTO vtiger_import_locks (userid, tabid, importid, locked_since) VALUES (1, 29, 12, '2024-05-05 08:34:35')
2024-05-05 08:34:35.8934 [info][[yii\db\Command::query]] - SELECT FROM u_yf_import_1 WHERE temp_status=0 LIMIT 250
2024-05-05 08:34:35.8942 [trace][] - Entering getColumnFields(Users) method ...
2024-05-05 08:34:35.8943 [info][[yii\db\Command::query]] - SELECT FROM vtiger_field LEFT JOIN s_yf_fields_anonymization ON vtiger_field.fieldid = s_yf_fields_anonymization.field_id WHERE tabid=29
2024-05-05 08:34:35.895 [trace][] - Exiting getColumnFields method ...
2024-05-05 08:34:35.8951 [trace][] - Entering to operatorE in App\Conditions\QueryFields\BaseField
2024-05-05 08:34:35.8953 [info][[yii\db\Command::query]] - SELECT vtiger_users.id AS id FROM vtiger_users WHERE vtiger_users.user_name='amarendra.jaltare' LIMIT 12024-05-05 08:34:35.9006 [info][[yii\db\Command::query]] - SELECT crmid, setype, deleted, smcreatorid, smownerid, createdtime, private FROM vtiger_crmentity WHERE crmid=92024-05-05 08:34:35.9011 [error][] - App\Cache::staticHas(): Argument #2 ($key) must be of type string, null given, called in /www/wwwroot/default/crm/yf/modules/Vtiger/models/Module.php on line 202
TypeError: App\Cache::staticHas(): Argument #2 ($key) must be of type string, null given, called in /www/wwwroot/default/crm/yf/modules/Vtiger/models/Module.php on line 202 and defined in /www/wwwroot/default/crm/yf/app/Cache.php:141
Stack trace:
When I tried to run below SQL query in crmentity table, not record found
SELECT crmid, setype, deleted, smcreatorid, smownerid, createdtime, private FROM vtiger_crmentity WHERE crmid=9
further checking 9 is the id of the existing user already in the system returned by below query.
SELECT vtiger_users.id AS id FROM vtiger_users WHERE vtiger_users.user_name='amarendra.jaltare' LIMIT 1
I am using release 6.5
While importing Users.csv file to create/merge users, I get administrator error
while checking system.log file, I noticed error, given in bold. SQL query checking data in crmentity table does not have users table values and returns null, hence throw error.
2024-05-05 08:34:35.8816 [info][[yii\db\Command::query]] - SHOW FULL COLUMNS FROM
vtiger_import_queue
2024-05-05 08:34:35.8845 [info][[yii\db\Command::query]] - SELECTkcu
.CONSTRAINT_NAME
ASconstraint_name
,kcu
.COLUMN_NAME
AScolumn_name
,kcu
.REFERENCED_TABLE_NAME
ASreferenced_table_name
,kcu
.REFERENCED_COLUMN_NAME
ASreferenced_column_name
FROMinformation_schema
.REFERENTIAL_CONSTRAINTS
ASrc
JOINinformation_schema
.KEY_COLUMN_USAGE
ASkcu
ON (kcu
.CONSTRAINT_CATALOG
=rc
.CONSTRAINT_CATALOG
OR (kcu
.CONSTRAINT_CATALOG
IS NULL ANDrc
.CONSTRAINT_CATALOG
IS NULL) ) ANDkcu
.CONSTRAINT_SCHEMA
=rc
.CONSTRAINT_SCHEMA
ANDkcu
.CONSTRAINT_NAME
=rc
.CONSTRAINT_NAME
WHERErc
.CONSTRAINT_SCHEMA
= database() ANDkcu
.TABLE_SCHEMA
= database() ANDrc
.TABLE_NAME
= 'vtiger_import_queue' ANDkcu
.TABLE_NAME
= 'vtiger_import_queue' 2024-05-05 08:34:35.8874 [info][[yii\db\Command::execute]] - INSERT INTOvtiger_import_queue
(userid
,tabid
,field_mapping
,default_values
,merge_type
,merge_fields
,temp_status
) VALUES (1, 29, '{\"user_name\":0,\"is_admin\":1,\"first_name\":2,\"last_name\":3,\"roleid\":4,\"status\":5,\"user_password\":6,\"confirm_password\":7,\"super_user\":8,\"email1\":9,\"secondary_email\":10,\"primary_phone\":11,\"emailoptout\":12,\"date_format\":13,\"hour_format\":14,\"time_zone\":15,\"dayoftheweek\":16,\"activity_view\":17,\"defaultactivitytype\":18,\"defaulteventstatus\":19,\"view_date_format\":20,\"reminder_interval\":21,\"othereventduration\":22,\"calendar_all_users_by_default\":23,\"currency_id\":24,\"currency_decimal_separator\":25,\"currency_symbol_placement\":26,\"truncate_trailing_zeros\":27,\"currency_grouping_pattern\":28,\"currency_grouping_separator\":29,\"no_of_currency_decimals\":30,\"start_hour\":31,\"end_hour\":32,\"language\":33,\"rowheight\":34,\"leftpanelhide\":35,\"default_record_view\":36,\"theme\":37,\"login_method\":38,\"force_password_change\":39,\"internal_mailer\":40,\"sync_carddav\":41,\"sync_caldav\":42,\"default_search_override\":43,\"default_search_operator\":44,\"available\":45,\"auto_assign\":46,\"records_limit\":47,\"reports_to_id\":48,\"is_owner\":49}', '[]', 3, '[\"user_name\"]', 0) 2024-05-05 08:34:35.8887 [info][[yii\db\Command::query]] - SELECT FROMvtiger_import_queue
WHERE (tabid
=29) AND (userid
=1) LIMIT 1 2024-05-05 08:34:35.8893 [info][[yii\db\Command::query]] - SELECT FROMvtiger_import_locks
WHEREtabid
=29 LIMIT 1 2024-05-05 08:34:35.8895 [info][[yii\db\Command::query]] - SHOW FULL COLUMNS FROMvtiger_import_locks
2024-05-05 08:34:35.8904 [info][[yii\db\Command::query]] - SELECTkcu
.CONSTRAINT_NAME
ASconstraint_name
,kcu
.COLUMN_NAME
AScolumn_name
,kcu
.REFERENCED_TABLE_NAME
ASreferenced_table_name
,kcu
.REFERENCED_COLUMN_NAME
ASreferenced_column_name
FROMinformation_schema
.REFERENTIAL_CONSTRAINTS
ASrc
JOINinformation_schema
.KEY_COLUMN_USAGE
ASkcu
ON (kcu
.CONSTRAINT_CATALOG
=rc
.CONSTRAINT_CATALOG
OR (kcu
.CONSTRAINT_CATALOG
IS NULL ANDrc
.CONSTRAINT_CATALOG
IS NULL) ) ANDkcu
.CONSTRAINT_SCHEMA
=rc
.CONSTRAINT_SCHEMA
ANDkcu
.CONSTRAINT_NAME
=rc
.CONSTRAINT_NAME
WHERErc
.CONSTRAINT_SCHEMA
= database() ANDkcu
.TABLE_SCHEMA
= database() ANDrc
.TABLE_NAME
= 'vtiger_import_locks' ANDkcu
.TABLE_NAME
= 'vtiger_import_locks' 2024-05-05 08:34:35.8926 [info][[yii\db\Command::execute]] - INSERT INTOvtiger_import_locks
(userid
,tabid
,importid
,locked_since
) VALUES (1, 29, 12, '2024-05-05 08:34:35') 2024-05-05 08:34:35.8934 [info][[yii\db\Command::query]] - SELECT FROMu_yf_import_1
WHEREtemp_status
=0 LIMIT 250 2024-05-05 08:34:35.8942 [trace][] - Entering getColumnFields(Users) method ... 2024-05-05 08:34:35.8943 [info][[yii\db\Command::query]] - SELECT FROMvtiger_field
LEFT JOINs_yf_fields_anonymization
ON vtiger_field.fieldid = s_yf_fields_anonymization.field_id WHEREtabid
=29 2024-05-05 08:34:35.895 [trace][] - Exiting getColumnFields method ... 2024-05-05 08:34:35.8951 [trace][] - Entering to operatorE in App\Conditions\QueryFields\BaseField 2024-05-05 08:34:35.8953 [info][[yii\db\Command::query]] - SELECTvtiger_users
.id
ASid
FROMvtiger_users
WHEREvtiger_users
.user_name
='amarendra.jaltare' LIMIT 1 2024-05-05 08:34:35.9006 [info][[yii\db\Command::query]] - SELECTcrmid
,setype
,deleted
,smcreatorid
,smownerid
,createdtime
,private
FROMvtiger_crmentity
WHEREcrmid
=9 2024-05-05 08:34:35.9011 [error][] - App\Cache::staticHas(): Argument #2 ($key) must be of type string, null given, called in /www/wwwroot/default/crm/yf/modules/Vtiger/models/Module.php on line 202 TypeError: App\Cache::staticHas(): Argument #2 ($key) must be of type string, null given, called in /www/wwwroot/default/crm/yf/modules/Vtiger/models/Module.php on line 202 and defined in /www/wwwroot/default/crm/yf/app/Cache.php:141 Stack trace:0 /www/wwwroot/default/crm/yf/modules/Vtiger/models/Module.php(202): App\Cache::staticHas()
1 /www/wwwroot/default/crm/yf/modules/Vtiger/models/Record.php(772): Vtiger_Module_Model::getInstance()
2 /www/wwwroot/default/crm/yf/modules/Import/actions/Data.php(305): Vtiger_Record_Model::getInstanceById()
3 /www/wwwroot/default/crm/yf/modules/Import/actions/Data.php(159): Import_Data_Action->importRecords()
4 /www/wwwroot/default/crm/yf/modules/Import/views/Main.php(81): Import_Data_Action->importData()
5 /www/wwwroot/default/crm/yf/modules/Import/views/Main.php(61): Import_Main_View->triggerImport()
6 /www/wwwroot/default/crm/yf/modules/Vtiger/views/Import.php(192): Import_Main_View::import()
7 /www/wwwroot/default/crm/yf/app/Controller/ExposeMethod.php(68): Vtiger_Import_View->import()
8 /www/wwwroot/default/crm/yf/modules/Vtiger/views/Import.php(72): Vtiger_Import_View->invokeExposedMethod()
9 /www/wwwroot/default/crm/yf/include/main/WebUI.php(188): Vtiger_Import_View->process()
10 /www/wwwroot/default/crm/yf/index.php(26): Vtiger_WebUI->process()
11 {main}
When I tried to run below SQL query in crmentity table, not record found SELECT
crmid
,setype
,deleted
,smcreatorid
,smownerid
,createdtime
,private
FROMvtiger_crmentity
WHEREcrmid
=9further checking 9 is the id of the existing user already in the system returned by below query. SELECT
vtiger_users
.id
ASid
FROMvtiger_users
WHEREvtiger_users
.user_name
='amarendra.jaltare' LIMIT 1Can not test on https://gitdeveloper.yetiforce.com as file size 0 error shows, probably not allowed to import data.
Please assist how to solve.
Jeevan Pendhari