Incorrect table definition

[ChristophWurst]

Hi,

just build a tarball with make appstore and uploaded it to another instance. Then I got

$ php occ app:enable documentserver_community
An exception occurred while executing 'ALTER TABLE oc_documentserver_changes ADD change_index BIGINT AUTO_INCREMENT NOT NULL':

SQLSTATE[42000]: Syntax error or access violation: 1075 Incorrect table definition; there can be only one auto column and it must be defined as a key

My db: mysql Ver 15.1 Distrib 10.3.18-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2

@icewind1991 any clue? Let me know if you need any other info for debugging :)

[rullzer]

Yep hitting the same bug.

Caused by: https://github.com/nextcloud-gmbh/documentserver_community/blob/ed8fe7d492b1279a026ba3c2092ac7f9bad8272d/lib/Migration/Version001000Date20200107143228.php#L21

But looking at: https://github.com/nextcloud-gmbh/documentserver_community/blob/ed8fe7d492b1279a026ba3c2092ac7f9bad8272d/lib/Document/ChangeStore.php#L49

I guess the change index doesn't need to be autoincrement and this is a copy paste error somewhere?

[icewind1991]

Fixed

this is a copy paste error

Correct