Database error Unknown column 'bypass' in 'where clause'

[Freddie Bingham]

You created the wrong table type if you used the above query:

TYPE=MyISAM

This is the correct query to create the session table

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;

[Stryker]

Thanks, but I've tried it both ways and the table still seems to get screwed up. I've read similar posts where it has been said that this table type should be set to HEAP yet it is automatically set to MyISAM by the forum installation routine. Another member said that his table has also been that way for as long as he can remember. This only started happening from beta 4 onwards, but then those Inktomi bots weren't swarming all over my forum when I was using beta 3 so I don't know if it would survive these intensive crawls if I happened to still be using beta 3.

[Freddie Bingham]

The installation sets the type to HEAP.

[qxh]

Freddie, it didn't for me. That was the exact dump of my session table for vB3 Beta 4.

[Freddie Bingham]

Did you upgrade or install? If you upgraded then it would have stayed at whatever type it was, which should have been HEAP.

[Stryker]

I upgraded from 2.3.0 to 3.0 beta 3, then to 3.0 beta 4 if that info is of any use to you.

[Freddie Bingham]

I can only assume that at the time we changed the session table to HEAP, you were on a version of Mysql that didn't support it.

[Stryker]

Ah, that sounds plausible. Good news - my session table hasn't crashed since I last posted in this thread. It must have been the queries I found in that install file that were causing the problems when I tried switching between HEAP and ISAM the first time. Using the alternative queries posted above as well as having the type set to HEAP seems to have done the trick. Thanks for all your help.

[Maagic]

I'm getting this error and I upgraded straight from 2.3.0 to beta 4 and ran the upgrade script...

everything else is working great though.

I tried the repair/optimize trick though... we'll see if that fixes it

[Maagic]

I'm getting this error and I upgraded straight from 2.3.0 to beta 4 and ran the upgrade script...

everything else is working great though.

I tried the repair/optimize trick though... we'll see if that fixes it

Nope still gettin the error... here is the email I get

Database error in vBulletin 3.0.0 Beta 3:
Invalid SQL:
### Query for stale sessions that don't bypass the lastactivity ###
SELECT userid,lastactivity
FROM session
WHERE lastactivity < 1058550998
AND bypass = 0
mysql error: Unknown column 'bypass' in 'where clause'
mysql error number: 1054
Date: Friday 18th of July 2003 06:06:38 PM
Script: http://www.rickandbubba.net/gundogs/cron.php?&rand=647389
Referer: http://www.rickandbubba.net/gundogs/
Username: Unregistered
IP Address: xxx.xx.xx.xx


I don't know why I'm seeing 'beta 3' listed everywhere, I just downloaded it last night


Edit> I tried dropping the table and making a new one with the info posted earlier... we'll see if that works

[Steve Machol]

I don't know why I'm seeing 'beta 3' listed everywhere, I just downloaded it last night

Did you run upgrade.php (not upgrade1 or 2) as per the instructions?

http://www.vbulletin.com/forum/showthread.php?t=75855

[Maagic]

yes I did :/

[Steve Machol]

Hmmm...then I don't see how it could say beta 3. The only other thing it could be is that you didn't complete the entire upgrade process.

[Mike Sullivan]

yes I did :/

Run it again. It'll take you to beta 4 (you only ran upgrade1.php, which takes you to beta 3).

[Maagic]

Run it again. It'll take you to beta 4 (you only ran upgrade1.php, which takes you to beta 3).

Tried that and got this error

Database error in vBulletin 3.0.0 Beta 3:
Invalid SQL: ALTER TABLE calendarcustomfield
ADD description MEDIUMTEXT NOT NULL
mysql error: Duplicate column name 'description'
mysql error number: 1060
Date: Saturday 19th of July 2003 01:44:10 AM
Script: http://www.rickandbubba.net/gundogs/...de2.php?step=1
Referer:
Username: Maagic