help in sql query

[fangweile]

I recently updated my tp to the latest version and i have a problem referred to this link
http://www.tinyportal.net/index.php?topic=34573.0

Now i want to run a sql query in phpmyadmin updating all my articles about its panel viewing options.
I want to uncheck this option "Display rightblocks" in all of my articles. I know that it can be achieved thru sql query and I really don't know how.

Any help is gladly appreciated
Thanks in advance.

[IchBin]

Make a backup before you do anything!

Make sure you substitute smf_ in the table name if you have a different prefix.

Code Select Expand

update `smf_tp_articles` set options = replace(options, ',rblock,rblockwidth,', ',rblockwidth,')

This should update all articles to remove the right block setting.

[fangweile]

thanks a lot IchBin, it works great.

[fangweile]

hello again,

I don't know what happen but when i viewed my articles today, it is showing the right block again.
I tried to run the sql query again but still the right blocks is showing.

thanks in advance

[IchBin]

And if you go into the article is the right block option turned on? Does it turn off if you uncheck the right block?

[fangweile]

when i go into the article, the right block is checked and when i uncheck it, the right blocks are turned off when i viewed the article..

[IchBin]

When you run the query, does it say that it's updated any rows?

[fangweile]

0 rows affected

[IchBin]

Don't know what to tell you. The query is running fine for me on my test site.

[Lum-chan]

Don't forget to check this for each category too. If an article has the option 'Use settings from category instead!' activated then the settings of the category apply over the settings of the article itself