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

[giaxaydung]

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:

​

What can I do now? I hate to do repair database day by day . Thank you for your support.

 

[Jake Bunce]

Do you mean xf_session?

See this doc:

http://dev.mysql.com/doc/refman/5.1/en/corrupted-myisam-tables.html

Ideally you should forward this to your web host or server admin.

 

[Jake Bunce]

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:

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;