Question

Has anyone had the "tags" column be inaccurate after an upgrade? Like have documents that have tags show as not having them in the "tags" column? If so, how did you go about fixing the issue?

Laserfiche

Updated September 11, 2014

asked on September 11, 2014

I have a customer that has done an update and has noticed that documents that have tags show in the "tags" column as not having them. But if he changes a tag or adds one, the column then displays correctly from then on. So he's wondering if there is a good way to get all the older documents updated so they display properly.

0 0

Answer

APPROVED ANSWER

replied on September 11, 2014 • Show version history

The upgrade should have handled this, but here is the SQL you can use to restore the column:

-- Clear the tag flags
update toc set toc_flags = toc_flags & ~(524288 | 1048576)

-- Set the 'has info tag' flag
update toc set toc_flags = toc_flags | 524288 
where tocid in (select tocid from entry_tag where tag_id in 
(select tag_id from tag where is_secure = 0))

-- Set the 'has security tag' flag
update toc set toc_flags = toc_flags | 1048576 
where tocid in (select tocid from entry_tag where tag_id in 
(select tag_id from tag where is_secure = 1))

Please back up your database before running this, just to be safe.

0 0

Replies

replied on September 11, 2014

Thank you so much for the response!

0 0

You are not allowed to follow up in this post.

Question

Question

Has anyone had the "tags" column be inaccurate after an upgrade? Like have documents that have tags show as not having them in the "tags" column? If so, how did you go about fixing the issue?

Answer

Replies

Sign in to reply to this post.