XF 2.1 dB error

Wigs

Wigs

Member
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?
 
Sort by date Sort by votes
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.
 
Upvote 0 Downvote
You must log in or register to reply here.

Similar threads

R
  • Question Question
XF 2.2 Unexpected db error after rollback
Replies
2
Views
37
rbrad
R
soloarquitectura
Server issue Search logs: XF\Db\Exception: MySQL fetch error [2014]
Replies
4
Views
105
soloarquitectura
soloarquitectura
yor14
  • Solved
XF 2.2 DB Errors on Fresh Install
Replies
17
Views
696
Jeremy P
Jeremy P
mcatze
Duplicate [XF\Db\Exception] MySQL statement prepare error [1054]: Unknown column 'xf_mg_media_item.album_state' in 'where clause' in src/XF/Db/AbstractStatement
Replies
1
Views
211
Chris D
Chris D
Mr Lucky
  • Question Question
XF 2.3 2.3.0 beta 7 error XF\Db\Exception: MySQL query error [1366]: Incorrect string value: '\xF0\x9F\x90\x88.1...
Replies
7
Views
178
Mr Lucky
Mr Lucky
Back
Top Bottom