Unable to get Google Integration working

Support intro

Sorry to hear you’re facing problems :slightly_frowning_face:

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:


Or for longer, use three backticks above and below the code snippet:


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 :heart:

Nextcloud version (eg, 20.0.5): 26.0.0
Operating system and version (eg, Ubuntu 20.04): Unraid 6.11.5
Apache or nginx version (eg, Apache 2.4.25): nextcloud:latest
PHP version (eg, 7.4): nextcloud:latest

The issue you are facing:
Google Integration is not downloading my google data. Im running the latest app for it. It allows me to login and it can see the data in google’s cloud. But it does not download. I have been waiting for 12 hours for 210mb

Is this the first time you’ve seen this error? Y:

Steps to replicate it:

  1. Install Google Integration and Setup Google API
  2. The Admin user is unable to import google’s data after authenticating

The output of your Nextcloud log in Admin > Logging:

[integration_google] Warning: Error when creating calendar event "<redacted>" An exception occurred while executing a query: SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect string value: '\xE2' for column `nextcloud`.`oc_calendarobjects_props`.`value` at row 1

GET /apps/integration_google/import-calendar?calId=klucinaken%40gmail.com&calName=klucinaken%40gmail.com&color=%239fe1e7
from by qw3r7yju4n at 2023-04-15T01:48:40+00:00

The output of your config.php file in /path/to/nextcloud (make sure you remove any identifiable information!):

$CONFIG = array (
  'htaccess.RewriteBase' => '/',
  'memcache.local' => '\\OC\\Memcache\\APCu',
  'apps_paths' => 
  array (
    0 => 
    array (
      'path' => '/var/www/html/apps',
      'url' => '/apps',
      'writable' => false,
    1 => 
    array (
      'path' => '/var/www/html/custom_apps',
      'url' => '/custom_apps',
      'writable' => true,
  'instanceid' => 'SECURITYj',
  'passwordsalt' => 'SECURITY',
  'secret' => 'SECURITY',
  'trusted_domains' => 
  array (
    0 => 'my ip:8666',
    1 => 'nextcloud.mydomain.com',
  'datadirectory' => '/var/www/html/data',
  'dbtype' => 'mysql',
  'version' => '',
  'overwrite.cli.url' => 'https://nextcloud.mydomain.com',
  'overwritehost' => 'nextcloud.mydomain.com',
  'overwriteprotocol' => 'https',
  'default_phone_region' => 'US',
  'dbname' => 'nextcloud',
  'dbhost' => 'serverip:3306',
  'dbport' => '',
  'dbtableprefix' => 'oc_',
  'mysql.utf8mb4' => true,
  'dbuser' => 'nextcloud',
  'dbpassword' => 'SECURITY',
  'installed' => true,
  'mail_from_address' => 'SECURITY',
  'mail_smtpmode' => 'smtp',
  'mail_smtpsecure' => 'ssl',
  'mail_smtphost' => 'smtp.gmail.com',
  'mail_smtpauth' => 1,
  'mail_smtpport' => '465',
  'mail_sendmailmode' => 'smtp',
  'mail_domain' => 'gmail.com',
  'mail_smtpname' => 'SECURITY@gmail.com',
  'mail_smtppassword' => 'SECURITY',

The output of your Apache/nginx/system log in /var/log/____:

Not sure where this is.

Output errors in nextcloud.log in /var/www/ or as admin user in top right menu, filtering for errors. Use a pastebin service if necessary.

Not sure where this is.