mtgjson / mtgsqlive

MTGJSON build scripts to generate alternative data formats
https://mtgjson.com
MIT License
54 stars 32 forks source link

sqllite import fails #82

Closed sgerodes closed 1 year ago

sgerodes commented 1 year ago

Steps to reproduce

Create a sqlite database (in my case with Pycharm)

What is expected?

import of the AllPrintings.sqlite creates tables and populates the DB with data

What is actually happening?

Error while importing:

end of turn.Instant10E,2ED,30A,3ED,4BB,4ED,5ED,9ED,CED,CEI,DDL,ELD,FBB,J22,LEA,LEB,M10,SUM{'cardKingdom': 'https://mtgjson.com/links/2a40307b3b5b449a', 'cardKingdomFoil': 'https://mtgjson.com/links/27f686be1b473504', 'cardmarket': 'https://... [2023-03-07 08:24:20] [1] [SQLITE_ERROR] SQL error or missing database (near "of": syntax error) end of each day, bringing on the cold blanket of night.2003Englishnormal{6}{U}{U1624414400498cd5a-75e9-5163-90e8-f8d15a97af592710327102135250Denizen of the Deep80When Denizen of the Deep comes into play, return each other creature you con... [2023-03-07 08:24:20] [1] [SQLITE_ERROR] SQL error or missing database (near "of": syntax error) end of turn. Play this ability no more than twice each turn.Creature - Bat010E,4BB,4ED,5ED,DDD,GVL,ITP,LEG,REN,RQS{'cardKingdom': 'https://mtgjson.com/links/e6388368a705aa47', 'cardmarket': 'https://mtgjson.com/links/61ff08dbdc04292a', 'tcg... [2023-03-07 08:24:20] [1] [SQLITE_ERROR] SQL error or missing database (near "of": syntax error) end of turn. This ability can only be used during opponent's turn, before the attack. May not be used on creatures summoned this turn.Summon - Imp12ED,30A,3ED,CED,CEI,FBB,LEA,LEB,SUM{'cardKingdom': 'https://mtgjson.com/links/9aaa6f32cbc0212... [2023-03-07 08:24:20] [1] [SQLITE_ERROR] SQL error or missing database (near "of": syntax error) end of turn.Enchantment — AuraEnchantment7e82ffc2-b036-568b-94b3-a7e3773af228�K�Ue!  U��?�}UUU�9UMark Tedinpaperdraftwhite2608939138RR �?���Q�nonfoil1993E... [2023-03-07 08:24:20] [1] [SQLITE_ERROR] SQL error or missing database (near "of": syntax error) end of combat.4Creature — CockatriceCreature7053701c-7ca4-5bf5-9a50-32544c628be4�,�{e)U�{� �}UUU�YURichard Thomaspaperdraftwhite2603139080GGnonfoil1993En... [2023-03-07 08:24:20] [1] [SQLITE_ERROR] SQL error or missing database (near "of": syntax error) end of combat, if Clockwork Beast attacked or blocked this combat, remove a +1/+0 counter from it. {X}, {T}: Put up to X +1/+0 counters on Clockwork Beast. This ability can't cause the total number of +1/+0 counters on Clockwork Beast to be... [2023-03-07 08:24:20] [1] [SQLITE_ERROR] SQL error or missing database (near "of": syntax error) end step, return target creature card with mana value X or less from your graveyard to the battlefield, where X is the amount of life you gained this turn.4Legendary Creature — Human WarriorCreaturedf89c644-171e-5c29-bcb0-f148a13a270781a909... [2023-03-07 08:24:20] [1] [SQLITE_ERROR] SQL error or missing database (near "step": syntax error) end step, return target creature card with mana value X or less from your graveyard to the battlefield, where X is the amount of life you gained this turn.Legendary Creature — Human Warrior340K{'cardKingdom': 'https://mtgjson.com/links/af00... [2023-03-07 08:24:20] [1] [SQLITE_ERROR] SQL error or missing database (near "step": syntax error) end step, return target creature card with mana value X or less from your graveyard to the battlefield, where X is the amount of life you gained this turn.4Legendary Creature — Human WarriorCreature81a9093e-b573-5d77-8e09-d80ceeecbfb5df89c6... [2023-03-07 08:24:20] [1] [SQLITE_ERROR] SQL error or missing database (near "step": syntax error) end of turn.InstantInstant6e1f4007-7c36-56aa-8888-3f5976e979025ecf0168-1293-59e1-9ad0-a709f3e13f00�A�ze)UC�w�}UUU�wUUGames Workshoppaperblack26613893667WW... [2023-03-07 08:24:20] [1] [SQLITE_ERROR] SQL error or missing database (near "of": syntax error) end of turn.Instant40K{'cardKingdom': 'https://mtgjson.com/links/9f8c3ea52a255fbf', 'tcgplayer': 'https://mtgjson.com/links/41becc97b35feac7'}uncommon84d1bcef-907c-4c3a-8b52-6e633fa19667275bb019-a883-4303-988e-09b212a5a1e50ea6d165-2c30-41a4... [2023-03-07 08:24:20] [1] [SQLITE_ERROR] SQL error or missing database (near "of": syntax error) end step, and if it would leave the battlefield, it is still exiled instead.a346e73e-f771-5eab-992a-94abb5c50b62�S�!�KU2022-10-07At the beginning of the end step, a permanent returned to the battlefield with unearth is exiled. This is a ... [2023-03-07 08:24:20] [1] [SQLITE_ERROR] SQL error or missing database (near "step": syntax error) end step, a permanent returned to the battlefield with unearth is exiled. This is a delayed triggered ability, and it can be countered by effects that counter triggered abilities. If the ability is countered, the permanent will stay on the ... [2023-03-07 08:24:20] [1] [SQLITE_ERROR] SQL error or missing database (near "step": syntax error) end of turn.4Creature — Human SoldierCreaturec7d8e4b4-845b-56b7-9a9d-76897a195f6f2fdcd5af-d981-58e6-a92a-bf9e9c1a6efa�R�JdAIU/�/A�}UUU'�1AUUØrjan Ruttenborg Sv... [2023-03-07 08:24:20] [1] [SQLITE_ERROR] SQL error or missing database (near "of": syntax error)

Additional context

The db driver is the latest provided by Pycharm: DBMS: SQLite (ver. 3.40.1) Case sensitivity: plain=mixed, delimited=mixed Driver: SQLite JDBC (ver. 3.40.1.0, JDBC4.2)

ZeldaZach commented 1 year ago

This should be fixed, please let me know if it's still an issue!