martialblog/docker-limesurvey

SQL error while saving questions

dom6770 opened this issue · 2 comments

I just set up limesurvey with this docker-compose.yaml:

version: '3'

services:
  limesurvey:
    image: docker.io/martialblog/limesurvey:6-apache
    container_name: limesurvey
    
    restart: unless-stopped
    depends_on:
      - postgres
    
    ports:
      - 7090:8080

    environment:
      - DB_TYPE=pgsql
      - DB_PORT=5432
      - DB_HOST=postgres
      - DB_PASSWORD=asdf
      - DB_NAME=limesurvey
      - DB_USERNAME=limesurvey
      - ADMIN_USER=Administrator
      - ADMIN_NAME=Administrator
      - ADMIN_PASSWORD=asdf
      - ADMIN_EMAIL=admin@sonn.intern
      - PUBLIC_URL=https://survey.example.org/

    volumes:
      - ./data:/var/www/html/upload/surveys

  postgres:
    image: docker.io/postgres:10-alpine
    container_name: limesurvey_postgres
    
    restart: unless-stopped

    environment:
      - POSTGRES_USER=limesurvey
      - POSTGRES_DB=limesurvey
      - POSTGRES_PASSWORD=asdf
    
    volumes:
      - ./postgres:/var/lib/postgresql/data

networks:
  limesurvey:
    name: limesurvey

Login in to the backend works fine, but when add a new question with an array and quick add subquestions and try to save that, the following error appears

CDbCommand failed to execute the SQL statement: SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for integer: "new64190" LINE 1: ...ELECT * FROM "lime_questions" "t" WHERE "t"."qid"='new64190'... ^

Hi, I think this might be this https://bugs.limesurvey.org/view.php?id=19351

The latest update should fix it. I just updated the tags and the images are on their way

Since it should be fixed with the latest LS version, I'll close this issues