Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

oc_phonetrack_points crash Nextcloud after update #8768

Closed
ReloadXP opened this issue Mar 10, 2018 · 5 comments
Closed

oc_phonetrack_points crash Nextcloud after update #8768

ReloadXP opened this issue Mar 10, 2018 · 5 comments

Comments

@ReloadXP
Copy link

ReloadXP commented Mar 10, 2018 •
edited
Loading

Обновление до 13.0.0
Doctrine\DBAL\Exception\DriverException: An exception occurred while executing 'ALTER TABLE oc_phonetrack_points ALTER deviceid TYPE INT': SQLSTATE[42804]: Datatype mismatch: 7 ERROR: column "deviceid" cannot be cast automatically to type integer HINT: You might need to specify "USING deviceid::integer".

Подробные журналы
Подготовка к обновлению
Установлен отладочный уровень протоколирования
Включён режим обслуживания
Выполняется обновление схемы базы данных
База данных обновлена
Doctrine\DBAL\Exception\DriverException: An exception occurred while executing 'ALTER TABLE oc_phonetrack_points ALTER deviceid TYPE INT': SQLSTATE[42804]: Datatype mismatch: 7 ERROR: column "deviceid" cannot be cast automatically to type integer HINT: You might need to specify "USING deviceid::integer".
Обновление не удалось. Пожалуйста, сообщите об этой проблеме сообществу Nextcloud.

Operating system:

Web server:

Database: PostgreSQL
PHP version: 7.0

Nextcloud version: 13

Updated from an older Nextcloud: 12

List of activated apps:
sudo -u www-data php occ app:list

Enabled:

  • activity: 2.6.1
  • admin_audit: 1.3.0
  • admin_notifications: 1.0.1
  • audioplayer: 2.2.5
  • bruteforcesettings: 1.0.3
  • comments: 1.3.0
  • dav: 1.4.6
  • drawio: 0.8.9
  • encryption: 2.0.0
  • federatedfilesharing: 1.3.1
  • federation: 1.3.0
  • files: 1.8.0
  • files_downloadactivity: 1.2.0
  • files_pdfviewer: 1.2.0
  • files_sharing: 1.5.0
  • files_texteditor: 2.5.1
  • files_trashbin: 1.3.0
  • files_versions: 1.6.0
  • files_videoplayer: 1.2.0
  • firstrunwizard: 2.2.1
  • gallery: 18.0.0
  • logreader: 2.0.0
  • lookup_server_connector: 1.1.0
  • metadata: 0.6.0
  • nextcloud_announcements: 1.2.0
  • notifications: 2.1.2
  • oauth2: 1.1.0
  • onlyoffice: 1.2.0
  • password_policy: 1.3.0
  • phonetrack: 0.1.1
  • provisioning_api: 1.3.0
  • quota_warning: 1.2.0
  • radio: 0.6.1
  • serverinfo: 1.3.0
  • sharebymail: 1.3.0
  • spreed: 3.1.0
  • survey_client: 1.1.0
  • systemtags: 1.3.0
  • theming: 1.4.1
  • twofactor_backupcodes: 1.2.3
  • updatenotification: 1.3.0
  • workflowengine: 1.3.0
    Disabled:
  • checksum
  • files_clipboard
  • files_external
  • user_external
  • user_ldap

Nextcloud configuration:

Config report 
If you have access to your command line run e.g.:
sudo -u www-data php occ config:list system

