Support intro
Sorry to hear you’re facing problems
help.nextcloud.com is for home/non-enterprise users. If you’re running a business, paid support can be accessed via portal.nextcloud.com where we can ensure your business keeps running smoothly.
In order to help you as quickly as possible, before clicking Create Topic please provide as much of the below as you can. Feel free to use a pastebin service for logs, otherwise either indent short log examples with four spaces:
example
Or for longer, use three backticks above and below the code snippet:
longer
example
here
Some or all of the below information will be requested if it isn’t supplied; for fastest response please provide as much as you can
Nextcloud version (eg, 18.0.2): 19.0.3
Operating system and version (eg, Ubuntu 20.04): Ubuntu 20.04
Apache or nginx version (eg, Apache 2.4.25): 2.4.41
PHP version (eg, 7.1): 7.4.3
The issue you are facing:
Hello
I have a new server with Ubuntu 20.04 instead of 16.04. I installed Nextcloud and then I put my old data and database to this new server.
Everything seems running, but then I tried to show contacts and photos on the map app. Nothing was working. This I good, because now I know there is a problem with the database. I removed old database, and created new one:
CREATE DATABASE IF NOT EXISTS nextcloud CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
GRANT ALL PRIVILEGES on nextcloud.* to nextcloud’@localhost;
FLUSH privileges;
exit
mysql -u nextcloud -p nextcloud < /opt/backup/nextcloud/nextcloud-sqlbkp_date +"%Y%m%d"
.bak
But still the problem:
An exception occurred
while executing
'INSERT INTO
oc_maps_address_geo
SQLSTATE[22001]:
String data, right
truncated: 1406 Data
too long for column
‘adr’ at row 1 at
…/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php
line 106
I used the whole day to find out what the problem is, I need help, please.
Is this the first time you’ve seen this error? (Y/N): yes
Steps to replicate it:
Not sure
The output of your Nextcloud log in Admin > Logging:
Error index Doctrine\DBAL\Exception\DriverException: 2020-09-25T16:06:31+00:00
An exception occurred
while executing
'INSERT INTO
`oc_maps_address_geo`
(`adr`, `adr_norm`,
`object_uri`, `lat`,
`lng`, `looked_up`)
VALUES(?, ?, ?, ?, ?,
?)' with params [";;7
An den
Wasenwiesen;Sch\u00e4binn
Haue;;20555;DE
a
Kq==",
"581118c1-3cf7-4748-84d0-4d95013c3a66.vcf",
null, null, false]:
SQLSTATE[22001]:
String data, right
truncated: 1406 Data
too long for column
'adr' at row 1 at
.../lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php
line 106
0. .../DBALException.php line 169
Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException(
)
1. .../DBALException.php line 145
Doctrine\DBAL\DBALException::wrapException(
)
2. .../Connection.php line 1063
Doctrine\DBAL\DBALException::driverExceptionDuringQuery(
)
3. .../Connection.php line 214
Doctrine\DBAL\Connection->executeUpdate(
)
4. .../QueryBuilder.php line 203
OC\DB\Connection->executeUpdate(
)
5. .../QueryBuilder.php line 216
Doctrine\DBAL\Query\QueryBuilder->execute(
)
6. .../AddressService.php line 277
OC\DB\QueryBuilder\QueryBuilder->execute(
)
7. .../AddressService.php line 110
OCA\Maps\Service\AddressService->scheduleForLookup(
)
8. .../AddressService.php line 58
OCA\Maps\Service\AddressService->lookupAddress(
)
9. .../ContactsController.php line 92
OCA\Maps\Service\AddressService->addressToGeo(
)
10. .../Dispatcher.php line 170
OCA\Maps\Controller\ContactsController->getContacts(
)
11. .../Dispatcher.php line 100
OC\AppFramework\Http\Dispatcher->executeController(
)
12. .../App.php line 137
OC\AppFramework\Http\Dispatcher->dispatch(
)
13. .../RouteActionHandler.php line 47
OC\AppFramework\App::main(
)
14. <<closure>>
OC\AppFramework\Routing\RouteActionHandler->__invoke(
)
15. .../Router.php line 297
call_user_func(
)
16. .../base.php line 1012
OC\Route\Router->match(
)
17. index.php line 37
OC::handleRequest(
)
Caused by Doctrine\DBAL\Driver\PDOException:
SQLSTATE[22001]:
String data, right
truncated: 1406 Data
too long for column
'adr' at row 1 at
.../dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php
line 119
0. .../Connection.php line 1054
Doctrine\DBAL\Driver\PDOStatement->execute(
)
1. .../Connection.php line 214
Doctrine\DBAL\Connection->executeUpdate(
)
2. .../QueryBuilder.php line 203
OC\DB\Connection->executeUpdate(
)
3. .../QueryBuilder.php line 216
Doctrine\DBAL\Query\QueryBuilder->execute(
)
4. .../AddressService.php line 277
OC\DB\QueryBuilder\QueryBuilder->execute(
)
5. .../AddressService.php line 110
OCA\Maps\Service\AddressService->scheduleForLookup(
)
6. .../AddressService.php line 58
OCA\Maps\Service\AddressService->lookupAddress(
)
7. .../ContactsController.php line 92
OCA\Maps\Service\AddressService->addressToGeo(
)
8. .../Dispatcher.php line 170
OCA\Maps\Controller\ContactsController->getContacts(
)
9. .../Dispatcher.php line 100
OC\AppFramework\Http\Dispatcher->executeController(
)
10. .../App.php line 137
OC\AppFramework\Http\Dispatcher->dispatch(
)
11. .../RouteActionHandler.php line 47
OC\AppFramework\App::main(
)
12. <<closure>>
OC\AppFramework\Routing\RouteActionHandler->__invoke(
)
13. .../Router.php line 297
call_user_func(
)
14. .../base.php line 1012
OC\Route\Router->match(
)
15. index.php line 37
OC::handleRequest(
)
Caused by PDOException:
SQLSTATE[22001]:
String data, right
truncated: 1406 Data
too long for column
'adr' at row 1 at
.../dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php
line 117
0. .../PDOStatement.php line 117
PDOStatement->execute(
)
1. .../Connection.php line 1054
Doctrine\DBAL\Driver\PDOStatement->execute(
)
2. .../Connection.php line 214
Doctrine\DBAL\Connection->executeUpdate(
)
3. .../QueryBuilder.php line 203
OC\DB\Connection->executeUpdate(
)
4. .../QueryBuilder.php line 216
Doctrine\DBAL\Query\QueryBuilder->execute(
)
5. .../AddressService.php line 277
OC\DB\QueryBuilder\QueryBuilder->execute(
)
6. .../AddressService.php line 110
OCA\Maps\Service\AddressService->scheduleForLookup(
)
7. .../AddressService.php line 58
OCA\Maps\Service\AddressService->lookupAddress(
)
8. .../ContactsController.php line 92
OCA\Maps\Service\AddressService->addressToGeo(
)
9. .../Dispatcher.php line 170
OCA\Maps\Controller\ContactsController->getContacts(
)
10. .../Dispatcher.php line 100
OC\AppFramework\Http\Dispatcher->executeController(
)
11. .../App.php line 137
OC\AppFramework\Http\Dispatcher->dispatch(
)
12. .../RouteActionHandler.php line 47
OC\AppFramework\App::main(
)
13. <<closure>>
OC\AppFramework\Routing\RouteActionHandler->__invoke(
)
14. .../Router.php line 297
call_user_func(
)
15. .../base.php line 1012
OC\Route\Router->match(
)
16. index.php line 37
OC::handleRequest(
)
Debug maps Externally looked 2020-09-25T16:06:31+00:00
failed
Error PHP implode(): Invalid 2020-09-25T16:06:31+00:00
arguments passed at
/var/www/nextcloud/apps/logreader/lib/Log/Formatter.php#73
Error PHP array_map(): Expected 2020-09-25T16:06:31+00:00
parameter 2 to be an
array, null given at
/var/www/nextcloud/apps/logreader/lib/Log/Formatter.php#73
Error PHP implode(): Invalid 2020-09-25T16:06:31+00:00
arguments passed at
/var/www/nextcloud/apps/logreader/lib/Log/Formatter.php#64
Error PHP array_map(): Expected 2020-09-25T16:06:31+00:00
parameter 2 to be an
array, null given at
/var/www/nextcloud/apps/logreader/lib/Log/Formatter.php#62
Error PHP Undefined index: args 2020-09-25T16:06:31+00:00
at
/var/www/nextcloud/apps/logreader/lib/Log/Formatter.php#62
Error PHP implode(): Invalid 2020-09-25T16:06:31+00:00
arguments passed at
/var/www/nextcloud/apps/logreader/lib/Log/Formatter.php#73
Error PHP array_map(): Expected 2020-09-25T16:06:31+00:00
parameter 2 to be an
array, null given at
/var/www/nextcloud/apps/logreader/lib/Log/Formatter.php#73
Error PHP implode(): Invalid 2020-09-25T16:06:31+00:00
arguments passed at
/var/www/nextcloud/apps/logreader/lib/Log/Formatter.php#64
Error PHP array_map(): Expected 2020-09-25T16:06:31+00:00
parameter 2 to be an
array, null given at
/var/www/nextcloud/apps/logreader/lib/Log/Formatter.php#62
Error PHP Undefined index: args 2020-09-25T16:06:31+00:00
at
/var/www/nextcloud/apps/logreader/lib/Log/Formatter.php#62
The output of your config.php file in /path/to/nextcloud
(make sure you remove any identifiable information!):
GNU nano 4.8 /var/www/nextcloud/config/config.php
<?php
$CONFIG = array (
'instanceid' => '',
'passwordsalt' => 'V',
'secret' => '',
'trusted_domains' =>
array (
0 => 'lll.de',
),
'datadirectory' => '/var/www/nextcloud/data',
'dbtype' => 'mysql',
'version' => '19.0.3.1',
'overwrite.cli.url' => 'http://lll.de/nextcloud',
'dbname' => 'nextcloud',
'dbhost' => 'localhost',
'dbport' => '',
'dbtableprefix' => 'oc_',
'mysql.utf8mb4' => true,
'dbuser' => 'nextcloud',
'dbpassword' => '##',
'installed' => true,
'logtimezone' => 'UTC',
'memcache.distributed' => '\\OC\\Memcache\\Redis',
'memcache.local' => '\\OC\\Memcache\\Redis',
'memcache.locking' => '\\OC\\Memcache\\Redis',
'redis' =>
array (
'host' => 'localhost',
'port' => 6379,
),
'maintenance' => false,
'loglevel' => 0,
'theme' => '',
'updater.release.channel' => 'stable',
);