Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

After upgrade matomo, then i import log, show sql error, who meet it? how to fix the issue? #13065

Closed
huang0808 opened this issue Jun 15, 2018 · 4 comments
Labels
not-in-changelog For issues or pull requests that should not be included in our release changelog on matomo.org.

Comments

@huang0808
Copy link

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&fa_ts=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
Copy link
Author

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

@huang0808
Copy link
Author

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

@mattab mattab added this to the 4.0.0 milestone Jun 25, 2018
@mattab
Copy link
Member

mattab commented Jun 25, 2018

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).

@mattab mattab added the not-in-changelog For issues or pull requests that should not be included in our release changelog on matomo.org. label Jun 25, 2018
@tsteur
Copy link
Member

tsteur commented Jun 25, 2018

FYI: There will be an update for this soonish.

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

ALTER TABLE piwik_site_formCHANGEfields fields MEDIUMTEXT NULL;

@tsteur tsteur closed this as completed Jun 25, 2018
@mattab mattab removed this from the 4.0.0 milestone Oct 22, 2019
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
not-in-changelog For issues or pull requests that should not be included in our release changelog on matomo.org.
Projects
None yet
Development

No branches or pull requests

3 participants