nextcloud / tables

🍱 Nextcloud tables app
https://apps.nextcloud.com/apps/tables
GNU Affero General Public License v3.0
148 stars 23 forks source link

Search no longer works after deleting a column #857

Closed Markoise closed 9 months ago

Markoise commented 9 months ago

Steps to reproduce

  1. Create column in existing table
  2. Delete column again
  3. Enter search term in search field

Expected behavior

Actual behavior

Tables app version

0.6.6

Browser

Firefox 122, Edge

Client operating system

Windows, Android

Operating system

Debian Linux

Web server

Nginx

PHP engine version

PHP 8.2

Database

MariaDB

Additional info

No response

enjeck commented 9 months ago

@Markoise What column type did you create and delete? And what column types are in the table?

Markoise commented 9 months ago

@Markoise What column type did you create and delete? And what column types are in the table?

In this case it was a column with type "Link" Otherwise, the types in the table are “text”, “selection”, “number field” and “star rating”.

enjeck commented 9 months ago

In this case it was a column with type "Link" Otherwise, the types in the table are “text”, “selection”, “number field” and “star rating”. Hmm, I tested out with a Table having these column types, and it works for me.

If you can, please record a screencast while reproducing the bug

juliusknorr commented 9 months ago

Also checking the Nextcloud log and browser error console would be great as this could give hints on where it fails. :)

Markoise commented 9 months ago

Also checking the Nextcloud log and browser error console would be great as this could give hints on where it fails. :)

I tried to reproduce it again. The problem does not occur again on my test system.

It looks like only the table in my production system is affected and can no longer be searched or exported as a CSV.

In mid-2023 I had the phenomenon with an older version of Tables on another server.

If you create a new table and import the data via CSV, everything is fine again. Unfortunately, you then have to create all the column properties again first.

Unfortunately there is nothing in the logs.

enjeck commented 9 months ago

We can reopen this later if the bug can reproduced or there are logs. For now, nothing can be done.