Jake, keep in mind that where the command does delete data, it wont' delete your announcements (which is what I think you're worried about, it simply removes the topic id from the table of what threads are stickied), it simply makes the announcements that are sticked no longer stickied.

So if I encounter any kind of problem with sticky posting (vanishing) after importing from classic I run the first sql to unstick all and then the command to clear the announcement table. Then I should see all postings and be able to restick them, correct?

I ask back because I never do this and now I thry to support somewhone with a huge board who have this problem.

This issue is caused by a previous hack.

The easy way to unstick the sticky posts is to sticky them again (yes despite them being already stickied, threads will allow you to action this request)

This will then error as mentioned above (as the post is already stickied in the database)

However you can now un-sticky and the post will return to normal.

Well my site had no hacks (unless it was put into the release code) and I had a couple issue with this as well.

None now or since though.

Oh okay - fair enough - anyway the above method will get rid of them....

It saves database diving and wiping out any stickies form other forums that you wish to keep.

Classic didn't always have sticky posts; it was a mod for a LONG period, then it was pushed out as an *official* feature in the code; so it could just be an issue of the compatability between the mod -> official

ok - was several years since I 'abandoned' ubb for threads LOL

:cough:traider:cough:

LOL - I went to threads, whilst it was still wwwthreads - it has taken you several years to see the light and catch up

nah, infopoop bought Rick out, then hired him, so I'm still on the path :nod: