Errors using the updated script.

[skinnyzaz]

Using the newly updated script I am getting the following errors:

/root/plex-db-sync: line 111: [: too many arguments
[Fri Jun 7 07:13:18 EDT 2019] Stopping Plex on Server 1... Done
[Fri Jun 7 07:13:20 EDT 2019] Stopping Plex on Server 2... Done
[Fri Jun 7 07:13:33 EDT 2019] Checking for changes... Found
Error: near line 1: table "metadata_item_settings" already exists
Error: near line 1: table "metadata_items" already exists
Error: near line 1: table "taggings" already exists
Error: near line 1: table "tags" already exists
Error: near line 1: no such table: tmpdb.metadata_item_settings1
Error: near line 1: no such table: tmpdb.metadata_item_settings2
[Fri Jun 7 07:13:35 EDT 2019] Processing tags...
Error: no such table: taggings1
Error: no such table: taggings1
Error: no such table: taggings2
Error: no such table: taggings2
[Fri Jun 7 07:13:35 EDT 2019] Processing for (0)...
[Fri Jun 7 07:13:35 EDT 2019] - Checking records that are in both databases
Error: no such table: metadata_item_settings1

[skinnyzaz]

Thanks using the fix I don't get the argument error anymore but I am still receiving the other errors. Do you have any idea why its happening? I removed the 1-136 setting server from the log below to shorten it up.

[Sat Jun 8 07:21:54 EDT 2019] Starting.
[Sat Jun 8 07:21:59 EDT 2019] Stopping Plex on Server 1... Done
[Sat Jun 8 07:22:06 EDT 2019] Stopping Plex on Server 2... Done
[Sat Jun 8 07:22:36 EDT 2019] Checking for changes... Found
Error: near line 1: table "metadata_item_settings" already exists
Error: near line 1: table "metadata_items" already exists
Error: near line 1: table "taggings" already exists
Error: near line 1: table "tags" already exists
Error: near line 1: no such table: tmpdb.metadata_item_settings1
Error: near line 1: no such table: tmpdb.metadata_item_settings2
[Sat Jun 8 07:22:39 EDT 2019] Processing tags...
Error: no such table: taggings1
Error: no such table: taggings1
Error: no such table: taggings2
Error: no such table: taggings2
[Sat Jun 8 07:22:40 EDT 2019] Processing for (0)...
[Sat Jun 8 07:22:40 EDT 2019] - Checking records that are in both databases
Error: no such table: metadata_item_settings1
[Sat Jun 8 07:22:40 EDT 2019] - (0/136) Setting server 2 status for:
[Sat Jun 8 07:22:40 EDT 2019] - (135/136) Setting server 2 status for:
[Sat Jun 8 07:22:40 EDT 2019] - Checking records missing from server 2
Error: no such table: metadata_item_settings1
[Sat Jun 8 07:22:40 EDT 2019] - (0/136) Setting server 2 status for:
[Sat Jun 8 07:22:41 EDT 2019] - (135/136) Setting server 2 status for:
[Sat Jun 8 07:22:41 EDT 2019] - Checking records missing from server 1
Error: no such table: metadata_item_settings2

[daxxi13]

try with this another fix please

[skinnyzaz]

Still receiving some errors, I am using media server V 1.15.8.1198 on Ubuntu if that helps.

[Sun Jun 9 08:00:49 EDT 2019] Starting.
[Sun Jun 9 08:00:50 EDT 2019] Stopping Plex on Server 1... Done
[Sun Jun 9 08:00:57 EDT 2019] Stopping Plex on Server 2... Done
[Sun Jun 9 08:01:20 EDT 2019] Checking for changes... Found
Error: near line 1: table "metadata_item_settings" already exists
Error: near line 1: table "metadata_items" already exists
Error: near line 1: table "taggings" already exists
Error: near line 1: table "tags" already exists
Error: near line 1: no such table: tmpdb.metadata_item_settings1
Error: near line 1: no such table: tmpdb.metadata_item_settings2
[Sun Jun 9 08:01:22 EDT 2019] Processing tags...
Error: no such table: taggings1
Error: no such table: taggings1
Error: no such table: taggings2
Error: no such table: taggings2
[Sun Jun 9 08:01:22 EDT 2019] Processing for (0)...
[Sun Jun 9 08:01:22 EDT 2019] - Checking records that are in both databases
Error: no such table: metadata_item_settings1

[daxxi13]

can you run with "--debug true" and post the result ?

[skinnyzaz]

./plex-db-sync --plex-db-1 "/home/databases1/com.plexapp.plugins.library.db" --plex-start-1 "ssh [email protected] service plexmediaserver start" --plex-stop-1 "ssh [email protected] service plexmediaserver stop" --plex-db-2 "/home/database2/com.plexapp.plugins.library.db" --plex-start-2 "ssh [email protected] service plexmediaserver start" --plex-stop-2 "ssh [email protected] service plexmediaserver stop" --debug true
[Mon Jun 10 07:15:45 EDT 2019] Starting.
[Mon Jun 10 07:15:45 EDT 2019] TMPFOLDER: /tmp/plex-db-sync
[Mon Jun 10 07:15:45 EDT 2019] DEBUG: true
[Mon Jun 10 07:15:45 EDT 2019] PLEXDB1: /home/databases1/com.plexapp.plugins.library.db
[Mon Jun 10 07:15:45 EDT 2019] PLEXDB2: /home/databases2/com.plexapp.plugins.library.db
[Mon Jun 10 07:15:45 EDT 2019] PLEXSTART1: ssh [email protected] service plexmediaserver start
[Mon Jun 10 07:15:45 EDT 2019] PLEXSTOP1: ssh [email protected] service plexmediaserver stop
[Mon Jun 10 07:15:45 EDT 2019] PLEXSTART2: ssh [email protected] service plexmediaserver start
[Mon Jun 10 07:15:45 EDT 2019] PLEXSTOP2: ssh [email protected] service plexmediaserver stop
[Mon Jun 10 07:15:45 EDT 2019] PLEXF1: /tmp/plex-db-sync/1.sql
[Mon Jun 10 07:15:45 EDT 2019] PLEXF2: /tmp/plex-db-sync/2.sql
[Mon Jun 10 07:15:45 EDT 2019] TMPDB: /tmp/plex-db-sync/tmp.db
[Mon Jun 10 07:15:45 EDT 2019] IGNORE:
[Mon Jun 10 07:15:45 EDT 2019] IGNORESTR:
[Mon Jun 10 07:15:45 EDT 2019] BACKUP: false
[Mon Jun 10 07:15:46 EDT 2019] version db1: 20190403100000 db2: 20190403100000
[Mon Jun 10 07:15:46 EDT 2019] Stopping Plex on Server 1... Done
[Mon Jun 10 07:15:50 EDT 2019] Stopping Plex on Server 2... Done
[Mon Jun 10 07:16:19 EDT 2019] Checking for changes... [Mon Jun 10 07:16:21 EDT 2019] UP1: 2019-06-10 07:15:46 - UP2: 2019-06-10 07:15:46
[Mon Jun 10 07:16:21 EDT 2019] CH1: 169570936 - CH2: 169165234
Found
Error: near line 1: table "metadata_item_settings" already exists
Error: near line 1: table "metadata_items" already exists
Error: near line 1: table "taggings" already exists
Error: near line 1: table "tags" already exists
Error: near line 1: no such table: tmpdb.metadata_item_settings1
Error: near line 1: no such table: tmpdb.metadata_item_settings2
[Mon Jun 10 07:16:21 EDT 2019] Processing tags...
[Mon Jun 10 07:16:21 EDT 2019] -=-: select distinct t1.* from taggings1 ts1, tags1 t1, metadata_items1 m1 where ts1.tag_id=t1.id and ts1.metadata_item_id=m1.id and t1.tag_type=11 and m1.guid in (select guid from metadata_items2) and t1.tag not in (select tag from tags2);
Error: no such table: taggings1
[Mon Jun 10 07:16:21 EDT 2019] -=-: select ts1., t1.tag, m1.guid from taggings1 ts1, tags1 t1, metadata_items1 m1 where ts1.tag_id=t1.id and ts1.metadata_item_id=m1.id and t1.tag_type=11 and m1.guid in (select guid from metadata_items2) and m1.guid not in (select distinct m2.guid from taggings2 ts2, tags2 t2, metadata_items2 m2 where ts2.tag_id=t2.id and ts2.metadata_item_id=m2.id and t2.tag_type=11 and t2.tag=t1.tag);
Error: no such table: taggings1
[Mon Jun 10 07:16:21 EDT 2019] -=-: select distinct t2. from taggings2 ts2, tags2 t2, metadata_items2 m2 where ts2.tag_id=t2.id and ts2.metadata_item_id=m2.id and t2.tag_type=11 and m2.guid in (select guid from metadata_items1) and t2.tag not in (select tag from tags1);
Error: no such table: taggings2
[Mon Jun 10 07:16:21 EDT 2019] -=-: select ts2.*, t2.tag, m2.guid from taggings2 ts2, tags2 t2, metadata_items2 m2 where ts2.tag_id=t2.id and ts2.metadata_item_id=m2.id and t2.tag_type=11 and m2.guid in (select guid from metadata_items1) and m2.guid not in (select distinct m1.guid from taggings1 ts1, tags1 t1, metadata_items1 m1 where ts1.tag_id=t1.id and ts1.metadata_item_id=m1.id and t1.tag_type=11 and t1.tag=t2.tag);
Error: no such table: taggings2
[Mon Jun 10 07:16:21 EDT 2019] -=-: select id, name from accounts where lower(name) not in () order by id;
[Mon Jun 10 07:16:21 EDT 2019] -=-: select id, name from accounts where lower(name) not in () order by id;
[Mon Jun 10 07:16:22 EDT 2019] Processing for (0)...
[Mon Jun 10 07:16:22 EDT 2019] - Checking records that are in both databases
[Mon Jun 10 07:16:22 EDT 2019] -=-: select s1.guid, s1.id as id1, s1.updated_at as updated_at1, s1.view_count as view_count1, s1.last_viewed_at as last_viewed_at1, s1.view_offset as view_offset1, s1.changed_at as changed_at1, s2.id as id2, s2.updated_at as updated_at2, s2.view_count as view_count2, s2.last_viewed_at as last_viewed_at2, s2.view_offset as view_offset2, s2.changed_at as changed_at2 from metadata_item_settings1 s1, metadata_item_settings2 s2 where s1.guid=s2.guid and s1.account_id=s2.account_id and s1.account_id=0 and (s1.view_count != s2.view_count or s1.last_viewed_at != s2.last_viewed_at or s1.view_offset != s2.view_offset or s1.changed_at != s2.changed_at);
Error: no such table: metadata_item_settings1

[daxxi13]

which version of sqlite3 are you using ?
can you run this one : debug-verbose

[skinnyzaz]

sqlite3 version 3.11.0
this is from the debug-verbose script.

[Tue Jun 11 06:49:23 EDT 2019] PLEXF1: /tmp/plex-db-sync/1.sql
[Tue Jun 11 06:49:23 EDT 2019] PLEXF2: /tmp/plex-db-sync/2.sql
[Tue Jun 11 06:49:23 EDT 2019] TMPDB: /tmp/plex-db-sync/tmp.db
[Tue Jun 11 06:49:23 EDT 2019] IGNORE:
[Tue Jun 11 06:49:23 EDT 2019] IGNORESTR:
[Tue Jun 11 06:49:23 EDT 2019] BACKUP: false
[Tue Jun 11 06:49:23 EDT 2019] version db1: 20190403100000 db2: 20190403100000
[Tue Jun 11 06:49:23 EDT 2019] Stopping Plex on Server 1... Done
[Tue Jun 11 06:49:23 EDT 2019] Stopping Plex on Server 2... Done
[Tue Jun 11 06:49:27 EDT 2019] Checking for changes... [Tue Jun 11 06:49:28 EDT 2019] UP1: 2019-06-11 06:46:43 - UP2: 2019-06-11 03:17:11
Found
[Tue Jun 11 06:49:28 EDT 2019] Running createTmpDB
[Tue Jun 11 06:49:28 EDT 2019] running CREATE TABLE "metadata_item_settings" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "account_id" integer, "guid" varchar(255), "rating" float, "view_offset" integer, "view_count" integer, "last_viewed_at" datetime, "created_at" datetime, "updated_at" datetime, "skip_count" integer DEFAULT 0, "last_skipped_at" datetime DEFAULT NULL, "changed_at" integer(8) DEFAULT 0, 'extra_data' varchar(255)); in
Error: near line 1: table "metadata_item_settings" already exists
Error: near line 1: table "metadata_items" already exists
Error: near line 1: table "taggings" already exists
Error: near line 1: table "tags" already exists
Error: near line 1: no such table: tmpdb.metadata_item_settings1
Error: near line 1: no such table: tmpdb.metadata_item_settings2
[Tue Jun 11 06:49:28 EDT 2019] Processing tags...
[Tue Jun 11 06:49:28 EDT 2019] -=-: select distinct t1.* from taggings1 ts1, tags1 t1, metadata_items1 m1 where ts1.tag_id=t1.id and ts1.metadata_item_id=m1.id and t1.tag_type=11 and m1.guid in (select guid from metadata_items2) and t1.tag not in (select tag from tags2);
Error: no such table: taggings1
[Tue Jun 11 06:49:28 EDT 2019] -=-: select ts1., t1.tag, m1.guid from taggings1 ts1, tags1 t1, metadata_items1 m1 where ts1.tag_id=t1.id and ts1.metadata_item_id=m1.id and t1.tag_type=11 and m1.guid in (select guid from metadata_items2) and m1.guid not in (select distinct m2.guid from taggings2 ts2, tags2 t2, metadata_items2 m2 where ts2.tag_id=t2.id and ts2.metadata_item_id=m2.id and t2.tag_type=11 and t2.tag=t1.tag);
Error: no such table: taggings1
[Tue Jun 11 06:49:28 EDT 2019] -=-: select distinct t2. from taggings2 ts2, tags2 t2, metadata_items2 m2 where ts2.tag_id=t2.id and ts2.metadata_item_id=m2.id and t2.tag_type=11 and m2.guid in (select guid from metadata_items1) and t2.tag not in (select tag from tags1);
Error: no such table: taggings2
[Tue Jun 11 06:49:28 EDT 2019] -=-: select ts2.*, t2.tag, m2.guid from taggings2 ts2, tags2 t2, metadata_items2 m2 where ts2.tag_id=t2.id and ts2.metadata_item_id=m2.id and t2.tag_type=11 and m2.guid in (select guid from metadata_items1) and m2.guid not in (select distinct m1.guid from taggings1 ts1, tags1 t1, metadata_items1 m1 where ts1.tag_id=t1.id and ts1.metadata_item_id=m1.id and t1.tag_type=11 and t1.tag=t2.tag);
Error: no such table: taggings2
[Tue Jun 11 06:49:28 EDT 2019] -=-: select id, name from accounts where lower(name) not in () order by id;
[Tue Jun 11 06:49:28 EDT 2019] -=-: select id, name from accounts where lower(name) not in () order by id;
[Tue Jun 11 06:49:28 EDT 2019] Processing for (0)...
[Tue Jun 11 06:49:28 EDT 2019] - Checking records that are in both databases
[Tue Jun 11 06:49:28 EDT 2019] -=-: select s1.guid, s1.id as id1, s1.updated_at as updated_at1, s1.view_count as view_count1, s1.last_viewed_at as last_viewed_at1, s1.view_offset as view_offset1, s1.changed_at as changed_at1, s2.id as id2, s2.updated_at as updated_at2, s2.view_count as view_count2, s2.last_viewed_at as last_viewed_at2, s2.view_offset as view_offset2, s2.changed_at as changed_at2 from metadata_item_settings1 s1, metadata_item_settings2 s2 where s1.guid=s2.guid and s1.account_id=s2.account_id and s1.account_id=0 and (s1.view_count != s2.view_count or s1.last_viewed_at != s2.last_viewed_at or s1.view_offset != s2.view_offset or s1.changed_at != s2.changed_at);
Error: no such table: metadata_item_settings1

