alonelyjuicebox / ofmetadatatostash Goto Github PK

Looks like the latest dev branch is incompatible with Stash v0.20.2 build hash e685f80e.

Invoke-SqliteQuery: /home/alex/opt/OFMetadataToStash-0.4/OFMetadataToStash.ps1:264
Line |
 264 |  … eryResult = Invoke-SqliteQuery -Query $Query -DataSource $PathToStash …
     |                ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
     | Exception calling "Fill" with "1" argument(s): "SQL logic error no such column: scenes.path"
Invoke-SqliteQuery: /home/alex/opt/OFMetadataToStash-0.4/OFMetadataToStash.ps1:275
Line |
 275 |  … eryResult = Invoke-SqliteQuery -Query $Query -DataSource $PathToStash …
     |                ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
     | Exception calling "Fill" with "1" argument(s): "SQL logic error no such column: path"

INFO

There's a file in this OnlyFans metadata database that we couldn't find in your Stash database but the file IS on your filesystem.
It could be a duplicate that Stash decided not to import, but try running a Scan Task in Stash then re-running this script.

I verified the file exists in stash. But still can't make it work.

Because the path to a given media file (in stash) fundamentally differs from from the path that might be seen in the OnlyFans database, I need to add support for auto translating chunks of a path if manually defined in the config file

I also need to copy the stash db file to a local path to avoid SQLite issues that occur when accessing the db over a network connection

This is possible, however since PSSQLite does not support blobs, I will likely end up waiting for this Stash issue where images may finally be stored outside of the Stash SQLite DB

Looks like the stash db schema has been updated and now im seeing this. I assume a script update is needed?

OnlyFans Metadata to Stash Database PoSH Script

Your Stash database has a newer database schema than expected!
(Expected version 41, your Stash database is running Stash schema version 43)
Checking for incompatibility...

- Hmm...The 'Images' table has been modified in this new db schema
- Hmm...The 'Performers' table has been modified in this new db schema

For the reason(s) mentioned above, your database may be incompatible with this script
Running this script may change your database in unexpected, untested ways.

1 - Press [Enter] to exit.
2 - You may override this warning by entering the phrase 'Never tell me the odds!', then pressing [Enter]

What would you like to do?:

Can you please consider introducing a feature to mass sanitize a selection of DBs? Perhaps it could output the clean dbs to a specific folder and next to the original

This integration would pave the way towards making this app more cross compatible.
Binaries for PS and PS Core are both available, this should work swimmingly...

Upon running the Powershell script, the only metadata that seems to be added to Stash are:

• A performer gets created with an OF url,
• The performer is added to the videos & images.

It doesn't appear to add any other metadata, like the post details, post url, creation date etc.

The only thing I can think of that might contribute to that, is that I have changed the default filename in the DC script to include the performer username, as below:

"filename_format": "{model_username}-{media_id}-{filename}.{ext}",

I'm running DC OF v7.6.1 and OFMetadataToStash v0.3.

Just wondering if there is any other configuration I might be missing?

elseif: /home/""/Downloads/OFMetadataToStash/OFMetadataToStash.ps1:703
Line |
 703 |     elseif($userscanselection -eq 2){
     |     ~~~~~~
     | The term 'elseif' is not recognized as a name of a cmdlet, function, script file, or executable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again.
elseif: /home/""/Downloads/OFMetadataToStash/OFMetadataToStash.ps1:1015
Line |
1015 |      elseif($userscanselection -eq 3){
     |      ~~~~~~
     | The term 'elseif' is not recognized as a name of a cmdlet, function, script file, or executable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again.
else: /home/""/Downloads/OFMetadataToStash/OFMetadataToStash.ps1:1019
Line |
1019 |      else{
     |      ~~~~
     | The term 'else' is not recognized as a name of a cmdlet, function, script file, or executable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again.

no changes have been made to the script

Trying to run this in a windows vm that runs DC's script and have tried mapping my stash directory and my OF directory but each time i try to run your script it tells me to define a valid filepath for stash or OF. If i move the stash db local it tells me i need to define a valid filepath for OF data. If i move the user_data.db for one person local and run it the script runs but then tells me that its referencing data thats not in my stash db.

Is there anyway for me to run this in a vm where all of my data is on another machine?