@huang0808 opened this Issue on June 15th 2018

FastCGI sent in stderr: "PHP message: Error in Matomo (tracker): Error query: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'fields' at row 1 In query: UPDATE piwik_site_form SET fields = ?, updated_date = ? WHERE idsiteform = ? AND idsite = ? Parameters: array ( 0 => '[{"name":"ctl00$ContentMain$login$login$Password","type":"password","displayName":""},{"name":"ctl00$ContentMain$login$login$UserName","type":"text","displayName":""},{"name":"ctl00$ContentMain$login$login$RememberMe","type":"checkbox","displayName":""},{"name":"ctl00$ContentMain$uc2$txtPartKeywordSearch","type":"text","displayName":""},{"name":"Keyword","type":"text","displayName":""},{"name":"ctl00$ContentMain$OrderHistoryLogin$login$Password","type":"password","displayName":""},{"name":"ctl00$ContentMain$uc5$AttributeCategoryList$ctl00$1000000411","type":"select","displayName":""},{"name":"auimgon","type":"text","displayName":""},{"name":"ctl00$ContentMain$uc2$chkStocked","type":"checkbox","displayName":""},{"name":"ctl00$Conten" while reading response header from upstream, client: 118.112.75.62, server: server_domain_name_or_ip, request: "GET //js/tracker.php?fa_vid=FwVlHf&fa_id=aspnetForm&fa_ef=ctl00%24ContentMain%24uc5%24AttributeCategoryList%24ctl04%241826902&fa_lf=ctl00%24ContentMain%24uc5%24AttributeCategoryList%24ctl07%241000000979&fa_fields=%5B%7B%22fa_fts%22%3A1760%2C%22fa_fht%22%3A1760%2C%22fa_fb%22%3Atrue%2C%22fa_fn%22%3A%22ctl00%24ContentMain%24uc5%24AttributeCategoryList%24ctl07%241000000979%22%2C%22fa_fch%22%3A0%2C%22fa_ff%22%3A1%2C%22fa_fd%22%3A0%2C%22fa_fcu%22%3A0%2C%22fa_ft%22%3A%22select%22%2C%22fa_fs%22%3A-1%7D%5D&fats=11327&&idsite=6&rec=1&r=477026&h=15&m=42&s=8&url=http%3A%2F%2Fwww.mouser.cn%2FSemiconductors%2FDiscrete-Semiconductors%2FTransistors%2FMOSFET%2F%2FN-ax1sf%2F&urlref=http%3A%2F%2Fwww.mouser.cn%2FSemiconductors%2FDiscrete-Semiconductors%2FTransistors%2F_%2FN-ax1rp%2F&_id=f498e62ac2103758&_idts=1504329558&_idvc=201&_idn=0&_refts=15290

@huang0808 commented on June 15th 2018

@Sija @nbezzala @bangpound could you help me see? thanks!

@huang0808 commented on June 21st 2018

I changed the fields type text to mediumtext, now is no sql error.

@mattab commented on June 25th 2018 Member

Thank you for the report @huang0808 - we have created this bug report in our internal ticket system for Form Analytics and will fix it in a newer version (refs DEV-1369).

@tsteur commented on June 25th 2018 Member

FYI: There will be an update for this soonish.

Otherwise you can fix it immediately by executing this MySQL query:

ALTER TABLEpiwik_site_formCHANGEfields`fields MEDIUMTEXT NULL;`

This Issue was closed on June 25th 2018
Powered by GitHub Issue Mirror