[daxxi13]

can you run this command please :
echo 'test "value1"'|sed -e 's,test "value1",test "value2",g'

[skinnyzaz]

This is the result of that command

test "value2"

BTW I really appreciate you helping me with this, do you have a donation link?

[daxxi13]

Your welcome. Thanks to you this script will be better.
I think this changes can resolve this issue

[skinnyzaz]

Errors are a bit different this time :)

[Sun Jun 16 05:55:51 EDT 2019] Starting.
[Sun Jun 16 05:55:52 EDT 2019] Stopping Plex on Server 1... Done
[Sun Jun 16 05:56:05 EDT 2019] Stopping Plex on Server 2... Done
[Sun Jun 16 05:56:23 EDT 2019] Checking for changes... Found
Error: incomplete SQL: CREATE TABLE "metadata_item_settings1" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "account_id" integer, "guid" varchar(255), "rating" float, "view_offset" integer, "view_count" integer, "last_viewed_at" datetime, "created_at" datetime, "updated_at" datetime, "skip_count" integer DEFAULT 0, "last_skipped_at" datetime DEFAULT NULL, "changed_at" integer(8) DEFAULT 0, 'extra_data' varchar(255))
Error: incomplete SQL: CREATE TABLE "metadata_item_settings2" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "account_id" integer, "guid" varchar(255), "rating" float, "view_offset" integer, "view_count" integer, "last_viewed_at" datetime, "created_at" datetime, "updated_at" datetime, "skip_count" integer DEFAULT 0, "last_skipped_at" datetime DEFAULT NULL, "changed_at" integer(8) DEFAULT 0, 'extra_data' varchar(255))
Error: incomplete SQL: CREATE TABLE "metadata_items1" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "library_section_id" integer, "parent_id" integer, "metadata_type" integer, "guid" varchar(255), "media_item_count" integer, "title" varchar(255), "title_sort" varchar(255) COLLATE NOCASE, "original_title" varchar(255), "studio" varchar(255), "rating" float, "rating_count" integer, "tagline" varchar(255), "summary" text, "trivia" text, "quotes" text, "content_rating" varchar(255), "content_rating_age" integer, "index" integer, "absolute_index" integer, "duration" integer, "user_thumb_url" varchar(255), "user_art_url" varchar(255), "user_banner_url" varchar(255), "user_music_url" varchar(255), "user_fields" varchar(255), "tags_genre" varchar(255), "tags_collection" varchar(255), "tags_director" varchar(255), "tags_writer" varchar(255), "tags_star" varchar(255), "originally_available_at" datetime, "available_at" datetime, "expires_at" datetime, "refreshed_at" datetime, "year" integer, "added_at" datetime, "created_at" datetime, "updated_at" datetime, "deleted_at" datetime, "tags_country" varchar(255), "extra_data" varchar(255), "hash" varchar(255), "audience_rating" float, "changed_at" integer(8) DEFAULT 0, "resources_changed_at" integer(8) DEFAULT 0, 'remote' integer)
Error: incomplete SQL: CREATE TABLE "metadata_items2" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "library_section_id" integer, "parent_id" integer, "metadata_type" integer, "guid" varchar(255), "media_item_count" integer, "title" varchar(255), "title_sort" varchar(255) COLLATE NOCASE, "original_title" varchar(255), "studio" varchar(255), "rating" float, "rating_count" integer, "tagline" varchar(255), "summary" text, "trivia" text, "quotes" text, "content_rating" varchar(255), "content_rating_age" integer, "index" integer, "absolute_index" integer, "duration" integer, "user_thumb_url" varchar(255), "user_art_url" varchar(255), "user_banner_url" varchar(255), "user_music_url" varchar(255), "user_fields" varchar(255), "tags_genre" varchar(255), "tags_collection" varchar(255), "tags_director" varchar(255), "tags_writer" varchar(255), "tags_star" varchar(255), "originally_available_at" datetime, "available_at" datetime, "expires_at" datetime, "refreshed_at" datetime, "year" integer, "added_at" datetime, "created_at" datetime, "updated_at" datetime, "deleted_at" datetime, "tags_country" varchar(255), "extra_data" varchar(255), "hash" varchar(255), "audience_rating" float, "changed_at" integer(8) DEFAULT 0, "resources_changed_at" integer(8) DEFAULT 0, 'remote' integer)
Error: incomplete SQL: CREATE TABLE "taggings1" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "metadata_item_id" integer, "tag_id" integer, "index" integer, "text" varchar(255), "time_offset" integer, "end_time_offset" integer, "thumb_url" varchar(255), "created_at" datetime, "extra_data" varchar(255))
Error: incomplete SQL: CREATE TABLE "taggings2" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "metadata_item_id" integer, "tag_id" integer, "index" integer, "text" varchar(255), "time_offset" integer, "end_time_offset" integer, "thumb_url" varchar(255), "created_at" datetime, "extra_data" varchar(255))
Error: incomplete SQL: CREATE TABLE "tags1" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "metadata_item_id" integer, "tag" varchar(255) COLLATE NOCASE, "tag_type" integer, "user_thumb_url" varchar(255), "user_art_url" varchar(255), "user_music_url" varchar(255), "created_at" datetime, "updated_at" datetime, "tag_value" integer, 'extra_data' varchar(255), 'key' varchar(255), 'parent_id' integer)
Error: incomplete SQL: CREATE TABLE "tags2" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "metadata_item_id" integer, "tag" varchar(255) COLLATE NOCASE, "tag_type" integer, "user_thumb_url" varchar(255), "user_art_url" varchar(255), "user_music_url" varchar(255), "created_at" datetime, "updated_at" datetime, "tag_value" integer, 'extra_data' varchar(255), 'key' varchar(255), 'parent_id' integer)
Error: near line 1: no such table: tmpdb.metadata_item_settings1
Error: near line 1: no such table: tmpdb.metadata_item_settings2
[Sun Jun 16 05:56:25 EDT 2019] Processing tags...
Error: no such table: taggings1
Error: no such table: taggings1
Error: no such table: taggings2
Error: no such table: taggings2
[Sun Jun 16 05:56:25 EDT 2019] Processing for (0)...
[Sun Jun 16 05:56:25 EDT 2019] - Checking records that are in both databases
Error: no such table: metadata_item_settings1

