Search result found, but after selecting the context of the conversation not loaded

Encourage4525 · June 2, 2023, 10:47pm

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

Some useful links to gather information about your Nextcloud Talk installation:
Information about Signaling server: /index.php/index.php/settings/admin/talk#signaling_server
Information about TURN server: /index.php/settings/admin/talk#turn_server
Information about STUN server: /index.php/settings/admin/talk#stun_server

Nextcloud version (eg, 24.0.1): 26.0.2
Talk Server version (eg, 14.0.2): 0.15.0
Custom Signaling server configured: no
Custom TURN server configured: no
Custom STUN server configured: no

In case the web version of Nextcloud Talk is involved:
Operating system (eg, Windows/Ubuntu/…): Windows10
Browser name and version (eg, Chrome v101): Firefox

In case mobile Nextcloud Talk apps are involved:
Talk iOS version (eg, 14.0.2): latest
Talk Android version (eg, 14.0.2): replace me

The issue you are facing:
After search for message click on the message ant the context of the conversation not loaded

Is this the first time you’ve seen this error? (Y/N):N

Steps to replicate it:

Create conversation
Search for old text (couple months old)
Click on the desired text
the context not loading

I have dedicated database, which gets high load after 1-3 steps.
The querry:

Summary

SELECT `file`.`fileid`, `storage`, `path`, `path_hash`, `file`.`parent`, `file`.`name`, `mimetype`, `mimepart`, `size`, `mtime`, `storage_mtime`, `encrypted`, `etag`, `permissions`, `checksum`, `unencrypted_size` FROM `oc_filecache` `file` LEFT JOIN `oc_vcategory_to_object` `tagmap` ON `file`.`fileid` = `tagmap`.`objid` LEFT JOIN `oc_systemtag_object_mapping` `systemtagmap` ON (`file`.`fileid` = `systemtagmap`.`objectid`) AND (`systemtagmap`.`objecttype` = 'files') LEFT JOIN `oc_vcategory` `tag` ON (`tagmap`.`type` = `tag`.`type`) AND (`tagmap`.`categoryid` = `tag`.`id`) AND (`tag`.`type` = 'files') AND (`tag`.`uid` = 'mate1213') LEFT JOIN `oc_systemtag` `systemtag` ON (`systemtag`.`id` = `systemtagmap`.`systemtagid`) AND (`systemtag`.`visibility` = '1') WHERE ((`tag`.`category`  COLLATE utf8mb4_general_ci LIKE '%ltny%') OR (`systemtag`.`name`  COLLATE utf8mb4_general_ci LIKE '%ltny%')) AND (((`storage` = 3) AND ((`path` = 'files') OR (`path` LIKE 'files/%'))) OR ((`storage` = 2) AND ((`path` = '__groupfolders/2') OR (`path` LIKE '\\_\\_groupfolders/2/%'))) OR (`storage` = 14) OR ((`storage` = 12) AND (`path` = 'files/Talk/IMG_1677071439908.jpg')) OR ((`storage` = 12) AND (`path` = 'files/Talk/IMG_1677271135250.jpg')) OR ((`storage` = 12) AND (`path` = 'files/Talk/IMG_1677271174109.jpg')) OR ((`storage` = 12) AND (`path` = 'files/Talk/Kperny?kp 2023-03-01 123713.jpg')) OR ((`storage` = 12) AND (`path` = 'files/Talk/Kperny?kp 2023-03-01 123713 (2).jpg')) OR ((`storage` = 12) AND (`path` = 'files/Talk/20230302_202525.png')) OR ((`storage` = 12) AND (`path` = 'files/Talk/20230304_182225.png')) OR ((`storage` = 12) AND (`path` = 'files/Talk/Szakdolgozat.docx')) OR ((`storage` = 12) AND (`path` = 'files/Talk/IMG_1678390374014.jpg')) OR ((`storage` = 12) AND (`path` = 'files/Talk/Talk recording from 2023-03-12 21-46-05 (Mt).mp3')) OR ((`storage` = 12) AND (`path` = 'files/Talk/Talk recording from 2023-03-12 21-48-12 (Mt).mp3')) OR ((`storage` = 12) AND (`path` = 'files/Talk/Talk recording from 2023-03-12 21-48-40 (Mt).mp3')) OR ((`storage` = 12) AND (`path` = 'files/Talk/Talk recording from 2023-03-12 21-53-07 (Mt).mp3')) OR ((`storage` = 12) AND (`path` = 'files/Talk/Talk recording from 2023-03-12 21-56-01 (Mt).mp3')) OR ((`storage` = 12) AND (`path` = 'files/Talk/IMG_1678685662683.jpg')) OR ((`storage` = 12) AND (`path` = 'files/Talk/IMG_1678685929986.jpg')) OR ((`storage` = 12) AND (`path` = 'files/Talk/IMG_1678809602545.jpg')) OR ((`storage` = 12) AND (`path` = 'files/Talk/20230316_190638.png')) OR ((`storage` = 12) AND (`path` = 'files/Talk/20230318_125649.png')) OR ((`storage` = 12) AND (`path` = 'files/Talk/20230318_142023.png')) OR ((`storage` = 12) AND (`path` = 'files/Talk/20230318_142434.png')) OR ((`storage` = 12) AND (`path` = 'files/Talk/20776473_818233361687517_6171846073017302724_o.jpg')) OR ((`storage` = 12) AND (`path` = 'files/Talk/20645522_817963335047853_3473667623910496869_o.jpg')) OR ((`storage` = 12) AND (`path` = 'files/Talk/11892338_508506755971662_2446580863344927420_o.jpg')) OR ((`storage` = 12) AND (`path` = 'files/Talk/11875153_508505832638421_260314147597889347_o.jpg')) OR ((`storage` = 12) AND (`path` = 'files/Talk/20230321_174240.png')) OR ((`storage` = 12) AND (`path` = 'files/Talk/20230323_230349.png')) OR ((`storage` = 12) AND (`path` = 'files/Talk/Kltsgtbla.xlsx')) OR ((`storage` = 12) AND (`path` = 'files/Talk/IMG_1541.jpg')) OR ((`storage` = 12) AND (`path` = 'files/Talk/IMG_1680740129536.jpg')) OR ((`storage` = 12) AND (`path` = 'files/Talk/IMG_1680778960068.jpg')) OR ((`storage` = 12) AND (`path` = 'files/Talk/IMG_1680886757694.jpg')) OR ((`storage` = 12) AND (`path` = 'files/Talk/20230407_214807.png')) OR ((`storage` = 12) AND (`path` = 'files/Talk/20230407_215144.png')) OR ((`storage` = 12) AND (`path` = 'files/Talk/IMG_1680989040306.jpg')) OR ((`storage` = 12) AND (`path` = 'files/Talk/IMG_1680989062507.jpg')) OR ((`storage` = 12) AND (`path` = 'files/Talk/20230417_223224.png')) OR ((`storage` = 12) AND (`path` = 'files/Talk/IMG_1681795027319.jpg')) OR ((`storage` = 12) AND (`path` = 'files/Talk/IMG_1590.jpg')) OR ((`storage` = 12) AND (`path` = 'files/Talk/Tomori Pl A bankjog kapcsolata a szellemi alkotsok jogval 2023-03-21 PPKE_handout.pdf')) OR ((`storage` = 12) AND (`path` = 'files/Talk/20230422_081729.png')) OR ((`storage` = 12) AND (`path` = 'files/Talk/IMG_1682178495020.jpg')) OR ((`storage` = 12) AND (`path` = 'files/Talk/IMG_1682178933963.jpg')) OR ((`storage` = 12) AND (`path` = 'files/Talk/IMG_1682237907342.jpg')) OR ((`storage` = 12) AND (`path` = 'files/Talk/20230423_112446.png')) OR ((`storage` = 12) AND (`path` = 'files/Talk/IMG_1682400128477.jpg')) OR ((`storage` = 12) AND (`path` = 'files/Talk/IMG_1682400240293.jpg')) OR ((`storage` = 12) AND (`path` = 'files/Talk/IMG_1682400267982.jpg')) OR ((`storage` = 12) AND (`path` = 'files/Talk/IMG_1682435817385.jpg')) OR ((`storage` = 12) AND (`path` = 'files/Talk/IMG_1682757625142.jpg')) OR ((`storage` = 12) AND (`path` = 'files/Talk/IMG_1682841648211.jpg')) OR ((`storage` = 12) AND (`path` = 'files/Talk/IMG_1682928135106.jpg')) OR ((`storage` = 12) AND (`path` = 'files/Talk/IMG_1601.jpg')) OR ((`storage` = 12) AND (`path` = 'files/Talk/IMG_1683230796280.jpg')) OR ((`storage` = 12) AND (`path` = 'files/Talk/IMG_1683230849710.jpg')) OR ((`storage` = 12) AND (`path` = 'files/Talk/IMG_1683231574912.jpg')) OR ((`storage` = 12) AND (`path` = 'files/Talk/IMG_1683231592368.jpg')) OR ((`storage` = 12) AND (`path` = 'files/Talk/IMG_1683302558828.jpg')) OR ((`storage` = 12) AND (`path` = 'files/Talk/IMG_1683307973439.jpg')) OR ((`storage` = 12) AND (`path` = 'files/Talk/Talk recording from 2023-05-06 12-21-07 (Mt Zslya).mp3')) OR ((`storage` = 12) AND (`path` = 'files/Talk/Talk recording from 2023-05-06 12-21-34 (Mt Zslya).mp3')) OR ((`storage` = 12) AND (`path` = 'files/Talk/Talk recording from 2023-05-06 12-24-22 (Mt Zslya).mp3')) OR ((`storage` = 12) AND (`path` = 'files/Talk/Talk recording from 2023-05-06 12-31-00 (Mt Zslya).mp3')) OR ((`storage` = 12) AND (`path` = 'files/Talk/IMG_1683369267090.jpg')) OR ((`storage` = 12) AND (`path` = 'files/Talk/IMG_1683373886590.jpg')) OR ((`storage` = 12) AND (`path` = 'files/Talk/IMG_1683374087686.jpg')) OR ((`storage` = 12) AND (`path` = 'files/Talk/IMG_1683405900626.jpg')) OR ((`storage` = 12) AND (`path` = 'files/Talk/IMG_1683618248563.jpg')) OR ((`storage` = 12) AND (`path` = 'files/Talk/IMG_1683784038273.jpg')) OR ((`storage` = 12) AND (`path` = 'files/Talk/IMG_1684258366765.jpg')) OR ((`storage` = 12) AND (`path` = 'files/Talk/IMG_1640.jpg')) OR ((`storage` = 12) AND (`path` = 'files/Talk/IMG_1641.jpg')) OR ((`storage` = 12) AND (`path` = 'files/Talk/IMG_1684388506230.jpg')) OR ((`storage` = 12) AND (`path` = 'files/Talk/20230518_090202.png')) OR ((`storage` = 12) AND (`path` = 'files/Talk/IMG_1684394510749.jpg')) OR ((`storage` = 12) AND (`path` = 'files/Talk/20230518_113817.png')) OR ((`storage` = 12) AND (`path` = 'files/Talk/IMG_1684441315369.jpg')) OR ((`storage` = 12) AND (`path` = 'files/Talk/Talk recording from 2023-05-19 15-14-29 (Mt Zslya).mp3')) OR ((`storage` = 12) AND (`path` = 'files/Talk/Talk recording from 2023-05-19 15-15-30 (Mt Zslya).mp3')) OR ((`storage` = 12) AND (`path` = 'files/Talk/Talk recording from 2023-05-19 15-16-14 (Mt Zslya).mp3')) OR ((`storage` = 12) AND (`path` = 'files/Talk/IMG_1684511342887.jpg')) OR ((`storage` = 12) AND (`path` = 'files/Talk/IMG_1684516482343.jpg')) OR ((`storage` = 12) AND (`path` = 'files/Talk/IMG_1684700920790.jpg')) OR ((`storage` = 12) AND (`path` = 'files/Talk/IMG_1684703336325.jpg')) OR ((`storage` = 12) AND (`path` = 'files/Talk/IMG_1684703365555.jpg')) OR ((`storage` = 12) AND (`path` = 'files/Talk/IMG_1684919775094.jpg')) OR ((`storage` = 12) AND (`path` = 'files/Talk/IMG_1656.jpg')) OR ((`storage` = 12) AND (`path` = 'files/Talk/IMG_1684942118100.jpg')) OR ((`storage` = 12) AND (`path` = 'files/Talk/IMG_1684942152935.jpg')) OR ((`storage` = 12) AND (`path` = 'files/Talk/IMG_1684942284973.jpg')) OR ((`storage` = 12) AND (`path` = 'files/Talk/VID_20230524_195341.mp4')) OR ((`storage` = 12) AND (`path` = 'files/Talk/IMG_1685094723531.jpg')) OR ((`storage` = 12) AND (`path` = 'files/Talk/IMG_1685096093188.jpg')) OR ((`storage` = 12) AND (`path` = 'files/Talk/IMG_1685096113111.jpg')) OR ((`storage` = 12) AND (`path` = 'files/Talk/IMG_1685098853745.jpg')) OR ((`storage` = 12) AND (`path` = 'files/Talk/IMG_1673.jpg')) OR ((`storage` = 12) AND (`path` = 'files/Talk/IMG_1680.jpg')) OR ((`storage` = 12) AND (`path` = 'files/Talk/IMG_1679.jpg')) OR ((`storage` = 12) AND (`path` = 'files/Talk/IMG_1678.jpg')) OR ((`storage` = 12) AND (`path` = 'files/Talk/IMG_1685273096139.jpg')) OR ((`storage` = 12) AND (`path` = 'files/Talk/IMG_1685273118496.jpg')) OR ((`storage` = 12) AND (`path` = 'files/Talk/336636349_896710361441917_3489625373991329392_n.png')) OR ((`storage` = 12) AND (`path` = 'files/Talk/IMG_1685349358115.jpg')) OR ((`storage` = 12) AND (`path` = 'files/Talk/IMG_1698.jpg')) OR ((`storage` = 12) AND (`path` = 'files/Talk/IMG_1685441491412.jpg')) OR ((`storage` = 12) AND (`path` = 'files/Talk/IMG_1685556907576.jpg')) OR ((`storage` = 12) AND (`path` = 'files/Talk/IMG_1685629052477.jpg')) OR ((`storage` = 12) AND (`path` = 'files/Talk/IMG_1685629068431.jpg'))) ORDER BY `mtime` + '0' desc LIMIT 5