XF 2.1 dB error

[Wigs]

Hi,

So I've just tried to import a live sites database to our upgraded development site and I'm getting some error.

MySQL query error [1265]: Data truncated for column 'route_type' at row 1 in src/XF/Db/AbstractStatement.php at line 228

I was getting the error that table xf_route_filter was missing the column route_type so I added the correct column and I'm getting the above error now any help?

 

[Paul B]

You should investigate why the source database has missing columns rather than trying to patch it on an ad hoc basis.

There could be other corruption.