URGENT: Session Table Default Structure

[GOSatisfy]

Urgent: Can someone send me the default structure of the "Session" table --- It seems that it broke my board when switching servers after a crash!

-bryan

[Lesane]

#
# Table structure for table `session`
#

CREATE TABLE session (
sessionhash char(32) NOT NULL default '',
userid int(10) unsigned NOT NULL default '0',
host char(50) NOT NULL default '',
useragent char(50) NOT NULL default '',
lastactivity int(10) unsigned NOT NULL default '0',
styleid smallint(5) unsigned NOT NULL default '0',
location char(255) NOT NULL default '',
PRIMARY KEY (sessionhash)
) TYPE=MyISAM;

[Admin]

CREATE TABLE session (
sessionhash char(32) NOT NULL,
userid int(10) unsigned DEFAULT '0' NOT NULL,
host char(50) NOT NULL,
useragent char(50) NOT NULL,
lastactivity int(10) unsigned DEFAULT '0' NOT NULL,
location CHAR (255) not null,
styleid smallint(5) unsigned DEFAULT '0' NOT NULL,
PRIMARY KEY (sessionhash)
) TYPE=HEAP;

[Admin]

The table type is HEAP Lesane, it's not a regular MyISAM table. :)

[GOSatisfy]

This fixed all problems except viewing and using some of the newer forums created... i will enslose mysql error later today

thanks for now :-)

[Lesane]

Originally posted by FireFly
The table type is HEAP Lesane, it's not a regular MyISAM table. :)

The table type of my session table is 'MyISAM'. It says 'MyISAM' if i look in PhpMyAdmin. I did not modified it or something. :)

[Admin]

Change it to HEAP then, you will get better performance.

[GOSatisfy]

My database is returning the following error:





Database error in vBulletin 2.2.5:

Invalid SQL:
SELECT

thread.threadid
FROM thread
WHERE thread.forumid = 28
AND thread.sticky=0
AND thread.visible=1
AND sticky=0

ORDER BY sticky DESC, lastpost DESC
LIMIT 0,25
mysql error: Unknown error

mysql error number: 1105

Date: Thursday 23rd of May 2002 07:53:09 PM
Script: http://dev.campkr.com/boards/boards/forumdisplay.php?s=&forumid=28
Referer: http://dev.campkr.com/boards/showthread.php?s=&threadid=79

However, if I remover the ", lastpost DESC" it returns what it is supposed to. How do I correct this so lastpost DESC will work when called from vB?

-bryan

[Admin]

What version of MySQL are you using?

[GOSatisfy]

mysql Ver 11.17 Distrib 3.23.49a, for pc-linux-gnu (i686)

[GOSatisfy]

Any ideas?

[Lesane]

Originally posted by FireFly
Change it to HEAP then, you will get better performance.

Changed, thanks. :)