plz help me in this

[*handsome*]

I am getting this message on my gellery front page

Code: [Select]

DB Error: Bad SQL Query: DELETE FROM 4images_sessions WHERE session_lastaction < 1231275448
Table './nokialov_imga4/4images_sessions' is marked as crashed and should be repaired

DB Error: Bad SQL Query: REPLACE INTO 4images_sessions (session_id, session_user_id, session_lastaction, session_location, session_ip) VALUES ('a1f07c38ca12056ce9087b376bef7389', -1, 1231276348, 'index.php', '116.71.167.6')
Table './nokialov_imga4/4images_sessions' is marked as crashed and should be repaired

Warning: Cannot modify header information - headers already sent by (output started at /home/nokialov/public_html/games/includes/db_mysql.php:190) in /home/nokialov/public_html/games/includes/sessions.php on line 133

Warning: Cannot modify header information - headers already sent by (output started at /home/nokialov/public_html/games/includes/db_mysql.php:190) in /home/nokialov/public_html/games/includes/sessions.php on line 133

DB Error: Bad SQL Query: SELECT s.session_user_id, s.session_lastaction, s.session_ip, u.user_id, u.user_level, u.user_name, u.user_invisible FROM 4images_sessions s LEFT JOIN 4images_users u ON (u.user_id = s.session_user_id) WHERE s.session_lastaction >= 1231276048 ORDER BY u.user_id ASC, s.session_ip ASC
Table './nokialov_imga4/4images_sessions' is marked as crashed and should be repaired

[Nicky]

hi,

over your host control panel and mysql manager you can try to repair your session table. in the most ways you can use phpmyadmin.
if this does not help contact your host, or replace ONLY the 4images_sessions table with a new one.

hope this was helpful for you.

[V@no]

Actually, you can't repair sessions table via mysql manager, because it's HEAP type.

You'll need execute this MySQL query in your mysql manager (or ask your host administrator do it for you)

Code: [Select]

DROP TABLE IF EXISTS 4images_sessions;
CREATE TABLE 4images_sessions (
  session_id varchar(32) NOT NULL default '',
  session_user_id int(11) NOT NULL default '0',
  session_lastaction int(11) unsigned NOT NULL default '0',
  session_location varchar(255) NOT NULL default '',
  session_ip varchar(15) NOT NULL default '',
  PRIMARY KEY  (session_id),
  KEY session_user_id (session_user_id),
  KEY session_id_ip_user_id (session_id,session_ip,session_user_id)
) TYPE=HEAP;

P.S.
Forum rules -> Type in a subject that summarizes your question

[*handsome*]

Actually, you can't repair sessions table via mysql manager, because it's HEAP type.

You'll need execute this MySQL query in your mysql manager (or ask your host administrator do it for you)

Code: [Select]

DROP TABLE IF EXISTS 4images_sessions;
CREATE TABLE 4images_sessions (
  session_id varchar(32) NOT NULL default '',
  session_user_id int(11) NOT NULL default '0',
  session_lastaction int(11) unsigned NOT NULL default '0',
  session_location varchar(255) NOT NULL default '',
  session_ip varchar(15) NOT NULL default '',
  PRIMARY KEY  (session_id),
  KEY session_user_id (session_user_id),
  KEY session_id_ip_user_id (session_id,session_ip,session_user_id)
) TYPE=HEAP;

P.S.
Forum rules -> Type in a subject that summarizes your question

Please help me step by step.......

[khansahib]

Thanks V@no u're savior