search

vitodeploy / vito

The Ultimate Server Management Tool
https://vitodeploy.com
GNU Affero General Public License v3.0
1.24k stars 190 forks source link

[Vito v2.x] Connect to a Source Control Failed: `SQLSTATE[22P02]: Invalid text representation ...` #314

Closed joglomedia closed 1 month ago

joglomedia commented 1 month ago

Describe the bug An error occurred while connecting to the Source Control provider due to a SQL issue.

SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for type json DETAIL:

To Reproduce Steps to reproduce the behavior:

  1. Go to 'Source Controls' menu
  2. Click on 'Connect' button
  3. Select the provider 'Github'
  4. Enter your Name and API Key
  5. Click on 'Connect'
  6. See the error

Expected behavior Successfully connect to source control and save the data to table.

Screenshots image

Additional context It appears there's a data type mismatch. The provider_data column is defined as a JSON type, but the stored data is actually an encrypted:array represented as a string.

saeedvaziry commented 1 month ago

Cannot reproduce the issue.

saeedvaziry commented 1 month ago

are you using Postgresql as VitoDeploy's database?

joglomedia commented 1 month ago

are you using Postgresql as VitoDeploy's database?

Yes, I am using PostgreSQL 16

saeedvaziry commented 1 month ago

Vito itself only supports SQLite as database. any other database usage is not supported and issues will not be fixed.