• 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'

#1
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.
 

Jake Bunce

XenForo moderator
Staff member
#3
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;