On Quote Create, Incorrect value detected. Please contact administrator

[JEEVAN28]

🐞 bug report

⁉️ Describe the bug

We are creating Quote, every this is ok, but on save button click it throws below error

#0 [info][yii\db\Connection::open] Opening DB connection: mysql:host=localhost;dbname=yCRM;port=3306
#1 [info][yii\db\Command::query] SELECT EXISTS(SELECT * FROM vtiger_users WHERE (id=1) AND ((status='Active') AND (deleted=0)))
#2 [info][yii\db\Command::query] SELECT * FROM vtiger_tab
#3 [info][yii\db\Command::query] SELECT * FROM vtiger_entityname
#4 [info][yii\db\Command::query] SELECT * FROM vtiger_field WHERE tabid=89
#5 [info][yii\db\Command::query] SELECT * FROM vtiger_actionmapping
#6 [info][yii\db\Command::query] SELECT vtiger_field.* FROM vtiger_field LEFT JOIN vtiger_blocks ON vtiger_field.block = vtiger_blocks.blockid WHERE vtiger_field.tabid=89 ORDER BY vtiger_blocks.sequence, vtiger_field.sequence
#7 [info][yii\db\Command::query] SELECT * FROM vtiger_blocks WHERE blockid=280 LIMIT 1
#8 [info][yii\db\Command::query] SELECT * FROM vtiger_blocks WHERE blockid=281 LIMIT 1
#9 [info][yii\db\Command::query] SELECT * FROM vtiger_blocks WHERE blockid=282 LIMIT 1
#10 [info][yii\db\Command::query] SELECT * FROM vtiger_blocks WHERE blockid=283 LIMIT 1
#11 [info][yii\db\Command::query] SELECT * FROM vtiger_blocks WHERE blockid=293 LIMIT 1
#12 [info][yii\db\Command::query] SELECT DISTINCT vtiger_field.fieldid, vtiger_field.fieldname, vtiger_field.columnname, vtiger_profile2field.readonly, vtiger_profile2field.visible FROM vtiger_field INNER JOIN vtiger_profile2field ON vtiger_profile2field.fieldid = vtiger_field.fieldid WHERE ((vtiger_field.tabid=89) AND (vtiger_profile2field.visible=0) AND (vtiger_field.visible=0) AND (vtiger_field.presence IN (0, 2))) AND (vtiger_profile2field.profileid=1)
#13 [info][yii\db\Command::query] SELECT * FROM vtiger_ws_fieldtype
#14 [info][yii\db\Command::query] SELECT * FROM u_yf_squotes_invfield ORDER BY block, sequence
#15 [error][IllegalValue] purifyByType:
#16 [error] ERR_NOT_ALLOWED_VALUE||
App\Exceptions\IllegalValue: ERR_NOT_ALLOWED_VALUE|| in app\Purifier.php:468
Stack trace:
#0 app\Request.php(334): App\Purifier::purifyByType(false, 'Integer')
#1 app\Request.php(321): App\Request->purifyMultiDimensionArray('', 'Integer')
#2 app\Request.php(362): App\Request->purifyMultiDimensionArray(Array, Array)
#3 modules\Vtiger\models\Record.php(1286): App\Request->getMultiDimensionArray('inventory', Array)
#4 modules\Vtiger\actions\Save.php(135): Vtiger_Record_Model->initInventoryDataFromRequest(Object(App\Request))
#5 modules\Vtiger\actions\Save.php(97): Vtiger_Save_Action->getRecordModelFromRequest(Object(App\Request))
#6 modules\Vtiger\actions\Save.php(75): Vtiger_Save_Action->saveRecord(Object(App\Request))
#7 include\main\WebUI.php(189): Vtiger_Save_Action->process(Object(App\Request))
#8 index.php(28): Vtiger_WebUI->process(Object(App\Request))
#9 {main}

Till yesterday, Quote created were saving. Even previously created quote edit is still wroking

👎 Actual Behavior

Throws error

👍 Expected Behavior

Quote should save

👷 Testing

