1
bigwolf
careless delete xoops_session and how can I recover....
  • 2005/12/28 16:58

  • bigwolf

  • Just popping in

  • Posts: 36

  • Since: 2002/4/20


*version: XOOPS 2.2.3 Final
*MySQL:3.23.54

================================
Due to admin log-in problem, I careless delete xoops_session and can't recover the table. I tried to copy original *.sql and pasted by phpMyAdmin, but it's not in vain. Now I can not only log in as an admin but lose xoops_session...Could anyone help? Thanks a bunch.

2
Dave_L
Re: careless delete xoops_session and how can I recover....
  • 2005/12/28 17:23

  • Dave_L

  • XOOPS is my life!

  • Posts: 2277

  • Since: 2003/11/7


Use this query to recreate the table:

CREATE TABLE xoops_session (
  
sess_id varchar(32NOT NULL default '',
  
sess_updated int(10unsigned NOT NULL default '0',
  
sess_ip varchar(15NOT NULL default '',
  
sess_data mediumblob NOT NULL,
  
PRIMARY KEY  (sess_id),
  
KEY updated (sess_updated)
TYPE=MyISAM;

3
bigwolf
Re: careless delete xoops_session and how can I recover....
  • 2005/12/29 15:10

  • bigwolf

  • Just popping in

  • Posts: 36

  • Since: 2002/4/20


Quote:

Dave_L wrote:
Use this query to recreate the table:

CREATE TABLE xoops_session (
  
sess_id varchar(32NOT NULL default '',
  
sess_updated int(10unsigned NOT NULL default '0',
  
sess_ip varchar(15NOT NULL default '',
  
sess_data mediumblob NOT NULL,
  
PRIMARY KEY  (sess_id),
  
KEY updated (sess_updated)
TYPE=MyISAM;


I tried to recreate the table, but there is an error message like this:

======================================================
#3 - Error writing file './tpedu/xoops_session.frm' (Errcode: 28)
======================================================

Please help! Many Thanks!

4
Dave_L
Re: careless delete xoops_session and how can I recover....
  • 2005/12/29 15:29

  • Dave_L

  • XOOPS is my life!

  • Posts: 2277

  • Since: 2003/11/7


Check whether the MySQL server is low on disk space.

Login

Who's Online

241 user(s) are online (155 user(s) are browsing Support Forums)


Members: 0


Guests: 241


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: May 31
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits