Answers not shown in Forms-App but in Database

[NeverLoseHope777]

Please use the 👍 reaction to show that you are affected by the same issue. Please don't comment if you have no relevant information to add!

Describe the bug Hello everyone, I have the problem that my forms answers are no longer displayed. However, they are available in the “oc_forms_v2_answers” database. When I fill out the form again, the new answer is also written to the database, but it does not appear under “Answers”. It only says “100 % no answer”

Do you have any idea?

(same Problem with 4.3.0-alpha-6)

To Reproduce Steps to reproduce the behavior:

1. create a form
2. answer a form
3. go to the answers

Expected behavior All given answers are shown

Screenshots

Nextcloud (please complete the following information):

• Nextcloud-Version: 29.0.5
• Forms-Version: 4.2.4

Desktop (please complete the following information):

• OS: Linux Mint
• Browser Libre Wolf / Firefox / Brave
• Version 129.0.1-1

[Chartman123]

Hi @NeverLoseHope777

Could you please check if there are any problems shown in your browser console?

[NeverLoseHope777]

Hi @NeverLoseHope777

Could you please check if there are any problems shown in your browser console?

Yes, thank you :)

[Chartman123]

Ok, this error is unrelated to your problem...

Can you please tell us more about your environment? (DB, Web server, PHP version) Do you use any script blockers / add-ons that might interfere with the application?

[NeverLoseHope777]

A few days ago, everything was still running normally. I'm not sure if it's related to the update from Nextcloud 29.0.4 to 29.0.5. We use web hosting with SSH access. I do not use any blockers or addons. I tried it in different clean browsers.

OS: Linux 4.18.0-553.8.1.lve.el8.x86_64 x86_64 Processor: AMD EPYC 7282 16-Core Processor (32 threads) Webserver: LiteSpeed V8.1 Cloudlinux 1.3 MySQL: 10.6.18 PHP: 8.2.22 Memory limit: 1 GB Maximum execution time: 3600 Maximum upload size: 64 MB OPcache revalidation frequency: 2 Extensions: Core, date, libxml, openssl, pcre, sqlite3, zlib, bz2, calendar, ctype, curl, hash, filter, ftp, gettext, json, iconv, SPL, pcntl, random, readline, Reflection, session, standard, mbstring, shmop, SimpleXML, tokenizer, xml, litespeed, apcu, bcmath, dba, dom, enchant, fileinfo, gd, gmp, igbinary, imagick, imap, intl, ldap, exif, memcache, PDO, mysqlnd, mysqli, odbc, pdo_mysql, PDO_ODBC, pdo_pgsql, pdo_sqlite, pgsql, Phar, posix, pspell, snmp, soap, sockets, sodium, sysvmsg, sysvsem, sysvshm, tidy, xmlreader, xmlrpc, xmlwriter, xsl, zip, Zend OPcache

[NeverLoseHope777]

I don't know if this is helpful, but today I have these errors in protocol.

[susnux]

The first 3 could be related, how did you update forms? Do you see any file integrity issues in the "security warnings" section of the admin settings?

[TannerNelson16]

Having the same issue. Confirmed I can also see the info in database in that same table.

[Chartman123]

@TannerNelson16 could you please also have a look at your browser console if there are any warnings/errors?

[TannerNelson16]

Is this what you're referring to?

[Chartman123]

I'm still clueless what could be the reason for this specific problem.

@TannerNelson16 @NeverLoseHope777:

• Do you use any additional plugins in your browsers? Can you reproduce the issue in a private tab without any plugins active?
• Do you see the correct answers if you have a look at the submissions view (Antworten) and not the summary view (Zusammenfassung)?
• Does this issue affect all users with result permissions on your servers?
• Does this affect all of your forms?

[TannerNelson16]

No plugins. I do have Adguard on the network. Not sure if that would have an affect, but I've disabled filtering and the same thing happens. Also tried in a different browser with the same result.

I can't see the answers either way, and it gives errors when I try to generate a csv. The only way I can see them is throught the sql database

It affects all users and forms.

[Chartman123]

Ok, then it has probably got something to do with either your installation of the Forms app, your NC Server or the web server.

Could you please create a backup and then try to uninstall the Forms app, remove all remnants of Forms in the apps directory of your Nextcloud inside the web server and then re-install the app?

[Chartman123]

@TannerNelson16 @NeverLoseHope777 Any news? Did you test a new and clean install of Forms?

[NeverLoseHope777]

Hello @Chartman123, uninstalling, removing and new-installation didn't solve my problem. But with new Nextcloud-Version (now 29.0.8) everything works fine again :)

[Chartman123]

@NeverLoseHope777 Ok thank you for your feedback :) I'm glad to hear that you can use Forms again :)