how do i fix this

[P11maf]

Database error in vBulletin 3.0.0 Beta 4:
Invalid SQL:
### SHOW USERS BROWSING THE BOARD ###
SELECT
user.username, (user.options & 512) AS invisible, user.usergroupid,
session.userid, session.inforum, session.lastactivity,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
FROM session AS session
LEFT JOIN user AS user ON(user.userid = session.userid)
WHERE session.lastactivity > 1058115951
ORDER BY invisible ASC, username ASC

mysql error: Can't open file: 'session.MYI'. (errno: 145)
mysql error number: 1016
Date: Sunday 13th of July 2003 01:06:29 PM
Script: http://forums.saiyancrusades.com/index.php
Referer:
Username: P11maf
IP Address: 62.254.32.6



it wont allow me into my cp

cp error

Database error in vBulletin 3.0.0 Beta 4:

Invalid SQL:
SELECT *
FROM session
WHERE sessionhash = '2c904801ee5adaa94191346a9092a862'
AND lastactivity > 1058116204
AND host = '62.254.32.6'
AND idhash = '84d1684e0d91045ee2970f39a4b52531'

mysql error: Can't open file: 'session.MYI'. (errno: 145)

mysql error number: 1016

Date: Sunday 13th of July 2003 01:10:43 PM
Script: http://forums.saiyancrusades.com/admincp/
Referer:
IP Address: 62.254.32.6

[Steve Machol]

Try this query:

DELETE FROM session;

If that doesn't work, run this one:

CREATE TABLE session (
sessionhash varchar(32) NOT NULL default '',
userid int(10) unsigned NOT NULL default '0',
host varchar(15) NOT NULL default '',
lastactivity int(10) unsigned NOT NULL default '0',
styleid smallint(5) unsigned NOT NULL default '0',
location varchar(255) NOT NULL default '',
althash varchar(32) NOT NULL default '',
badlocation tinyint(3) unsigned NOT NULL default '0',
inforum smallint(5) unsigned NOT NULL default '0',
inthread int(10) unsigned NOT NULL default '0',
incalendar int(10) unsigned NOT NULL default '0',
loggedin smallint(5) unsigned NOT NULL default '0',
idhash varchar(32) NOT NULL default '',
useragent varchar(100) NOT NULL default '',
bypass smallint(6) NOT NULL default '0',
PRIMARY KEY (sessionhash)
) TYPE=HEAP;

[P11maf]

done nothin mate, when i did delete from session; it said session does not exsit

and i created the table, and now it doesnt show the error on the main page, it emails it to me now.

Database error in vBulletin 3.0.0 Beta 4:

Invalid SQL:
SELECT *
FROM session
WHERE sessionhash = 'c7c3d7890b001f43514dac1983888992'
AND lastactivity > 1058116988
AND host = '62.254.32.6'
AND idhash = '84d1684e0d91045ee2970f39a4b52531'

mysql error: Can't open file: 'session.MYI'. (errno: 145)

mysql error number: 1016

Date: Sunday 13th of July 2003 01:23:47 PM
Script: http://forums.saiyancrusades.com/index.php
Referer:
IP Address: 62.254.32.6

[Steve Machol]

The session table is crashed again. Close your forums and repeat the second query I posted above.

[P11maf]

how do i close the forum, if it wont allow me to log in to the admincp, or is there away im not sure of doing it from phpmyadmin

[Steve Machol]

Try it again without closing the forum.

[P11maf]

i have done so, many times, nothing happend

edit: also the private message system on this bored is giving me errors

[Steve Machol]

What do you mean 'nothing happened'? What was the result after running this query?

And what errors are you getting on these forums?

[P11maf]

when i make the table it tells me its already there.

Error
SQL-query :
CREATE TABLE SESSION ( sessionhash varchar( 32 ) NOT NULL default '',
userid int( 10 ) unsigned NOT NULL default '0',
host varchar( 15 ) NOT NULL default '',
lastactivity int( 10 ) unsigned NOT NULL default '0',
styleid smallint( 5 ) unsigned NOT NULL default '0',
location varchar( 255 ) NOT NULL default '',
althash varchar( 32 ) NOT NULL default '',
badlocation tinyint( 3 ) unsigned NOT NULL default '0',
inforum smallint( 5 ) unsigned NOT NULL default '0',
inthread int( 10 ) unsigned NOT NULL default '0',
incalendar int( 10 ) unsigned NOT NULL default '0',
loggedin smallint( 5 ) unsigned NOT NULL default '0',
idhash varchar( 32 ) NOT NULL default '',
useragent varchar( 100 ) NOT NULL default '',
bypass smallint( 6 ) NOT NULL default '0',
PRIMARY KEY ( sessionhash )
) TYPE = HEAP
MySQL said:

Table 'SESSION' already existsBack

so i deleted it, and remade the it, and it said the same thing. it does not tell me the error on the forums here, so i took a screen shot http://www.saiyancrusades.com/error.JPG

[Steve Machol]

My bad. Try this one:

DROP TABLE session;
CREATE TABLE session (
sessionhash varchar(32) NOT NULL default '',
userid int(10) unsigned NOT NULL default '0',
host varchar(15) NOT NULL default '',
lastactivity int(10) unsigned NOT NULL default '0',
styleid smallint(5) unsigned NOT NULL default '0',
location varchar(255) NOT NULL default '',
althash varchar(32) NOT NULL default '',
badlocation tinyint(3) unsigned NOT NULL default '0',
inforum smallint(5) unsigned NOT NULL default '0',
inthread int(10) unsigned NOT NULL default '0',
incalendar int(10) unsigned NOT NULL default '0',
loggedin smallint(5) unsigned NOT NULL default '0',
idhash varchar(32) NOT NULL default '',
useragent varchar(100) NOT NULL default '',
bypass smallint(6) NOT NULL default '0',
PRIMARY KEY (sessionhash)
) TYPE=HEAP;

[P11maf]

now i get this:

Database error in vBulletin 3.0.0 Beta 4:

Invalid SQL:
SELECT *
FROM session
WHERE sessionhash = 'aeeb96bcc6448015fc6f156e7ff7c4fe'
AND lastactivity > 1058130189
AND host = '62.254.32.6'
AND idhash = '84d1684e0d91045ee2970f39a4b52531'

mysql error: Table 'piemaf_theforum.session' doesn't exist

mysql error number: 1146

and, maybe this is some thing, in phpmyadmin, under the forum db, were it lists the tables, it goes like this:


SESSION
access
adminhelp
administrator
adminlog
adminutil
etc. and yes, i refresh the db

oh, and when i redid what u said, it give me this Error
SQL-query :
DROP TABLE SESSION
MySQL said:

Unknown table 'session'Back

[P11maf]

i have fixed the problems, thanks very much steve, it take the table with capkeys, so i done it by hand, i dont know why it made the sessions in caps, but thats why it never worked, maybe because of the last part ) TYPE=HEAP; but i dunno. dont want to fiddle with it
but thats alot

[P11maf]

hey steve, i done that, and it work, but now i have a new problem, it wont allow me to login to the admincp or modcp, it says thank you for loging in, then it put me back to the login panel, what should i do to fix this

[Steve Machol]

Try running the fix_login.php script here:

http://www.vbulletin.com/forum/showp...&postcount=140

[P11maf]

oh i done that, and its still not allowing me in