Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBSkins.com
Who's Online
1 registered (Ruben), 11 Guests and 32 Spiders online.
Key: Admin, Global Mod, Mod
Featured Member
Registered: 05/20/08
Posts: 8
Top Posters (30 Days)
Ruben 114
Gizmo 39
Rick 39
JAISP 22
24hourcampfire 18
pinkmelon 16
Daryl Fawcett 14
Ian 14
FordDoctor 13
bakerzdosen 12
Latest Photos
Gizmo goes Locks of Love...
Sleepy eyes
Hang Time
Our get away hobby
This is a test
Page 1 of 2 1 2 >
Topic Options
Rate This Topic
#45717 - 11/06/05 01:53 PM 6.5.0->6.5.2 upgrade, some board sgive "Access denied"?
drakino42 Offline
stranger

Registered: 11/06/05
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?

Top
#45718 - 11/06/05 01:57 PM Re: 6.5.0->6.5.2 upgrade, some board sgive "Access denied"?
drakino42 Offline
stranger

Registered: 11/06/05
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.

Top
#45719 - 11/06/05 02:30 PM Re: 6.5.0->6.5.2 upgrade, some board sgive "Access denied"?
drakino42 Offline
stranger

Registered: 11/06/05
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:
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);


Top
#45720 - 11/10/05 12:50 AM Re: 6.5.0->6.5.2 upgrade, some board sgive "Access denied"?
drakino42 Offline
stranger

Registered: 11/06/05
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.

Top
#45721 - 11/10/05 09:27 AM Re: 6.5.0->6.5.2 upgrade, some board sgive "Access denied"?
Anno Offline
member

Registered: 06/07/06
Posts: 182
The fastest(only?) way to get support here is to submit a support ticket.

Top
#45722 - 11/13/05 06:51 PM Re: 6.5.0->6.5.2 upgrade, some board sgive "Access denied"?
George_Bris Offline
stranger

Registered: 11/02/04
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 :
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



Top
#45723 - 11/13/05 07:13 PM Re: 6.5.0->6.5.2 upgrade, some board sgive "Access denied"?
AllenAyres Offline


****

Registered: 12/29/03
Posts: 1847
Loc: Texas
interesting, thanks for sharing
_________________________
- Allen
- ThreadsDev | PraiseCafe

Top
#45724 - 11/13/05 11:49 PM Re: 6.5.0->6.5.2 upgrade, some board sgive "Access denied"?
Zarzal Offline
old hand

Registered: 06/05/06
Posts: 1128
Loc: Berlin, Germany
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.
_________________________
my board: http://www.dragon-clan.de
my hobby: http://www.biker-reise.de
Ich kann bei Fragen zu UBBthreads in Deutsch weiterhelfen oder es zumindest versuchen

Top
#45725 - 11/26/05 04:22 PM Re: 6.5.0->6.5.2 upgrade, some board sgive "Access denied"?
drakino42 Offline
stranger

Registered: 11/06/05
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.

Top
#45726 - 01/26/06 08:19 PM Re: 6.5.0->6.5.2 upgrade, some board sgive "Access denied"?
Zarius Offline
stranger

Registered: 10/26/04
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.

Top
#45727 - 04/20/06 12:57 PM Re: 6.5.0->6.5.2 upgrade, some board sgive "Access denied"?
fatalpapercut Offline
member
****

Registered: 04/19/06
Posts: 116
Quote:

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.

Top
#45728 - 06/01/06 06:53 AM Re: 6.5.0->6.5.2 upgrade, some board sgive "Access denied"?
Stan Offline
addict

Registered: 06/05/06
Posts: 463
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

Top
Page 1 of 2 1 2 >


Moderator:  AllenAyres, Gizmo, Harold, Ian, Ron M, usrbingeek 
Shout Box

Today's Birthdays
wmearn
Recent Topics
Suffestion: Donation Feature and Amount Raised Graph
by sb
Today at 01:25 PM
Backups via Control Panel
by JAISP
Today at 10:55 AM
Gallery Permissions
by Willzter
07/01/09 08:50 PM
SERIOUS EMERGENCY. NEED A QUICK ANSWER STAT
by 24hourcampfire
07/01/09 02:18 PM
What do I have to do to have a forum where only users with 200 plus post can post?
by pinkmelon
07/01/09 02:06 PM
Forum Stats
4444 Members
33 Forums
31488 Topics
162449 Posts

Max Online: 978 @ 06/24/07 08:19 PM