DBRepair development

Dev Community Apps & Creations
554

I see if I can get ahold of my MacOS guy and have him try it.

My Mac Mini died last year

555

So should I try manual commands?

556

are you confortable with the Linux shell / bash ?

557

Nah, not at all

558

Before I rip this apart.

Youā€™ve not had any trouble until this update of MacOS ?
(DBRepair hasnā€™t changed in months either)

559

I have not noticed prior to 15.3, thats when this AI rubbish was introduced

560

Thanks. That really points the finger at Apple.

Have you the time to talk to them about it?

I realize weā€™ll need to get a repeatable example of the failure for them to take action ā€” which means running the code in full verbose debug and then examining it.

Iā€™ll work on a procedure for you to capture that verbose output

1 Like
561

So what harm is the error to my Mac or more important PMS. God help me if Plex craps itself, divorce or a shooting :grimacing:

562

As for Talking to apple I would not know where to start considering this is all third party analysis.

563

My guess is this: regex - RE error: illegal byte sequence on Mac OS X - Stack Overflow

Try prefixing the sed commands with LC_ALL=C.

# Edit the .SQL files if all OK
    if [ $Fail -eq 0 ]; then

      # Edit
      LC_ALL=C sed -i -e 's/ROLLBACK;/COMMIT;/' "$TMPDIR/library.plexapp.sql-$TimeStamp"
      LC_ALL=C sed -i -e 's/ROLLBACK;/COMMIT;/' "$TMPDIR/blobs.plexapp.sql-$TimeStamp"
    fi
1 Like
564

WTH? Why now ?

2 Likes
565

Ok, do you mean?

Screenshot 2025-03-18 at 12.46.54 pm
Screenshot 2025-03-18 at 12.46.54 pm577Ɨ375 53 KB

566

Maybe the database has some new extended text characters now, a movie or person name with something, or an emoji even.

@SE56 ā€¦ you could share a database file, zipped up?

567

Iā€™m sorry I meant to modify the script, thatā€™s the section @ChuckPa identified as the likely failing commands.

1 Like
568

The SQL wonā€™t cause a RE error.

Setting LC=C controls the operation of sed arguments

Standby please, Iā€™m crafting a test

1 Like
570

DBRepair with correct mods :smiling_face_with_sunglasses:

DBRepair-test.tar.gz (16.6 KB)

Sorry about that

571

Instructions, just run it

572
  1. :popcorn:
  2. :beer_mug:
  3. Run it
573

So just zip it and post

DBRepair-test.sh.zip (17.1 KB)

574

I gave you the tar.gz.

  1. Extract it. (tar xf DBRepair-test.tar.gz)
  2. Make popcorn & pour beer
  3. Run it
  4. Use fire extinguisher as required.
    ( itā€™s been a long day )