[Spip-maintainers] Bug#880881: spip: fails to create key word group, giving cryptic error messages

[Axel]

Package: spip
Version: 3.1.4-3~deb9u1
Severity: normal

Dear Maintainer,

When I try to create a group of key words, I can enter lots of text but when I finally
press the button, no new group is created, all entered text seems to have vanished, and
the screen is filled with error messages, most of which are in a language different from
the one I use:

- «Zugang gesperrt» (access blocked — Why? I am logged in and can edit everything else.)
- «Vous n'avez pas le droit d'accéder à la page groupe_mots.»
- «SQL-Fehler 1000 — errcode: 1000 : column "id_groupe_mots" does not exist LINE 3: WHERE id_groupe_mots=2 ^ SELECT * FROM spip_groupes_mots WHERE id_groupe_mots=2»
- «SQL-Fehler 1000 — errcode: 1000 : column "id_groupe_mots" does not exist LINE 3: WHERE id_groupe_mots=2 ^ SELECT * FROM spip_groupes_mots WHERE id_groupe_mots=2»

The last two messages appear as part of a table which blocks the right side of the browser
window.

Maybe the version nummber should include the word ‘beta’.

-- System Information:
Debian Release: 9.2
  APT prefers stable-updates
  APT policy: (500, 'stable-updates'), (500, 'stable')
Architecture: amd64 (x86_64)

Kernel: Linux 4.9.0-4-amd64 (SMP w/4 CPU cores)
Locale: LANG=en_AX.UTF-8, LC_CTYPE=en_AX.UTF-8 (charmap=UTF-8), LANGUAGE=en_IE:en (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash
Init: systemd (via /run/systemd/system)

Versions of packages spip depends on:
ii  apache2 [httpd]               2.4.25-3+deb9u3
ii  debconf [debconf-2.0]         1.5.61
ii  fonts-dustin                  20030517-10
ii  libjs-excanvas                0.r3-4
ii  libjs-jquery                  3.1.1-2
ii  libjs-jquery-colorbox         1.6.3-1
ii  libjs-jquery-cookie           11-3
ii  libjs-jquery-flot             0.8.3+dfsg-1
ii  libjs-jquery-form             11-3
ii  libjs-jquery-ui               1.12.1+dfsg-4
ii  libjs-mediaelement            2.15.1+dfsg-1
ii  php-common                    1:49
ii  php-getid3                    1.9.12+dfsg-1
ii  php-html-safe                 0.10.1-4
ii  php-mysql                     1:7.0+49
ii  php-pclzip                    2.8.2-4
ii  php-pgsql                     1:7.0+49
ii  php-sqlite3                   1:7.0+49
ii  php-xml-htmlsax3              3.0.0+really3.0.0-3
ii  php7.0-pgsql [php-pgsql]      7.0.19-1
ii  php7.0-sqlite3 [php-sqlite3]  7.0.19-1

Versions of packages spip recommends:
ii  imagemagick                                 8:6.9.7.4+dfsg-11+deb9u1
ii  imagemagick-6.q16 [imagemagick]             8:6.9.7.4+dfsg-11+deb9u1
ii  mariadb-server-10.1 [virtual-mysql-server]  10.1.26-0+deb9u1
ii  mysql-server                                5.5.9999+default
ii  netpbm                                      2:10.0-15.3+b2
ii  php-sqlite3                                 1:7.0+49
ii  php7.0-sqlite3 [php-sqlite3]                7.0.19-1
ii  postgresql                                  9.6+181

spip suggests no packages.

-- debconf information:
  spip/webserver: apache2