The "unique" column option is not supported #541

J0WI · 2021-02-23T01:32:45Z

Error: Doctrine\DBAL\Schema\Exception\UnknownColumnOption: The "unique" column option is not supported.

details

``` 0. /var/www/html/3rdparty/doctrine/dbal/src/Schema/Column.php line 84 Doctrine\DBAL\Schema\Exception\UnknownColumnOption::new("unique") 1. /var/www/html/3rdparty/doctrine/dbal/src/Schema/Column.php line 68 Doctrine\DBAL\Schema\Column->setOptions({notnull: true,length: 255,unique: true}) 2. /var/www/html/3rdparty/doctrine/dbal/src/Schema/Table.php line 355 Doctrine\DBAL\Schema\Column->__construct("adr", Doctrine\DBAL\Types\StringType {}, {notnull: true,length: 255,unique: true}) 3. /var/www/html/custom_apps/maps/lib/Migration/Version000009Date20190625000800.php line 43 Doctrine\DBAL\Schema\Table->addColumn("adr", "string", {notnull: true,length: 255,unique: true}) 4. /var/www/html/lib/private/DB/MigrationService.php line 455 OCA\Maps\Migration\Version000009Date20190625000800->changeSchema(OC\Migration\SimpleOutput {}, Closure {}, {tablePrefix: "oc_"}) 5. /var/www/html/lib/private/DB/MigrationService.php line 418 OC\DB\MigrationService->migrateSchemaOnly("latest") 6. /var/www/html/lib/private/Installer.php line 163 OC\DB\MigrationService->migrate("latest", true) 7. /var/www/html/apps/settings/lib/Controller/AppSettingsController.php line 448 OC\Installer->installApp("maps") 8. /var/www/html/lib/private/AppFramework/Http/Dispatcher.php line 218 OCA\Settings\Controller\AppSettingsController->enableApps(["maps"], []) 9. /var/www/html/lib/private/AppFramework/Http/Dispatcher.php line 127 OC\AppFramework\Http\Dispatcher->executeController(OCA\Settings\Con ... {}, "enableApps") 10. /var/www/html/lib/private/AppFramework/App.php line 157 OC\AppFramework\Http\Dispatcher->dispatch(OCA\Settings\Con ... {}, "enableApps") 11. /var/www/html/lib/private/Route/Router.php line 302 OC\AppFramework\App::main("OCA\\Settings\\ ... r", "enableApps", OC\AppFramework\ ... {}, {_route: "settin ... "}) 12. /var/www/html/lib/base.php line 993 OC\Route\Router->match("/settings/apps/enable") 13. /var/www/html/index.php line 37 OC::handleRequest() ```

gwenhael-le-moine · 2021-02-23T14:15:20Z

I get the same error with MariaDB 10.5.9 with a fresh install. When trying to enable Maps it fails with this error message.

arnakazim · 2021-02-23T20:51:06Z

Just installed the latest version of Nextcloud (21.0.0) using SQLite and I get the same error when I try to enable the app.

barti04 · 2021-02-24T07:46:43Z

Same. Nextcloud 21 and MariaDB.

pxlkng · 2021-02-24T18:37:32Z

Same with Nextcloud 21.0.0.18 and MySQL 8

bertieuk · 2021-02-24T19:04:18Z

Just got this, editted /var/www/nextcloud/apps/maps/lib/Migration/Version000009Date20190625000800.php and removed the two lines (45 & 50) containing 'unique' => true,

Now works, gave an sql error when first enabled but seems to be working now it's analysing photos.

pxlkng · 2021-02-24T23:49:03Z

Just got this, editted /var/www/nextcloud/apps/maps/lib/Migration/Version000009Date20190625000800.php and removed the two lines (45 & 50) containing 'unique' => true,

Now works, gave an sql error when first enabled but seems to be working now it's analysing photos.

Yeah this may be a hotfix but no long-term solution, I dont want to have to temper with the files. That should be getting fixed by nextcloud/contributors for this app.

snevas · 2021-03-10T10:48:08Z

Here is the nextcloud server issue:
nextcloud/server#25607

It's broken for more apps.
I'm using docker fpm alpine image + sqlite db

