Just completed an upgrade from 6.5.0 to 6.5.2, and when I went to bring everything back up, certain sections of the board give an "Access denied" error, areas where even guests used to have at least read access. I've reset the permissions to nothing then set them back they way they should be in the control panel and verified that the table w3t_Boards is being changed. But yet the problem still persists, and I'm out of ideas.

Any other suggestions before I revery to backups on 6.5.0 and try the upgrade another day?

As an odd update, if I click a link off the front page to the newest post, I can see the post fine. Hitting the index button then returns me to the Access Denied error.

Digging deeper, I'm getting more confused. I started tracking what would cause Access Denied to appear, and found the code in postlist.php causing it:
Code:

---

$Board_q = addslashes($Board);
$query = "
        SELECT Bo_Title,Bo_Last,Bo_Read_Perm,Bo_Write_Perm,Bo_Moderated,Bo_Cat,Bo_CatName,Bo_ThreadAge,Bo_Reply_Perm,Bo_HTML,Bo_Markup,Bo_SpecialHeader,Bo_StyleSheet,Bo_Number,Bo_Threads
        FROM   {$config['tbprefix']}Boards
        WHERE  Bo_Keyword = '$Board_q'
        AND Bo_Active = '1'
        $groupquery
";
$sth = $dbh -> do_query($query,__LINE__,__FILE__);
$rows = $dbh -> fetch_array($sth);
list($Title,$Last,$CanRead,$CanWrite,$Moderated,$C,$CatName,$ThreadAge,$CanReply,$HTML,$Markup,$fheader,$fstyle,$bonumber,$totaltopics) = $rows;
$dbh -> finish_sth($rows);
if (!$Title) {
      $html -> not_right($ubbt_lang['BAD_GROUP'],$Cat);
}

---

For some reason, some boards are now not returning $Title, though the SQL database is healthy, and inspecting the table manually shows no glaring faults.

Here is an SQL dumo of two of my boards. the ICE one doesn't work, the Announcements does:

Code:

---

INSERT INTO `w3t_Boards` VALUES ('ICE', 'Discussion of other In Car Entertainment components', 'empeg_ice', 2219, 1130966641, 'Off', 'On', 3, 927126065, NULL, 'Off', 'no', 1, '-1-2-3-4-5-6-', '-1-2-3-5-', 213, 4, 'General', NULL, '-1-2-3-5-', NULL, NULL, 268639, 259473, 2330, NULL, 1);
INSERT INTO `w3t_Boards` VALUES ('Announcements', 'Announcements (Moderated)', 'ann', 175, 1131329158, 'Off', 'On', 10, 960540408, 0, 'Off', 'no', 1, '-1-2-3-4-5-6-', '-1-2-5-', 104, 1, 'General', 0, '-1-2-5-', 0, 'usedefault', 268937, 268935, 35, '', 1);

---

Is there any other information I might be able to provide to help find a solution for this? I rolled back to 6.5.0 pretty quickly, as 50% of my board became inaccessable with the upgrade.

The fastest(only?) way to get support here is to submit a support ticket.

I had the same issue..
After further investigation from the details given in this post, I tracked down the problem as being an underscores '_' in the database keyword name for the particular forum.
Fixes are either remove and do not use underscores in forum identification names or, as I did make a change in ubbt.inc.php.
I made the change in the file and all is now accessible.
The routine to change is :
Code:

---

ubbt_validate($validate="",$value="") {
..
..
..
elseif ($validate == "alphanum") {
        $value = preg_replace("/[^A-Za-z0-9\-]/","",$value);   <- original
        $value = preg_replace("/[^A-Za-z0-9\-_]/","",$value);  <- changed

 

---

interesting, thanks for sharing

This was reported while testing Beta 6.5 and it was marked as fixed. It's annoying that this is in again. This problem hits only people who update the board, not fresh installs. With a fresh install you cant create boards with _ inside the board name.

I encounter many trouble with old users convert from Classic. They have sometimes spaces in the username and I switch of special chars in threads. In result you have very stange effects with this users inside the board.

It indeed seems to be that. I'm now running 6.5.2 with no problems now that I allowed _, as about half my boards use that in their short name.

Thanks George! That post just saved me hours of aggrivation trying to figure out what was wrong with the site. I made the change you posted and I'm back in business.

Regards,

Zarius.