Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[Bug]: Clone Environment / Project causes SQLSTATE[42703] error #4592

Closed
janviehweger opened this issue Dec 15, 2024 · 3 comments · Fixed by #4598
Closed

[Bug]: Clone Environment / Project causes SQLSTATE[42703] error #4592

janviehweger opened this issue Dec 15, 2024 · 3 comments · Fixed by #4598

Comments

@janviehweger
Copy link

Error Message and Logs

While trying to clone a fully setup & working environment ("stage") to another environment ("dev") via Clone to a new Environment i get this SQL Error:

SQLSTATE[42703]: Undefined column: 7 ERROR:  column "additional_servers_count" of relation "applications" does not exist
LINE 1: ..., "last_online_at", "custom_nginx_configuration", "additiona...
                                                             ^ (Connection: pgsql, SQL: insert into "applications" ("repository_project_id", "uuid", "name", "fqdn", "config_hash", "git_repository", "git_branch", "git_commit_sha", "git_full_url", "docker_registry_image_name", "docker_registry_image_tag", "build_pack", "static_image", "install_command", "build_command", "start_command", "ports_exposes", "ports_mappings", "base_directory", "publish_directory", "health_check_path", "health_check_port", "health_check_host", "health_check_method", "health_check_return_code", "health_check_scheme", "health_check_response_text", "health_check_interval", "health_check_timeout", "health_check_retries", "health_check_start_period", "limits_memory", "limits_memory_swap", "limits_memory_swappiness", "limits_memory_reservation", "limits_cpus", "limits_cpuset", "limits_cpu_shares", "status", "preview_url_template", "destination_type", "destination_id", "source_type", "source_id", "private_key_id", "environment_id", "description", "dockerfile", "health_check_enabled", "dockerfile_location", "custom_labels", "dockerfile_target_build", "manual_webhook_secret_github", "manual_webhook_secret_gitlab", "docker_compose_location", "docker_compose", "docker_compose_raw", "docker_compose_domains", "deleted_at", "docker_compose_custom_start_command", "docker_compose_custom_build_command", "swarm_replicas", "swarm_placement_constraints", "manual_webhook_secret_bitbucket", "custom_docker_run_options", "post_deployment_command", "post_deployment_command_container", "pre_deployment_command", "pre_deployment_command_container", "watch_paths", "custom_healthcheck_found", "manual_webhook_secret_gitea", "redirect", "compose_parsing_version", "last_online_at", "custom_nginx_configuration", "additional_servers_count", "additional_networks_count", "updated_at", "created_at") values (....) returning "id")

As a result, the dev environment has been created but is completely empty (no resources). The source environment is setup on another ssh server. The cloned environment was cloned to the same server as the stage

The same error happens, when trying to Clone to a new Project

Steps to Reproduce

  1. select a Projects
  2. select a project
  3. select Clone
  4. choose a Server from the list
  5. select Clone to a new Project or Clone to a new Environment

Example Repository URL

No response

Coolify Version

v4.0.0-beta.379

Are you using Coolify Cloud?

No (self-hosted)

Operating System and Version (self-hosted)

Ubuntu 24.04.1

Additional Information

No response

@janviehweger janviehweger added 🐛 Bug Reported issues that need to be reproduced by the team. 🔍 Triage Issues that need assessment and prioritization. labels Dec 15, 2024
@jiaweing
Copy link

I'm having the same issue

@brunofuentes
Copy link

same issue here!

@surajtiwari06
Copy link

The same issue occurs.

@peaklabs-dev peaklabs-dev self-assigned this Jan 7, 2025
@peaklabs-dev peaklabs-dev added 🐞 Confirmed Bug Verified issues that have been reproduced by the team. and removed 🔍 Triage Issues that need assessment and prioritization. labels Jan 7, 2025
@peaklabs-dev peaklabs-dev marked this as a duplicate of #4572 Jan 9, 2025
@peaklabs-dev peaklabs-dev added this to the v4.0.0 Stable Release milestone Jan 9, 2025
@github-actions github-actions bot removed 🐛 Bug Reported issues that need to be reproduced by the team. 🐞 Confirmed Bug Verified issues that have been reproduced by the team. labels Jan 14, 2025
@andrasbacsai andrasbacsai marked this as not a duplicate of #4572 Jan 17, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

Successfully merging a pull request may close this issue.

5 participants