No data of existing tables after update #999

Jednadvacet · 2024-04-25T09:41:20Z

Steps to reproduce

Update Tables to 0.7.0. (NC 28.0.4, 29.0.0.)
Tables -> Select a table
Cry

Expected behavior

Table data views should be available.

Actual behavior

After Tables app update to 0.7.0. no table data to display. 0, none.

Log:
InternalError, No column found to build filter with for id -2
An internal error or exception occurred: No column found to build filter with for id -2

Help, please.

Tables app version

0.7.0.

Browser

Edge

Client operating system

No response

Operating system

Ubuntu 20.04

Web server

Nginx

PHP engine version

PHP 8.1

Database

MariaDB

Additional info

No response

osm-frasch · 2024-04-25T09:43:43Z

We have the same problem. I opened a bug report at the same time. I think this can be merged

Jednadvacet · 2024-04-25T09:44:58Z

Sure!

GoOz · 2024-04-25T10:17:49Z

Got the same issue there. I don't have access to the DB myself but do you know if the data is lost or is it just the app failing the DB request?

juliushaertl · 2024-04-25T11:26:23Z

Can you paste the full raw json content of the error message, however just from the message it looks like #998 and it looks like it is just failing to list the tables due to a somewhat strange view filter in place

Jednadvacet · 2024-04-25T11:46:49Z

This is mine:

{"reqId":"7nwHGp5F7xMealyHHIVM","level":3,"time":"2024-04-25T09:34:34+00:00","remoteAddr":"213.250.193.178","user":"ondra","app":"tables","method":"GET","url":"/apps/tables/table","message":"No column found to build filter with for id -2","userAgent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/123.0.0.0 Safari/537.36 Edg/123.0.0.0","version":"29.0.0.19","exception":{"Exception":"OCA\Tables\Errors\InternalError","Message":"No column found to build filter with for id -2","Code":0,"Trace":[{"file":"/var/www/html/nextcloud/apps/tables/lib/Db/Row2Mapper.php","line":263,"function":"getFilter","class":"OCA\Tables\Db\Row2Mapper","type":"->"},{"file":"/var/www/html/nextcloud/apps/tables/lib/Db/Row2Mapper.php","line":241,"function":"getFilterGroups","class":"OCA\Tables\Db\Row2Mapper","type":"->"},{"file":"/var/www/html/nextcloud/apps/tables/lib/Db/Row2Mapper.php","line":143,"function":"addFilterToQuery","class":"OCA\Tables\Db\Row2Mapper","type":"->"},{"file":"/var/www/html/nextcloud/apps/tables/lib/Db/Row2Mapper.php","line":827,"function":"getWantedRowIds","class":"OCA\Tables\Db\Row2Mapper","type":"->"},{"file":"/var/www/html/nextcloud/apps/tables/lib/Service/RowService.php","line":535,"function":"countRowsForView","class":"OCA\Tables\Db\Row2Mapper","type":"->"},{"file":"/var/www/html/nextcloud/apps/tables/lib/Service/ViewService.php","line":413,"function":"getViewRowsCount","class":"OCA\Tables\Service\RowService","type":"->"},{"file":"/var/www/html/nextcloud/apps/tables/lib/Service/ViewService.php","line":90,"function":"enhanceView","class":"OCA\Tables\Service\ViewService","type":"->"},{"file":"/var/www/html/nextcloud/apps/tables/lib/Service/TableService.php","line":227,"function":"findAll","class":"OCA\Tables\Service\ViewService","type":"->"},{"file":"/var/www/html/nextcloud/apps/tables/lib/Service/TableService.php","line":149,"function":"enhanceTable","class":"OCA\Tables\Service\TableService","type":"->"},{"file":"/var/www/html/nextcloud/apps/tables/lib/Controller/TableController.php","line":39,"function":"findAll","class":"OCA\Tables\Service\TableService","type":"->"},{"file":"/var/www/html/nextcloud/apps/tables/lib/Controller/Errors.php","line":16,"function":"OCA\Tables\Controller\{closure}","class":"OCA\Tables\Controller\TableController","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/html/nextcloud/apps/tables/lib/Controller/TableController.php","line":40,"function":"handleError","class":"OCA\Tables\Controller\TableController","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":232,"function":"index","class":"OCA\Tables\Controller\TableController","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":138,"function":"executeController","class":"OC\AppFramework\Http\Dispatcher","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/AppFramework/App.php","line":184,"function":"dispatch","class":"OC\AppFramework\Http\Dispatcher","type":"->"},{"file":"/var/www/html/nextcloud/lib/private/Route/Router.php","line":338,"function":"main","class":"OC\AppFramework\App","type":"::"},{"file":"/var/www/html/nextcloud/lib/base.php","line":1050,"function":"match","class":"OC\Route\Router","type":"->"},{"file":"/var/www/html/nextcloud/index.php","line":49,"function":"handleRequest","class":"OC","type":"::"}],"File":"/var/www/html/nextcloud/apps/tables/lib/Db/Row2Mapper.php","Line":276,"message":"No column found to build filter with for id -2","exception":[],"CustomMessage":"No column found to build filter with for id -2"},"id":"662a42782dffb"}

