I had to restore my database, and now having some problems. Anyone have an idea of what is going on here?
I’m running latest build of EE 1.7.
Problem 1: New Entries are all given an entry number of ‘0’, and on entry submit, I am presented with the following error:
MySQL ERROR:
Error Number: 1062
Description: Duplicate entry ‘0’ for key ‘PRIMARY’
Query: INSERT INTO `exp_weblog_titles` (`entry_id`, `weblog_id`, `author_id`, `site_id`, `ip_address`, `title`, `url_title`, `entry_date`, `edit_date`, `versioning_enabled`, `year`, `month`, `day`, `expiration_date`, `comment_expiration_date`, `sticky`, `status`, `allow_comments`, `allow_trackbacks`, `forum_topic_id`, `dst_enabled`) VALUES (’‘, ‘4’, ‘1’, ‘1’, ‘64.151.46.94’, ‘Test Post’, ‘test_post1’, ‘1298694678’, ‘20110225123119’, ‘y’, ‘2011’, ‘02’, ‘25’, ‘0’, ‘0’, ‘n’, ‘open’, ‘y’, ‘y’, ‘0’, ‘n’)
Problem 2: If I am logged in, and try to access any page that contains a CAPTCHA, I am presented with the following error. This only occurs if I am logged in:
MySQL ERROR:
Error Number: 1062
Description: Duplicate entry ‘0’ for key ‘PRIMARY’
Query: INSERT INTO exp_captcha (date, ip_address, word) VALUES (UNIX_TIMESTAMP(), ‘64.xxx.xx.xx’, ‘carried86’)