I've tried installing commerce kickstart on LAMP VPS and i get stuck at this error:

SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'info' at row 198

Anyone know how to fix? I've read about changing varchar but i can't do this since there are no tables to change as the installation hasnt populated them yet.

Anyone has ideas for troubleshooting?

Thankful for any help :)

Comments

minoxes created an issue. See original summary.

minoxes’s picture

minoxes CreditAttribution: minoxes commented
Component: User interface » Code
minoxes’s picture

minoxes CreditAttribution: minoxes commented

Ran "SELECT @ @SQL_MODE , @ @GLOBAL.SQL_MODE" and it gave this. It's a Mariadb server.

@@SQL_MODE
NO_BACKSLASH_ESCAPES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

@@GLOBAL.SQL_MODE
NO_BACKSLASH_ESCAPES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

minoxes’s picture

minoxes CreditAttribution: minoxes commented
Status: Active » Closed (fixed)
howdytom’s picture

howdytom CreditAttribution: howdytom as a volunteer commented

It would be great if you could share your solution to help other with a similar problem.