ExpressionEngine CMS
Open, Free, Amazing

Thread

This is an archived forum and the content is probably no longer relevant, but is provided here for posterity.

The active forums are here.

Table exp_remember_me missing after updating from 2.3.1 -> 2.4.0

February 19, 2012 8:12am

Subscribe [2]
  • #1 / Feb 19, 2012 8:12am

    Komtur

    15 posts

    This question may be related to a resolved thread.


    Got the same error after updating from 2.3.1 -> 2.4.0.

    Solution:

    Create a new DB.
    Backup/ dump the old DB.
    Install a blank EE instanace into the new DB.
    Import the old DB into the new one.
    Error is gone.

    If you compare new with the old DB structure, table “exp_remember_me” is indeed missing.

    Here’s the Structure. Might save you lot of work.

    CREATE TABLE `exp_remember_me` (
       `remember_me_id` varchar(40) NOT NULL default '0',
       `member_id` int(10) default '0',
       `ip_address` varchar(16) default '0',
       `user_agent` varchar(120) default '',
       `admin_sess` tinyint(1) default '0',
       `site_id` int(4) default '1',
       `expiration` int(10) default '0',
       `last_refresh` int(10) default '0',
       PRIMARY KEY  (`remember_me_id`),
       KEY `member_id` (`member_id`)
     ) ENGINE=MyISAM DEFAULT CHARSET=utf8;

     

    EllisLab Team: please fix your EE Update Script!

  • #2 / Feb 19, 2012 11:39am

    Batdelfuego

    45 posts

    I’ve been loosing 10 hours of my weekend working on that same error.

    Thanks for your solution.

    I’ll try this out after I’m done sitting on cold ice.

  • #3 / Feb 20, 2012 1:08pm

    Sean C. Smith

    3818 posts

    Komtur,

    Thanks for sharing your solution. glad to see it worked for David as well.

    Sean

.(JavaScript must be enabled to view this email address)

ExpressionEngine News!

#eecms, #events, #releases