[MAILMANAGER]Insert mailbox failed query
Hi,
I'm using master branch (and i've searched the issues), and i didn't find any related issue.It's related to strict mode on my local server (UWAMP) since on my production server it does work. (I have STRICT_TRANS_TABLES on my local server)
OK so the query error is this one
"12/02/17 16:18:06,202 [5512] DEBUG VT - Prepared sql query parameters : [[email protected],ssl0.ovh.net,[email protected],z87Oz8_Oz8_Pzs7Oz8_Ozs_Ozs_Pz87Oz87Oz87Ozs7Pzs7Pzs7Pzs_Pzs7Pzs7Pz8_Ozs_Ozs_Pz87Pz87Pz8_Pzs_Pzs_P,IMAP4,ssl,novalidate-cert,,INBOX.INBOX.Sent,1,20,[email protected],1,0,1] 12/02/17 16:18:06,202 [5512] INFO VT - PearDatabase ->ADODB error Query Failed:INSERT INTO vtiger_mail_accounts(display_name, mail_servername, mail_username, mail_password, mail_protocol, ssltype, sslmeth, box_refresh,sent_folder, user_id, mails_per_page, account_name, status, set_default, account_id) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)::->[1366]Incorrect integer value: '' for column 'box_refresh' at row 1"
The "$this->refreshTimeOut()" is empty at creation (INSERT) since in the select is hidden at creation and the default value is empty (so it's not an INT).
I would like to correct it myself and send a merge request but i'm kinda new with GIT (i use GITKRAKEN to manage it) and new with vtiger also, so maybe i shouldn't correct it (i guess we should set the default value on 0 in the template located in "V:\vtiger_git\layouts\v7\modules\MailManager\SettingsEdit.tpl")
So for now i've disabled strict_trans_tables and it works.