|
Joined: Nov 2006
Posts: 190 Likes: 5
Member
|
Member
Joined: Nov 2006
Posts: 190 Likes: 5 |
Upgraded from UBB.classic 6.7.1 to UBB.threads 7.0.1 then 7.0.2.
We thought we lost one of the threads we were using as an informative sticky at the beginning of one of the forums. Clicking through each page of that forum and searching for that author did not reveal it (nor did a "Show User's Posts" - at least we didn't find it). But it wasn't important enough to worry about so we forgot about it.
Then I was reading the first post in that forum and clicked on "Next Topic". Lo and behold that thread was displayed. It was still a sticky but just not being listed in that forum. I unstickied it to see if that would get it listed in that forum. Nothing. So I restickied it and left it (and I can now find it by clicking "Next Topic" while in the first post of that forum).
Ideas?
|
|
|
|
Joined: Aug 2006
Posts: 1,649 Likes: 1
Pooh-Bah
|
Pooh-Bah
Joined: Aug 2006
Posts: 1,649 Likes: 1 |
I had a problem importing stickied threads a couple months ago... sorry to hear that it still might be an issue. What I did was un-sticky the threads, then start over. It was okay after that.. :/
GangsterBB.NET (Ver. 7.6.1.1) PHP Version 5.6.40 / MySQL 5.7.23-23 (was 5.6.41-84.1) / Apache 2.4.54 2007 Content Rulez Contest - Hon Mention UBB.classic 6.7.2 - RIP
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
You can do a database query to unsticky them all and they'll show up. Unfortunately you'd need to find them and resticky them afterwards. If you want to go this route you can run the following sql command:
update ubbt_TOPICS set TOPIC_IS_STICKY='0'
|
|
|
|
Joined: Nov 2006
Posts: 190 Likes: 5
Member
|
Member
Joined: Nov 2006
Posts: 190 Likes: 5 |
update ubbt_TOPICS set TOPIC_IS_STICKY='0' worked to unstick all of the sticky threads. When I viewed a listing of each forum the stickys were gone.
BUT, when I went back to re-sticky each of the topics I got this error message for each and every thread that was unstickyed with the SQL command:
Script: ../forums/scripts/stickpost.inc.php Line#: 123 SQL Error: Duplicate entry '426-1' for key 1 SQL Error #: 1062 Query: INSERT INTO ubbt_ANNOUNCEMENTS VALUES ( 426 , 1 )
Please use your back button to return to the previous page.
[I shortened the directory. Also the '426-1' was different for each but I think all of them were the same SQL error 1062.]
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
ok, you'll need to clear out the announcements table as well by running this query:
DELETE FROM ubbt_ANOUNCEMENTS
|
|
|
|
Joined: Nov 2006
Posts: 3,095 Likes: 1
Carpal Tunnel
|
Carpal Tunnel
Joined: Nov 2006
Posts: 3,095 Likes: 1 |
Such an ugly term. -
|
|
|
|
Joined: Nov 2006
Posts: 190 Likes: 5
Member
|
Member
Joined: Nov 2006
Posts: 190 Likes: 5 |
Well, it appears to be working properly. Are there really duplicate entries in ubbt_ANNOUNCEMENTS VALUES or did it attempt to make duplicate entries and complain because it could not make the duplicate entry?
What happens if I don't do a DELETE FROM ubbt_ANOUNCEMENTS?
Also, doesn't a SQL command need to specifically delete something specific. That command has me worried!
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
Basically the announcements table keeps track of which topics are sticky. With the first command I gave you that set all topics to unsticky in the topics table, but didn't account for those in the announcements table. Those 2 commands go hand in hand. What's happening is those that you are trying to make sticky again are already in the announcements table and you're getting the error.
|
|
|
|
Joined: Nov 2006
Posts: 190 Likes: 5
Member
|
Member
Joined: Nov 2006
Posts: 190 Likes: 5 |
Thanks for the response. I realized as much.
What happens if I don't do a DELETE FROM ubbt_ANOUNCEMENTS?
Can I just leave it alone at this point or do I need to repeat the two commands?
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
If you have all of your stickies working as intended, then don't worry about running that command.
|
|
|
|
Joined: Jun 2006
Posts: 16,299 Likes: 116
|
Joined: Jun 2006
Posts: 16,299 Likes: 116 |
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.
|
|
|
|
Joined: Jun 2006
Posts: 956
Old Hand
|
Old Hand
Joined: Jun 2006
Posts: 956 |
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.
|
|
|
|
Joined: Jun 2006
Posts: 3,837
Carpal Tunnel
|
Carpal Tunnel
Joined: Jun 2006
Posts: 3,837 |
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.
|
|
|
|
Joined: Nov 2006
Posts: 3,095 Likes: 1
Carpal Tunnel
|
Carpal Tunnel
Joined: Nov 2006
Posts: 3,095 Likes: 1 |
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.
|
|
|
|
Joined: Jun 2006
Posts: 3,837
Carpal Tunnel
|
Carpal Tunnel
Joined: Jun 2006
Posts: 3,837 |
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.
|
|
|
|
Joined: Jun 2006
Posts: 16,299 Likes: 116
|
Joined: Jun 2006
Posts: 16,299 Likes: 116 |
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
|
|
|
|
Joined: Jun 2006
Posts: 3,837
Carpal Tunnel
|
Carpal Tunnel
Joined: Jun 2006
Posts: 3,837 |
ok - was several years since I 'abandoned' ubb for threads LOL
|
|
|
|
Joined: Jun 2006
Posts: 16,299 Likes: 116
|
Joined: Jun 2006
Posts: 16,299 Likes: 116 |
|
|
|
|
Joined: Jun 2006
Posts: 3,837
Carpal Tunnel
|
Carpal Tunnel
Joined: Jun 2006
Posts: 3,837 |
LOL - I went to threads, whilst it was still wwwthreads - it has taken you several years to see the light and catch up
|
|
|
|
Joined: Jun 2006
Posts: 16,299 Likes: 116
|
Joined: Jun 2006
Posts: 16,299 Likes: 116 |
nah, infopoop bought Rick out, then hired him, so I'm still on the path :nod:
|
|
|
|
Joined: Jun 2006
Posts: 3,837
Carpal Tunnel
|
Carpal Tunnel
Joined: Jun 2006
Posts: 3,837 |
poor excuse xxx
|
|
|
|
Joined: Jun 2006
Posts: 16,299 Likes: 116
|
Joined: Jun 2006
Posts: 16,299 Likes: 116 |
It's a great one ..
|
|
|
Bots
by Outdoorking - 04/13/2024 5:08 PM
|
|
|
|
|
|
1 members (Nightcrawler),
445
guests, and
142
robots. |
Key:
Admin,
Global Mod,
Mod
|
|
|
|