#45717
11/06/2005 5:53 PM
|
Joined: Nov 2005
Posts: 8
stranger
|
|
stranger
Joined: Nov 2005
Posts: 8 |
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?
|
|
|
#45718
11/06/2005 5:57 PM
|
Joined: Nov 2005
Posts: 8
stranger
|
|
stranger
Joined: Nov 2005
Posts: 8 |
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.
|
|
|
#45719
11/06/2005 6:30 PM
|
Joined: Nov 2005
Posts: 8
stranger
|
|
stranger
Joined: Nov 2005
Posts: 8 |
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: $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: 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);
|
|
|
#45720
11/10/2005 4:50 AM
|
Joined: Nov 2005
Posts: 8
stranger
|
|
stranger
Joined: Nov 2005
Posts: 8 |
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.
|
|
|
#45721
11/10/2005 1:27 PM
|
Joined: Jun 2006
Posts: 182
member
|
|
member
Joined: Jun 2006
Posts: 182 |
The fastest(only?) way to get support here is to submit a support ticket.
|
|
|
#45722
11/13/2005 10:51 PM
|
Joined: Nov 2004
Posts: 1
stranger
|
|
stranger
Joined: Nov 2004
Posts: 1 |
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 :
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
|
|
|
#45723
11/13/2005 11:13 PM
|
Joined: Dec 2003
Posts: 1,796
Pooh-Bah
|
|
Pooh-Bah
Joined: Dec 2003
Posts: 1,796 |
interesting, thanks for sharing <img src="https://www.ubbcentral.com/boards/images/graemlins/smile.gif" alt="" />
|
|
|
#45724
11/14/2005 3:49 AM
|
Joined: Jun 2006
Posts: 956
Old Hand
|
|
Old Hand
Joined: Jun 2006
Posts: 956 |
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.
|
|
|
#45725
11/26/2005 8:22 PM
|
Joined: Nov 2005
Posts: 8
stranger
|
|
stranger
Joined: Nov 2005
Posts: 8 |
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.
|
|
|
#45726
01/27/2006 12:19 AM
|
Joined: Oct 2004
Posts: 2
stranger
|
|
stranger
Joined: Oct 2004
Posts: 2 |
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.
|
|
|
#45727
04/20/2006 3:57 PM
|
Joined: Apr 2006
Posts: 116
member
|
|
member
Joined: Apr 2006
Posts: 116 |
[]This problem hits only people who update the board, not fresh installs. [/]
Oh yes, it hits fresh installs as well. Just installed threads from scratch, made a test forum, in the database name for the forum put "test_forum" and got access denied. So "_" and MySQL is definite no no.
|
|
|
#45728
06/01/2006 9:53 AM
|
Joined: Jun 2006
Posts: 869
old hand
|
|
old hand
Joined: Jun 2006
Posts: 869 |
I have this problem, not with forums but with a couple of threads inside of a forum. This happened when i went from 6.5.2 to 6.5.4. I can access the mysql, but do not how to make it work or do anything... sp P L E A S E type slow, so I can understand <img src="https://www.ubbcentral.com/boards/images/graemlins/smile.gif" alt="" />
|
|
|
|
0 members (),
80
guests, and
88
robots. |
|
Key:
Admin,
Global Mod,
Mod
|
|
|
|