mchugh19 · 2021-03-11T07:17:14Z

On a pretty new install of nextcloud 21, I was able to edit the migration script as suggested to remove the unique elements. This allowed me to install maps. However, while I can now browse to the maps app, nothing loads, and the logs show:

Doctrine\DBAL\Exception\TableNotFoundException: An exception occurred while executing a query: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'nextcloud.oc_maps_tracks' doesn't exist
Doctrine\DBAL\Exception\TableNotFoundException: An exception occurred while executing a query: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'nextcloud.oc_maps_favorite_shares' doesn't exist
Doctrine\DBAL\Exception\TableNotFoundException: An exception occurred while executing a query: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'nextcloud.oc_maps_favorites' doesn't exist

Is there a way to re-run the table creation scripts?

Tyil · 2021-03-11T13:22:02Z

On Wed, Mar 10, 2021 at 11:17:29PM -0800, Christian McHugh wrote: On a pretty new install of nextcloud 21, I was able to edit the migration script as suggested to remove the unique elements. This allowed me to install maps. However, while I can now browse to the maps app, nothing loads, and the logs show: ``` Doctrine\DBAL\Exception\TableNotFoundException: An exception occurred while executing a query: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'nextcloud.oc_maps_tracks' doesn't exist Doctrine\DBAL\Exception\TableNotFoundException: An exception occurred while executing a query: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'nextcloud.oc_maps_favorite_shares' doesn't exist Doctrine\DBAL\Exception\TableNotFoundException: An exception occurred while executing a query: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'nextcloud.oc_maps_favorites' doesn't exist ``` Is there a way to re-run the table creation scripts?

Yes, using the occ utility in your Nextcloud directory. occ migrations:execute maps <name> The names of the migrations can be found in any app's lib/Migration directory, but leave out the leading Version, and ending .php parts. If Nextcloud complains they already ran, you can find the migration history in the oc_migrations table in your database. Keep in mind that manually altering records in this table might have unintended consequences. Ensure you have a suitable backup before hacking around.

…

-- With kind regards, Patrick Spek www: https://www.tyil.nl/ mail: ***@***.*** pgp: 1660 F6A2 DFA7 5347 322A 4DC0 7A6A C285 E2D9 8827 git: https://git.tyil.nl/

hakunamatata97k · 2021-03-15T17:56:21Z

nextcloud 21 with mariadb fresh install same error here!.

localjo · 2021-03-15T21:28:59Z

I tried removing the unique lines, and now I'm getting another error:

An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1072 Key column 'contact_uid' doesn't exist in table

localjo · 2021-03-15T21:57:24Z

@Tyil I apologize if this is an obvious question, but I'm new to NextCloud and I don't have any context. Does this occ utility need to be run in a terminal via ssh? I'm not sure if my provider gives me ssh access.

oucil · 2021-03-16T21:12:44Z

Nextcloud 21 with MySQL8, same problem.

k6av · 2021-03-17T10:19:33Z

The same issue arises with Postgres on Nextcloud 21.

Signed-off-by: Julien Veyssier <[email protected]>

tacruc · 2021-03-19T17:13:13Z

Test of #568 are welcome.

VoOoUoOoV · 2021-03-20T22:36:21Z

Just got this, editted /var/www/nextcloud/apps/maps/lib/Migration/Version000009Date20190625000800.php and removed the two lines (45 & 50) containing 'unique' => true,

Now works, gave an sql error when first enabled but seems to be working now it's analysing photos.

After del this line 45&50, i got another error.
Therefore i rewrote " 'unique' => true " back to the lines 45 & 50. Then no errors occours. Dont know why it works, but it does..

Update:
In App error occours. Cant find anything.. No Contacts, No GeoTagged Pictures, nothing..

Update 2:
Scan via "occ maps:scan-photos" and the other one, do not working. Getting exception errors:
""""""""""""""""""""""""""""""""""""""""""
In ExceptionConverter.php line 47:

An exception occurred while executing a query: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'nextcloud.oc_maps_photos' doesn't exist

In Exception.php line 26:
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'nextcloud.oc_maps_photos' doesn't exist

In Statement.php line 82:
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'nextcloud.oc_maps_photos' doesn't exist
""""""""""""""""""""""""""""""""""""""""""

