Local Yokel
Posts: 1494
Joined: 2/4/2007 From: Somerset, U.K. Status: offline
|
quote:
ORIGINAL: Woos * The "Numeric value out of range" problem (Thanks to Lokal Yokel for the csv files) aka CHS 157/158 problem This is caused by the "P-61A Black Widow" (Aircraft number 177) having a durability of 129 where I only provided a byte for durability (in stock nothing comes near 128). Short term solution: Edit the WITPair.csv file in a spreadsheet program (Excel or OOcalc) and set the durability of that plane to 127. Afterwards _remove_ witpload.exe from the scenario directory (or rename it). Start WitpDecoder, Initialize Database, Ignore the warning on missing witpload.exe and voila (except of course that the plane will show with a durability of 127 within witpDecoder). Don't forget to bring witpload.exe back into the scenario directory for future DB initializations of other scenarios. quote:
ORIGINAL: Roger Neilson II Nope, have edited the spreadsheet as suggested, it does now come up with warning about being unable to find witpload... proceeds but then will not work as before. Something very odd here. That's on a completely fresh install of the utility, with the password put in - I'm quite used to all this now! Roger Think Roger and I may have hit the same, or a similar, problem. I edited the witpair.csv file as directed, then tried initialising the database with witpload.exe disabled (renamed). That produced the following error in witpdecoder.log: 'Could not create or initialize the databasejava.sql.SQLException: bad TEXT table source file - line number: 76 Attempt to insert null into a non-nullable column: column: NAME table: WITPAIRCRAFT in statement [SET TABLE WITPAIRCRAFT SOURCE "WITPair.csv;ignore_first=true"] java.sql.SQLException: bad TEXT table source file - line number: 76 Attempt to insert null into a non-nullable column: column: NAME table: WITPAIRCRAFT in statement [SET TABLE WITPAIRCRAFT SOURCE "WITPair.csv;ignore_first=true"]' Examination of the witpair.csv in Excel revealed a number of empty cells in the aircraft names column (B) - the first at line 76, as the log indicated. 'Aha', thought I, 'there be the "nulls" that the schema doesn't like' - so I substituted 'DUMMY' for each occurrence of such an empty cell in the aircraft names column of the witpair.csv file, and tried to re-initialise the database. That cured the problem , once I remembered to edit witpdecoder.bat by inclusion of my password . Roger, this may be the solution to your problem - HTH Woos, this enhancement looks excellent - many thanks for identifying the source of my problem and the solution to it
_____________________________
|