{
    "system": {
        "instanceid": "***REMOVED SENSITIVE VALUE***",
        "passwordsalt": "***REMOVED SENSITIVE VALUE***",
        "secret": "***REMOVED SENSITIVE VALUE***",
        "trusted_domains": [
            "192.168.200.214",
        ],
        "trusted_proxy": [
            "192.168.200.251"
        ],
        "forwarded_for_headers": [
            "HTTP_X_FORWARDED",
            "HTTP_FORWARDED_FOR"
        ],
        "datadirectory": "***REMOVED SENSITIVE VALUE***",
        "overwrite.cli.url": "http:\/\/192.168.200.214",
        "dbtype": "pgsql",
        "version": "13.0.0.14",
        "dbname": "***REMOVED SENSITIVE VALUE***",
        "dbhost": "***REMOVED SENSITIVE VALUE***",
        "dbport": "",
        "dbtableprefix": "oc_",
        "dbuser": "***REMOVED SENSITIVE VALUE***",
        "dbpassword": "***REMOVED SENSITIVE VALUE***",
        "installed": true,
        "mail_from_address": "***REMOVED SENSITIVE VALUE***",
        "mail_smtpmode": "smtp",
        "mail_smtpauthtype": "LOGIN",
        "mail_domain": "***REMOVED SENSITIVE VALUE***",
        "mail_smtphost": "***REMOVED SENSITIVE VALUE***",
        "mail_smtpport": "465",
        "mail_smtpauth": 1,
        "mail_smtpname": "***REMOVED SENSITIVE VALUE***",
        "mail_smtppassword": "***REMOVED SENSITIVE VALUE***",
        "mail_smtpsecure": "ssl",
        "memcache.local": "\\OC\\Memcache\\APCu",
        "updater.release.channel": "beta",
        "maintenance": false,
        "data-fingerprint": "28bd7be3fde69f50f1c99fcb8a12526b",
        "updater.secret": "***REMOVED SENSITIVE VALUE***",
        "theme": "",
        "loglevel": 2
    },
    "apps": {
        "activity": {
            "types": "filesystem",
            "enabled": "yes",
            "installed_version": "2.6.1"
        },
        "admin_audit": {
            "types": "logging",
            "enabled": "yes",
            "installed_version": "1.3.0"
        },
        "admin_notifications": {
            "types": "logging",
            "enabled": "yes",
            "installed_version": "1.0.1"
        },
        "audioplayer": {
            "types": "filesystem",
            "enabled": "yes",
            "installed_version": "2.2.5"
        },
        "backgroundjob": {
            "lastjob": "594"
        },
        "bruteforcesettings": {
            "types": "",
            "enabled": "yes",
            "installed_version": "1.0.3"
        },
        "checksum": {
            "enabled": "no",
            "installed_version": "0.3.5",
            "types": "filesystem"
        },
        "comments": {
            "types": "logging",
            "enabled": "yes",
            "installed_version": "1.3.0"
        },
        "core": {
            "installedat": "1507586615.9742",
            "vendor": "nextcloud",
            "public_webdav": "dav\/appinfo\/v1\/publicwebdav.php",
            "public_files": "files_sharing\/public.php",
            "installed.bundles": "[\"CoreBundle\"]",
            "lastupdatedat": "1519986995",
            "encryption_enabled": "yes",
            "default_encryption_module": "OC_DEFAULT_MODULE",
            "updater.secret.created": "1518183244",
            "oc.integritycheck.checker": "[]",
            "shareapi_enforce_expire_date": "no",
            "shareapi_default_expire_date": "no",
            "moveavatarsdone": "yes",
            "previewsCleanedUp": "1",
            "lastupdateResult": "[]",
            "scss.variables": "9342ed3137eeba4a4eac625b93ff9da4",
            "lastcron": "1520698787"
        },
        "dav": {
            "types": "filesystem",
            "enabled": "yes",
            "installed_version": "1.4.6",
            "buildCalendarSearchIndex": "yes"
        },
        "drawio": {
            "types": "filesystem",
            "installed_version": "0.8.9",
            "enabled": "yes",
            "DrawioUrl": "https:\/\/www.draw.io",
            "DrawioXml": "yes",
            "DrawioTheme": "kennedy",
            "DrawioLang": "auto"
        },
        "encryption": {
            "recoveryKeyId": "recoveryKey_34fa9422",
            "recoveryAdminEnabled": "1",
            "publicShareKeyId": "pubShare_34fa9422",
            "installed_version": "2.0.0",
            "masterKeyId": "master_34fa9422",
            "types": "filesystem",
            "enabled": "yes",
            "useMasterKey": "0"
        },
        "federatedfilesharing": {
            "types": "",
            "enabled": "yes",
            "installed_version": "1.3.1"
        },
        "federation": {
            "types": "authentication",
            "enabled": "yes",
            "installed_version": "1.3.0"
        },
        "files": {
            "types": "filesystem",
            "enabled": "yes",
            "cronjob_scan_files": "500",
            "installed_version": "1.8.0"
        },
        "files_clipboard": {
            "enabled": "no",
            "types": "",
            "installed_version": "0.7.1"
        },
        "files_downloadactivity": {
            "types": "filesystem",
            "enabled": "yes",
            "installed_version": "1.2.0"
        },
        "files_pdfviewer": {
            "types": "",
            "enabled": "yes",
            "installed_version": "1.2.0"
        },
        "files_sharing": {
            "types": "filesystem",
            "enabled": "yes",
            "installed_version": "1.5.0"
        },
        "files_texteditor": {
            "types": "",
            "enabled": "yes",
            "installed_version": "2.5.1"
        },
        "files_trashbin": {
            "types": "filesystem",
            "enabled": "yes",
            "installed_version": "1.3.0"
        },
        "files_versions": {
            "types": "filesystem",
            "enabled": "yes",
            "installed_version": "1.6.0"
        },
        "files_videoplayer": {
            "types": "",
            "enabled": "yes",
            "installed_version": "1.2.0"
        },
        "firstrunwizard": {
            "types": "logging",
            "enabled": "yes",
            "installed_version": "2.2.1"
        },
        "gallery": {
            "types": "",
            "enabled": "yes",
            "installed_version": "18.0.0"
        },
        "logreader": {
            "installed_version": "2.0.0",
            "ocsid": "170871",
            "types": "",
            "enabled": "yes"
        },
        "lookup_server_connector": {
            "types": "authentication",
            "enabled": "yes",
            "installed_version": "1.1.0"
        },
        "metadata": {
            "types": "",
            "enabled": "yes",
            "installed_version": "0.6.0"
        },
        "nextcloud_announcements": {
            "types": "logging",
            "enabled": "yes",
            "pub_date": "Sat, 10 Dec 2016 00:00:00 +0100",
            "installed_version": "1.2.0"
        },
        "notifications": {
            "types": "logging",
            "enabled": "yes",
            "installed_version": "2.1.2"
        },
        "oauth2": {
            "types": "authentication",
            "enabled": "yes",
            "installed_version": "1.1.0"
        },
        "onlyoffice": {
            "ocsid": "174798",
            "installed_version": "1.2.0",
            "types": "filesystem",
            "enabled": "yes",
            "DocumentServerUrl": "",
            "DocumentServerInternalUrl": "",
            "StorageUrl": "",
            "jwt_secret": "",
            "defFormats": "{\"docx\":\"true\",\"xlsx\":\"true\",\"pptx\":\"true\",\"ppsx\":\"true\",\"txt\":\"true\",\"csv\":\"false\"}",
            "sameTab": "false",
            "skey": "1519987151143"
        },
        "password_policy": {
            "types": "",
            "enabled": "yes",
            "installed_version": "1.3.0"
        },
        "phonetrack": {
            "types": "",
            "enabled": "yes",
            "installed_version": "0.1.1"
        },
        "provisioning_api": {
            "types": "prevent_group_restriction",
            "enabled": "yes",
            "installed_version": "1.3.0"
        },
        "quota_warning": {
            "enabled": "yes",
            "types": "filesystem",
            "installed_version": "1.2.0"
        },
        "radio": {
            "types": "",
            "enabled": "yes",
            "installed_version": "0.6.1"
        },
        "serverinfo": {
            "types": "",
            "enabled": "yes",
            "installed_version": "1.3.0"
        },
        "sharebymail": {
            "types": "filesystem",
            "enabled": "yes",
            "installed_version": "1.3.0",
            "enforcePasswordProtection": "no"
        },
        "spreed": {
            "types": "prevent_group_restriction",
            "stun_servers": "[\"stun.nextcloud.com:443\"]",
            "enabled": "yes",
            "installed_version": "3.1.0"
        },
        "survey_client": {
            "types": "",
            "enabled": "yes",
            "server": "no",
            "php": "no",
            "database": "no",
            "apps": "no",
            "stats": "no",
            "files_sharing": "no",
            "encryption": "no",
            "installed_version": "1.1.0"
        },
        "systemtags": {
            "types": "logging",
            "enabled": "yes",
            "installed_version": "1.3.0"
        },
        "theming": {
            "types": "logging",
            "enabled": "yes",
            "name": "LUXE-CLOUD",
            "url": "https:\/\/luxe-cloud.com",
            "cachebuster": "2",
            "installed_version": "1.4.1"
        },
        "twofactor_backupcodes": {
            "types": "",
            "enabled": "yes",
            "installed_version": "1.2.3"
        },
        "updatenotification": {
            "types": "",
            "enabled": "yes",
            "update_check_errors": "0",
            "installed_version": "1.3.0"
        },
        "workflowengine": {
            "types": "filesystem",
            "enabled": "yes",
            "installed_version": "1.3.0"
        }
    }
}

