Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online
4 registered (Dunny, Mike L, Bjab, Gizmo), 19 Guests and 21 Spiders online.
Key: Admin, Global Mod, Mod
Featured Member
Registered: 02/27/11
Posts: 15
Top Posters (30 Days)
Ruben 62
SD 54
Gizmo 48
gliderdad 33
Dunny 21
driv 18
dbremer 16
Stan 14
Mark S 13
Iann128 12
Latest Photos
Testing
Basildon Train Station
Basildon Town Centre looking from the rounderbout
Basildon Town Square
Gizzo Marx
Topic Options
#227027 - 06/04/09 10:48 AM Who's On-Line Table Crashed. Help!
soulstrut75 Offline
stranger
Registered: 06/04/09
Posts: 3
Hello,

The Who's Online table (w3t_Online) crashed and is corrupt beyond repair. I was just going to reinstall the table but I don't have a backup of the SQL commands.

Can someone please help? This is an urgent matter.
Top
#227029 - 06/04/09 01:31 PM Re: Who's On-Line Table Crashed. Help! [Re: soulstrut75]
Rick Offline
Post-a-holic
Registered: 06/04/06
Posts: 10164
Loc: Aberdeen, WA
Can you tell me what version you are currently running? It looks like a 6.x version but will need to know the exact version # to give you the proper create table you'll need.

You "might" be able to get away with just running this sql command:

delete from w3t_Online

Also, I would recommend upgrading at some point since this table is now stored in memory, which gets rid of the problematic crashing issue.
Top
#227032 - 06/04/09 02:23 PM Re: Who's On-Line Table Crashed. Help! [Re: Rick]
soulstrut75 Offline
stranger
Registered: 06/04/09
Posts: 3
Hi,

I'm at 6x now that I look at it. I managed to find a create table script and rebuilt the table by hand. Now, the users logged in are listed multiple times. Any way to solve that?
Top
#227033 - 06/04/09 02:31 PM Re: Who's On-Line Table Crashed. Help! [Re: soulstrut75]
Rick Offline
Post-a-holic
Registered: 06/04/06
Posts: 10164
Loc: Aberdeen, WA
It sounds like you might have used a different createtable for the version you are running. We'd need to know the exact version # to make sure you have the right details for the table creation.
Top
#227035 - 06/04/09 03:04 PM Re: Who's On-Line Table Crashed. Help! [Re: Rick]
Ruben Online   hyper

Registered: 12/20/03
Posts: 4268
Loc: Lutz,FL
Shame on you Rick for not moving this to the 6.x area.
50 lashes with a wet noodle coming to you soon.
_________________________
Blue Man Group
Top
#227036 - 06/04/09 03:17 PM Re: Who's On-Line Table Crashed. Help! [Re: Ruben]
soulstrut75 Offline
stranger
Registered: 06/04/09
Posts: 3
I'm using version 6.5.2.

Thanks in advance.
Top
#227037 - 06/04/09 03:23 PM Re: Who's On-Line Table Crashed. Help! [Re: Ruben]
Gizmo Online   cat

Registered: 06/05/06
Posts: 14904
Loc: Portland, OR; USA
Originally Posted By: Ruben
Shame on you Rick for not moving this to the 6.x area.
Moved
_________________________
Forums: UGN Security & VNC Web Design & Development
UBB.Threads: UBB.Wiki, My UBBSkins, UBB.Sitemaps
Longtime UBB Supporter, UBB Beta Tester & Resident Post-A-Holic.
UBB Modifications, Styling, Coding Services, Disaster Recovery, and more!
Top
#227041 - 06/04/09 04:16 PM Re: Who's On-Line Table Crashed. Help! [Re: Gizmo]
Rick Offline
Post-a-holic
Registered: 06/04/06
Posts: 10164
Loc: Aberdeen, WA
Ok, so you want:

Sql Query:
CREATE TABLE w3t_Online(
O_Username $varchar(64) NOT NULL,
O_Uid $int9 NOT NULL,
O_Last $int9 DEFAULT '0' NOT NULL,
O_What $varchar(64),
O_Extra $varchar(200),
O_Read $varchar(255),
O_Type $varchar(1) NOT NULL,
O_Board VARCHAR(100),
UNIQUE Oindx1 (O_Username), 
INDEX Oindx2 (O_Last), 
INDEX type_index(O_Type)
)
Top



Shout Box

Today's Birthdays
No Birthdays
Recent Topics
Edit Post
by Bert
01:19 PM
A positive note
by SteveS
09:36 PM
How to locate links to particular site if they are only used in images?
by Conrad
02/10/12 09:41 PM
Pictures not displaying
by Marker23
02/09/12 10:04 PM
Issue with logging out constantly
by Flanuva
02/09/12 07:05 PM
Forum Stats
10213 Members
36 Forums
33667 Topics
180917 Posts

Max Online: 978 @ 06/24/07 11:19 PM
Random Image