[Fmstrat]

Anyone else seeing this?

[daxxi13]

Your using an old version of sqlite3 (from 2016).
Please try with the lastest version.

[skinnyzaz]

OMG that worked!!! I updated to 3.22.0 and it seems to have worked perfectly, I am sorry I thought I was at the latest version I didn't realize I needed to add a new repo to get the newest version of it.
Thank you so much for your help I really appreciate it and this script.

BTW can you tell me exactly what command do I use to add the ignore user option? Or is there a way to sync for only 1 user?

[daxxi13]

Did you tried --ignore-accounts "user1 user2 user3" ?

[skinnyzaz]

not yet but I will try it once I get a chance, I am now getting a plex database not equal error and am not sure how to fix it. Both plex servers are running the same version but I am still getting the error.

version db1: 20190316132700 db2: 20190528190600
Versions of plex databases not equal

[daxxi13]

Are you sure about running the same version on these plex servers ? maybe you tried a new beta in one of them then revert ?

You can use option --nocomparedb "true" to ignore this verification.

[skinnyzaz]

to fix this I had to install one of the servers at a lower version that I had the other server at then upgrade it again to the current version which the other server was at. I think it was because one of the servers skipped an update.

[daxxi13]

good to know
Thanks

[AllofTheThangz]

Need to set this to closed.