Insert your config.php content here. 

<?php
$CONFIG = array (
  'instanceid' => 'XXX',
  'passwordsalt' => 'XXX',
  'secret' => 'XXX',
  'trusted_domains' =>.
  array (
    0 => '192.168.200.214',
    1 => 'XXX',
    2 => 'XXX',
  ),
  'trusted_proxy' =>.
  array (
    0 => '192.168.200.251',
  ),
  'forwarded_for_headers' =>.
  array (
    0 => 'HTTP_X_FORWARDED',
    1 => 'HTTP_FORWARDED_FOR',
  ),
  'datadirectory' => '/var/www/nextcloud/data',
  'overwrite.cli.url' => 'http://192.168.200.214',


**Are you using external storage, if yes which one:** local/smb/sftp/...

**Are you using encryption:** yes

**Are you using an external user-backend, if yes which one:** Webdav.

With access to your command line run e.g.:

sudo -u www-data php occ ldap:show-config
Nextcloud or one of the apps require upgrade - only a limited number of commands are available
You may use your browser or the occ upgrade command to do the upgrade

[Symfony\Component\Console\Exception\CommandNotFoundException]
There are no commands defined in the "ldap" namespace.

root@nextcloud:/var/www/nextcloud#

Client configuration

Browser: Opera 51.0.2830.40

**Operating system:**Windows 10

Logs

Web server error log

Web server error log 
Insert your webserver log here

Nextcloud log (data/nextcloud.log)

+++++

Insert your Nextcloud log here

Browser log

Browser log 
Insert your browser log here, this could for example include:

a) The javascript console log
b) The network log
c) ...
@ReloadXP
Copy link
Author