VoOoUoOoV · 2021-03-21T00:21:18Z

Test of #568 are welcome.

Just testet it. Still not working.

localjo · 2021-03-21T19:55:04Z

It looks like #568 fixes the problem. To get it to work, you need to disable the maps app, reset maps related database values, check out the fix branch, and then re-enable the maps app. Database commands are in #568 comments thread.

VoOoUoOoV · 2021-03-22T14:58:39Z

Very Nice! oc_maps_* was missing like in #566
This is how it works @ my NC-DB
similar to #568

Edit like described here
Deactivate maps app in Nextcloud
In DataBase goto oc_migrations delete/drop: app=maps
Enable maps app in Nextcloud

oc_maps_* should be available and maps app works after a few minutes (after auto scan via nextcloud)

Another Bug?
When you get the problem like loading screen for pictures ( #543 ), then you can fix it with edit this

tacruc · 2021-03-22T21:24:51Z

Another Bug?
After the contacts and pictures are shown in the maps, it is not possible to enlarge the pictures when choosing any.. Just seeing only the loading screen.

Probably you mean #543, or something else?

VoOoUoOoV · 2021-03-22T21:32:32Z

Another Bug?
After the contacts and pictures are shown in the maps, it is not possible to enlarge the pictures when choosing any.. Just seeing only the loading screen.

Probably you mean #543, or something else?

Yes, Thank you very Much! Now it works :)

Joshua2504 · 2021-03-27T16:28:17Z

Same issue, latest nextcloud with mariadb.

yuriry · 2021-03-27T23:41:05Z

The same issue

Nextcloud 21.0.0
PostgreSQL 12

Update:
Just verified that the maps app installs/enables fine in Nextcloud 20.0.8

VoOoUoOoV · 2021-03-30T22:05:55Z

you can test the nightly or try this to fix it shortly. I used webmin to edit the DB

ThatCoffeeGuy · 2021-04-04T19:45:35Z

Same issue. Nextcloud 21.0.0 and Mysql 8

It might worth considering removing a completely broken app from featured.

Fortunately this worked:

1.) #541 (comment)
2.) disable maps
3.) mysql> DELETE FROM oc_migrations WHERE app LIKE "maps" ;
Query OK, 9 rows affected (0.01 sec)
4.) enable maps (ignore random syntax error..)
5.) $ sudo -u www-data php7.4 /var/www/nextcloud/occ maps:scan-photos

gardinenstange · 2021-04-18T18:31:07Z

Same issue. Nextcloud 21.0.0 and Mysql 8

It might worth considering removing a completely broken app from featured.

Fortunately this worked:

1.) #541 (comment)
2.) disable maps
3.) mysql> DELETE FROM oc_migrations WHERE app LIKE "maps" ;
Query OK, 9 rows affected (0.01 sec)
4.) enable maps (ignore random syntax error..)
5.) $ sudo -u www-data php7.4 /var/www/nextcloud/occ maps:scan-photos

didnt work :
An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1072 Key column 'contact_uid' doesn't exist in table

lupinehorror · 2021-04-18T18:32:58Z

same error here with 21.0.1 on apache2 with mariadb v10.5.9 and php7.4

Akruidenberg · 2021-04-25T10:36:55Z

same here. Using 21.0.0.1 with mariadb 10.3

snevas · 2021-04-26T08:48:20Z

As stated here, the nextcloud server will not support unique in the same way anymore. So the only hope is someone fixing it in the maps-app.

srvoets · 2021-04-29T21:47:07Z

Same issue, fresh nextcloud and mariadb install running in docker/unraid

solmarcus · 2021-05-01T02:30:24Z

Same issue. This app is one of the main reasons I use NC, but I can't install it. 😭

Redsandro · 2021-05-04T02:16:01Z

Same issue, using PostgreSQL 12.2.

I'd like to point out that I just installed maps for the first time today, so it doesn't seem like the February patch fixed this for me. What exactly causes this to be an issue for me if I haven't used Maps before?

debdolph · 2021-05-04T20:11:46Z

Same issue on PostgreSQL 13…

Redsandro · 2021-05-04T22:14:06Z

