The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

horde sql error

Discussion in 'Database Discussions' started by caeos, Aug 31, 2008.

  1. caeos

    caeos Well-Known Member

    Joined:
    Jul 18, 2007
    Messages:
    79
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    UK
    can someone suggest how to repair this without telling me to ssh,

     
  2. electron33

    electron33 Well-Known Member

    Joined:
    Feb 24, 2004
    Messages:
    90
    Likes Received:
    0
    Trophy Points:
    16
    Log in as root and type the following commands (in bold):


    #mysql
    #mysql> use horde
    #mysql> repair table horde_sessionhandler;

    The final command should return:

    +----------------------------+--------+----------+----------+
    | Table | Op | Msg_type | Msg_text |
    +----------------------------+--------+----------+----------+
    | horde.horde_sessionhandler | repair | status | OK |
    +----------------------------+--------+----------+----------+
    1 row in set (0.91 sec)
     
  3. caeos

    caeos Well-Known Member

    Joined:
    Jul 18, 2007
    Messages:
    79
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    UK
    thanks butanyone else please
    can someone suggest how to repair this without telling me to ssh,
    or in other words.. i do not have telnet/putty/ssh access:eek:






     
  4. caeos

    caeos Well-Known Member

    Joined:
    Jul 18, 2007
    Messages:
    79
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    UK
    SOLVED
    checked the main sql processes and

    as it says its "in use"

    deleted table and recreated with
    Code:
    CREATE TABLE horde_sessionhandler (session_id VARCHAR(32) NOT NULL, session_lastmodified INT NOT NULL, session_data LONGBLOB, PRIMARY KEY (session_id)) ENGINE = InnoDB;
    GRANT SELECT, INSERT, UPDATE, DELETE ON horde_sessionhandler TO horde@localhost;
    log in now granted.
    i will let you know if i get issue with imap log in
     
Loading...

Share This Page