|
|
Joined: Jun 2009
Posts: 3
stranger
|
|
stranger
Joined: Jun 2009
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.
|
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
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.
|
|
|
|
|
Joined: Jun 2009
Posts: 3
stranger
|
|
stranger
Joined: Jun 2009
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?
|
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
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.
|
|
|
|
|
Joined: Dec 2003
Posts: 6,649 Likes: 88
|
|
Joined: Dec 2003
Posts: 6,649 Likes: 88 |
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
There is no such thing as stupid questions. Just stupid answers
|
|
|
|
|
Joined: Jun 2009
Posts: 3
stranger
|
|
stranger
Joined: Jun 2009
Posts: 3 |
I'm using version 6.5.2.
Thanks in advance.
|
|
|
|
|
Joined: Jun 2006
Posts: 16,532 Likes: 150
|
|
Joined: Jun 2006
Posts: 16,532 Likes: 150 |
Shame on you Rick for not moving this to the 6.x area. Moved
|
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
Ok, so you want:
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)
)
|
|
|
|
0 members (),
322
guests, and
186
robots. |
|
Key:
Admin,
Global Mod,
Mod
|
|
|
|
