Thread

Hi

There seem to be numerous topics on the database error problems but I don’t see any fixes so I have added mine below.

This is a live site so would appreciate a response ASAP.

Thanks

David

A Database Error Occurred
Error Number: 1091

Can’t DROP ‘user_blog’; check that column/key exists

ALTER TABLE `exp_referrers` DROP COLUMN `user_blog`

Filename: /www/sssss/public_html/ssssss/expressionengine/modules/referrer/upd.referrer.php

Line Number: 146

David- goto to this thread for a solution You’ll need to edit one of the files

http://ellislab.com/forums/viewthread/218435/

That’s not it. I fixed that error , then I got this one.

thanks

Hi David,

I do apologize for your frustration and errors during the upgrade process.

When you get this error in the updater, can you look into the database and see if the “user_blog” column is already been dropped?

If so, you can add it back in, refresh the updater and let it continue the update process.

I look forward to your reply.

Cheers,

Hi Dan,

Its fixed.

Thanks

David

Glad to see Dan was able to get you all squared away, David. Let us know if you need anything else!