# Unspecified "Error" When Updating Row from Action to PostgreSQL DB, Working in Builder not in Production
**URL:** https://community.glideapps.com/t/unspecified-error-when-updating-row-from-action-to-postgresql-db-working-in-builder-not-in-production/69919
**Category:** Ask for Help
**Created:** [January 23, 2024, 10:18pm UTC](https://community.glideapps.com/t/unspecified-error-when-updating-row-from-action-to-postgresql-db-working-in-builder-not-in-production/69919 "2024-01-23T22:18:15Z")
**Posts on this page:** 20
**Page:** 1
### Author:  [@Maximilian\_Philip](https://community.glideapps.com/u/Maximilian_Philip)
#### Post date: [January 23, 2024, 10:18pm UTC](https://community.glideapps.com/t/unspecified-error-when-updating-row-from-action-to-postgresql-db-working-in-builder-not-in-production/69919/1 "2024-01-23T22:18:15Z")
Hello Everyone!
New to Glide but experience with no code tools like it. I am working on a project where with a button I am updating one of the columns in a row. The column is named ‘case status’ when the button is clicked the status is changed to ‘Open’
Here is my action:
Currently the button is in a button block but I have tried out of the block and am experiencing the same issue.
The data source is NOT a Glide table but a PostgreSQL database. In the editor the button works without issue but in the published application I am getting an error message with no explanation or idea of how to figure out what the error actually is. Here is what the error message looks like:
Big thanks to everyone in advance!
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [January 24, 2024, 12:26am UTC](https://community.glideapps.com/t/unspecified-error-when-updating-row-from-action-to-postgresql-db-working-in-builder-not-in-production/69919/2 "2024-01-24T00:26:32Z")
Not sure why this would happen. Is your SQL table a read-and-write table, or a query table?
---
### Author:  [@Maximilian\_Philip](https://community.glideapps.com/u/Maximilian_Philip)
#### Post date: [January 24, 2024, 1:17am UTC](https://community.glideapps.com/t/unspecified-error-when-updating-row-from-action-to-postgresql-db-working-in-builder-not-in-production/69919/3 "2024-01-24T01:17:18Z")
Thanks for the reply @ThinhDinh !
This was my initial thought. I checked the permissions of the users at the database level and it has access to every function as shown below:
I understand if the permissions I would not be able to update rows in the builder either but in this case I can ONLY update the rows in the editor and not the shared app.
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [January 24, 2024, 1:24am UTC](https://community.glideapps.com/t/unspecified-error-when-updating-row-from-action-to-postgresql-db-working-in-builder-not-in-production/69919/4 "2024-01-24T01:24:57Z")
I was referring more to how you construct your table in Glide.
> **[SQL Server | Glide Docs](https://www.glideapps.com/docs/sql-server)**
>
> Connect to your SQL Server and build database-grade apps and tools.
You can check the two sections: “Creating a read-and-write table” and “Creating a read-only table with a query”.
---
### Author:  [@Maximilian\_Philip](https://community.glideapps.com/u/Maximilian_Philip)
#### Post date: [January 24, 2024, 1:36am UTC](https://community.glideapps.com/t/unspecified-error-when-updating-row-from-action-to-postgresql-db-working-in-builder-not-in-production/69919/5 "2024-01-24T01:36:34Z")
Oh yes! The table is a Read-and-Write table.
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [January 24, 2024, 1:43am UTC](https://community.glideapps.com/t/unspecified-error-when-updating-row-from-action-to-postgresql-db-working-in-builder-not-in-production/69919/6 "2024-01-24T01:43:24Z")
Then I’m not sure what can cause the error. Maybe you can try submitting a ticket.
> [@How to open a support ticket?](https://community.glideapps.com/t/how-to-open-a-support-ticket/59883/2):
>
> Please note: the option to create a support ticket is only available if your App is in a Pro, Business or Enterprise Team. If you need help with a Billing Issue (on any plan), you should open a Billing Enquiry via the [Glide Support Page](https://www.glideapps.com/support). To create a Support Ticket: Open the App that is giving you problems, and go to Settings → Contact Support: Glide will prompt you to create a support link for your App. Click on Create Link:
---
### Author:  [@Maximilian\_Philip](https://community.glideapps.com/u/Maximilian_Philip)
#### Post date: [January 24, 2024, 1:55am UTC](https://community.glideapps.com/t/unspecified-error-when-updating-row-from-action-to-postgresql-db-working-in-builder-not-in-production/69919/7 "2024-01-24T01:55:23Z")
Thank you again!
Submitted a ticket yesterday, waiting to hear back. Did it through the portal! It’s a business team.
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [January 24, 2024, 1:58am UTC](https://community.glideapps.com/t/unspecified-error-when-updating-row-from-action-to-postgresql-db-working-in-builder-not-in-production/69919/8 "2024-01-24T01:58:14Z")
Please report back here if you hear anything from them. Thank you!
---
### Author:  [@Maximilian\_Philip](https://community.glideapps.com/u/Maximilian_Philip)
#### Post date: [January 24, 2024, 7:15pm UTC](https://community.glideapps.com/t/unspecified-error-when-updating-row-from-action-to-postgresql-db-working-in-builder-not-in-production/69919/9 "2024-01-24T19:15:21Z")
If anyone in the community has a line on the Glide support team please let me know.
If the platform can not properly support DB connections I would like to know this before it’s too late into my billing cycle for the Business plan.
Thanks!
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [January 25, 2024, 12:02am UTC](https://community.glideapps.com/t/unspecified-error-when-updating-row-from-action-to-postgresql-db-working-in-builder-not-in-production/69919/10 "2024-01-25T00:02:45Z")
@NoCodeAndy can you check this case? Thank you.
---
### Author:  [@Chase3](https://community.glideapps.com/u/Chase3)
#### Post date: [January 25, 2024, 2:13am UTC](https://community.glideapps.com/t/unspecified-error-when-updating-row-from-action-to-postgresql-db-working-in-builder-not-in-production/69919/11 "2024-01-25T02:13:52Z")
I’m having a similar experience. I can’t add a row manually from the data editor and I can’t add a row from an action.
---
### Author:  [@Maximilian\_Philip](https://community.glideapps.com/u/Maximilian_Philip)
#### Post date: [January 25, 2024, 2:27am UTC](https://community.glideapps.com/t/unspecified-error-when-updating-row-from-action-to-postgresql-db-working-in-builder-not-in-production/69919/12 "2024-01-25T02:27:55Z")
This certainly seems like a glitch or bug.
I spun up a different DB and connected it and had the same result. I also know that there is no issue with permissions on the DB side because I can perform all DB activities from other tools.
Did you reach out to support, if yes, any luck?
I will keep this thread posted for updates if i don’t cancel the membership and move to Retool…
It seems that support just isn’t really there.
---
### Author:  [@david](https://community.glideapps.com/u/david)
#### Post date: [January 25, 2024, 3:08am UTC](https://community.glideapps.com/t/unspecified-error-when-updating-row-from-action-to-postgresql-db-working-in-builder-not-in-production/69919/13 "2024-01-25T03:08:28Z")
I’ve raised this with support.
---
### Author:  [@Chase3](https://community.glideapps.com/u/Chase3)
#### Post date: [January 25, 2024, 9:10pm UTC](https://community.glideapps.com/t/unspecified-error-when-updating-row-from-action-to-postgresql-db-working-in-builder-not-in-production/69919/14 "2024-01-25T21:10:18Z")
Support contacted me this morning. Still waiting for a solution. Will keep you updated.
---
### Author:  [@Maximilian\_Philip](https://community.glideapps.com/u/Maximilian_Philip)
#### Post date: [January 25, 2024, 10:08pm UTC](https://community.glideapps.com/t/unspecified-error-when-updating-row-from-action-to-postgresql-db-working-in-builder-not-in-production/69919/15 "2024-01-25T22:08:08Z")
Support reached out to also asking questions that were clearly stated in the initial support request. Followed up and no answer since 7:03 AM.
Will keep this thread updated on the resolution if any.
---
### Author:  [@Chase3](https://community.glideapps.com/u/Chase3)
#### Post date: [January 26, 2024, 3:48pm UTC](https://community.glideapps.com/t/unspecified-error-when-updating-row-from-action-to-postgresql-db-working-in-builder-not-in-production/69919/16 "2024-01-26T15:48:34Z")
I’ve had similar experience - Followed up again via email.
---
### Author:  [@Chase3](https://community.glideapps.com/u/Chase3)
#### Post date: [January 29, 2024, 4:26pm UTC](https://community.glideapps.com/t/unspecified-error-when-updating-row-from-action-to-postgresql-db-working-in-builder-not-in-production/69919/17 "2024-01-29T16:26:19Z")
@david can we get someone on support to update us today?
---
### Author:  [@david](https://community.glideapps.com/u/david)
#### Post date: [January 29, 2024, 6:04pm UTC](https://community.glideapps.com/t/unspecified-error-when-updating-row-from-action-to-postgresql-db-working-in-builder-not-in-production/69919/18 "2024-01-29T18:04:58Z")
I’ve raised it with support again.
---
### Author:  [@Marcel\_at\_Glide](https://community.glideapps.com/u/Marcel_at_Glide)
#### Post date: [January 29, 2024, 7:48pm UTC](https://community.glideapps.com/t/unspecified-error-when-updating-row-from-action-to-postgresql-db-working-in-builder-not-in-production/69919/19 "2024-01-29T19:48:07Z")
Hey folks,
Support is looking into these issues and will follow up with each of you individually.
Thanks for your patience.
---
### Author:  [@system](https://community.glideapps.com/u/system)
#### Post date: [February 5, 2024, 7:49pm UTC](https://community.glideapps.com/t/unspecified-error-when-updating-row-from-action-to-postgresql-db-working-in-builder-not-in-production/69919/20 "2024-02-05T19:49:07Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.