VPF Index Download Error: ER_TRUNCATED_WRONG_VALUE_FOR_FIELD

[MizterB]

Looks like a parsing error while downloading the VPForums table index (log edited to fit)

2013-09-14T13:24:37.515Z - info: ↩ rpc:23 vpforums.tables (6ms) 2013-09-14T13:24:38.389Z - info: ↪ rpc:24 vpforums.createIndex 2013-09-14T13:24:38.390Z - info: [announce] "vpf.createIndexStarted": {"id":"crvpfindex"} 2013-09-14T13:24:38.392Z - info: SELECT * FROM vpf_files WHERE vpf_files.category=41; 2013-09-14T13:24:38.393Z - info: [vpf] Fetching page 1 for category 41. 2013-09-14T13:24:41.472Z - info: [announce] "vpf.downloadProgressUpdated": {"progress":0.038461538461538464} 2013-09-14T13:24:41.473Z - info: [vpf] Fetching page 2 for category 41. 2013-09-14T13:24:43.688Z - info: [announce] "vpf.downloadProgressUpdated": {"progress":0.07692307692307693} . . .

2013-09-14T13:25:36.108Z - info: [vpf] Fetching page 25 for category 41. 2013-09-14T13:25:38.241Z - info: [announce] "vpf.downloadProgressUpdated": {"progress":0.9615384615384616} 2013-09-14T13:25:38.242Z - info: [vpf] Fetching page 26 for category 41. 2013-09-14T13:25:40.151Z - info: [vpf] Fetched 637 items in 61.8 seconds. 2013-09-14T13:25:40.151Z - info: [vpf] Updating cache... 2013-09-14T13:25:40.158Z - info: INSERT INTO vpf_files (ipdb_id,category,letter,title,description,fileId,downloads,views,author,lastUpdatedAt,createdAt,updatedAt) VALUES ('4089',41,'0','250cc VP9 FS','Fullscreen VP9 table\n\nUpdated to VP9 from the latest VP8 table.\nIt...',3081,929,5107,'kruge99','2010-03-26 16:00:00','2013-09-14 13:25:40','2013-09-14 13:25:40'); 2013-09-14T13:25:40.175Z - info: INSERT INTO vpf_files (ipdb_id,category,letter,title,description,fileId,downloads,views,author,lastUpdatedAt,createdAt,updatedAt) VALUES ('4089',41,'0','250cc VP91x 1.1 FS','Based on the table by Inder from 1992\n\nUpdate 1.1\n- Updated for VP9...',5378,1258,4135,'jpsalas','2011-04-19 16:00:00','2013-09-14 13:25:40','2013-09-14 13:25:40'); . . .

2013-09-14T13:25:41.018Z - info: INSERT INTO vpf_files (ipdb_id,category,letter,title,description,fileId,downloads,views,author,lastUpdatedAt,createdAt,updatedAt) VALUES ('1260',41,'i','Ice Fever VP9 FS','This is a Full screen version for cabinets. Done by Wildman. Submit...',5208,285,1093,'Itchigo','2011-03-13 16:00:00','2013-09-14 13:25:41','2013-09-14 13:25:41'); 2013-09-14T13:25:41.020Z - info: INSERT INTO vpf_files (ipdb_id,category,letter,title,description,fileId,downloads,views,author,lastUpdatedAt,createdAt,updatedAt) VALUES ('4868',41,'i','Impacto FS B2S','Recreativos Franco Impacto released in FS with animated backglass B...',6137,449,1368,'luvthatapex','2011-12-03 17:00:00','2013-09-14 13:25:41','2013-09-14 13:25:41'); 2013-09-14T13:25:41.023Z - info: INSERT INTO vpf_files (ipdb_id,category,letter,title,description,fileId,downloads,views,author,lastUpdatedAt,createdAt,updatedAt) VALUES ('5350',41,'i','Incredible Hulk FS (Gottlieb 1979)','I got the ok from Eala to release this as well. Great artwork on t...',4832,1034,2644,'vidmouse','2011-01-10 17:00:00','2013-09-14 13:25:41','2013-09-14 13:25:41'); 2013-09-14T13:25:41.026Z - info: INSERT INTO vpf_files (ipdb_id,category,letter,title,description,fileId,downloads,views,author,lastUpdatedAt,createdAt,updatedAt) VALUES ('3878',41,'i','Independence Day FS v1.3','Based on the table by Sega�1997 Updated Version 1.3\n\n\nINDEPENDENCE...',4310,2086,5210,'Nealtron','2011-01-24 17:00:00','2013-09-14 13:25:41','2013-09-14 13:25:41'); 2013-09-14T13:25:41.030Z - error: Error: ER_TRUNCATED_WRONG_VALUE_FOR_FIELD: Incorrect string value: '\xEF\xBF\xBD199...' for column 'description' at row 1: {"category":41,"letter":"i","title":"Independence Day FS v1.3","description":"Based on the table by Sega�1997 Updated Version 1.3\n\n\nINDEPENDENCE...","fileId":4310,"downloads":2086,"views":5210,"author":"Nealtron","lastUpdatedAt":"2011-01-24T17:00:00.000Z","ipdb_id":"3878"} 2013-09-14T13:25:41.030Z - error: [rpc] [vpf] [create index] %s code=ER_TRUNCATED_WRONG_VALUE_FOR_FIELD, errno=1366, sqlState=22007, index=0 2013-09-14T13:25:41.031Z - error: [api] %s code=ER_TRUNCATED_WRONG_VALUE_FOR_FIELD, errno=1366, sqlState=22007, index=0 2013-09-14T13:25:41.031Z - info: ↩ rpc:24 vpforums.createIndex (62642ms) 2013-09-14T13:25:41.032Z - error: ERROR: %s code=ER_TRUNCATED_WRONG_VALUE_FOR_FIELD, errno=1366, sqlState=22007, index=0

[freezy]

Hmm, this should have been fixed in 78b859f. Try to run node create-schema and retry. Note this will erase data from the Pind database (user, tables, etc).