There is step to upgrade citizenlab version maintaining the history of all projects and ideas?

Hello,

Is this option available in free CitizenLab version:

If this is not possible then how to enable: user_confirmation as probably this should be available in a free version as this module is listen in: "citizenlab.config.json"

Hello
After following the steps to deploy your documentation, I receive this error : ERR_SSL_PROTOCOL_ERROR

developers.citizenlab.co

Hello,

I'm trying to setup environment and deploy application like it was described here: https://developers.citizenlab.co/start-deployment on Ubuntu Server 22.04. All steps are going just fine, I get application up and running, can perform customization, etc. and all changes are being saved. Then after a machine reboot, every time when I try to save any change done using Admin Panel I receive a 500 Internal Server Error. App is available, I can navigate to the page and preview every content but not save anything.

All the docker componenets are up and running. If I repeat two steps form documentation, first executing docker-compose stop and then:

$ docker-compose run --rm web rake db:setup
$ docker-compose up -d

With .env option DISABLE_DATABASE_ENVIRONMENT_CHECK=1 a DB is being recreated, all content is being lost but again I can perform any required change in Admin Panel up to the next reboot.

The only action performed after machine reboot to start the app is docker-compose up -d. Is there anything missing in what I do, is it a bug or is it by design?

Hi! I am triyng to install citizenlab in a VM with ubuntu 20.04. I have suived the https://developers.citizenlab.co/start-deployment
and i have edited the env file with my data, but when i navigate i see only the welcome page of ruby on rails on port 4000...

Hi, log in pop up works fine but registration dose not display. The screen darkens as it does when you click "log in", but no fields or form visible.
During website homepage loading console list 1 error referring to route:

1. 404 https://wspoldecyduje.click/web_api/v1/users/me

When I click on "register" console lists 2 errors:

1. 404 https://wspoldecyduje.click/web_api/v1/users/custom_fields/schema
2. Uncaught TypeError: Cannot read properties of undefined (reading 'pl-PL')

Do you know what cause this?
Thanks

Bonjour, nous sommes une entreprise désireux d'utiliser la version opensource dans notre SI et nous aimerions savoir quels sont les contraintes d'exploitation de cette solution ?
Pouvons nous librement la modifier et l'exploiter à notre guise ?
Et aussi avez vous prévu quelque chose pour l'intégration SSO dans le code ?

Je vous remercie pour votre retour

When trying to delete a project and error occurs. Steps to reproduce:

1. Deploy the application as described in the deployment guide (having it with default settings).

2. Run the application as described in the deployment guide.

3. Navigate to Admin -> Settings -> Project and add a new project with Published status.

4. Deleting a project leads to an error like here:

An error is related to a Foreign Key settings in DB. Steps to reproduce:

1. Login to DB.

2. Find an ID of a project to delete.

3. Execute Delete for example: DELETE FROM "public"."projects" WHERE "id"='fa133ac8-71c1-4360-ae37-3730eae4c220';

4. Have foreign key constraint violation as below:

Executing ALTER TABLE projects_allowed_input_topics DROP CONSTRAINT fk_rails_91bda1f137 solves the deletion error on DB level but event without a foreign key constraint deleting from Web Interface does not work.

Hello,
I have an error during database initialization

Command:
docker-compose run --rm web rake db:create db:migrate db:seed

Error:
rake aborted!
ActiveModel::UnknownAttributeError: unknown attribute 'registration_completed_at' for User.

Thanks

👋 First of all: nice work! I like that you recently made the project open source and I hope you’ll get significant contributions from the community.

Opening this as an issue but it’s more a roadmap/feature request: are you planning to add a translation for it-IT soon?

I might take a stab at generating an automated translation from app/translations/en.json if you think it might be a good start.

Thank you!

You have not published a coordinated vulnerability disclosure policy.
How can I contact you regarding some potentially serious security issues I found?

Hello,

As written here I did an update to the newest possible version and having a clean install without the data I did encounter an issue. One cannot edit 'About' page after the update.

Steps to follow:

1. Clean install deployement as described in deployment guide.
2. Go to: Pages -> About -> Edit

3. Have an error:

Could you please fix it?

In a free version a problem occurrs when homepage_info_multiloc in app configurations table is set to any value. So if one provides a value in Homepage customizable section like here:

After a reboot editing stops. Steps to reproduce:

Deploy the application as described in the deployment guide (having it with default settings).

Run the application as described in the deployment guide.

Go to Admin Panel -> Settings -> General and make sure that default laguage was set (EN for this case).

Go to Admin Panel -> Settings -> Customize and apply a value for 'Homepage customizable section'

