Announcement

Collapse
No announcement yet.

SQL PROBLEM.....Please Help!!

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

  • SQL PROBLEM.....Please Help!!

    Database error in vBulletin 2.2.9:

    Invalid SQL: INSERT INTO session (sessionhash,userid,host,useragent,lastactivity,althash,location) VALUES ('224022c7624eb398e3fe17a8e3f1310d','1','141.157.221.189','Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1;','1058889611','','/forum/member.php')
    mysql error: Duplicate entry '224022c7624eb398e3fe17a8e3f1310d' for key 1

    mysql error number: 1062

    Date: Tuesday 22nd of July 2003 09:00:11 AM
    Script: http://www.jaydabhi.com/forum/forum/member.php
    Referer: http://www.jaydabhi.com/forum/

    I GET THIS PROBLEM WHEN I GO TO THE BOARD....

    If I clear my cookies, I can access my board, but when I login, it takes me back to that page, im sure it has to do with the sessions cuz its trying to put in info which exists......

    Please help...

    Peace

  • #2
    Try this query:

    DELETE FROM session;

    If that doesn't work, run this one:

    DROP TABLE session;
    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,
    althash CHAR (32) NOT NULL,
    PRIMARY KEY (sessionhash)
    ) TYPE=HEAP;
    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


    • #3
      Error

      SQL-query :

      DELETE FROM SESSION

      MySQL said:


      Table 'jaydabhi_forum.SESSION' doesn't exist


      WHEN I RUN THE FIRST QUERY....I GET THIS ERROR.......help :-P

      Peace

      Comment


      • #4
        When i run the next query everything gets populated, but when i go to the board i get this error...:

        Database error in vBulletin 2.2.9:

        Invalid SQL: INSERT INTO session (sessionhash,userid,host,useragent,lastactivity,althash,location) VALUES ('e9645b65200861c605dee7715fba6250','1','141.157.221.189','Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1;','1058891894','','/forum/')
        mysql error: Table 'jaydabhi_forum.session' doesn't exist

        mysql error number: 1146

        Date: Tuesday 22nd of July 2003 09:38:14 AM
        Script: http://www.jaydabhi.com/forum/forum/
        Referer:


        and then this one:

        Database error in vBulletin 2.2.9:

        Invalid SQL: DELETE FROM session WHERE sessionhash=''
        mysql error: Table 'jaydabhi_forum.session' doesn't exist

        mysql error number: 1146

        Date: Tuesday 22nd of July 2003 09:38:14 AM
        Script: http://www.jaydabhi.com/forum/forum/
        Referer:

        Peace

        Comment


        • #5
          Fill out a support ticket at:

          http://www.vbulletin.com/members/support_form.php

          Be sure to include the login info to your Admin CP, phpMyAdmin and FTP.
          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

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