vb3_cpsession NOT found

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Andrew B.
    Member
    • Aug 2004
    • 56

    vb3_cpsession NOT found

    I have a fresh install of vBulletin 3.0.6. I want to import the users from another vBulletin, directly from its database. The other vBulletin is 3.0.5.

    I downloaded ImpEx tonight. It is Revision: 1.55 Date: 2005/01/06.

    I clicked the first step to check the database. Everything was okay, except for this message: "vb3_cpsession NOT found or a non standard table"

    I looked in phpMyAdmin and I can see that table. But I have no way of telling if it was created correctly.

    Suggestions?
  • Zachery
    Former vBulletin Support
    • Jul 2002
    • 59097

    #2
    the cpsession table is not important for an import.

    Comment

    • Steve Machol
      Former Customer Support Manager
      • Jul 2000
      • 154488

      #3
      Nonetheless that is a standard table in vB 3.0.6 and is required to log into the Admin CP. Have you checked the database to see if it's there and if it's set to 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

      • Zachery
        Former vBulletin Support
        • Jul 2002
        • 59097

        #4
        Just so we are clear, the above error states that it found it (most likely) but at the time of the importers development it is a NON STANDARD TABLE. Which just means its there, impex is telling you its there, but it wont do anything with it.

        Comment

        • Andrew B.
          Member
          • Aug 2004
          • 56

          #5
          The table is there. I had vBulletin back it up so I could show the SQL code that would create it. Here it is, except I am posting it here with an "x" in each data value in case this should not be posted.

          DROP TABLE IF EXISTS vb3_cpsession;
          CREATE TABLE vb3_cpsession (
          userid int(10) unsigned NOT NULL default '0',
          hash varchar(32) NOT NULL default '',
          dateline int(10) unsigned NOT NULL default '0',
          PRIMARY KEY (userid,hash)
          ) TYPE=HEAP;

          INSERT INTO vb3_cpsession VALUES('1', 'x', 'x');

          Comment

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