I manually installed the 0.1.9 nightly and it works now. 👍

Manually installing apps is not ideal. We have the option to choose Nextcloud channels (stable, daily beta, production); we should similarly have the option to allow installing nighty (beta) app versions.

Please thumbs up the relevant issue: nextcloud/server#10487

hobbsecky · 2021-05-09T04:46:25Z

you can test the nightly or try this to fix it shortly. I used webmin to edit the DB

Worked for me too on a clean NextcloudVM running NC 21.0.1. Thanks!

saschamander · 2021-05-22T22:31:01Z

Just installed the nightly build of Nextcloud/Maps manually and it worked like a charm.
I used docker and tested it with a fresh installation of version 21.0.1 and 21.0.2(current latest). Both work with the nightly build.

My steps where

Download nightly build of Nextcloud/Maps(link above)
Extract nightly build archive
Upload extracted maps-Folder to server into nextcloud/apps-Folder
Update Owner/Group (with chown)
Activate Maps via NC-WebInterface

EDIT:
If you want to have the stable version, you can disable and remove Maps again via the NC-WebInterface.
Also you will have to delete the maps folder from the nextcloud/apps-Folder.
After that you should be able to download and activate Maps in the current stable version.
(Though it seems I can't load my GPX-Tracks, but that is another issue)

gianlucagiacometti · 2021-05-23T07:04:17Z

Confirmed, thanks

ma-gh · 2021-05-24T19:01:05Z

Very Nice! oc_maps_* was missing like in #566
This is how it works @ my NC-DB
similar to #568

Edit like described here

Deactivate maps app in Nextcloud

In DataBase goto oc_migrations delete/drop: app=maps

Enable maps app in Nextcloud

oc_maps_* should be available and maps app works after a few minutes (after auto scan via nextcloud)

Another Bug?
When you get the problem like loading screen for pictures ( #543 ), then you can fix it with edit this

I did not have to drop anything from the Database, enabled via occ after editing files.
Thank you!

rugk · 2021-05-30T16:16:54Z

With Nextcloud 21.0.2.1 and a fresh installation of Maps 0.1.8 (never installed/enabled before) this error also happens at installation time.
So I cannot "disable and re-enable it", as I cannot install it in the first place (via the web interface, at least).

Given that a fix has been integrated already if I read this issue correctly, what is stopping you from releasing the new version now?

jjdsec · 2021-06-02T02:35:53Z

Just installed the nightly build of Nextcloud/Maps manually and it worked like a charm.
I used docker and tested it with a fresh installation of version 21.0.1 and 21.0.2(current latest). Both work with the nightly build.

My steps where
1. Download nightly build of Nextcloud/Maps(link above)

2. Extract nightly build archive

3. Upload extracted maps-Folder to server into nextcloud/apps-Folder

4. Update Owner/Group (with chown)

5. Activate Maps via NC-WebInterface
EDIT:
If you want to have the stable version, you can disable and remove Maps again via the NC-WebInterface.
Also you will have to delete the maps folder from the nextcloud/apps-Folder.
After that you should be able to download and activate Maps in the current stable version.
(Though it seems I can't load my GPX-Tracks, but that is another issue)

Confirmed as well, running NextCloud 21.0.2 with MariaDB 10.3.28 on CentOS 8 with php74-fpm
download, extract in apps folder (replacing existing maps folder) and enable in your applications in nextcloud

snowphone · 2021-06-05T15:21:03Z

I just started NextCloud a week ago, and found this issue recently.

Thus, do you guys know how long it takes to be stabilized? I'm planning to download 0.1.9 when it becomes stable, but I'm not sure how long should I wait for.

alehaa · 2021-06-06T17:20:52Z

I can confirm 0.1.9 works quite well, at least for those never have used it before. Just downloaded and copied it into the /apps subdirectory and works like a charm.

tedmarcin · 2021-06-07T10:07:06Z

same error here on postgresql 13

AgentCasey · 2021-06-23T20:47:02Z

I think that I may have a solution to this issue; cd to /var/www/nextcloud/apps/maps/lib/Migration and move all *.php files to somewhere for safekeeping. The directory should now be empty, then install the app again. It should install and act properly now. Thanks.

tacruc · 2022-04-14T10:35:26Z

I would summarize that #568 fixes this issue.
There might be a still be a problem with old tables, therefore I would like to point to #568 (comment).

J0WI added the bug label Feb 23, 2021

J0WI changed the title ~~Postgres: The "unique" column option is not supported~~ The "unique" column option is not supported Feb 23, 2021

Tyil mentioned this issue Feb 25, 2021

Remove broken unique constraints #542

Closed

e-LUNATIC mentioned this issue Mar 4, 2021

Cannot install Maps on Nextcloud 21.0.0.18 with Postgres Backend #551

Closed

localjo mentioned this issue Mar 18, 2021

Fresh installation of Maps api endpoints returning 500 errors #567

Closed

julien-nc pushed a commit that referenced this issue Mar 19, 2021

refs #541 fix db-related install problems on NC 21

b7875f0

Signed-off-by: Julien Veyssier <[email protected]>

julien-nc mentioned this issue Mar 19, 2021

Fix db-related install problems on NC 21 #568

Merged

stickr mentioned this issue Mar 19, 2021

Maps database tables do not exist #566

Open

VoOoUoOoV mentioned this issue Mar 22, 2021

Exception when scaning photos, NC 21 maps 0.1.8 #547

Closed

Redsandro mentioned this issue May 4, 2021

Import Location History to nextcloud maps nextcloud/integration_google#6

Open

beardhatcode mentioned this issue May 15, 2021

nextcloud: add option to set datadir and extensions NixOS/nixpkgs#119638

Merged

10 tasks

whizzrd mentioned this issue May 19, 2021

Installation fails: Invalid appinfo.xml file found: Element 'types' #604

Open

tacruc closed this as completed Apr 14, 2022

The "unique" column option is not supported #541

The "unique" column option is not supported #541

Comments

J0WI commented Feb 23, 2021

gwenhael-le-moine commented Feb 23, 2021

arnakazim commented Feb 23, 2021

barti04 commented Feb 24, 2021

pxlkng commented Feb 24, 2021

bertieuk commented Feb 24, 2021

pxlkng commented Feb 24, 2021

snevas commented Mar 10, 2021

mchugh19 commented Mar 11, 2021

Tyil commented Mar 11, 2021 via email

hakunamatata97k commented Mar 15, 2021

localjo commented Mar 15, 2021

localjo commented Mar 15, 2021

oucil commented Mar 16, 2021

k6av commented Mar 17, 2021

tacruc commented Mar 19, 2021

VoOoUoOoV commented Mar 20, 2021 • edited Loading

VoOoUoOoV commented Mar 21, 2021

localjo commented Mar 21, 2021

VoOoUoOoV commented Mar 22, 2021 • edited Loading

tacruc commented Mar 22, 2021

VoOoUoOoV commented Mar 22, 2021

Joshua2504 commented Mar 27, 2021

yuriry commented Mar 27, 2021 • edited Loading

VoOoUoOoV commented Mar 30, 2021

ThatCoffeeGuy commented Apr 4, 2021

gardinenstange commented Apr 18, 2021

lupinehorror commented Apr 18, 2021

Akruidenberg commented Apr 25, 2021

snevas commented Apr 26, 2021

srvoets commented Apr 29, 2021

solmarcus commented May 1, 2021

Redsandro commented May 4, 2021 • edited Loading

debdolph commented May 4, 2021

Redsandro commented May 4, 2021

hobbsecky commented May 9, 2021

saschamander commented May 22, 2021 • edited Loading

gianlucagiacometti commented May 23, 2021

ma-gh commented May 24, 2021

rugk commented May 30, 2021

jjdsec commented Jun 2, 2021

snowphone commented Jun 5, 2021

alehaa commented Jun 6, 2021

tedmarcin commented Jun 7, 2021

AgentCasey commented Jun 23, 2021

tacruc commented Apr 14, 2022

VoOoUoOoV commented Mar 20, 2021 •

edited

Loading

VoOoUoOoV commented Mar 22, 2021 •

edited

Loading

yuriry commented Mar 27, 2021 •

edited

Loading

Redsandro commented May 4, 2021 •

edited

Loading

saschamander commented May 22, 2021 •

edited

Loading