• [ Yes] I confirm that I tested it at https://gitstable.yetiforce.com
• Quote saves properly
• [Y ] I confirm that I tested it at https://gitdeveloper.yetiforce.com
  Quote Saves properly

📝 PHP/Apache/Nginx/Browser/CRM Logs

I am using XAMPP and not able to find CRM Logs folder. Do not know how to configure

[JEEVAN28]

I checked system.log file and found below details towards error, may be useful to track

2021-05-27 09:10:59.5864 [info][yii\db\Connection::open] - Opening DB connection: mysql:host=localhost;dbname=yCRM;port=3306
2021-05-27 09:10:59.596 [info][yii\db\Command::query] - SELECT EXISTS(SELECT * FROM vtiger_users WHERE (id=1) AND ((status='Active') AND (deleted=0)))
2021-05-27 09:10:59.6124 [info][yii\db\Command::query] - SELECT * FROM vtiger_tab
2021-05-27 09:10:59.6166 [info][yii\db\Command::query] - SELECT * FROM vtiger_entityname
2021-05-27 09:10:59.6288 [trace] - Entering getColumnFields(SQuotes) method ...
2021-05-27 09:10:59.6289 [info][yii\db\Command::query] - SELECT * FROM vtiger_field WHERE tabid=89
2021-05-27 09:10:59.633 [trace] - Exiting getColumnFields method ...
2021-05-27 09:10:59.6339 [info][yii\db\Command::query] - SELECT * FROM vtiger_actionmapping
2021-05-27 09:10:59.6418 [info][yii\db\Command::query] - SELECT vtiger_field.* FROM vtiger_field LEFT JOIN vtiger_blocks ON vtiger_field.block = vtiger_blocks.blockid WHERE vtiger_field.tabid=89 ORDER BY vtiger_blocks.sequence, vtiger_field.sequence
2021-05-27 09:10:59.6993 [info][yii\db\Command::query] - SELECT * FROM vtiger_blocks WHERE blockid=280 LIMIT 1
2021-05-27 09:10:59.7001 [info][yii\db\Command::query] - SELECT * FROM vtiger_blocks WHERE blockid=281 LIMIT 1
2021-05-27 09:10:59.7008 [info][yii\db\Command::query] - SELECT * FROM vtiger_blocks WHERE blockid=282 LIMIT 1
2021-05-27 09:10:59.7016 [info][yii\db\Command::query] - SELECT * FROM vtiger_blocks WHERE blockid=283 LIMIT 1
2021-05-27 09:10:59.7025 [info][yii\db\Command::query] - SELECT * FROM vtiger_blocks WHERE blockid=293 LIMIT 1
2021-05-27 09:10:59.7049 [trace] - Entering App\Field::getFieldPermission: 89,contact_id
2021-05-27 09:10:59.7049 [trace] - Entering App\Field::getFieldsPermissions: 89
2021-05-27 09:10:59.7065 [info][yii\db\Command::query] - SELECT DISTINCT vtiger_field.fieldid, vtiger_field.fieldname, vtiger_field.columnname, vtiger_profile2field.readonly, vtiger_profile2field.visible FROM vtiger_field INNER JOIN vtiger_profile2field ON vtiger_profile2field.fieldid = vtiger_field.fieldid WHERE ((vtiger_field.tabid=89) AND (vtiger_profile2field.visible=0) AND (vtiger_field.visible=0) AND (vtiger_field.presence IN (0, 2))) AND (vtiger_profile2field.profileid=1)
2021-05-27 09:10:59.7181 [info][yii\db\Command::query] - SELECT * FROM vtiger_ws_fieldtype
2021-05-27 09:10:59.7187 [trace] - Entering App\Field::getFieldPermission: 89,contact_id
2021-05-27 09:10:59.7187 [trace] - Entering App\Field::getFieldsPermissions: 89
2021-05-27 09:10:59.7223 [trace] - Entering App\Field::getFieldPermission: 89,assigned_user_id
2021-05-27 09:10:59.7223 [trace] - Entering App\Field::getFieldsPermissions: 89
2021-05-27 09:10:59.7223 [trace] - Entering App\Field::getFieldPermission: 89,assigned_user_id
2021-05-27 09:10:59.7223 [trace] - Entering App\Field::getFieldsPermissions: 89
2021-05-27 09:10:59.7242 [trace] - Entering App\Field::getFieldPermission: 89,subject
2021-05-27 09:10:59.7243 [trace] - Entering App\Field::getFieldsPermissions: 89
2021-05-27 09:10:59.7243 [trace] - Entering App\Field::getFieldPermission: 89,subject
2021-05-27 09:10:59.7243 [trace] - Entering App\Field::getFieldsPermissions: 89
2021-05-27 09:10:59.7309 [trace] - Entering App\Field::getFieldPermission: 89,valid_until
2021-05-27 09:10:59.7309 [trace] - Entering App\Field::getFieldsPermissions: 89
2021-05-27 09:10:59.731 [trace] - Entering App\Field::getFieldPermission: 89,valid_until
2021-05-27 09:10:59.731 [trace] - Entering App\Field::getFieldsPermissions: 89
2021-05-27 09:10:59.7322 [trace] - Entering App\Field::getFieldPermission: 89,squotes_status
2021-05-27 09:10:59.7322 [trace] - Entering App\Field::getFieldsPermissions: 89
2021-05-27 09:10:59.7322 [trace] - Entering App\Field::getFieldPermission: 89,squotes_status
2021-05-27 09:10:59.7322 [trace] - Entering App\Field::getFieldsPermissions: 89
2021-05-27 09:10:59.734 [trace] - Entering App\Field::getFieldPermission: 89,carrier
2021-05-27 09:10:59.734 [trace] - Entering App\Field::getFieldsPermissions: 89
2021-05-27 09:10:59.734 [trace] - Entering App\Field::getFieldPermission: 89,carrier
2021-05-27 09:10:59.734 [trace] - Entering App\Field::getFieldsPermissions: 89
2021-05-27 09:10:59.7341 [trace] - Entering App\Field::getFieldPermission: 89,shownerid
2021-05-27 09:10:59.7341 [trace] - Entering App\Field::getFieldsPermissions: 89
2021-05-27 09:10:59.7341 [trace] - Entering App\Field::getFieldPermission: 89,shownerid
2021-05-27 09:10:59.7341 [trace] - Entering App\Field::getFieldsPermissions: 89
2021-05-27 09:10:59.7351 [trace] - Entering App\Field::getFieldPermission: 89,created_user_id
2021-05-27 09:10:59.7351 [trace] - Entering App\Field::getFieldsPermissions: 89
2021-05-27 09:10:59.7351 [trace] - Entering App\Field::getFieldPermission: 89,created_user_id
2021-05-27 09:10:59.7351 [trace] - Entering App\Field::getFieldsPermissions: 89
2021-05-27 09:10:59.7351 [trace] - Entering App\Field::getFieldPermission: 89,description
2021-05-27 09:10:59.7351 [trace] - Entering App\Field::getFieldsPermissions: 89
2021-05-27 09:10:59.7352 [trace] - Entering App\Field::getFieldPermission: 89,description
2021-05-27 09:10:59.7352 [trace] - Entering App\Field::getFieldsPermissions: 89
2021-05-27 09:10:59.7427 [trace] - Entering App\Field::getFieldPermission: 89,sum_total
2021-05-27 09:10:59.7427 [trace] - Entering App\Field::getFieldsPermissions: 89
2021-05-27 09:10:59.7427 [trace] - Entering App\Field::getFieldPermission: 89,sum_total
2021-05-27 09:10:59.7427 [trace] - Entering App\Field::getFieldsPermissions: 89
2021-05-27 09:10:59.7427 [trace] - Entering App\Field::getFieldPermission: 89,sum_marginp
2021-05-27 09:10:59.7428 [trace] - Entering App\Field::getFieldsPermissions: 89
2021-05-27 09:10:59.7428 [trace] - Entering App\Field::getFieldPermission: 89,sum_marginp
2021-05-27 09:10:59.7428 [trace] - Entering App\Field::getFieldsPermissions: 89
2021-05-27 09:10:59.7428 [trace] - Entering App\Field::getFieldPermission: 89,sum_margin
2021-05-27 09:10:59.7428 [trace] - Entering App\Field::getFieldsPermissions: 89
2021-05-27 09:10:59.7428 [trace] - Entering App\Field::getFieldPermission: 89,sum_margin
2021-05-27 09:10:59.7428 [trace] - Entering App\Field::getFieldsPermissions: 89
2021-05-27 09:10:59.7428 [trace] - Entering App\Field::getFieldPermission: 89,sum_gross
2021-05-27 09:10:59.7428 [trace] - Entering App\Field::getFieldsPermissions: 89
2021-05-27 09:10:59.7428 [trace] - Entering App\Field::getFieldPermission: 89,sum_gross
2021-05-27 09:10:59.7428 [trace] - Entering App\Field::getFieldsPermissions: 89
2021-05-27 09:10:59.7429 [trace] - Entering App\Field::getFieldPermission: 89,sum_discount
2021-05-27 09:10:59.7429 [trace] - Entering App\Field::getFieldsPermissions: 89
2021-05-27 09:10:59.7429 [trace] - Entering App\Field::getFieldPermission: 89,sum_discount
2021-05-27 09:10:59.7429 [trace] - Entering App\Field::getFieldsPermissions: 89
2021-05-27 09:10:59.7429 [trace] - Entering App\Field::getFieldPermission: 89,createdtime
2021-05-27 09:10:59.7429 [trace] - Entering App\Field::getFieldsPermissions: 89
2021-05-27 09:10:59.7429 [trace] - Entering App\Field::getFieldPermission: 89,createdtime
2021-05-27 09:10:59.7429 [trace] - Entering App\Field::getFieldsPermissions: 89
2021-05-27 09:10:59.7429 [trace] - Entering App\Field::getFieldPermission: 89,squotes_no
2021-05-27 09:10:59.7429 [trace] - Entering App\Field::getFieldsPermissions: 89
2021-05-27 09:10:59.7429 [trace] - Entering App\Field::getFieldPermission: 89,squotes_no
2021-05-27 09:10:59.7429 [trace] - Entering App\Field::getFieldsPermissions: 89
2021-05-27 09:10:59.743 [trace] - Entering App\Field::getFieldPermission: 89,modifiedtime
2021-05-27 09:10:59.743 [trace] - Entering App\Field::getFieldsPermissions: 89
2021-05-27 09:10:59.743 [trace] - Entering App\Field::getFieldPermission: 89,modifiedtime
2021-05-27 09:10:59.743 [trace] - Entering App\Field::getFieldsPermissions: 89
2021-05-27 09:10:59.746 [info][yii\db\Command::query] - SELECT * FROM u_yf_squotes_invfield ORDER BY block, sequence
2021-05-27 09:10:59.7828 [trace] - Entering Vtiger_Record_Model::initInventoryData
2021-05-27 09:10:59.7828 [trace] - Entering Vtiger_Record_Model::getInventoryData
2021-05-27 09:10:59.7832 [trace] - Exiting Vtiger_Record_Model::getInventoryData
2021-05-27 09:10:59.7838 [info][yii\db\Command::query] - SELECT * FROM vtiger_currency_info WHERE deleted=0
2021-05-27 09:10:59.7904 [info][yii\db\Command::query] - SELECT crmid, setype, deleted, smcreatorid, smownerid, createdtime, private FROM vtiger_crmentity WHERE crmid=656982
2021-05-27 09:10:59.7914 [info][yii\db\Connection::open] - Opening DB connection: mysql:host=localhost;dbname=yCRM;port=3306
2021-05-27 09:10:59.7925 [info][yii\db\Command::query] - SELECT * FROM a_yf_taxes_config
2021-05-27 09:10:59.7938 [trace] - Entering Vtiger_Record_Model::getInventoryData
2021-05-27 09:10:59.7938 [trace] - Exiting Vtiger_Record_Model::getInventoryData
2021-05-27 09:10:59.7938 [trace] - Entering Vtiger_Record_Model::getInventoryData
2021-05-27 09:10:59.7938 [trace] - Exiting Vtiger_Record_Model::getInventoryData
2021-05-27 09:10:59.7938 [trace] - Entering Vtiger_Record_Model::getInventoryData
2021-05-27 09:10:59.7938 [trace] - Exiting Vtiger_Record_Model::getInventoryData
2021-05-27 09:10:59.7938 [trace] - Entering Vtiger_Record_Model::getInventoryData
2021-05-27 09:10:59.7938 [trace] - Exiting Vtiger_Record_Model::getInventoryData
2021-05-27 09:10:59.7938 [trace] - Entering Vtiger_Record_Model::getInventoryData
2021-05-27 09:10:59.7938 [trace] - Exiting Vtiger_Record_Model::getInventoryData
2021-05-27 09:10:59.7938 [trace] - Exiting Vtiger_Record_Model::initInventoryData
2021-05-27 09:10:59.7943 [info][yii\db\Command::query] - SELECT * FROM s_yf_fields_dependency WHERE (status=0) AND (tabid=89)
2021-05-27 09:10:59.7963 [info][yii\db\Command::query] - SELECT * FROM vtiger_eventhandlers WHERE is_active=1 ORDER BY priority DESC
2021-05-27 09:10:59.7997 [trace] - Entering App\Field::getFieldsPermissions: 89
2021-05-27 09:10:59.8031 [info][yii\db\Command::query] - SELECT * FROM vtiger_modentity_num WHERE tabid=89 LIMIT 1
2021-05-27 09:10:59.8054 [info][yii\db\Command::query] - SHOW FULL COLUMNS FROM vtiger_modentity_num
2021-05-27 09:10:59.924 [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_modentity_num' AND kcu.TABLE_NAME = 'vtiger_modentity_num'
2021-05-27 09:10:59.925 [info][yii\db\Command::execute] - UPDATE vtiger_modentity_num SET cur_sequence='', cur_id=4827 WHERE tabid=89
2021-05-27 09:10:59.9292 [info][yii\db\Command::query] - SHOW FULL COLUMNS FROM vtiger_crmentity
2021-05-27 09:10:59.9425 [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_crmentity' AND kcu.TABLE_NAME = 'vtiger_crmentity'
2021-05-27 09:10:59.9433 [info][yii\db\Command::execute] - INSERT INTO vtiger_crmentity (setype, users, smcreatorid, createdtime, modifiedtime, modifiedby, smownerid, description) VALUES ('SQuotes', ',1,', 1, '2021-05-27 09:10:59', '2021-05-27 09:10:59', 1, 1, '')
2021-05-27 09:10:59.9489 [info][yii\db\Command::query] - SHOW FULL COLUMNS FROM u_yf_squotes
2021-05-27 09:10:59.9654 [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 = 'u_yf_squotes' AND kcu.TABLE_NAME = 'u_yf_squotes'
2021-05-27 09:10:59.9677 [info][yii\db\Command::execute] - INSERT INTO u_yf_squotes (squotesid, subject, squotes_status, squotes_no, sum_total, sum_marginp, sum_margin, sum_gross, sum_discount, valid_until, contact_id) VALUES (657229, 'Test Quote', 'PLL_DRAFT', 'S-Q4826', '1500', '0', '1500', '1680', '0', NULL, 119)
2021-05-27 09:10:59.9713 [info][yii\db\Command::query] - SHOW FULL COLUMNS FROM u_yf_squotescf
2021-05-27 09:10:59.9843 [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 = 'u_yf_squotescf' AND kcu.TABLE_NAME = 'u_yf_squotescf'
2021-05-27 09:10:59.985 [info][yii\db\Command::execute] - INSERT INTO u_yf_squotescf (squotesid, carrier) VALUES (657229, '')
2021-05-27 09:10:59.9867 [info][yii\db\Command::query] - SHOW FULL COLUMNS FROM u_yf_squotes_address
2021-05-27 09:11:00.0025 [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 = 'u_yf_squotes_address' AND kcu.TABLE_NAME = 'u_yf_squotes_address'
2021-05-27 09:11:00.0043 [info][yii\db\Command::execute] - INSERT INTO u_yf_squotes_address (squotesaddressid) VALUES (657229)
2021-05-27 09:11:00.0056 [info][yii\db\Command::query] - SHOW FULL COLUMNS FROM vtiger_entity_stats
2021-05-27 09:11:00.0472 [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_entity_stats' AND kcu.TABLE_NAME = 'vtiger_entity_stats'
2021-05-27 09:11:00.0481 [info][yii\db\Command::execute] - INSERT INTO vtiger_entity_stats (crmid) VALUES (657229)
2021-05-27 09:11:00.0493 [trace] - Start Vtiger_Record_Model::saveInventoryData
2021-05-27 09:11:00.0493 [trace] - Entering Vtiger_Record_Model::getInventoryData
2021-05-27 09:11:00.0493 [trace] - Exiting Vtiger_Record_Model::getInventoryData
2021-05-27 09:11:00.0648 [error] - ERR_ILLEGAL_FIELD_VALUE||currency||
App\Exceptions\Security: ERR_ILLEGAL_FIELD_VALUE||currency|| in D:\xampp\htdocs\yCRM\modules\Vtiger\inventoryfields\Currency.php:93
Stack trace:
#0 D:\xampp\htdocs\yCRM\modules\Vtiger\models\Record.php(1159): Vtiger_Currency_InventoryField->validate(NULL, 'currency', false)
#1 D:\xampp\htdocs\yCRM\modules\Vtiger\models\Record.php(561): Vtiger_Record_Model->saveInventoryData()
#2 D:\xampp\htdocs\yCRM\modules\Vtiger\models\Record.php(518): Vtiger_Record_Model->saveToDb()
#3 D:\xampp\htdocs\yCRM\modules\Vtiger\actions\Save.php(104): Vtiger_Record_Model->save()
#4 D:\xampp\htdocs\yCRM\modules\Vtiger\actions\Save.php(75): Vtiger_Save_Action->saveRecord(Object(App\Request))
#5 D:\xampp\htdocs\yCRM\include\main\WebUI.php(189): Vtiger_Save_Action->process(Object(App\Request))
#6 D:\xampp\htdocs\yCRM\index.php(28): Vtiger_WebUI->process(Object(App\Request))
#7 {main}
2021-05-27 09:10:59.4341 [info][application] -
$_GET = []
$_POST = [
'_csrf' => 'sid:75ce037e498c5cbfe5e4df9964a9b17e00dba422,1622086833'
'module' => 'SQuotes'
'fromView' => 'Create'
'action' => 'Save'
'picklistDependency' => '[]'
'mappingRelatedField' => '{"accountid":{"Accounts":{"company":["accountname"]}},"salesprocessid":{"SSalesProcesses":{"accountid":["related_to"]}}}'
'listFilterFields' => '["company","accountid"]'
'defaultOtherEventDuration' => '[{"activitytype":"Call","duration":"60"},{"activitytype":"Meeting","duration":"60"},{"activitytype":"Task","duration":"60"}]'
'popupReferenceModule' => 'Products'
'contact_id' => '119'
'contact_id_display' => ' RK Photography'
'assigned_user_id' => '1'
'subject' => 'Test Quote'
'valid_until' => ''
'squotes_status' => 'PLL_DRAFT'
'carrier' => ''
'shownerid' => ''
'inventory' => [
1 => [
'discountmode' => '1'
'taxmode' => '1'
'currency' => '1'
'currencyparam' => '{"1":{"date":"2021-05-26","value":1,"conversion":1},"2":{"date":"2021-05-26","value":1,"conversion":1}}'
'name' => '656982'
'unit' => 'Pcs'
'qty' => '1'
'price' => '1500'
'total' => '1500'
'discount' => '0'
'discountparam' => ''
'net' => '1500'
'purchase' => '0'
'marginp' => '0'
'margin' => '1500'
'tax_percent' => '12'
'taxparam' => '{"aggregationType":"group","groupTax":"12.00"}'
'tax' => '180'
'gross' => '1680'
'comment1' => ''
]
]
'description' => ''
]
$_FILES = []
$_COOKIE = [
'YTSID' => '3p6i3jgacncl1mg8rcggpkhght'
]
$_SESSION = [
'CSP_TOKEN' => 'ca2e79699cd3b70802538dd52d29e79591d4bcd89dcffdf61bed4463f4656a1c'
'last_activity' => 1622086859.5252
'UserAuthMethod' => 'PASSWORD'
'authenticated_user_id' => 1
'app_unique_key' => '5ded4ce65bbdb0b5974b1116ed771e5dc5cc42a0'
'user_name' => 'adminY'
'full_user_name' => 'Jeevan Pendhari'
'fingerprint' => 'd520c7a8-421b-4563-b955-f5abc56b97ec'
'user_agent' => 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/90.0.4430.212 Safari/537.36'
]
HEADERS = [
'Host' => '59.95.101.138:10222'
'Connection' => 'keep-alive'
'Content-Length' => '4964'
'Cache-Control' => 'max-age=0'
'Upgrade-Insecure-Requests' => '1'
'Origin' => 'null'
'Content-Type' => 'multipart/form-data; boundary=----WebKitFormBoundaryADqegA53zrAREiAJ'
'User-Agent' => 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/90.0.4430.212 Safari/537.36'
'Accept' => 'text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,/;q=0.8,application/signed-exchange;v=b3;q=0.9'
'Accept-Encoding' => 'gzip, deflate'
'Accept-Language' => 'en-GB,en-US;q=0.9,en;q=0.8'
'Cookie' => 'YTSID=3p6i3jgacncl1mg8rcggpkhght'
]
$stability = [
'output_buffering' => '1'
'memory_limit' => '512 MB'
]
$security = [
'HTTPS' => 'Off'
'public_html' => 'Off'
]
$headers = [
'Header: access-control-allow-methods' => false
'Header: access-control-allow-origin' => false
'Header: referrer-policy' => false
'Header: expect-ct' => false
'Header: x-frame-options' => false
'Header: x-xss-protection' => false
'Header: x-content-type-options' => false
'Header: x-robots-tag' => false
'Header: x-permitted-cross-domain-policies' => false
'Header: content-security-policy' => false
]
$libraries = [
'OPcache' => 'LBL_NO'
'apcu' => 'LBL_NO'
'imagick' => 'LBL_NO'
]
$database = [
'table_definition_cache' => '400'
'innodb_lock_wait_timeout' => '50'
'max_allowed_packet' => '1.00 MB'
'character_set_server' => 'utf8mb4'
'character_set_database' => 'utf8mb4'
]
$performance = [
'opcache.enable' => 'Off'
'opcache.enable_cli' => 'Off'
]
$environment = [
'currentUser' => 'SYSTEM'
]

[mariuszkrzaczkowski]

currency in null

[error] - ERR_ILLEGAL_FIELD_VALUE||currency||
App\Exceptions\Security: ERR_ILLEGAL_FIELD_VALUE||currency|| in D:\xampp\htdocs\yCRM\modules\Vtiger\inventoryfields\Currency.php:93
Stack trace:
#0 D:\xampp\htdocs\yCRM\modules\Vtiger\models\Record.php(1159): Vtiger_Currency_InventoryField->validate(NULL, 'currency', false)

[JEEVAN28]

Hi,

please refer to code suggested in discussion,

#14724

when I commented below code in squotes.php issue resolved. there is something wrong due to below code
public static $defaultInventoryData = [
'discountmode' => 1,
'taxmode' => 1,
];

but commenting this has again reset discountmode and taxmode to Group

Please assist to handle both

regards
Jeevan Pendhari

[mariuszkrzaczkowski]

a demonstration of what your data form looks like

[JEEVAN28]

Data form is

[JEEVAN28]

@mariuszkrzaczkowski

hello, do need to handle in js file as code suggest js file sets values on client side.

please assist.

regards
Jeevan Pendhari

[mariuszkrzaczkowski]

Does the problem still exist in the newest version?

[JEEVAN28]

I need to check will revert tomorrow

[JEEVAN28]

@mariuszkrzaczkowski
I have followed changes as per 770396f

values are changed for dropdown list but it did not triggered change event for js file

Jeevan Pendhari

[JEEVAN28]

Please ignore my earlier post, in 6.4 functionality is working.