Bryan at 01:01, 10 August 2022

2022-08-10T01:01:48Z

Bryan: select * from oc_share where id = 247;

2022-08-09T23:45:24Z

select * from oc_share where id = 247;

New page

Next cloud info.

If you want to have a custom timeout (override) on a public share link.
# find the share id in the oc_share table
select * from oc_share where id = 247;
# update it to some date in the future
update oc_share SET expiration = '2100-01-01' WHERE id = 247;

If you want to change the share URL, you can make the token custom up to 32 char
# find the share id in the oc_share table
select * from oc_share where id = 247;
# set the token ID, but ensure it's unique!
update oc_share SET token = 'incoming-files' WHERE id = 247;

← Older revision		Revision as of 01:01, 10 August 2022
Line 12:		Line 12:
	# set the token ID, but ensure it's unique!		# set the token ID, but ensure it's unique!
	update oc_share SET token = 'incoming-files' WHERE id = 247;		update oc_share SET token = 'incoming-files' WHERE id = 247;
		+
		+	Nextcloud talk/chat. Some times you need delete coments or edit them. This is not allowed in the client for old messages. This can be done in the db
		+
		+	from the /call/<token> take the <token> and use it to find the chat ID
		+	select oc_comments.id, actor_id,creation_timestamp,message from oc_talk_rooms INNER JOIN oc_comments on oc_talk_rooms.id = oc_comments.object_id where token = '<token>';
		+	# then take the oc_comments.id of the message ton confirm it
		+	select * from oc_comments where id = 307;
		+	# now update it or set it to '' to delete it
		+	update oc_comments SET message = 'NEW MESSAGE HERE' WHERE id = 307;

Nextcloud - Revision history

Bryan at 01:01, 10 August 2022

Bryan: select * from oc_share where id = 247;