Community Forums
Connect with us on LinkedIn
+ Reply to Thread
Results 1 to 4 of 4
  1. #1
    Member
    Join Date
    Jul 2007
    Location
    UK
    Posts
    76

    Default horde sql error

    can someone suggest how to repair this without telling me to ssh,

    horde.horde_sessionhandler
    Error : Can't find file: 'horde_sessionhandler' (errno: 2)
    error : Corrupt

  2. #2
    Member
    Join Date
    Feb 2004
    Posts
    105

    Default

    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. #3
    Member
    Join Date
    Jul 2007
    Location
    UK
    Posts
    76

    Default

    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






    Quote Originally Posted by electron33 View Post
    Log in as root and type the following commands (in bold):

  4. #4
    Member
    Join Date
    Jul 2007
    Location
    UK
    Posts
    76

    Thumbs up

    SOLVED
    checked the main sql processes and

    horde.horde_sessionhandler repair Error Can't find file: 'horde_sessionhandler' (errno: 2)
    horde.horde_sessionhandler repair error Corrupt
    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

Similar Threads & Tags
Similar threads

  1. Horde and the PHPmyadmin sql error
    By caeos in forum E-mail Discussions
    Replies: 2
    Last Post: 08-12-2009, 10:30 PM
  2. horde sql error
    By caeos in forum cPanel and WHM Discussions
    Replies: 3
    Last Post: 08-31-2008, 04:35 PM
  3. Replies: 4
    Last Post: 06-25-2008, 11:03 AM
  4. [line 108 of /usr/local/cpanel/base/horde/lib/Prefs/sql.php]
    By Christleo in forum Database Discussions
    Replies: 17
    Last Post: 08-11-2004, 04:14 AM
  5. Horde Error -/usr/local/cpanel/base/horde/lib/Registry.php
    By compunet2 in forum cPanel and WHM Discussions
    Replies: 8
    Last Post: 01-20-2004, 08:19 AM
Linkedin       Facebook       Twitter       RSS       Flickr       YouTube