Welcome to Geeklog, Anonymous Saturday, November 30 2024 @ 12:48 am EST
Geeklog Forums
broken MySQL table
Status: offline
Esteban
Forum User
Newbie
Registered: 07/22/02
Posts: 11
Someone go and look at www.ultramonkey.co.uk and tell me how to fix the problem. I have dropped the gl_sessions table as it was corrupt and now I dunno how to recreate it. It would be great if someone could post the SQL to regenerate it.
Thanks in advance.
10
9
Quote
Status: offline
Dirk
Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
It's all in sql/mysqltableanddata.php:
Text Formatted Code
CREATE TABLE gl_sessions (sess_id int(10) unsigned NOT NULL default '0',
start_time int(10) unsigned NOT NULL default '0',
remote_ip varchar(15) NOT NULL default '',
uid mediumint(8) NOT NULL default '1',
md5_sess_id varchar(128) default NULL,
PRIMARY KEY (sess_id),
KEY sess_id (sess_id),
KEY start_time (start_time),
KEY remote_ip (remote_ip)
) TYPE=MyISAM
bye, Dirk
8
6
Quote
All times are EST. The time is now 12:48 am.
- Normal Topic
- Sticky Topic
- Locked Topic
- New Post
- Sticky Topic W/ New Post
- Locked Topic W/ New Post
- View Anonymous Posts
- Able to post
- Filtered HTML Allowed
- Censored Content