daCaPo · 2024-04-25T12:16:10Z

Same issue here.

JohannesTeichert · 2024-04-25T14:12:31Z

same issue here any chance the data can be recovered? 😬

This is the log I got in nextcloud logging section:

Exception
Repair step 'OCA\Tables\Migration\NewDbStructureRepairStep' can't be instantiated: Could not resolve OCA\Tables\Db\RowMapper! Class "OCA\Tables\Db\RowMapper" does not exist
Exception thrown: Exception

GoOz · 2024-04-25T14:15:43Z

@JohannesTeichert from what I understood and what is said in #998 the data is indeed still there, so no loss.

daCaPo · 2024-04-25T14:20:22Z

See my #998 (comment) (and maybe merge #988 and #999?)

JohannesTeichert · 2024-04-25T15:24:18Z

I updated my initial comment with the log from the Log viewer:

This is the log I got in nextcloud logging section:

Exception
Repair step 'OCA\Tables\Migration\NewDbStructureRepairStep' can't be instantiated: Could not resolve OCA\Tables\Db\RowMapper! Class "OCA\Tables\Db\RowMapper" does not exist
Exception thrown: Exception

are we having the same problem?

ostasevych · 2024-04-25T15:28:20Z

All my rows from the table have gone (!!!) after update to 0.7.0. These are around 250 records. What to do to bring them back? Is it possible to downgrade?

UPD: This command fixed the issue:

occ tables:legacy:transfer:rows --all

Jednadvacet · 2024-04-25T15:42:07Z

Yes, we are - on my 28.0.4 instance. And PHP error: Undefined array key "manageTable" at /var/www/html/nextcloud/cloud.live/custom_apps/tables/lib/Service/ViewService.php#419. Probably for every table view. But: On my second NC instance 29.0.0. there are another messages: Warning: Try to set no user in context, but request is not allowed. Warning: An internal error or exception occurred: No column found to build filter with for id -2 Error: InternalError No column found to build filter with for id -2 28.0.5 is Ubuntu php8.1 nginx posqgres 29.0.0. is Raspberry ubuntu, php8.1 nginx mariadb/mysql čt 25. 4. 2024 v 17:24 odesílatel Johannes Teichert < ***@***.***> napsal:

…

I updated my initial comment with the log from the Log viewer: This is the log I got in nextcloud logging section: Exception Repair step 'OCA\Tables\Migration\NewDbStructureRepairStep' can't be instantiated: Could not resolve OCA\Tables\Db\RowMapper! Class "OCA\Tables\Db\RowMapper" does not exist Exception thrown: Exception are we having the same problem? — Reply to this email directly, view it on GitHub <#999 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ASTVCR55IICYXIACWGSKL4TY7EN3RAVCNFSM6AAAAABGYQNDC6VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDANZXGU3DSNBUGY> . You are receiving this because you authored the thread.Message ID: ***@***.***>

rakurtz · 2024-04-26T08:13:55Z

occ tables:legacy:transfer:rows --all

works perfectly

Morethanevil · 2024-04-26T20:32:18Z

All my rows from the table have gone (!!!) after update to 0.7.0. These are around 250 records. What to do to bring them back? Is it possible to downgrade?

UPD: This command fixed the issue:
occ tables:legacy:transfer:rows --all

Thank you so much 🥹

You saved a lot of work

clatoverada · 2024-04-27T13:14:31Z

occ tables:legacy:transfer:rows --all

Sadly, this command did not solve the problem for me. Tables are still not displayed. Creating new tables also fails.

