Polls app update fails: InvalidFieldNameException

🍱 Features & apps polls
1

Hi, got following message while trying to update Polls app on NC 14.0.4 with Postgresql Database on Debian server:

Aktualisierung auf 14.0.4

Doctrine\DBAL\Exception\InvalidFieldNameException: An exception occurred while executing ‘SELECT “id” FROM “oc_polls_options” WHERE (poll_id = “2”) AND (poll_option_text =“Ich komme Dienstag, 28.11.2017.”)’: SQLSTATE[42703]: Undefined column: 7 FEHLER: Spalte »2« existiert nicht LINE 1: …ECT “id” FROM “oc_polls_options” WHERE (poll_id = “2”) AND (… ^

2

I think, the new release 0.9.4 of the Polls app should fix that. Did you tried it with this version?

3

Hi, have been initially noticed that there was an update for 0.9.3 and started it, then, after getting stuck in the update failure, I did work-around the problem following this:

https://github.com/nextcloud/polls/issues/454

I have just verified the installed Polls app version and is reported as 0.9.4, but now NC is reporting:

  • Some files have not passed the integrity check. Further information on how to resolve this issue can be found in the [documentation]. ([List of invalid files…]

Technical information

The following list covers which files have failed the integrity check. Please read
the previous linked documentation to learn more about the errors and how to fix
them.

Results

  • core
    • INVALID_HASH
      • core/js/mimetypelist.js

Raw output

Array
(
[core] => Array
(
[INVALID_HASH] => Array
(
[core/js/mimetypelist.js] => Array
(
[expected] => dc48de7ad4baa030c5e563350c9a80b274bad783f6f5adbf1595ecef6c6a32e52890a24cb26cddb0aa20193ba52c001150c68d8bfb567f0aed566f4029a190a3
[current] => 6a05a7a2bd52651177dc54170f94c7ccf1966c421f30540be49d64770d71c71731052565c2f8e00406a579e7c78dad16673202051231626f1e6d4e656046e6fc
)
)
)
)

4

The failed integrity check hasn’t to do with the polls app. Does polls now work, or are there still errors?

5

Hi @dartcafe, Polls 0.9.4, and now 0.9.5, are working for me. I plan to investigate this afternoon where the integrity check failure comes from.