Announcement

Collapse
No announcement yet.

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

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • #16
    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;

    Comment


    • #17
      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.

      Comment


      • #18
        The installation sets the type to HEAP.

        Comment


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

          Comment


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

            Comment


            • #21
              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.

              Comment


              • #22
                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.

                Comment


                • #23
                  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.

                  Comment


                  • #24
                    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

                    Comment


                    • #25
                      Originally posted by 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
                      Last edited by Maagic; Fri 18th Jul '03, 10:56am.

                      Comment


                      • #26
                        Originally posted by Maagic
                        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
                        Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
                        Change CKEditor Colors to Match Style (for 4.1.4 and above)

                        Steve Machol Photography


                        Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


                        Comment


                        • #27
                          yes I did :/

                          Comment


                          • #28
                            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.
                            Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
                            Change CKEditor Colors to Match Style (for 4.1.4 and above)

                            Steve Machol Photography


                            Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


                            Comment


                            • #29
                              Originally posted by Maagic
                              yes I did :/
                              Run it again. It'll take you to beta 4 (you only ran upgrade1.php, which takes you to beta 3).

                              Comment


                              • #30
                                Originally posted by Ed Sullivan
                                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

                                Comment

                                widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
                                Working...
                                X