Who's On-Line Table Crashed. Help! - UBB.threads PHP Forum Software Community

You are not logged in. [Log In] UBB.threads PHP Forum Software Community » Forums » UBB.threads 6.x Discussion » UBB.threads Assistance (How Do I?) » Who's On-Line Table Crashed. Help!

Site Links

Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com

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

Basildon Town Centre looking from the rounderbout

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

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

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

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

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

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

Previous Topic

Index

Next Topic

Hop to:

Shout Box

February
Su	M	Tu	W	Th	F	Sa
			1	2	3	4
5	6	7	8	9	10	11
12	13	14	15	16	17	18
19	20	21	22	23	24	25
26	27	28	29

Today's Birthdays

No Birthdays