so about https://blog.theretroweb.com/2023/04/25/the-r … ing-volunteers/
readme.md appears slightly outdated. Debian 12 wouldnt work with php8.0. I had to (disclaimer, I dont know what Im doing, >10 years out of managing linux boxes):
-sudo apt install php8.0 php8.0-mbstring php8.0-dom php8.0-gd php8.0-intl php8.0-pgsql php8.0-xsl
+sudo apt install php8.2 php8.2-{mbstring,dom,gd,intl,pgsql,xsl}
+composer require symfony/stimulus-bundle
+yarn upgrade webpack@^5.0.0

\i database.pgsql generated some errors:

1psql:database.pgsql:46218: ERROR:  insert or update on table "chip_image" violates foreign key constraint "fk_e3ead662df91ac92"
2DETAIL:  Key (creditor_id)=(6) is not present in table "creditor".

-yarn dev encore --watch
//doesnt work "Unknown command or entry 'encore'"
+yarn encore dev
//works, no idea if it does the business

-symfony serve -d --document-root=./
+symfony serve -d --document-root=./public
//only place with index.php

1An exception occurred while executing a query: SQLSTATE[42703]: Undefined column: 7 ERROR: column m0_.slug does not exist
2LINE 1: ...dited AS last_edited_4, m0_.max_cpu AS max_cpu_5, m0_.slug A...

debian:/var/www/ultimateretro$ grep -roaF .slug ./ |tail -n1
./migrations/Version20220506194008.php:.slug
cat ./migrations/Version20220506194008.php

1        // this up() migration is auto-generated, please modify it to your needs
2        $this->addSql('ALTER TABLE motherboard ADD slug VARCHAR(80)');

psql:

1SELECT column_name 
2  FROM information_schema.columns
3 WHERE table_schema = 'public'
4   AND table_name   = 'motherboard';
5column_name | id
6column_name | manufacturer_id
7column_name | chipset_id
8column_name | form_factor_id
9column_name | video_chipset_id
10column_name | max_video_ram_id
11column_name | audio_chipset_id
12column_name | name
13column_name | dimensions
14column_name | note
15column_name | last_edited
16column_name | max_cpu

"slug" column missing, /migrations arent being executed?
TLDR: cant bootstrap the repo as is by my own, I need some help.

evasive wrote on 2023-10-28, 20:23:

Ah yes, I checked my vogons notifications and I see I left off around July this year. […]
Show full quote

Ah yes, I checked my vogons notifications and I see I left off around July this year.

When I started to study for a few certificates as I had no project.

I may or may not have been more busy with trying to find something to pay the mortgage/food. My apologies.

I started again two weeks ago so now I have something to fend off the people asking for money.

Hi, evasive,
As far as I know you were the only one here to actively update theretroweb's database from info published in this and the other trw-thread. Since this thread will be locked, but "you're back", do you intend to continue this work based on posts in other (official??) trw-thread or there will be really no more vogons-forum-user-post's updates as declared in the first post here?

I am processing whatever was posted before the cutoff.

I think the post from the other admin member speaks for itself.

I really don't like the way things are going, apparently shots were fired and it came to this.

Evasive out.