Nextcloud file sync broken

sasha commented

2024-06-28 18:31:27 +02:00

Recently I've been unable to sync any files to Nextcloud or vice versa, and I just get the error:

An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')) AND (sh.parent IS NULL)' at line 1

for every file

Recently I've been unable to sync any files to Nextcloud or vice versa, and I just get the error: An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')) AND (`sh`.`parent` IS NULL)' at line 1 for every file

floss4good commented

2024-06-28 23:02:54 +02:00

By what client (desktop / mobile) is the mentioned error reported?

Also, when you say recently are you referring to hours / days / weeks?

By what client (desktop / mobile) is the mentioned error reported? Also, when you say _recently_ are you referring to hours / days / weeks?

sasha commented

2024-06-28 23:58:40 +02:00

Author

Few days I think. And the Nextcloud client on Linux but WebDAV doesn't work either.

sasha closed this issue

2024-06-28 23:58:40 +02:00

sasha reopened this issue

2024-06-28 23:58:48 +02:00

floss4good commented

2024-06-29 11:49:55 +02:00

I am now facing the same issues (using Nextcloud desktop client v.3.13.0 installed through APT).
However, 26 hours ago I was able to upload something.

I am now facing the same issues (using Nextcloud desktop client v.3.13.0 installed through APT). However, 26 hours ago I was able to upload something.

floss4good commented

2024-06-29 11:58:33 +02:00

Others are also complaining: https://help.nextcloud.com/t/unable-to-upload-file-to-root-dir-atfer-update-to-29-0-3/196306

And according to https://github.com/nextcloud/server/issues/46196 an workaround would be to disable the Circles/Teams app. - ping @muppeth.

A fix is also pending.

Others are also complaining: https://help.nextcloud.com/t/unable-to-upload-file-to-root-dir-atfer-update-to-29-0-3/196306 And according to https://github.com/nextcloud/server/issues/46196 an workaround would be to disable the Circles/Teams app. - ping @muppeth. A fix is also pending.

sasha commented

2024-06-29 14:46:32 +02:00

Author

so it's an upstream bug good to know

floss4good commented

2024-06-29 17:11:11 +02:00

If anyone else is following this discussion, about 4 hours ago @muppeth disabled Circles app until the upstream fix is merged and released.

muppeth commented

2024-07-01 11:13:30 +02:00

Owner

Sorry for not updating this Issue. I totally missed it being reported so I only put info on status page. Thanks again @floss4good for catching this one.

👍 1

floss4good commented

2024-07-07 16:41:25 +02:00

... disabled Circles app until the upstream fix is merged and released.

The upstream fix was merged and back-ported only to stable28 and stable29; therefore I'm afraid they are not going to also release a fix for version 27 - because Nextcloud Hub 6 is now EOL (version 27.1.11 being the final community maintenance release) and the Circles/Teams app is currently being released only bundled within Nextcloud server (as they confirmed on git).

So you will have to either manually patch the Circles app or update to Nextcloud 28.0.8 when it will be released.

> ... disabled Circles app until the upstream fix is merged and released. The upstream fix was merged and back-ported only to stable28 and stable29; therefore I'm afraid they are not going to also release a fix for version 27 - because [Nextcloud Hub 6 is now EOL](https://nextcloud.com/blog/june-updates-for-nextcloud-hub-6-7-and-8-are-here/) (version 27.1.11 being _the final community maintenance release_) and the Circles/Teams app is currently being released only bundled within Nextcloud server (as they [confirmed on git](https://github.com/nextcloud/circles/pull/1615#issuecomment-2212470044)). So you will have to either manually patch the Circles app or update to Nextcloud 28.0.8 when it will be released.

muppeth commented

2024-07-07 16:54:19 +02:00

Owner

Yes. I am planning to do upgrade to 29 this tuesday

👍 1

meaz commented

2024-07-07 17:00:15 +02:00

Owner

ok then I add this in the July milestone

meaz added this to the 24.07 - July milestone 2024-07-07 17:00:19 +02:00

muppeth commented

2024-07-07 17:08:26 +02:00

Owner

Added it to changelog too.

floss4good commented

2024-07-07 17:18:21 +02:00

BTW, isn't it safer to first update from 27 to 28?

muppeth commented

2024-07-07 18:06:45 +02:00

Owner

Updater updates in stages. First all minor version, then major etc. So It will now update to 28, we can then do quick test and then jump over to 29. Depending on the process and possible issues along the way I might stop at 28 and do 29 in couple of days. But if the update does ok and all tested functions seem fine, we could just jump over

muppeth commented

2024-07-10 01:10:40 +02:00

Owner

Did update to 28 this evening but looks like the fix is added to milestone 28.0.8 while current version is 28.0.7. Doesn't look like the fix has been pushed to 29 neither as its added to 29.0.4. Unless I'm missing something (its late), we need to wait a bit more for the fix. If that's the case, once pushed, we will jump to nextcloud 29 and try our best to be up to date with stuff.

floss4good referenced this issue

2024-07-19 19:42:44 +02:00

[NEXTCLOUD] • [COLLECTIVES APP] Feature request #760

meaz modified the milestone from 24.07 - July to 24.08 - August

2024-08-04 15:32:15 +02:00

muppeth commented

2024-08-07 01:01:17 +02:00

Owner

Updated nextcloud to the latest version 29.0.4 and teams app (formerly circles) is back without the bug.

muppeth closed this issue

2024-08-07 01:01:17 +02:00

Nextcloud file sync broken #909