zeropingheroes / lancache-autofill

Automatically fill a Lancache with content
GNU General Public License v3.0
132 stars 25 forks source link

SQLSTATE[23000]: Integrity constraint violation #61

Open rwesterflan opened 3 years ago

rwesterflan commented 3 years ago

Hello, after installing on a clean Ubuntu 18.04, I get the following error;

`user@autofill:~/lancache-autofill$ ./lancache-autofill steam:update-app-list Clearing apps from database Downloading app list from Steam Web API Inserting records into database ▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓░░░░░░░ 77% In Connection.php line 664:

SQLSTATE[23000]: Integrity constraint violation: 19 UNIQUE constraint failed: steam_apps.id (SQL: insert into "steam_apps" ("id", "name") select 473610 as "id", Shock Tactics a
s "name" union all select 473660 as "id", Until I Have You OST as "name" union all select 473670 as "id", The Dolls as "name" union all select 473690 as "id", Absolver as "name
" union all select 473720 as "id", Mutant Mudds Super Challenge as "name" union all select 473770 as "id", BallisticNG as "name" union all select 473780 as "id", Splitter Critt
ers as "name" union all select 473790 as "id", Astro Duel Demo as "name" union all select 473810 as "id", Killbot as "name" union all select 473840 as "id", Diib's Dilemma as "
name" union all select 473850 as "id", The Center - ARK Expansion Map as "name" union all select 473870 as "id", Infinity Wars - Treasures of the Calamity as "name" union all s
elect 473871 as "id", Infinity Wars - Martyr's Bounty as "name" union all select 473900 as "id", Oath of Genesis as "name" union all select 473910 as "id", The Nest as "name" u
nion all select 473920 as "id", Corinne Cross's Dead & Breakfast as "name" union all select 473950 as "id", Manifold Garden as "name" union all select 473960 as "id", RPG Maker
MV - Horror Soundscapes as "name" union all select 473090 as "id", Shoppe Keep - Original Soundtrack as "name" union all select 473100 as "id", Shmups Skill Test Original Soun
dtrack as "name" union all select 473110 as "id", EXZEAL Original Soundtrack as "name" union all select 473120 as "id", TRIZEAL Original Soundtrack as "name" union all select 4
73140 as "id", BomberZone as "name" union all select 473410 as "id", Rocket Fist - Soundtrack as "name" union all select 473420 as "id", She Wants Me Dead - Track DLC as "name"
union all select 473430 as "id", The Official AppGameKit Tier 2 Starter's Guide as "name" union all select 473440 as "id", Reflectron Laser as "name" union all select 473441 a
s "id", Sting Shot as "name" union all select 473442 as "id", Volatile Napalm as "name" union all select 473443 as "id", Pure Decoy Launcher 5 Pack A [Karia] [Moegi] [Chiri] [O
uka] [Rinrin] as "name" union all select 473444 as "id", Pure Decoy Launcher 5 Pack B [Seira] [Miyabi] [Noko] [Mitsuki] [Anju] as "name" union all select 473445 as "id", Depth
Crawler Gold Coat as "name" union all select 473446 as "id", Gigantus DCC-Zero Marking as "name" union all select 473447 as "id", Gigantus DCC-Gogo. Marking as "name" union al
l select 473450 as "id", The Narrator is a DICK as "name" union all select 473460 as "id", Memory Oblivion Box as "name" union all select 472670 as "id", Fantasy Grounds - Sava
ge Worlds - Rippers Resurrected: Game Master's Handbook as "name" union all select 472671 as "id", Fantasy Grounds - Savage Worlds - Rippers Resurrected: Player's Guide as "nam
e" union all select 472680 as "id", Elisa: The Innkeeper - Prequel as "name" union all select 472690 as "id", SOMBRERO: Spaghetti Western Mayhem as "name" union all select 4727
20 as "id", Car Car Crash Hands On Edition as "name" union all select 472740 as "id", Ghrian as "name" union all select 472750 as "id", The Incredible Baron OST as "name" union
all select 472770 as "id", HELP: THE GAME as "name" union all select 472810 as "id", VEGA Conflict - Elite Pack as "name" union all select 472811 as "id", VEGA Conflict - Comm
anders Pack as "name" union all select 472830 as "id", Ke-Tsu-No-Ana as "name" union all select 472840 as "id", Tree of Savior - Beginner's Pack for NA Servers as "name" union
all select 472841 as "id", Tree of Savior - Beginner's Pack for EU Servers as "name" union all select 472850 as "id", Demetrios - The BIG Cynical Adventure Demo as "name" union
all select 472860 as "id", Tree of Savior - Beginner's Pack for SEA Servers as "name" union all select 472861 as "id", Tree of Savior - Beginner's Pack for SA Servers as "name
" union all select 472870 as "id", Higurashi When They Cry Hou - Ch.3 Tatarigoroshi as "name" union all select 473050 as "id", UnderWater Adventure as "name" union all select 4
72350 as "id", Bloons TD Battles - Club Starter Pack as "name" union all select 472420 as "id", Duke Grabowski, Mighty Swashbuckler as "name" union all select 472490 as "id", I
strolid - Paint Job as "name" union all select 472630 as "id", GiAnt - A GiAnt Soundtrack as "name" union all select 471810 as "id", Death Squared as "name" union all select 47
1870 as "id", CODE OF PRINCESS - Original Soundtrack as "name" union all select 471880 as "id", AFL Evolution Demo as "name" union all select 471890 as "id", FSX Steam Edition:
F-105D Thunderchief Add-On as "name" union all select 471891 as "id", FSX Steam Edition: C-17 Globemaster III Add-On as "name" union all select 471893 as "id", FSX Steam Editi
on: Sindal Airport Add-On as "name" union all select 471894 as "id", FSX Steam Edition: Sæby Airfield Add-On as "name" union all select 471895 as "id", FSX Steam Edition: Endel
ave Airport Add-On as "name" union all select 471896 as "id", FSX Steam Edition: Herning Airport Add-On as "name" union all select 471897 as "id", FSX Steam Edition: Randers Ai
rport Add-On as "name" union all select 471898 as "id", FSX Steam Edition: Tunø Airport Add-On as "name" union all select 471899 as "id", FSX Steam Edition: Boeing B-29 Superfo
rtress™ Add-On as "name" union all select 471900 as "id", Eclipse --- Defending the motherland Demo as "name" union all select 471920 as "id", Pan-Pan as "name" union all selec
t 472030 as "id", Europa Universalis IV: Fredman's Epistles as "name" union all select 472060 as "id", Ortus Regni as "name" union all select 472070 as "id", Crusader Kings II:
Full Plate Metal as "name" union all select 471320 as "id", Axe, Bow & Staff: The Soundtrack as "name" union all select 471330 as "id", Versus Squad as "name" union all select
471350 as "id", Trove Essentials Pack as "name" union all select 471380 as "id", Urban Pirate as "name" union all select 471390 as "id", VEGA Conflict - Starter Pack as "name"
union all select 471400 as "id", Space Jammers as "name" union all select 471410 as "id", Zenodyne R - Soundtrack as "name" union all select 471420 as "id", Zero Escape: Zero
Time Dilemma - Mini-OST as "name" union all select 471450 as "id", I and Me Original Soundtrack as "name" union all select 471520 as "id", Zero Escape: Zero Time Dilemma - Bonu
s Pamphlet as "name" union all select 471550 as "id", Nine Parchments as "name" union all select 471570 as "id", Grandpa's Table as "name" union all select 471580 as "id", Cybe
rLink PowerDirector 14 Ultimate Suite as "name" union all select 471610 as "id", UNO Demo as "name" union all select 471630 as "id", Rexodus: A VR Story Experience as "name" un
ion all select 471640 as "id", .EXE as "name" union all select 471650 as "id", AdVenture Capitalist - Savvy Investor Bundle as "name" union all select 471660 as "id", Kingspray
Graffiti as "name" union all select 471700 as "id", Greedy Guns as "name" union all select 471720 as "id", K Station as "name" union all select 471730 as "id", Rocket Ski Raci
ng as "name" union all select 471740 as "id", Stories: The Path Of Destinies Original Soundtrack as "name" union all select 471741 as "id", Stories: The Path Of Destinies Artbo
ok as "name" union all select 471750 as "id", URSA as "name" union all select 471760 as "id", Fantasy Grounds - 5E: To Worlds Unknown as "name" union all select 471770 as "id",
In Case of Emergency, Release Raptor as "name" union all select 471800 as "id", Dolphin Defense - Soundtrack as "name" union all select 470800 as "id", She Remembered Caterpil
lars Demo as "name" union all select 470870 as "id", Mecha Ritz: Steel Rondo OST as "name" union all select 470890 as "id", WarFire as "name" union all select 471010 as "id", S
even: Enhanced Edition as "name" union all select 471160 as "id", Moonshot Galaxy™ as "name" union all select 471200 as "id", Melody as "name" union all select 471220 as "id",
Don't Drop the Bass as "name" union all select 471230 as "id", Dead by Daylight: BETA as "name" union all select 471240 as "id", Natural Selection 2 - Shadow Fade as "name" uni
on all select 471250 as "id", Fantasy Grounds - Call of Cthulhu: Secrets of San Francisco as "name" union all select 471260 as "id", Osozaki 遅咲き Late Blooming - First as "na
me" union all select 471270 as "id", Leave The Nest as "name" union all select 471310 as "id", Fantasy Grounds - 5E: Tarin's Crown as "name" union all select 470300 as "id", Wi
nged Sakura: Demon Civil War as "name" union all select 470320 as "id", Dirty Grandpa - Unrated: The Filthy Truth: The Making of Dirty Grandpa as "name" union all select 470330
as "id", Dirty Grandpa - Unrated: I Got Nothin' To Hide: A Look at Daytona's Most Vibrant Dealer as "name" union all select 470340 as "id", Dirty Grandpa - Unrated: Lessons in
Seduction as "name" union all select 470350 as "id", Dirty Grandpa - Unrated: Daytona Heat as "name" union all select 470360 as "id", Dirty Grandpa - Unrated: Gag Reel as "nam
e" union all select 470370 as "id", Gods of Egypt: A Divine Vision: Creating A Cinematic Action Fantasy as "name" union all select 470380 as "id", Gods of Egypt: Of Gods and Mo
rtals: The Cast as "name" union all select 470390 as "id", Gods of Egypt: Transformation: Costume, Make-Up & Hair as "name" union all select 470400 as "id", Gods of Egypt: On L
ocation: Shooting in Australia as "name" union all select 470410 as "id", Gods of Egypt: The Battle for Eternity: Stunts as "name" union all select 470420 as "id", Gods of Egyp
t: A Window Into Another World: Visual Effects as "name" union all select 470430 as "id", Gods of Egypt: Deleted Storyboard Sequences as "name" union all select 470440 as "id",
Matris as "name" union all select 470450 as "id", Where's My Helmet470470 as "name" union all select Birdsketball as "id", 470480 as "name" union all select Angel Express [Tok
kyu Tenshi] as "id", 470490 as "name" union all select RollerGirls From Beyond as "id", 470500 as "name" union all select PlayClaw 5 - Chroma Key for overlays as "id", 470540 a
s "name" union all select Barony Extended Soundtrack by Chris Kukla as "id", 470570 as "name" union all select Paradox Paradigm Demo as "id", 470580 as "name" union all select
In The Shadows as "id", 470590 as "name" union all select moto RKD dash as "id", 470610 as "name" union all select Infinity Wars - Wealthy Noble's Lock Box as "id", 470670 as "
name" union all select Subterrain - Original Soundtrack as "id", 470690 as "name" union all select Spangled Wrastor as "id", 470691 as "name" union all select Panda Maypul as "
id", 470740 as "name" union all select Demolish & Build 2017 as "id", 470750 as "name" union all select Battlezone 98 Redux - The Red Odyssey as "id", 470760 as "name" union al
l select Antiflux as "id", 470770 as "name" union all select Mini's Magic World - Soundtrack as "id", 470780 as "name" union all select She Remembered Caterpillars as "id", 469
850 as "name" union all select Fantasy Grounds - 5E: Champion's Rest as "id", 469880 as "name" union all select Atulos Online - Reaper & Orc as "id", 469890 as "name" union all
select Space Codex as "id", 469900 as "name" union all select Paradox Paradigm as "id", 469910 as "name" union all select Fantasy Grounds - Wild Thing - PFRPG as "id", 469920
as "name" union all select hackmud as "id", 469930 as "name" union all select Pandum online as "id", 469940 as "name" union all select Fantasy Grounds - The Sinking: Complete S
erial - PFRPG as "id", 469980 as "name" union all select Legend of Miro as "id", 469990 as "name" union all select NEKOPALIVE as "id", 470000 as "name" union all select RefRain

In Connection.php line 458:

SQLSTATE[23000]: Integrity constraint violation: 19 UNIQUE constraint failed: steam_apps.id `

Installation steps: user@autofill:~/lancache-autofill$ history 1 git clone https://github.com/zeropingheroes/lancache-autofill.git 2 cd lancache-autofill/ 3 ./install 4 ./install.sh 5 ls 6 vi .env 7 ./lancache-autofill 8 ./lancache-autofill steam:update-app-list

EugeneGGHQ commented 2 years ago

I am also getting this now - And have confirmed that the previous 'biginteger' type had been set in /src/Commands/App/InitialiseDatabase

Ksdmg commented 2 years ago

I have the same issue on a fresh install

Tyzam1 commented 2 years ago

I am also having this issue. Fails at ID 968600

tpill90 commented 2 years ago

Since this app seems to not be actively developed, you could also take a look at my project as an alternative. https://github.com/tpill90/steam-lancache-prefill Its a complete ground up rewrite of autofill, without a dependency on steamcmd, and is currently in active development.