We are working on migrating our database. During the import process, it’s throwing an error related to the express tables.
ERROR 1064 (42000) at line 695: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ''O:48:\"Concrete\\Core\\Express\\Search\\ColumnSet\\ColumnSet\":2:{s:10:\"\0*...' at line 55
I’m definitely no SQL expert, but it looks like the line it is referencing contains most/all of our express data. It’s a lot to sort through, especially if you don’t know where or what you’re looking at.
Has anyone seen this before? Does anyone have any suggestions on where to look or how to tackle this? Any help is appreciated.
Sometimes you bash your head against a wall for a long time trying to figure out a problem and in the end the answer is quite simple.