Fresh Debian install under Nginx (NextCloud 21.0.0.18), everything flawless, until I just tried to install “Maps” app. The application has downloaded, but I get the following error when attempting to enable it:
The “unique” column option is not supported."
The following screenie shows what I’m looking at I’m wondering whether I need to add a column or something in MariaDB?
Any assistance, your comments, suggestions, would be most appreciated
j-ed
March 24, 2021, 9:06am
2
The problem has already been reported and a workaround seems to exist too:
opened 01:32AM - 23 Feb 21 UTC
closed 10:35AM - 14 Apr 22 UTC
bug
Error: Doctrine\DBAL\Schema\Exception\UnknownColumnOption: The "unique" column o… ption is not supported.
<details><summary>details</summary>
```
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()
```
</details>
odea
April 5, 2021, 8:20am
3
Hi,
the problem remains for some of us. After commenting “‘unique’ => true,” I am still unable to install maps and now have this error :
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
The issue in NC21 here
Server version: Apache/2.4.41-4ubuntu3.1
PHP 7.4.3 (cli) (built: Oct 6 2020 15:47:56) ( NTS )
Nexcloud version: 21
Database: MariaDB 1:10.3.25-0ubuntu0.20.04.1
Where did you install Nextcloud from: Source
j-ed
April 5, 2021, 8:42am
4
As long as the status of the mentioned issue ticket isn’t changed from “Open” to “Closed ” you cannot expect to see that issue fixed in the app and have to live with the workaround
odea
April 5, 2021, 8:42am
5
FYI, I removed the app and reinstalled it and it worked.
1 Like
Hello,
I’ve a Netxcloud 21.0.1 and Maps don’t installed. with the same error ‘unique’.
Getting the same error, and the workaround suggested in the bug report doesn’t work.
It’s pretty pathetic If this is someone’s idea of a featured app. At least remove that until this is fixed.
Same here with NC 21.0.2
Would love to use the maps app.
Ubuntu 20.04
Apache
MySQL 8.0.25
PHP 7.4.3