Если можно - пишите ответ по-русски
Description: Ubuntu 16.04.4 LTS
Release: 16.04
Codename: xenial

@c0fe
Copy link

c0fe commented Mar 10, 2018

Хорошо, послушайте, я понимаю русский (хотя я использую google translate, потому что у меня нет русской клавиатуры), но лучше всего, если вы попытаетесь написать на английском языке, потому что тогда будет больше людей, которые могут вам помочь.

@c0fe
Copy link

c0fe commented Mar 10, 2018

@MorrisJobke I can assist in translation if you wish.

@MorrisJobke
Copy link
Member

Please report this to the app developer: https://gitlab.com/eneiluj/phonetrack-oc

@julien-nc
Copy link
Member

@ReloadXP I found this issue by chance 😉

Let's keep it closed. It's about PhoneTrack and not about Nextcloud's core.

This error happens because i only took care of database migration in the version following this DB structure change. My fault...

If you don't care about loosing your data you can delete all entries of oc_phonetrack_points table and then launch the update again.

If you want to keep your data...then you have to fix the deviceid column value for each entry. The oc_phonetrack_points's deviceid is now the id column of oc_phonetrack_device table.

If you want to talk about that or to get help, post an issue there : https://gitlab.com/eneiluj/phonetrack-oc as @MorrisJobke said.

@nextcloud-bot nextcloud-bot mentioned this issue Aug 3, 2018
Closed
@nextcloud-bot nextcloud-bot mentioned this issue Sep 28, 2018
Closed
@nextcloud-bot nextcloud-bot mentioned this issue Oct 18, 2018
Closed
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
4 participants
@MorrisJobke @c0fe @julien-nc @ReloadXP