ErikGartner / ardb

Mirror of Anarch Revolt Deck Builder from Google Code.
0 stars 0 forks source link

bug in update datebase, win xp #47

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago
What steps will reproduce the problem?
1. click on "file"->"update database"
2. click on "ok" for start download and update

What is the expected output? What do you see instead?
Downloading...
Importing file vtescrypt.csv... 
Importing file vteslib.csv... 
Importing file vtessets.csv... 
ERROR -> UPDATE ABORTED (ROLLBACK)
Database update has ended.
You may need to restart ARDB.

and details

12:45:46: Query was: CREATE TABLE Crypt (       name TEXT,       type TEXT,
      clan TEXT,       adv TEXT,       groupnumber int,       capacity int,
      disciplines TEXT,       cardtext TEXT,       edition TEXT,      
title TEXT,       artist TEXT, artist int, abombwe int, animalism int,
auspex int, celerity int, chimerstry int, daimoinon int, dementation int,
dominate int, fortitude int, melpominee int, mytherceria int, necromancy
int, obeah int, obfuscate int, obtenebration int, potence int, presence
int, protean int, quietus int, sanguinus int, serpentis int, spiritus int,
temporis int, thanatosis int, thaumaturgy int, valeren int, vicissitude
int, visceratika int, edition_save TEXT);
12:45:46: SQL error: duplicate column name: artist
12:45:46: Query was: CREATE TABLE cards_crypt_unsorted (       card_name
INTEGER,       clan INTEGER,       adv INTEGER,       groupnumber INTEGER,
      capacity INTEGER,       disciplines STRING,       superior STRING,  
    inferior STRING,       title STRING,       card_text INTEGER,      
release_set INTEGER,       release_date INTEGER,       rarity INTEGER,    
  artist STRING,       url STRING, artist INTEGER, abombwe INTEGER,
animalism INTEGER, auspex INTEGER, celerity INTEGER, chimerstry INTEGER,
daimoinon INTEGER, dementation INTEGER, dominate INTEGER, fortitude
INTEGER, melpominee INTEGER, mytherceria INTEGER, necromancy INTEGER, obeah
INTEGER, obfuscate INTEGER, obtenebration INTEGER, potence INTEGER,
presence INTEGER, protean INTEGER, quietus INTEGER, sanguinus INTEGER,
serpentis INTEGER, spiritus INTEGER, temporis INTEGER, thanatosis INTEGER,
thaumaturgy INTEGER, valeren INTEGER, vicissitude INTEGER, visceratika
INTEGER, record_num INTEGER PRIMARY KEY);
12:45:46: SQL error: duplicate column name: artist
12:45:46: Query was: INSERT INTO Crypt VALUES("Aabbt
Kindred","Vampire","Follower of Set","","2","4","for pre ser","Independent:
Aabbt Kindred cannot perform (D) actions unless Nefertiti is ready. Aabbt
Kindred can prevent 1 damage each combat. Aabbt Kindred are not unique and
do not contest.","FN:U2","","","Lawrence
Snelly",0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,1,0,0,0,1,0,0,0,0,0,0,0, NULL);
12:45:46: SQL error: no such table: Crypt
12:45:46: An error occured : canceling import.
12:45:46: Query was: INSERT INTO Library VALUES(".44
Magnum","Equipment","","","2","","","","Weapon, gun. 2R damage each strike,
with an optional maneuver each combat.","","Jyhad:C, VTES:C, Sabbat:C,
SW:PB, CE:PTo3, LoB:PO3","","","Ne Ne Thomas; Greg Simanson", NULL);
12:45:46: SQL error: table Library has 14 columns but 15 values were supplied
12:45:46: An error occured : canceling import.
12:45:46: Cancelling changes to prevent database corruption

What version of the product are you using? On what operating system?
ARDB v 2 RC 4, build Jan 11 2008; Win XP; I have last edition update Lords
of the Night.

Original issue reported on code.google.com by smejko.m...@gmail.com on 6 Jul 2008 at 10:56

GoogleCodeExporter commented 9 years ago
White Wolfs CSV file format has changed.  You need to download version
ardb_release_2_8_0 to support this new file format.

Original comment by graham.r...@gmail.com on 6 Jul 2008 at 4:55