Get Error Oops The software powering this discussion forum encountered an unexpected problem after upgrade

thaidb · July 11, 2024, 6:05am

I get this message after upgrade via command .launcher rebuild app :

Oops
The software powering this discussion forum encountered an unexpected problem. We apologize for the inconvenience.

Detailed information about the error was logged, and an automatic notification generated. We’ll take a look at it.

No further action is necessary. However, if the error condition persists, you can provide additional detail, including steps to reproduce the error, by posting a discussion topic in the site’s feedback category.

I don’t get log with link Sitetor.com/logs. This is 404 error page normal.
Access safe mode page Ok, but not action when choice:

Disable themes and theme components
Disable unofficial client-side plugin customizations
Disable all client-side plugin customizations

I put ## before each line get plugin in app.yml file . Only for back Docker manager plugin.

And run command launcher Rebuild app.
But not effect.
I restart my Vultr server after 1 hours But unstill get same Message OPS.

JammyDodger · July 11, 2024, 6:21am

Hmm. This is a tricky one. There’s not a lot to go on with the error in the browser console.

I’m wondering if you can’t see the /logs because you’re not logged in. It may be possible to use the admin login page to bypass whatever is going on and get access to the logs, if you could give that a try (/u/admin-login).

thaidb · July 11, 2024, 6:40am

I input my email admin and get link login session in email, but when follow that link i meet back That Message again:

Ops
…
…

JammyDodger · July 11, 2024, 6:44am

That was a bit of a long shot.

It is unusual that commenting out the plugins doesn’t help. When you rebuilt afterwards, was the rebuild successful?

thaidb · July 11, 2024, 6:46am

Tks, Success.
Yesterday, i rebuild app OK, my forum OK. Later i get noticefication Updrade in Admin page, I Upgrade via website. Later i get message “Ops… …”
So i rebuild with via commandline again. And error to now.

Here is my Logs in page Log

