Contacts app doesn't show anything after Upgrade to NC 11.0 #66
Comments
|
Sorry for the delay, I'm moving my office. |
|
Any log in the console? |
|
In Firefox Developer Panel / Console I see CSS warnings, but no JS warnings/errors at all. Unbekannte Eigenschaft 'zoom'. Deklaration ignoriert. select2.css:9:8 |
|
Can I do anything else? |
|
Do you have access to your database? Could you send an export of oc_cards to [email protected]? I can't really debug remotely, and since you don't have any errors, it seems to be the best way (like I did in #53 with op) |
|
Okay, so I tried importing your data with the app and this literally took like 15 mins.. After importing you rdata works fine. Please use your dump file and import it directly into the app file. Should do the trick. :) |
|
I restored oc_cards via ownbackup and get the error below. Don't know what to do next. |
|
No, I meant import it from the import function of the contacts app :) |
|
I can't, since my contacts app is not responsive at all (idle only). How to reset it? |
|
Create a new addressbook and delete the old ones. |
|
I cannot access the app settings! So I cannot delete any address book (IF it is still there). |
|
This is strange. Could your remove it from your database directly? |
|
Okay, I just deleted my old addressbook and I found out what is your issue.
|
|
When you click the Settings in the bottom left, what's in there? |
|
Sure, how? Could you provide the correct SQL statements? This is what I see: I can enter a new addressbok name, but cannot create it. |
|
You can't create a new addressbook? When clicking the arrow, do you get a failed request in your network debug tab? |
|
I did try that of course, but nothing happens (no visible feedback). Would it help to use the master app? Or should I add some debugging somewhere in the code? |
|
I need to see if the dav core is blocking the creation. :) |
|
No, only when opening settings, I see network activity. And (periodically) notifications (not related to klicking the right-arrow): BTW: Would it help to uninstall and reinstall the app? I guess not since the data in the DB is not modified, is it? |
|
You could try the latest master release (don't forget to compile it). |
|
No, Enter also does not do anything. |
|
See #91 :) |
|
thumbup - so if I understand the process correctly, I must wait for review before I could download master. Could you send me a compiled version to test/verify? |
|
Added a tar.gz for testing :) |
|
I moved app/contacts, extracted .tar.gz, copied it from contacts-73 to contacts, checked ownership and permissions (was OK), shift-reloaded contacts, tried to add an addressbook. Same as before! |
|
Could you try again the network tab? ps: for easy check, use the "xhr" filter on the network debug tab. 😉 |
|
|
|
You got indeed an error 500. Mind to check your logs? 😄 |
|
Sorry, should have done that right away. Since it contains more personal data, I sent it to protonet. |
|
Perfect! |
|
Do you mean these? I use the latest ownbackup copy - OK? oc_cards/structure.xml: oc_addressbooks/structure.xml |
|
This seems to be the problem. You need to fix your database. CREATE TABLE `oc_addressbooks` (
`id` bigint(20) UNSIGNED NOT NULL,
`principaluri` varchar(255) COLLATE utf8_bin DEFAULT NULL,
`displayname` varchar(255) COLLATE utf8_bin DEFAULT NULL,
`uri` varchar(255) COLLATE utf8_bin DEFAULT NULL,
`description` varchar(255) COLLATE utf8_bin DEFAULT NULL,
`synctoken` int(10) UNSIGNED NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
CREATE TABLE `oc_cards` (
`id` bigint(20) UNSIGNED NOT NULL,
`addressbookid` int(11) NOT NULL DEFAULT '0',
`carddata` longblob,
`uri` varchar(255) COLLATE utf8_bin DEFAULT NULL,
`lastmodified` bigint(20) UNSIGNED DEFAULT NULL,
`etag` varchar(32) COLLATE utf8_bin DEFAULT NULL,
`size` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; |
|
OK, so I need to DROP tables before that, right? Anything else I must do prior to importing cards via the app? |
|
The app can easily become unresponsive (I opened an issue about that) |
|
Dropping and creating tables allows me to create a new addressbook. But if I import cards, they aren't associated to any addressbook, even if there's only one. So, I cannot delete these cards by deleting the addressbook (after adding a second one). There seems to be more corrupt. Would you recommend to setup from scratch? |
SELECT * FROM `oc_addressbooks`;
+----+--------------------------+-------------+----------+-----------------------------------------------------------+-----------+
| id | principaluri | displayname | uri | description | synctoken |
+----+--------------------------+-------------+----------+-----------------------------------------------------------+-----------+
| 2 | principals/system/system | system | system | System addressbook which holds all users of this instance | 27 |
| 23 | principals/users/admin | Contacts | Contacts | NULL | 1 |
+----+--------------------------+-------------+----------+-----------------------------------------------------------+-----------+Get your addressbook id (here 23) and then update your cards: UPDATE `oc_cards` SET `addressbookid`=YOURID |
|
@nursoda Can we close? |
|
Sorry I did not respond earlier. I had no time to solve this out since I see similar issues in multiple NC instances each supporting multiple users and NC does not provide tools or documentation that allows me to fix things myself. Due to time constraints, I did not try your last recommendation. Yet I will one day in the near future. Sure, you may close the bug, I'll ask to reopen if necessary. But does label "invalid" suggest that this bug that was not caused by software but by me. If so, I'm irritated, since all I did was to upgrade from NC10 to NC11. Before the upgrade, all was fine, after the upgrade, I had trouble getting things back to a usable state. |
|
Well, this isn't related to the contacts app, this is why I added the invalid label. |
|
OK, Thanks. |
|
I'm closing this, so if you got any more issues, let me know :) |
|
I will. |
Since you state "migration issues belong in the server repo", but also ask for "Updated from an older Nextcloud or fresh install", I'm unsure if this should be here or in server. Please point me there if you feel it should be elsewhere.
I upgraded three NC installations from 10.0.2 to 11.0 and all went smooth. In two of them, all apps work flawless, in one the calendar app no longer works at all: It no longer shows any contacts in the web interface (idles, see screenshot), and clients (DAVdroid, CardDAV) show error "not found".
Any hint appreciated on how to recover from this (preferrably without loosing contact data), or how to reset.
These seem to be a similar issues:
Notes:
System parameters
OS: debian stable, Web server: apache2, Database: MySQL 5.5, PHP 5.6, Nextcloud 11.0.0.10, Contacts: 1.5.2, UPDATED FROM 10.0.0.2, Signing: No errors in Admin check, /settings/integrity/failed yields "No errors have been found.", NOT using external storage, encryption or external user-backend.
List of activated apps:
Enabled:
Disabled:
The content of config/config.php:
{
"system": {
"instanceid": "",
"trashbin_retention_obligation": "auto,90",
"versions_retention_obligation": "90,auto",
"memcache.local": "\OC\Memcache\APCu",
"memcache.locking": "\OC\Memcache\Redis",
"filelocking.enabled": "true",
"redis": {
"host": "localhost",
"port": 6379,
"timeout": 0
},
"passwordsalt": "REMOVED SENSITIVE VALUE",
"secret": "REMOVED SENSITIVE VALUE",
"trusted_domains": [
""
],
"datadirectory": "/",
"overwrite.cli.url": "https:///cloud",
"dbtype": "mysql",
"version": "11.0.0.10",
"dbname": "",
"dbhost": "localhost",
"dbport": "",
"dbtableprefix": "oc_",
"dbuser": "REMOVED SENSITIVE VALUE",
"dbpassword": "REMOVED SENSITIVE VALUE",
"logtimezone": "Europe/Berlin",
"installed": true,
"mail_from_address": "",
"mail_smtpmode": "php",
"mail_domain": "",
"defaultapp": "calendar",
"maintenance": false,
"loglevel": 2,
"theme": "",
"updater.release.channel": "stable"
}
}
Client configuration
Browser: Firefox 50, OS: ApricityOS, CardDAV-clients: DAVdroid, CardDAV.
Logs
Web server error log
- [25/Dec/2016:00:44:29 +0100] "PROPFIND /cloud/remote.php/webdav/ HTTP/1.1" 207 2231 "-" "Mozilla/5.0 (Linux) mirall/2.2.4"
- - [25/Dec/2016:00:44:34 +0100] "GET /cloud/ocs/v2.php/apps/notifications/api/v2/notifications HTTP/1.1" 200 913 "-" "Mozilla/5.0 (X11; Linux x86_64; rv:50.0) Gecko/20100101 Firefox/50.0"
Nextcloud log (data/nextcloud.log)
{"reqId":"","remoteAddr":"","app":"core","message":"Login failed: '' (Remote IP: '')","level":2,"time":"2016-12-25T01:25:59+01:00","method":"PROPFIND","url":"/cloud/remote.php/webdav/","user":"--","version":"11.0.0.10"}
{"reqId":"","remoteAddr":"","app":"core","message":"Login failed: '' (Remote IP: '')","level":2,"time":"2016-12-25T01:25:59+01:00","method":"GET","url":"/cloud/ocs/v2.php/apps/notifications/api/v1/notifications?format=json","user":"--","version":"11.0.0.10"}
Browser JS log
Sending message that cannot be cloned. Are you trying to send an XPCOM object? MessageChannel.jsm:504:4
JQMIGRATE: Migrate is installed, version 1.4.0 jquery-migrate.min.js:2:542
Sending message that cannot be cloned. Are you trying to send an XPCOM object? MessageChannel.jsm:504:4
The text was updated successfully, but these errors were encountered: