Register Log In

UBB.threads PHP Forum Software Community Forums UBB.threads 7 Bug Reports User Has Error Just Viewing a Forum

Print Thread

Hop To

User Has Error Just Viewing a Forum #228464 08/19/2009 2:39 PM
Joined: May 2006 Posts: 34 S Shawn Grim newbie
Shawn Grim newbie S Joined: May 2006 Posts: 34	Greetings, I have a soon to be new Forum member, who gets the classic: Quote UBB Error We encountered a problem. The reason reported was Database error only visible to forum administrators Please click back <javascript:history.go(-1)> to return to the previous page when he clicks on our pull down menu to go to our forums, so he doesn't even get to see the forums, much less sign up for, or peruse them. The logs show a lot of this similar issue: Quote Tue, Aug 18 2009 08:33:50 -0500 91.214.44.231 Script: D:\Home\Sites\LearningStrategies.com\wwwroot\forum\libs\ubbthreads.inc.php - Line: 2126 replace into ubbt_CACHED_PERMISSIONS (USER_ID,CACHED_PERMISSION_DATA,CACHED_TIMESTAMP) values ( 'deleted' , 'a:25:{i:1;a:3:{s:4:\"read\";s:1:\"1\";s:5:\"topic\";s:1:\"0\";s:5:\"reply\";s:1:\"0\";}i:10;a:3:{s:4:\"read\";s:1:\"1\";s:5:\"topic\";s:1:\"0\";s:5:\"reply\";s:1:\"0\";}i:11;a:3:{s:4:\"read\";s:1:\"1\";s:5:\"topic\";s:1:\"0\";s:5:\"reply\";s:1:\"0\";}i:12;a:3:{s:4:\"read\";s:1:\"1\";s:5:\"topic\";s:1:\"0\";s:5:\"reply\";s:1:\"0\";}i:13;a:3:{s:4:\"read\";s:1:\"1\";s:5:\"topic\";s:1:\"0\";s:5:\"reply\";s:1:\"0\";}i:14;a:3:{s:4:\"read\";s:1:\"1\";s:5:\"topic\";s:1:\"0\";s:5:\"reply\";s:1:\"0\";}i:15;a:3:{s:4:\"read\";s:1:\"1\";s:5:\"topic\";s:1:\"0\";s:5:\"reply\";s:1:\"0\";}i:16;a:3:{s:4:\"read\";s:1:\"1\";s:5:\"topic\";s:1:\"0\";s:5:\"reply\";s:1:\"0\";}i:17;a:3:{s:4:\"read\";s:1:\"1\";s:5:\"topic\";s:1:\"0\";s:5:\"reply\";s:1:\"0\";}i:18;a:3:{s:4:\"read\";s:1:\"1\";s:5:\"topic\";s:1:\"0\";s:5:\"reply\";s:1:\"0\";}i:19;a:3:{s:4:\"read\";s:1:\"1\";s:5:\"topic\";s:1:\"0\";s:5:\"reply\";s:1:\"0\";}i:20;a:3:{s:4:\"read\";s:1:\"1\";s:5:\"topic\";s:1:\"0\";s:5:\"reply\";s:1:\"0\";}i:21;a:3:{s:4:\"read\";s:1:\"1\";s:5:\"topic\";s:1:\"0\";s:5:\"reply\";s:1:\"0\";}i:22;a:3:{s:4:\"read\";s:1:\"1\";s:5:\"topic\";s:1:\"0\";s:5:\"reply\";s:1:\"0\";}i:23;a:3:{s:4:\"read\";s:1:\"0\";s:5:\"topic\";s:1:\"0\";s:5:\"reply\";s:1:\"0\";}i:24;a:3:{s:4:\"read\";s:1:\"0\";s:5:\"topic\";s:1:\"0\";s:5:\"reply\";s:1:\"0\";}i:25;a:3:{s:4:\"read\";s:1:\"1\";s:5:\"topic\";s:1:\"0\";s:5:\"reply\";s:1:\"0\";}i:26;a:3:{s:4:\"read\";s:1:\"0\";s:5:\"topic\";s:1:\"0\";s:5:\"reply\";s:1:\"0\";}i:27;a:3:{s:4:\"read\";s:1:\"1\";s:5:\"topic\";s:1:\"0\";s:5:\"reply\";s:1:\"0\";}i:4;a:3:{s:4:\"read\";s:1:\"1\";s:5:\"topic\";s:1:\"0\";s:5:\"reply\";s:1:\"0\";}i:5;a:3:{s:4:\"read\";s:1:\"1\";s:5:\"topic\";s:1:\"0\";s:5:\"reply\";s:1:\"0\";}i:6;a:3:{s:4:\"read\";s:1:\"1\";s:5:\"topic\";s:1:\"0\";s:5:\"reply\";s:1:\"0\";}i:7;a:3:{s:4:\"read\";s:1:\"1\";s:5:\"topic\";s:1:\"0\";s:5:\"reply\";s:1:\"0\";}i:8;a:3:{s:4:\"read\";s:1:\"1\";s:5:\"topic\";s:1:\"0\";s:5:\"reply\";s:1:\"0\";}i:9;a:3:{s:4:\"read\";s:1:\"1\";s:5:\"topic\";s:1:\"0\";s:5:\"reply\";s:1:\"0\";}}' , '1250602430' ) - Incorrect integer value: 'deleted' for column 'USER_ID' at row 1 Something that is an issue on our end, or that has been fixed in a more recent build? Best, Shawn

Re: User Has Error Just Viewing a Forum Shawn Grim #228465 08/19/2009 2:51 PM
Joined: Jun 2006 Posts: 9,242 Likes: 1 Aberdeen, WA R Rick Former Developer
Rick Former Developer R Joined: Jun 2006 Posts: 9,242 Likes: 1 Aberdeen, WA	This has been fixed in a recent version. Basically some browsers would send the word "deleted" instead of the userid when cookies were being deleted, which in turn led to the database error. We've since fixed that so it will catch it and actually delete the entry properly. On Edit: I don't think we were able to post a fix for this one since it actually required a few fairly complex edits to get this corrected. On Edit #2: For that particular user, they should be able to log in again if they just manually delete the cookies from your site. Last edited by Rick; 08/19/2009 2:52 PM.

Re: User Has Error Just Viewing a Forum Shawn Grim #228466 08/19/2009 2:52 PM
Joined: Dec 2003 Posts: 6,562 Likes: 78 Lutz,FL Ruben
Ruben Joined: Dec 2003 Posts: 6,562 Likes: 78 Lutz,FL	The site seems to work fine for me. You did have some file permission issues before. Maybe a particular topic is corrupted. What is the url associated with the pull down menu they are using. Ah Rick types faster than me. He posted at the same time. He has the real answer. But I do recall that you were going to upgrade from 7.2.2 anyway. Last edited by Ruben; 08/19/2009 2:55 PM. Reason: Added comment Blue Man Group There is no such thing as stupid questions. Just stupid answers

Re: User Has Error Just Viewing a Forum Rick #228467 08/19/2009 2:53 PM
Joined: May 2006 Posts: 34 S Shawn Grim newbie
Shawn Grim newbie S Joined: May 2006 Posts: 34	Thanks Rick, Brad couldn't get to it before taking off to the Philippines on Friday, so he said next week. Best, Shawn

Re: User Has Error Just Viewing a Forum Shawn Grim #228468 08/19/2009 2:56 PM
Joined: May 2006 Posts: 34 S Shawn Grim newbie
Shawn Grim newbie S Joined: May 2006 Posts: 34	No Ruben, I've gotten into the forum pages and list from various computers here, through the "Forums" pull down on our site's header bar. Best, Shawn

Re: User Has Error Just Viewing a Forum Shawn Grim #228469 08/19/2009 4:01 PM
Joined: Dec 2003 Posts: 6,562 Likes: 78 Lutz,FL Ruben
Ruben Joined: Dec 2003 Posts: 6,562 Likes: 78 Lutz,FL	BTW, I registered at your site and never got the verification email to activate my account. Blue Man Group There is no such thing as stupid questions. Just stupid answers

Link Copied to Clipboard

Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.

Bots
by Outdoorking - 04/13/2024 5:08 PM

Can you add html to language files?
by Baldeagle - 04/07/2024 2:41 PM

Do I need to rebuild my database?
by Baldeagle - 04/07/2024 2:58 AM

This is not a bug, but a suggestion
by Baldeagle - 04/05/2024 11:25 PM

Is UBB.threads still going?
by Aaron101 - 04/01/2022 8:18 AM

Who's Online Now

2 members (Ruben, 1 invisible), 717 guests, and 165 robots.

Key: Admin, Global Mod, Mod

Random Gallery Image

Latest Gallery Images

Los Angeles

Los Angeles
by isaac, August 6

3D Creations

3D Creations
by JAISP, December 30

Artistic structures

Artistic structures
by isaac, August 29

Stones

Stones
by isaac, August 19

Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20240430)