WEBVTT

NOTE Machine-generated captions; not manually listened or word-verified.

00:00:00.000 --> 00:00:02.760
but anyway, version three and four

00:00:02.760 --> 00:00:05.120
were running out of an SQL Lite database,

00:00:05.120 --> 00:00:07.680
and I could see that version five

00:00:07.680 --> 00:00:09.920
only supported SQL Lite

00:00:09.920 --> 00:00:14.240
up until I think 5.0.83 or something,

00:00:14.240 --> 00:00:16.880
and the latest version is 5.2 something.

00:00:16.880 --> 00:00:19.040
So I had to upgrade air quotes,

00:00:19.040 --> 00:00:22.400
upgrade from SQL Lite to my SQL

00:00:22.400 --> 00:00:24.520
as the database backend.

00:00:24.520 --> 00:00:28.520
That's what all version five installs now do by default anyway.

00:00:28.520 --> 00:00:32.880
So I tried with Claude for maybe two or three hours

00:00:32.880 --> 00:00:36.840
to get all of the foreign key constraints and things like that

00:00:36.840 --> 00:00:41.320
with an SQL Lite to my SQL migration tool working,

00:00:41.320 --> 00:00:44.160
and I kind of got most of the way there.

00:00:44.160 --> 00:00:45.560
And then there was something happen,

00:00:45.560 --> 00:00:46.720
I can't remember what exactly,

00:00:46.720 --> 00:00:48.880
but I ended up back at square one again,

00:00:48.880 --> 00:00:51.520
where it was running from the SQL Lite database,

00:00:51.520 --> 00:00:53.240
even though I told it not to,

00:00:53.240 --> 00:00:55.400
and then I upgraded,

00:00:55.400 --> 00:00:57.000
oh, this is what it was,

00:00:57.000 --> 00:01:01.560
I upgraded my SQL on a fresh install to 8.4,

00:01:01.560 --> 00:01:06.080
but Ghost 5 has a bug where it only initializes properly

00:01:06.080 --> 00:01:08.840
with 8.0 of my SQL.

00:01:08.840 --> 00:01:10.480
I'll go figure.

00:01:10.480 --> 00:01:13.840
I tell you, I had a rough evening with that one.