To Quote George Armstrong Custer "Argghhhh"

[]scroungr said:<br />To Quote George Armstrong Custer "Argghhhh" [/]<br /><img src="http://www.ubbdev.com/forum/images/graemlins/jester.gif" alt="" />

[]Omegatron said: <br />Come on now guys leave the dude alone. 6.4 will be out before you know it. I mean they are on beta1 in the member area but yet on beta3 in the beta group. I would bet this thing does right to final without anymore beta trials to members. [/] <br />To be fair, there was an issue of *someone* posting a fake 6.4 changelog announcement. <br />And to qoute Josh qouting Navaho: "have a ball with it, tease your friends and neighbors with it because they can't get one yet ". Granted, that for b1, but I think the sentiment still applies. <br /> <br />I am anxiously awaiting 6.4. I know that it has been screaming through, but I know that it will be ready "when its ready". Its just fun to joke about it a little to take the edge off of the waiting. If I had beta 3, it would probally be installed on my site right now and hacked to heck, but I can't afford to put b1 on my production site, no matter how sweet the calender is and how much my higher up is breathing down my neck for it. I probally get asked if the new version is out yet, about, 3 times as often as I make, or even see, a comment about it yet. <br /> <br />So, in sumation, I want it now. <img src="http://www.ubbdev.com/forum/images/graemlins/tongue.gif" alt="" /> <img src="http://www.ubbdev.com/forum/images/graemlins/jester.gif" alt="" /> <img src="http://www.ubbdev.com/forum/images/graemlins/threaddevil.gif" alt="" /> <img src="http://www.ubbdev.com/forum/images/graemlins/devil.gif" alt="" /> <br />But, I understand that I have to wait.

Nothing wrong with some light-hearted joking around <img src="http://www.ubbdev.com/forum/images/graemlins/smile.gif" alt="" /> I know you guys are anxiously waiting for it and I really want to get it out to you as soon as we can. Yeah, it takes awhile to get a version up to the final release, but during that time we're always working on the next version to keep the ball rolling <img src="http://www.ubbdev.com/forum/images/graemlins/smile.gif" alt="" /> Hopefully it won't be too much longer <img src="http://www.ubbdev.com/forum/images/graemlins/wink.gif" alt="" />

[]Scream said: <br />As for trying to track down the problem with #7 and #8. On import are you setting B_Approved to 'yes' on all imported posts? The Bo_Total and Bo_Threads fields in the w3t_Boards table should only match the total # of threads/posts that have the B_Approved field set to 'yes'. If any threads/posts do not have that field set properly you may find some inconsistencies. [/] <br /> <br />Thanks for the update (I'm the author of the original queries; Jim is working with me on the site and posted them here). <br /> <br />FYI, all, I've fixed those queries to be: <br /> <br />SELECT Bo_Keyword, Bo_Threads, COUNT(*) AS ActualThreads FROM w3t_Boards JOIN w3t_Posts ON B_Board = Bo_Keyword WHERE B_Number = B_Main AND B_Approved='yes' GROUP BY Bo_Keyword HAVING ActualThreads != Bo_Threads <br /> <br />and <br /> <br />SELECT Bo_Keyword, Bo_Total, COUNT(*) AS ActualPosts FROM w3t_Boards JOIN w3t_Posts ON B_Board = Bo_Keyword WHERE B_Approved='yes' GROUP BY Bo_Keyword HAVING Bo_Total != ActualPosts <br /> <br />Unfortunately, this hasn't gotten rid of my inconsistencies: we're still trying to track down what action creates them. They show up on boards other than imported boards, so I think it's not an import issue. <br /> <br />Also, here's another one, which finds posts that are on a different board from their parent post or their main thread post: <br /> <br />SELECT t1.B_Number, t1.B_Parent, t1.B_Main, t1.B_Board, t2.B_Board as ParentBoard, t3.B_Board as ThreadBoard FROM w3t_Posts AS t1 JOIN w3t_Posts AS t2 ON t1.B_Parent = t2.B_Number JOIN w3t_Posts AS t3 ON t1.B_Main = t3.B_Number WHERE t1.B_Parent != 0 AND (t1.B_Board != t2.B_Board OR t1.B_Board != t3.B_Board) <br /> <br />I'm also working on a script which will find, display, and repair all of these problems. I'll post a reference to it here when I'm done, if anyone's interested.

yes, of course.. sounds like a great utility <img src="http://www.ubbdev.com/forum/images/graemlins/smile.gif" alt="" />

I'd recommend to update to 6.3.2.<br />If I remember correctly, 6.2.1 still had some bugs regarding counting the replies of a threads with caused errors while displaying threads (Empty pages or posts weren't visible). This had been fixed in newer versions.<br /><br />You can manually apply this fix to 6.2.1 of course. I did that for my board. Rick used a slightly modified version of my fix in the 6.3.x versions.