UPDATE: After restarting the server, the tables are accessible again. :-)

seindal · 2024-04-30T06:33:52Z

After upgrading to 0.7.1 all my tables are gone. The occ command above did nothing.

I haven't found anything relevant in the log, only a couple of "Try to set no user in context, but request is not allowed" but one was from before the upgrade.

90madness · 2024-05-02T09:08:29Z

Yes, Same here. After Update to 0.7.1 all tables are empty. using Nextcloud All in One on Debian

NL-CCMLM · 2024-05-03T09:37:21Z

occ tables:legacy:transfer:rows --all

worked for us, without restart, but ....
some rows behave strangely... but no data was lost !
Anyway, that's a big thanks you for the tip and ... the app !

ostasevych · 2024-05-03T09:52:36Z

The most strange thing observer by me is loosing date/time format. The rows are not sorted by date anymore :(

b108 · 2024-05-05T08:15:11Z

Same issue here.

UPD: This command fixed the issue:
occ tables:legacy:transfer:rows --all

thank you!

Throntorus · 2024-05-05T08:46:28Z

All my rows from the table have gone (!!!) after update to 0.7.0. These are around 250 records. What to do to bring them back? Is it possible to downgrade?

UPD: This command fixed the issue:
occ tables:legacy:transfer:rows --all

Unfortunatelly i got "Look for tables Error while fetching tables. Will aboard." - anyone else wiht this problem?

Blackfire-dev · 2024-05-09T16:53:02Z

UPD: This command fixed the issue:
occ tables:legacy:transfer:rows --all

Thank you so much. I nearly nearly had a heart attack. This is worked for me on 7 tables with over 100 records between them.

ostasevych · 2024-05-09T16:55:46Z

UPD: This command fixed the issue:
occ tables:legacy:transfer:rows --all
Thank you so much. I nearly nearly had a heart attack. This is worked for me on 7 tables with over 100 records between them.

Check data consistency. I have lost sorting by date, eg.

Blackfire-dev · 2024-05-12T10:45:55Z

UPD: This command fixed the issue:
occ tables:legacy:transfer:rows --all
Thank you so much. I nearly nearly had a heart attack. This is worked for me on 7 tables with over 100 records between them.
Check data consistency. I have lost sorting by date, eg.

I have just checked, fortunately I haven't had any loss or data or sorting options. Thank you for the heads up.

Taxicletter · 2024-05-13T13:54:14Z

How can I do this (occ tables:legacy:transfer:rows --all) when my NexCloud instance is on a hosted server? I tried OCCweb, but that crashes...

daCaPo · 2024-05-13T16:07:23Z

How can I do this (occ tables:legacy:transfer:rows --all) when my NexCloud instance is on a hosted server? I tried OCCweb, but that crashes...

I use a PHP script like this:

<?php
$occ = "/usr/bin/env php -d memory_limit=512M [your path to Nextcloud here]/occ ";
# Use relative path to point to occ of your nextcloud installation and append the occ-command
$command = "/usr/bin/env php -d memory_limit=512M [your path to Nextcloud here]/occ tables:legacy:transfer:rows --all
";
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8" />
<title>Execute Nextcloud occ-command on shared hosting</title>
<style>body { font-family: sans-serif; }</style>
</head>
<body>
<?php echo "<h1>Command</h1><p>" . htmlspecialchars($command) . "</p><h1>Result</h1><p>" . htmlspecialchars(exec($command)) . "</p>"; ?>
</body>
</html>

(Credits go to https://www.ich-war-hier.de/2020/09/21/nextcloud-occ-kommando-auf-webhoster-ohne-ssh-ausfuehren/)

Jacky-no1 · 2024-05-18T06:14:39Z

How can I do this (occ tables:legacy:transfer:rows --all) when my NexCloud instance is on a hosted server? I tried OCCweb, but that crashes...

I also run on a hosted server.
OCC Web also crashes for me.

But i could connect via Windows PowerShell to SSH
ssh [email protected]
and then put following command that works for me:
php -d memory_limit=512M [your path to Nextcloud here]/occ tables:legacy:transfer:rows --all

First i tried with a .php file on server according this, but it doesnt work:
https://www.ich-war-hier.de/2020/09/21/nextcloud-occ-kommando-auf-webhoster-ohne-ssh-ausfuehren/
Error says: old php version. My Server runs with php 8.3 but in the /user/bin/env is version 7.x set. Dont know how to change it.
Via SSH the command php -v shows the 8.3 version.

hermann-san · 2024-06-07T10:01:50Z

Just for People who are on Linux and don't know how to execute the occ command. This is run in the Nextcloud install directory, wherever this may be for you. For me it's /var/www/nextcloud
sudo -u www-data php occ tables:legacy:transfer:rows --all
This has worked for me.

Jednadvacet added 0. Needs triage Pending approval or rejection. This issue is pending approval. bug Something isn't working labels Apr 25, 2024

daCaPo mentioned this issue Apr 25, 2024

Tables appear empty (No entries) after update from 0.6.6 to 0.7.0 official (via App Store) #998

Closed

Sylvain303 mentioned this issue Apr 29, 2024

API Insert row into a table duplicate key value violates unique constraint "oc_tables_row_sleeves_pkey" #1029

Closed

slu-010101 mentioned this issue May 2, 2024

No more data in the tables after the last update #1039

Open

enjunear mentioned this issue May 5, 2024

Cannot insert row after upgrade to 0.7 #1058

Closed

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

No data of existing tables after update #999

No data of existing tables after update #999

Jednadvacet commented Apr 25, 2024

osm-frasch commented Apr 25, 2024

Jednadvacet commented Apr 25, 2024

GoOz commented Apr 25, 2024

juliushaertl commented Apr 25, 2024

Jednadvacet commented Apr 25, 2024

daCaPo commented Apr 25, 2024

JohannesTeichert commented Apr 25, 2024 •

edited

GoOz commented Apr 25, 2024

daCaPo commented Apr 25, 2024

JohannesTeichert commented Apr 25, 2024

ostasevych commented Apr 25, 2024 •

edited

Jednadvacet commented Apr 25, 2024 via email

rakurtz commented Apr 26, 2024

Morethanevil commented Apr 26, 2024

clatoverada commented Apr 27, 2024 •

edited

seindal commented Apr 30, 2024

90madness commented May 2, 2024

NL-CCMLM commented May 3, 2024

ostasevych commented May 3, 2024

b108 commented May 5, 2024

Throntorus commented May 5, 2024 •

edited

Blackfire-dev commented May 9, 2024

ostasevych commented May 9, 2024

Blackfire-dev commented May 12, 2024

Taxicletter commented May 13, 2024

daCaPo commented May 13, 2024

Jacky-no1 commented May 18, 2024 •

edited

hermann-san commented Jun 7, 2024

No data of existing tables after update #999

No data of existing tables after update #999

Comments

Jednadvacet commented Apr 25, 2024

Steps to reproduce

Expected behavior

Actual behavior

Tables app version

Browser

Client operating system

Operating system

Web server

PHP engine version

Database

Additional info

osm-frasch commented Apr 25, 2024

Jednadvacet commented Apr 25, 2024

GoOz commented Apr 25, 2024

juliushaertl commented Apr 25, 2024

Jednadvacet commented Apr 25, 2024

daCaPo commented Apr 25, 2024

JohannesTeichert commented Apr 25, 2024 • edited

GoOz commented Apr 25, 2024

daCaPo commented Apr 25, 2024

JohannesTeichert commented Apr 25, 2024

ostasevych commented Apr 25, 2024 • edited

Jednadvacet commented Apr 25, 2024 via email

rakurtz commented Apr 26, 2024

Morethanevil commented Apr 26, 2024

clatoverada commented Apr 27, 2024 • edited

seindal commented Apr 30, 2024

90madness commented May 2, 2024

NL-CCMLM commented May 3, 2024

ostasevych commented May 3, 2024

b108 commented May 5, 2024

Throntorus commented May 5, 2024 • edited

Blackfire-dev commented May 9, 2024

ostasevych commented May 9, 2024

Blackfire-dev commented May 12, 2024

Taxicletter commented May 13, 2024

daCaPo commented May 13, 2024

Jacky-no1 commented May 18, 2024 • edited

hermann-san commented Jun 7, 2024

JohannesTeichert commented Apr 25, 2024 •

edited

ostasevych commented Apr 25, 2024 •

edited

clatoverada commented Apr 27, 2024 •

edited

Throntorus commented May 5, 2024 •

edited

Jacky-no1 commented May 18, 2024 •

edited