CSP Violation: 'https://sitetor.com/assets/plugins/footnote-79e2a367b53b791240c3504826b87b2787c9d197d77cd422969d592aae9cf23b.js'
5 Jun 8:27 am
CSP Violation: 'https://sitetor.com/assets/plugins/discourse-lazy-videos-bdf1486acc96b228a2163490640a2bdc90f5e0a1bb1949335fd1fde2ad48795c.js'
5 Jun 8:27 am
CSP Violation: 'https://sitetor.com/theme-javascripts/a3636f1729d8c81989eb6665a5a33c82564fcec4.js?__ws=sitetor.com'
5 Jun 8:27 am
CSP Violation: 'https://sitetor.com/theme-javascripts/ca4f2222209109b7d767260935bb303d2b284516.js?__ws=sitetor.com'
5 Jun 8:27 am
Deprecation notice: `SiteSetting.min_trust_level_to_allow_ignore` has been deprecated. Please use `SiteSetting.ignore_allowed_groups` instead. (removal in Discourse 3.3) At /var/www/discourse/lib/gua
8 Jun 7:55 pm
15
CSP Violation: 'https://www.google-analytics.com'
10 Jun 9:32 pm
2
CSP Violation: 'https://sitetor.com/svg-sprite/sitetor.com/svg-93-10018d578f2d963b00e0465dc2060daae0e3a6cc.js'
16 Jun 3:24 pm
CSP Violation: 'https://sitetor.com/javascripts/magnific-popup/1.1.0/jquery.magnific-popup.min.js'
16 Jun 3:24 pm
6
CSP Violation: 'wasm-eval'
22 Jun 10:05 am
ActiveRecord::RecordNotUnique (PG::UniqueViolation: ERROR: duplicate key value violates unique constraint "index_topic_tags_on_topic_id_and_tag_id" DETAIL: Key (topic_id, tag_id)=(65105, 601) alread
30 Jun 11:47 am
Failed to handle exception in exception app middleware : ActiveRecord::RecordNotUnique : PG::UniqueViolation: ERROR: duplicate key value violates unique constraint "index_topic_tags_on_topic_id_and_t
30 Jun 11:47 am
10
NoMethodError (undefined method `scan' for {:one=>"Categories (%{count} more)…", :other=>"Categories (%{count} more)…"}:Hash) lib/i18n/i18n_interpolation_keys_finder.rb:6:in `find' app/controllers/adm
30 Jun 9:19 pm
24
CSP Violation: 'eval' () => { utils.preloadCache() }
1 Jul 11:34 pm
21
NoMethodError (undefined method `slug_path' for nil:NilClass) app/models/category.rb:1103:in `slug_path' app/models/category.rb:945:in `block in url' lib/distributed_cache.rb:20:in `defer_get_set' app
4 Jul 9:59 am
3
MaxMindDB (/var/www/discourse/vendor/data/GeoLite2-City.mmdb) could not be found: No such file or directory @ rb_sysopen - /var/www/discourse/vendor/data/GeoLite2-City.mmdb
4 Jul 3:23 pm
3
MaxMindDB (/var/www/discourse/vendor/data/GeoLite2-ASN.mmdb) could not be found: No such file or directory @ rb_sysopen - /var/www/discourse/vendor/data/GeoLite2-ASN.mmdb
4 Jul 3:23 pm
3
MaxMindDB (/var/www/discourse/vendor/data/GeoLite2-City.mmdb) could not be found: No such file or directory @ rb_sysopen - /var/www/discourse/vendor/data/GeoLite2-City.mmdb
5 Jul 4:17 pm
3
MaxMindDB (/var/www/discourse/vendor/data/GeoLite2-ASN.mmdb) could not be found: No such file or directory @ rb_sysopen - /var/www/discourse/vendor/data/GeoLite2-ASN.mmdb
5 Jul 4:17 pm
Deprecation notice: `AdminDashboardData#add_problem_check` is deprecated. Implement a class that inherits `ProblemCheck` instead. (removal in Discourse 3.3) At /var/www/discourse/plugins/discourse-si
6 Jul 1:00 am
20
CSP Violation: 'https://sitetor.com/assets/start-discourse-c524a8995f2f0cbcea43353efe8e8f269da821ea97c21ef0f04df5fcd916170a.js'
Su 4:33 pm
20
CSP Violation: 'https://sitetor.com/assets/browser-update-9070f07226d022f68c06506e046ae33f8fe725302ff53955cd3d483f2fc47ff6.js'
Su 4:33 pm
CSP Violation: 'https://sitetor.com/svg-sprite/sitetor.com/svg-87-ca7d0fff2c92f16b8b655f85bb0a36f4c6eb98df.js'
Su 4:33 pm
CSP Violation: 'https://sitetor.com/uploads/default/original/2X/d/d8ce366bd7aad8f9fc7b26b08aecc855dd6d425c.js'
Su 4:33 pm
3
CSP Violation: 'https://pagead2.googlesyndication.com'
Su 4:33 pm
23
ActionView::Template::Error (undefined method `slug_path' for nil:NilClass) app/models/category.rb:1103:in `slug_path' app/models/category.rb:945:in `block in url' lib/distributed_cache.rb:20:in `defe
Mo 6:50 pm
69
RequestTracker.get_data failed : Encoding::UndefinedConversionError : "\xA3" from ASCII-8BIT to UTF-8
Tu 2:15 am
181
RequestTracker.get_data failed : Encoding::UndefinedConversionError : "\xA1" from ASCII-8BIT to UTF-8
Tu 3:52 pm
8
Deprecation notice: `UsersController#modify_user_params` method is deprecated. Please use the `users_controller_update_user_params` modifier instead. (deprecated since Discourse 3.1.0.beta4) (removal
Tu 11:18 pm
Deprecation notice: `AdminDashboardData#add_problem_check` is deprecated. Implement a class that inherits `ProblemCheck` instead. (removal in Discourse 3.3) At /var/www/discourse/plugins/discourse-si
We 2:46 pm
Corrupt cache... skipping entry for key _CACHE:sitemap/1/50000 : ArgumentError : dump format error (user class)
We 6:39 pm
MaxMindDB (/var/www/discourse/vendor/data/GeoLite2-City.mmdb) could not be found: No such file or directory @ rb_sysopen - /var/www/discourse/vendor/data/GeoLite2-City.mmdb
We 10:51 pm
MaxMindDB (/var/www/discourse/vendor/data/GeoLite2-ASN.mmdb) could not be found: No such file or directory @ rb_sysopen - /var/www/discourse/vendor/data/GeoLite2-ASN.mmdb
We 10:51 pm
Deprecation notice: `AdminDashboardData#add_problem_check` is deprecated. Implement a class that inherits `ProblemCheck` instead. (removal in Discourse 3.3) At /var/www/discourse/plugins/discourse-si
5:40 am
ActionView::Template::Error ({:cause=>#<MiniRacer::RuntimeError: Error: The plural case one is not valid in this locale at line 4 col 15:>}) lib/js_locale_helper.rb:153:in `output_MF' app/controllers/
5:57 am
Failed to handle exception in exception app middleware : ActionView::Template::Error : {:cause=>#<MiniRacer::RuntimeError: Error: The plural case one is not valid in this locale at line 4 col 15:>}
5:57 am
Deprecation notice: `AdminDashboardData#add_problem_check` is deprecated. Implement a class that inherits `ProblemCheck` instead. (removal in Discourse 3.3) At /var/www/discourse/plugins/discourse-si
8:49 am
ActionView::Template::Error ({:cause=>#<MiniRacer::RuntimeError: Error: The plural case one is not valid in this locale at line 4 col 15:>}) lib/js_locale_helper.rb:153:in `output_MF' app/controllers/
9:03 am
ActionView::Template::Error ({:cause=>#<MiniRacer::RuntimeError: Error: The plural case one is not valid in this locale at line 4 col 15:>}) lib/js_locale_helper.rb:153:in `output_MF' app/controllers/
9:18 am
Deprecation notice: `AdminDashboardData#add_problem_check` is deprecated. Implement a class that inherits `ProblemCheck` instead. (removal in Discourse 3.3) At /var/www/discourse/plugins/discourse-si
10:11 am
ActionView::Template::Error ({:cause=>#<MiniRacer::RuntimeError: Error: The plural case one is not valid in this locale at line 4 col 15:>}) lib/js_locale_helper.rb:153:in `output_MF' app/controllers/
10:48 am
3
NoMethodError (undefined method `slug_path' for nil) app/models/category.rb:1229:in `slug_path' app/models/category.rb:1069:in `block in url' lib/distributed_cache.rb:20:in `defer_get_set' app/models/
12:26 pm
ActionView::Template::Error ({:cause=>#<MiniRacer::RuntimeError: Error: The plural case one is not valid in this locale at line 4 col 15:>}) lib/js_locale_helper.rb:153:in `output_MF' app/controllers/
1:21 pm
10
ActionView::Template::Error ({:cause=>#<MiniRacer::RuntimeError: Error: The plural case one is not valid in this locale at line 4 col 15:>}) lib/js_locale_helper.rb:153:in `output_MF' app/controllers/
1:46 pm
16
ActionView::Template::Error ({:cause=>#<MiniRacer::RuntimeError: Error: The plural case one is not valid in this locale at line 4 col 15:>}) lib/js_locale_helper.rb:153:in `output_MF' app/controllers/
1:48 pm
59
ActionView::Template::Error ({:cause=>#<MiniRacer::RuntimeError: Error: The plural case one is not valid in this locale at line 4 col 15:>}) lib/js_locale_helper.rb:153:in `output_MF' app/controllers/
1:52 pm
47
ActionView::Template::Error ({:cause=>#<MiniRacer::RuntimeError: Error: The plural case one is not valid in this locale at line 4 col 15:>}) lib/js_locale_helper.rb:153:in `output_MF' app/controllers/
2:10 pm
ActionView::Template::Error ({:cause=>#<MiniRacer::RuntimeError: Error: The plural case one is not valid in this locale at line 4 col 15:>}) lib/js_locale_helper.rb:153:in `output_MF' app/controllers/
2:23 pm
16
ActionView::Template::Error ({:cause=>#<MiniRacer::RuntimeError: Error: The plural case one is not valid in this locale at line 4 col 15:>}) lib/js_locale_helper.rb:153:in `output_MF' app/controllers/
2:24 pm
ActionView::Template::Error ({:cause=>#<MiniRacer::RuntimeError: Error: The plural case one is not valid in this locale at line 4 col 15:>}) lib/js_locale_helper.rb:153:in `output_MF' app/controllers/
2:25 pm
17
Failed to handle exception in exception app middleware : ActionView::Template::Error : {:cause=>#<MiniRacer::RuntimeError: Error: The plural case one is not valid in this locale at line 4 col 15:>}
2:25 pm

pfaffman · July 11, 2024, 9:53am

That ‘record not unique’ error suggests that you have a corrupt index. You’ll need to find the topics that define fixing that (mostly delete the duplicate tags).

Do you have tags in both upper and lower case, perchance? (like mytag and myTag)

thaidb · July 11, 2024, 11:23am

I remember not,
Is there any SSH command to list created tags?
However, even though I can’t access the homepage in the new tab, luckily my browser still retains the old tab before upgrading, and I can still load many new topics on the homepage.

pfaffman · July 11, 2024, 12:08pm

Can you navigate to the tags page?

But you’ll need to resolve your database problem by hand. It’ll be easiest to just delete the duplicate entries.

I think there are a couple of topics about doing that in some other cases.

I think you try to rebuild the index, find the thing that causes it to fail and then delete it and do that until it works.

thaidb · July 11, 2024, 12:21pm

I tried to access tag page but it didn’t work. This error occurred when I upgraded. Why does the forum still work normally without upgrading? How resolve your database problem by hand? I’m a normal user, not dev

pfaffman · July 11, 2024, 1:09pm

I don’t know. Perhaps something changed and now tags are case insensitive? Or maybe it’s a bug.

But this looks like it has to do with tags not being unique somehow:

thaidb:

ActiveRecord::RecordNotUnique (PG::UniqueViolation: ERROR: duplicate key value violates unique constraint "index_topic_tags_on_topic_id_and_tag_id" DETAIL: Key (topic_id, tag_id)=(65105, 601) alread

It’s not a task for a normal user.

thaidb · July 11, 2024, 2:28pm

And what about this error ActionView::Template::Error ({:cause=>#<MiniRacer::RuntimeError: Error: The plural case one is not valid in this locale at line 4 col 15:>) lib/js_locale_helper.rb:153:in output_MF’ app/controllers/`

Previously, I used Remove Dashes from Tag Names. Could that be the cause of duplicate tags?

I successfully accessed the tags page:

All tags are listed on the tags page, and I didn’t find any duplicate pairs.

View tag page detail

Tag

Sorted by: count name

Business

24h x 3

English Language

Cafe x 7

Gas Station x 1

Chain x 58

Food Store x 1

Telephone x 2

Game x 1

Entertainment x 6

Delivery x 1

Laundry x 1

Shoes x 3

Gym x 1

Wine Cellar x 1

Karaoke x 8

Optical Shop x 1

Restaurant x 10

Dental Clinic x 2

Bookstore x 2

Pharmacy x 3

Interior Design x 5

Notary Office

Clinic x 2

Recording Studio x 1

Pizza x 2

Eatery x 2

Drinking Spot x 3

Salon x 1

Sang x 1

Showroom x 10

Supermarket x 8

Spa x 3

Fashion x 11

Fast Food x 2

Internet Cafe x 1

Milk Tea x 1

Fruit x 1

Jewelry x 1

School x 2

Office x 18

Car x 1

Motorbike x 2

Cigar x 1

Property Type

Villa x 20

Apartment x 27

Serviced Apartment x 1

Condominium x 23

Land x 11

Duplex

Warehouse x 1

Street-side Kiosk

Mall

Shophouse Premises x 361

Penthouse

Room for Rent

Rooftop x 1

ShophouseViet x 3

Building x 3

Office x 18

Transaction Type

Sale x 47

For Sale x 32

For Rent x 413

Rent x 12942

Frontage (m)

10m Width x 632

11m Width x 539

12m Width x 553

13m Width x 396

14m Width x 403

15m Width x 504

16m Width x 332

17m Width x 158

18m Width x 262

19m Width x 38

20m Width x 445

3m Width x 988

4m Width x 1562

5m Width x 907

6m Width x 977

7m Width x 978

8m Width x 959

9m Width x 976

Purpose of Use

Investment x 1

Residential x 5

Business x 392

tickets_priority

tickets_reason

tickets_status

Ho Chi Minh City

Binh Chanh

Binh Tan x 1

Binh Thanh x 2

Can Gio x 1

Cu Chi x 1

Go Vap x 1

Hoc Mon x 1

Nha Be x 1

District 1 x 2

District 10 x 1

District 11 x 1

District 12 x 2

District 2 x 1

District 3 x 1

District 4 x 1

District 5 x 1

District 6 x 1

District 7 x 1

District 8 x 1

District 9 x 1

Phu Nhuan District x 1

Tan Binh

Tan Phu x 1

Thu Duc x 1

Transaction Status

Undetermined x 1

Completed x 2

In Progress x 1

Suspended x 1

Location

Alley/Lane x 8

Frontage x 12914

Internal x 1

Other Tags

3PN x 2

4 Floors x 1

Selling Land x 2

Selling House x 1

Binh Tri Dong A x 1

Opportunity x 2

With Video x 6

cv x 1

Red Book Updated x 2

Deposit Made x 1

Da Nang x 1

Empty Land x 1

Area 10x24m x 1

Area 17x31m x 1

Area 4x16m x 1

Area 4X17M x 1

Area 4x18 x 1

Area 4x20 x 1

Area 5x15m x 1

Area 5x19m x 1

Area 6x28 x 1

Area 7x21m x 1

Area 8x15m x 1

Area 8x20m x 1

Area 8x22m x 1

Area 8x26m x 1

Area 9x41m x 1

Land Area 105m2 x 1

Area: 10x7m x 1

Area: 6x17m x 1

Total Area 120m2

Total Area 2880m2 x 1

Usable Area 805m2 x 1

Project x 1

Flycam x 1

Price 100 billion x 1

Price 108 billion x 1

Price 110 billion x 1

Price 130 billion x 1

Price 150 billion x 3

Price 180 billion x 1

Price 200 billion x 1

Price 218 billion x 1

Price 220 billion x 1

Price 7 billion x 1

Land Price 350 million/m2 x 1

Rent Price 50 million x 1

Rent Price 50 million/month x 1

Price: 27 billion x 1

Price: 29 billion x 1

Price: 32 billion x 1

Price: 39 billion x 1

Structure 7 Floors x 1

Ground + 7 Floors x 1

Customer House for Sale x 1

No Rent x 2

Green Area x 1

Property Type x 2

Premises x 1

Beautiful Premises x 69

17m Frontage

4m Frontage x 1

26m Width x 1

29m Width x 1

Sale Suspended x 2

Rent Suspended x 1

House x 5

Ben Nghe House x 1

Townhouse x 5

VT House x 1

Segment 100-200 billion x 3

Segment 100-200 billion x 1

Segment 20-50 billion x 1

Segment 200-300 billion x 1

Segment 50-100 billion x 3

Segment Under 10 billion x 1

Ward 13 Phu Nhuan x 1

Ward 9 District 3

Ward Ben Nghe x 5

Ward Ben Thanh x 174

Ward Cau Kho x 1

Ward Cau Ong Lanh x 1

Ward Da Kao x 2

Ward Nguyen Thai Binh x 2

Ward Thao Dien x 3

Ward Vo Thi Sau x 2

Urban Residential Planning x 1

Transfer x 2

Tan Dinh x 1

TDT 62m2

Decor Design x 14

Subscription x 1

Office Building x 2

Ho Chi Minh City x 417

Ground + 2 Floors x 1

Jobs x 13

Villa x 1

vnBuildings x 4

Vo Van Kiet x 1

VP x 1

Price Reduced x 1

I see two similar tags: „Phân

Heliosurge · July 11, 2024, 10:34pm

As this is a #theme-component you can disable it in components tab. Not sure if it could cause the issue as these from my understanding are client side modifications. This component in particular is just altering appearance of tags. No harm though testing to rule it out.

Where your database is server side.

thaidb · July 12, 2024, 12:18am

Yeah! @Heliosurge I access to Setting page and turn off of all theme component and select default theme, And access Home page but not effect.

Heliosurge · July 12, 2024, 12:29am

If running in safe mode not working. Then you may need to consider posting in Marketplace if your not familiar/comfortable with the with rebuilding by hand.

I know by what @pfaffman said I would need to seek help I this situation.

thaidb · July 12, 2024, 1:08am

Hello, what Administrative Bulk Operations to i can delete (topic_id, tag_id)=(65105, 601) ?

thaidb · July 12, 2024, 11:17am

Thank you

thaidb · August 4, 2024, 9:16am

I created the topic Need to resolve my database problem by hand error with tags not being unique after upgrade forum And I have received support from @ itsbhanusharma but still can’t find the cause.

I restored the Vultr server that I backed up in April 2024. Then I restored the backed up data in the Dashboard .tar.gz file. But still got the same error as above. It seems that this backup (.tar.gz file) has the same error, although it was restored, the website cannot be accessed.

I have reused the Vultr server version 044/2024 and developed the content until now.

Today, I accessed admin/customize/site_texts/js.topic.read_more_MF?locale=en_GB

To translate the contents

topic remaining
or browse other topics in
view latest topics

{ HAS_UNREAD_AND_NEW, select,
  true {
    { UNREAD, plural,
         =0 {}
        one {There is <a href="{basePath}/unread"># unread</a>}
      other {There are <a href="{basePath}/unread"># unread</a>}
    }
    { NEW, plural,
         =0 {}
        one { and <a href="{basePath}/new"># new</a> topic remaining,}
      other { and <a href="{basePath}/new"># new</a> topics remaining,}
    }
  }
  false {
    { UNREAD, plural,
         =0 {}
        one {There is <a href="{basePath}/unread"># unread</a> topic remaining,}
      other {There are <a href="{basePath}/unread"># unread</a> topics remaining,}
    }
    { NEW, plural,
         =0 {}
        one {There is <a href="{basePath}/new"># new</a> topic remaining,}
      other {There are <a href="{basePath}/new"># new</a> topics remaining,}
    }
  }
  other {}
}
{ HAS_CATEGORY, select,
  true { or browse other topics in {categoryLink}}
  false { or <a href="{basePath}/latest">view latest topics</a>}
  other {}
}

With English it is Successful but with Vietnamese i get error message when saving from settings that:
Error: The plural case one is not valid in this locale at line 4 col 15:

and i find this error coincide with page Log:

Is there any correlation?

Moin · August 4, 2024, 9:32am

Have you read the topic on how those strings are translated?

Why do you customize the text on your forum? Is there a mistake in the translation or do you just prefer a different wording?

thaidb · August 4, 2024, 10:37am

Thank you so much for your tutorial, i read it and edited it as follows and it displayed sucessfull:

{ HAS_UNREAD_AND_NEW, select,
  true {
    { UNREAD, plural,
        =0 {}
        other {Có <a href="{basePath}/unread"># tin còn lại</a>}
      }
    { NEW, plural,
        =0 {}
        other { và <a href="{basePath}/new"># new</a> chưa đọc,}
      }
  }
  false {
    { UNREAD, plural,
        =0 {}
        other {Có <a href="{basePath}/unread"># tin còn lại</a> chưa đọc,}
      }
    { NEW, plural,
        =0 {}
        other {Có <a href="{basePath}/new"># tin mới</a> chưa đọc,}
      }
  }
  other {}
}
{ HAS_CATEGORY, select,
  true { hoặc xem tin tức khác trong {categoryLink}}
  false { hoặc <a href="{basePath}/latest">xem tin mới nhất</a>}
  other {}
}

Topic		Replies	Views
I could not edit tags for old topics Support	9	784	May 6, 2022
Internal Server Error on using some tags (ERROR: duplicate key value violates unique constraint "index_tags_on_name") Bug	19	3330	November 8, 2019
After updating to 2.4.0beta10 some topics from a specific category are not viewable Support	11	1125	February 11, 2020
Problems while updating from 3.0.0 to 3.0.1 Self-hosting	16	1267	June 14, 2023
Help! Upgrade led to complete fail Self-hosting	7	1396	March 9, 2021

Get Error Oops The software powering this discussion forum encountered an unexpected problem after upgrade

Tag

Location

Domains

Projects

Direction

Business

Property Type

Transaction Type

Frontage (m)

Purpose of Use

tickets_priority

tickets_reason

tickets_status

Ho Chi Minh City

Transaction Status

Location

Other Tags

Related topics