# Error when I send a message in chat \[downgraded to Stable from 3.1.0beta4\]

**URL:** https://meta.discourse.org/t/error-when-i-send-a-message-in-chat-downgraded-to-stable-from-3-1-0beta4/267780
**Category:** Self-hosting
**Tags:** unsupported-install
**Created:** [June 9, 2023, 10:53am UTC](https://meta.discourse.org/t/error-when-i-send-a-message-in-chat-downgraded-to-stable-from-3-1-0beta4/267780 "2023-06-09T10:53:28Z")
**Posts on this page:** 17
**Page:** 1

<div class="post-metadata">

### Author: ![FrancescoM](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/francescom/32/387072_2.png) [@FrancescoM](https://meta.discourse.org/u/FrancescoM)
#### Post date: [June 9, 2023, 10:53am UTC](https://meta.discourse.org/t/error-when-i-send-a-message-in-chat-downgraded-to-stable-from-3-1-0beta4/267780/1 "2023-06-09T10:53:28Z")

</div>

Hi, a few days ago I changed my version of Discourse from 3.1.0.beta4 to 3.0.3 due to theme installation issues.

Now when I send a message in chat I get this error:

> _ERROR: relation “chat\_uploads” does not exist LINE 1: SELECT “uploads”. FROM “uploads” INNER JOIN “chat\_uploads” …_\* ^

The website link is: [https://oii.francescomancuso.it/forum/](https://oii.francescomancuso.it/forum/)

How can I fix it? Thank you

---

<div class="post-metadata">

### Author: ![Cosmoss](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/cosmoss/32/310491_2.png) [@Cosmoss](https://meta.discourse.org/u/Cosmoss)
#### Post date: [June 9, 2023, 11:16am UTC](https://meta.discourse.org/t/error-when-i-send-a-message-in-chat-downgraded-to-stable-from-3-1-0beta4/267780/2 "2023-06-09T11:16:08Z")

</div>

quick question, the forum is from discouse right?

---

<div class="post-metadata">

### Author: ![FrancescoM](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/francescom/32/387072_2.png) [@FrancescoM](https://meta.discourse.org/u/FrancescoM)
#### Post date: [June 9, 2023, 11:17am UTC](https://meta.discourse.org/t/error-when-i-send-a-message-in-chat-downgraded-to-stable-from-3-1-0beta4/267780/3 "2023-06-09T11:17:36Z")

</div>

Yes, is configured to run on the /forum/ subfolder

---

<div class="post-metadata">

### Author: ![JammyDodger](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/jammydodger/32/254611_2.png) [@JammyDodger](https://meta.discourse.org/u/JammyDodger)
#### Post date: [June 9, 2023, 11:41am UTC](https://meta.discourse.org/t/error-when-i-send-a-message-in-chat-downgraded-to-stable-from-3-1-0beta4/267780/4 "2023-06-09T11:41:04Z")

</div>

> [@FrancescoM](#):
>
> I changed my version of Discourse from 3.1.0.beta4 to 3.0.3

I’m afraid it’s not possible to downgrade.

---

<div class="post-metadata">

### Author: ![FrancescoM](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/francescom/32/387072_2.png) [@FrancescoM](https://meta.discourse.org/u/FrancescoM)
#### Post date: [June 9, 2023, 2:22pm UTC](https://meta.discourse.org/t/error-when-i-send-a-message-in-chat-downgraded-to-stable-from-3-1-0beta4/267780/5 "2023-06-09T14:22:32Z")

</div>

Hi, thanks for the reply.  
I didn’t downgrade exactly, I changed the version from beta to stable

---

<div class="post-metadata">

### Author: ![JammyDodger](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/jammydodger/32/254611_2.png) [@JammyDodger](https://meta.discourse.org/u/JammyDodger)
#### Post date: [June 9, 2023, 2:45pm UTC](https://meta.discourse.org/t/error-when-i-send-a-message-in-chat-downgraded-to-stable-from-3-1-0beta4/267780/6 "2023-06-09T14:45:39Z")

</div>

Unfortunately that is a downgrade. Changing from the `beta` or `tests-passed` \[1\] branches down to `stable` is not possible as there will be differences in your database that aren’t backwards compatible.

* * *

1. the default one

---

<div class="post-metadata">

### Author: ![FrancescoM](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/francescom/32/387072_2.png) [@FrancescoM](https://meta.discourse.org/u/FrancescoM)
#### Post date: [June 9, 2023, 2:47pm UTC](https://meta.discourse.org/t/error-when-i-send-a-message-in-chat-downgraded-to-stable-from-3-1-0beta4/267780/7 "2023-06-09T14:47:08Z")

</div>

Ok, thanks a lot for the reply  
So should I switch to the beta version to fix the problem?  
Or wait for the stable version?

Thanks for your help 😁

---

<div class="post-metadata">

### Author: ![JammyDodger](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/jammydodger/32/254611_2.png) [@JammyDodger](https://meta.discourse.org/u/JammyDodger)
#### Post date: [June 9, 2023, 3:10pm UTC](https://meta.discourse.org/t/error-when-i-send-a-message-in-chat-downgraded-to-stable-from-3-1-0beta4/267780/8 "2023-06-09T15:10:02Z")

</div>

A new Stable version is released about twice a year, so if you can hang on a couple of months you can wait for the next Stable version to be released. 👍 I’m not 100% sure if that will automagically make everything good again as it might be a spikey update considering you have 3.1.0beta4 rather than 3.0.3 Stable, but I think it might be okay. 🤞

Or you can go back to using `tests-passed` in your `app.yml` and have an up-to-date version which should sort everything out. Just to check, is this a [standard install](https://meta.discourse.org/t/142537?silent=true)?

---

<div class="post-metadata">

### Author: ![FrancescoM](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/francescom/32/387072_2.png) [@FrancescoM](https://meta.discourse.org/u/FrancescoM)
#### Post date: [June 9, 2023, 3:15pm UTC](https://meta.discourse.org/t/error-when-i-send-a-message-in-chat-downgraded-to-stable-from-3-1-0beta4/267780/9 "2023-06-09T15:15:50Z")

</div>

Hi, thanks for the reply.  
Yes it is, but I followed a guide here on the forum to make Discourse accessible via the /forum/ subfolder

Initially I had installed 3.1.0.beta4 but when I installed “Air Theme” or any other theme the site didn’t load the CSS stylesheets and the layout broke. 😓

After upgrading from beta to stable the theme didn’t conflict, but I lost some features 😔

---

<div class="post-metadata">

### Author: ![JammyDodger](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/jammydodger/32/254611_2.png) [@JammyDodger](https://meta.discourse.org/u/JammyDodger)
#### Post date: [June 9, 2023, 3:37pm UTC](https://meta.discourse.org/t/error-when-i-send-a-message-in-chat-downgraded-to-stable-from-3-1-0beta4/267780/10 "2023-06-09T15:37:09Z")

</div>

> [@FrancescoM](#):
>
> Yes it is, but I followed a guide here on the forum to make Discourse accessible via the /forum/ subfolder

Ah yes, you did say earlier on. The subfolder setup is an advanced one, and is not for the fainthearted. If you want an easy life you should consider the regular subdomain version.

---

<div class="post-metadata">

### Author: ![FrancescoM](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/francescom/32/387072_2.png) [@FrancescoM](https://meta.discourse.org/u/FrancescoM)
#### Post date: [June 9, 2023, 3:39pm UTC](https://meta.discourse.org/t/error-when-i-send-a-message-in-chat-downgraded-to-stable-from-3-1-0beta4/267780/11 "2023-06-09T15:39:30Z")

</div>

Hi, thanks for your reply.  
It is a temporary solution while waiting to buy a new domain

Also, following the steps seems to be working fine, including other sites installed on the server using nginx 😁

---

<div class="post-metadata">

### Author: ![merefield](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/merefield/32/176214_2.png) [@merefield](https://meta.discourse.org/u/merefield)
#### Post date: [June 9, 2023, 5:36pm UTC](https://meta.discourse.org/t/error-when-i-send-a-message-in-chat-downgraded-to-stable-from-3-1-0beta4/267780/12 "2023-06-09T17:36:53Z")

</div>

> [@FrancescoM](#):
>
> while waiting to buy a new domain

You can’t use a subdomain? I’d argue that’s less confusing for users usually, e.g.:

`community.acme.com`

---

<div class="post-metadata">

### Author: ![FrancescoM](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/francescom/32/387072_2.png) [@FrancescoM](https://meta.discourse.org/u/FrancescoM)
#### Post date: [June 9, 2023, 5:43pm UTC](https://meta.discourse.org/t/error-when-i-send-a-message-in-chat-downgraded-to-stable-from-3-1-0beta4/267780/13 "2023-06-09T17:43:07Z")

</div>

Hi, thanks for the reply. 😃  
Actually for this project I’m already using a subdomain: [https://oii.francescomancuso.it/](https://oii.francescomancuso.it/)

This includes a python application divided into 3 sections:  
/admin/  
/contest/  
/ranking/

The user who logs in in the /contest/ section can connect via SSO to the forum, which is located in /forum/

Could the fact that the site is reachable from a subfolder cause me compatibility problems, for example with the theme using the beta version?

Thank you

---

<div class="post-metadata">

### Author: ![Stephen](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/stephen/32/95011_2.png) [@Stephen](https://meta.discourse.org/u/Stephen)
#### Post date: [June 9, 2023, 6:02pm UTC](https://meta.discourse.org/t/error-when-i-send-a-message-in-chat-downgraded-to-stable-from-3-1-0beta4/267780/14 "2023-06-09T18:02:12Z")

</div>

There are no guarantees of compatibility with _anything_ when using subfolder. It’s an advanced installation and very little is tested against it.

You could use a different subdomain for your discourse installation. SSO will work between subdomains.

The top of the subfolder guide contains this text:

> [@Serve Discourse from a subfolder (path prefix) instead of a subdomain](https://meta.discourse.org/t/serve-discourse-from-a-subfolder-path-prefix-instead-of-a-subdomain/30507/1):
>
> ### ⚠ Discourse Official Statement about Subfolder setup
> 
> We support subfolder setups for our hosted customers at the enterprise level and up. Due to heavy technical setup complexity we strongly recommend you do not use this setup unless you are very experienced in custom subfolder setups.
> 
> It is critical you have a deep understanding of
> 
> - NGINX setup in the Discourse Docker container
> - Secure original IP forwarding using custom headers in the proxy chain
> - Rate limiting in front proxy server
> 
> If this all sounds odd and strange to you **we strongly recommend** you avoid this setup.

You need to move back to tests-passed to be in a remotely supportable state, assuming your database isn’t just broken now. Rolling back a version is wholly unsupported.

---

<div class="post-metadata">

### Author: ![FrancescoM](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/francescom/32/387072_2.png) [@FrancescoM](https://meta.discourse.org/u/FrancescoM)
#### Post date: [June 9, 2023, 6:05pm UTC](https://meta.discourse.org/t/error-when-i-send-a-message-in-chat-downgraded-to-stable-from-3-1-0beta4/267780/15 "2023-06-09T18:05:35Z")

</div>

Hi, thanks for the reply.  
How can I transfer the site to the forum.francescomancuso.it subdomain?

Is there a special procedure or just change the settings of the app.yaml file and the nginx configuration?

Thanks for your help

---

<div class="post-metadata">

### Author: ![Stephen](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/stephen/32/95011_2.png) [@Stephen](https://meta.discourse.org/u/Stephen)
#### Post date: [June 9, 2023, 6:07pm UTC](https://meta.discourse.org/t/error-when-i-send-a-message-in-chat-downgraded-to-stable-from-3-1-0beta4/267780/16 "2023-06-09T18:07:06Z")

</div>

You need to revert [the changes you made for subfolder](https://meta.discourse.org/t/serve-discourse-from-a-subfolder-path-prefix-instead-of-a-subdomain/30507), and [change the domain name](https://meta.discourse.org/t/change-the-domain-name-or-rename-your-discourse/16098) on your install once the new subdomain is in DNS.

Hopefully you have a backup from before you attempted to downgrade - take another backup before you attempt the above.

Then you’ll need to reestablish SSO.

---

<div class="post-metadata">

### Author: ![FrancescoM](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/francescom/32/387072_2.png) [@FrancescoM](https://meta.discourse.org/u/FrancescoM)
#### Post date: [June 9, 2023, 6:42pm UTC](https://meta.discourse.org/t/error-when-i-send-a-message-in-chat-downgraded-to-stable-from-3-1-0beta4/267780/17 "2023-06-09T18:42:35Z")

</div>

Hi, thanks again for your reply.  
I will try to transfer the forum.
