I’m trying multisite, I have installed the second instance and it works like a charm. But now I just can’t rebuild. The logs shows: warning " > babel-plugin-debug-macros@0.4.0-pre1" has unmet peer dependency "@babel/core@^7.0.0". warning "workspace-aggregator-ffab61d1-8b70-4cda-8f38-dde575adc062 > …

Have you installed Discourse Chatbot :robot: (supporting ChatGPT) ?

Yep and tried to uninstall then (because I saw I can’t test plugins in multisite without picking them by hand).

That error is coming from it, you will need to manually fix the database record and remove the duplicates even after uninstalling a plugin as what it adds to a database is permanent.

Thanks. Can you please confirm if that’s what I’m looking for? discourse=# \d category_users Table "public.category_users" Column | Type | Collation | Nullable | Default -------------…

Hmmm, presumably dozens of installs and no issues of this kind that I’m aware of. What’s the specific problem here? The fixtures script seeds the bot user (so the admin doesn’t need to hit the rails console) and that may fail if attempted twice but there is a check. I’ll check if the check is bom…

You should NOT drop the index! You just need to delete the duplicate record. Find the second record with user_id= -4 and category_id 9 and delete it using it’s id This is a risky operation so first check with: SELECT FROM category_users WHERE id = <the second id>; to ensure it just brings bac…

Just to add I don’t think you need to remove the plugin here once this is resolved but I’m very curious why this scenario arose in the first place as had no other reports?

Thanks Robert, I asked because clearly I’m not a DB guy and I have backups BTW but it’s always better to do not deliberately the wrong :smiling_face_with_sunglasses: The bot is not modified by me but I’m using default categories on every group and it seems to breaks your implementation. There are …

Ok so maybe not entirely my doing :sweat_smile:

How to check what prevents rake migrate?

Support Self-hosting

merefield (Robert) March 14, 2023, 2:15pm 10

Ok so maybe not entirely my doing

Topic		Replies	Views
Migration from discourse v2.8.13 (on Ubuntu 20.04.6 LTS) to latest Self-hosting	3	865	August 15, 2023
Upgrade failed: ERROR: relation "idx_regular_post_search_data" already exists Self-hosting	2	752	August 21, 2020
Upgrade fails while migrating Self-hosting	4	963	July 11, 2019
Upgrade failed with "duplicate key value violates unique constraint" error Self-hosting	17	2701	February 29, 2020
Update failed - PG::UniqueViolation: ERROR Self-hosting	7	941	December 21, 2018

How to check what prevents rake migrate?

Related topics