[webmaster74]

As the mod does NOT offer to affect all posts or a group of posts automatically and requires that you manually enter [LOCK] and [/LOCK] before and after content that you wish to hide till click in every single post, I am trying to find a way to concatenate the pagetext in post in order to add the LOCK tag to every FIRST post of every topic.

I would appreciate your help fixing this one line.

UPDATE post SET pagetext =CONCAT('[lock]', pagetext,'[/lock]') WHERE postid =(Select firstpostid from dbname_vb.thread) ;

But when I try the substatement,
SELECT post WHERE postid =(Select firstpostid from dbname_vb.thread)
I get :
#1242 - Subquery returns more than 1 row
it must look in the thread table, where there are thousands of rows...

Please help