Reboot.

Go to Admin Panel -> Settings -> General

Now editing leads to a 500 Internal Server Error

Connect to DB and execute: UPDATE app_configurations SET homepage_info_multiloc = null

Navigate to Admin Panel -> Settings editing starts working again without any reboot.

Navigate to Admin Panel -> Settings -> General and try setting a value for 'Homepage customizable section' form.

Saving leads to a 500 Internal Server Error

Refresh the page, navigate to Home page and then navigate back to Admin Panel -> Settings -> Customize and try to change anything except 'Homepage customizable section'.

Admin Panel -> Settings editing works.

Adding Projects, Activities, Comments, etc. and editing them does not work.

Reboot.

Adding Projects, Activities, Comments, etc. starts working again.

Good day,
My deployed open-source platform does not conduct settings update properly. System notifies that something went wrong without details. It refers to Settings: general, style and registration. I can add geographic area or edit Terms & Conditions as well as I can add proposal without problem.
When I try to save new settings I have following answer from request:

PATCH https://wspoldecyduje.click/web_api/v1/app_configuration 422

{"errors":{"settings":[{"error":{"fragment":"#/","error":"AdditionalProperties","human_message":"The property '#/' contains additional properties [\"user_confirmation\"] outside of the schema when none are allowed in schema 21a6d023-6dc2-5182-a016-a0c94a55d452"}, ...

You can check it is live.

Do you have an idea what the reason is?
Thanks

postgresql folder not inastall in this folder.

give permission to folder of read and write

Log output & screenshots

here are the screen shot:

✔ Container citizenlab-docker_memcached_1 Recreated 1.4s
✔ Container citizenlab-docker_postgres_1 Recreated 0.3s
✔ Container cl-docker-back-rabbit Started 9.1s
✔ Container cl-docker-front Started 7.1s
✔ Container cl-docker-que Created 0.2s
✔ Container cl-docker-back-web Created 0.2s
✔ Container citizenlab-docker-caddy-1 Created 0.1s
✔ Container citizenlab-docker-memcached-1 Started 4.2s
⠹ Container citizenlab-docker-postgres-1 Starting 5.2s
Error response from daemon: error while creating mount source path '/var/www/html/citizenlab-docker/postgresql-data': mkdir /var/www: read-only file system

Hello,

I am running into a couple of problems regarding the map settings in the .env file. I have followed the instructions in the deployment guideline (inserted latitude/longitude and google maps api key) but the map does not adjust to said location, instead it positions itself in the middle of ocean, west of Africa. Furthermore, I am unable to submit an idea on a project after manually navigating to project location. After filling out the requirement for adding a new idea and hitting submit, the submit button gets a circular loading icon and just sits there indefinitely. Any help would be greatly appreciated. Also, is there any guide for utilizing different tile providers?

Edit: Just did another test and I am unable to submit an idea via the projects page as a regular user. However, I am able to submit a proposal as a regular user.

Hello,

I am a student who is interested in utilizing your open source platform in a research project and I am running into an error when running the following command:

$ docker-compose run --rm web rake db:create db:migrate db:seed

to "Initialize the database" as instructed in the deployment guide. I am not sure what the issue is, I have followed the instructions without any changes. Any help would be appreciated.

Here is the error message:

[2021-05-10T20:24:54.436732 #1] WARN -- #<Bunny::Session:0x55f68718afa0 guest@rabbitmq:5672, vhost=/, addresses=[rabbitmq:5672]>: Could not establish TCP connection to rabbitmq:5672: Connection refused - connect(2) for 172.18.0.4:5672
rake aborted!
ActiveRecord::StatementInvalid: PG::UndefinedTable: ERROR: relation "app_configurations" does not exist
LINE 1: SELECT "app_configurations".* FROM "app_configurations" ORDE...

I have configured the ID and the secret in my .env file, and set as true login_enabled, but i don't see the purpose of enter with facebook or google account

Hey everyone,

I was able to deploy the citizenlab platform to a domain but the settings for the admin user in the .env file

`# ***** USER *****

INITIAL_ADMIN_EMAIL=NA
INITIAL_ADMIN_PASSWORD=NA
INITIAL_ADMIN_FIRST_NAME=NA
INITIAL_ADMIN_LAST_NAME=NA`

does not work. It indicates that "The provided information is not correct. Click 'Forgot Password?' to reset your password." I am able to create an account as a regular user and it successfully logs in but the initial admin user settings in the .env file is not taking. Any help would be appreciated

edit: an attempt to reset the password prompts the following message as well We couldn't find an account linked to this email. You can try to sign up instead.