This is an archived forum and the content is probably no longer relevant, but is provided here for posterity.
The active forums are here.
December 17, 2011 3:37am
Subscribe [3]#1 / Dec 17, 2011 3:37am
I’ve had to re-import the database and yet errors persist.
Has anyone encountered this problem? What do you advise?
Many thanks for your support and development of a superior Content Management System.
(Also—I’ve been MIA for a while. It’s good to be back!).
Have a great holiday season,
Bobby McGee
#2 / Dec 19, 2011 12:50am
bump
#3 / Dec 19, 2011 5:33am
Hi Bobby,
Welcome back 😊
What were your exact errors please?
When you roll back your database make sure you delete existing database first. See here
#4 / Dec 19, 2011 11:29pm
error below:
A Database Error Occurred
Error Number: 1060
Duplicate column name 'field_content_type'
ALTER TABLE `exp_weblog_fields` ADD COLUMN `field_content_type` VARCHAR(20) NOT NULL default 'any'
Filename: updates/ud_200.php
Line Number: 1704
« BackWill try to revamp the database tomorrow…thanks for the info
Bobby
#5 / Dec 21, 2011 1:13am
Have you been able to re-try your upgrade after making sure your database was clear of any artifacts from previous upgrades?
#6 / Dec 22, 2011 2:17am
First, I’m unsure what you mean by “artifacts”.
Second, I did try to re-upgrade EE and got this error:
A Database Error Occurred
Error Number: 1060
Duplicate column name 'field_content_type'
ALTER TABLE `exp_weblog_fields` ADD COLUMN `field_content_type` VARCHAR(20) NOT NULL default 'any'
Filename: updates/ud_200.php
Line Number: 1704Thoughts?
#7 / Dec 23, 2011 3:39pm
Bobby,
It looks like when you re-tried the upgrade after the failed attempt you did not completely drop all tables before restoring your database - see this article on Retrying After a Failed Upgrade.
Can you completely delete your database and then restore from the back up and try again.
Sean