1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

XF 1.5 Mysqli statement execute error : Duplicate entry '1448588197' for key 'expiry_date'

Discussion in 'Troubleshooting and Problems' started by giaxaydung, Nov 27, 2015.

  1. giaxaydung

    giaxaydung New Member

    I get the error repair xf_section table in database day by day. When the error appear, I sign in phpMyAdmin, choose the xf_section table and run repair command. That's OK.

    But my forum now always get this error (day by day). Before I convert my forum from VBB to Xenforo. Every thing seem OK. When I upgraded to Xenforo 1.5 and PhP 5.4.23 (follow upgrade required) I got this error. Today I get another error:
    server error.jpg

    What can I do now? I hate to do repair database day by day :(. Thank you for your support.
     
  2. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

  3. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    Actually...

    Why is there a duplicate key error on a non-unique index? It looks to me like your xf_session definition might be... wrong. Try recreating that table by running these queries in phpmyadmin:

    Code:
    DROP TABLE xf_session;
    
    CREATE TABLE xf_session (
    	session_id VARBINARY(32) NOT NULL,
    	session_data MEDIUMBLOB NOT NULL,
    	expiry_date INT UNSIGNED NOT NULL,
    	PRIMARY KEY (session_id),
    	KEY expiry_date (expiry_date)
    ) ENGINE = MyISAM CHARACTER SET utf8 COLLATE utf8_general_ci;
    
     

Share This Page