I have tried to upgrade to 9.1.2.1 and keep hitting a brick wall.
The first time I loaded it I got as far as logging in and hit the maintainance screen on all the pages (index.php, admin.php) which I couldn't get past.
I tried re-installing and now I get the following:

Code::

On /install.php While executing query "ALTER TABLE cms_bbsmilies ADD pos SMALLINT NOT NULL DEFAULT '0'" the following error occured: Duplicate column name 'pos' In: /home/conkers/public_html/includes/classes/installer.php on line: 94

I have re-loaded everything about three times now and can't get beyond this screen.
I did try all the various solutions in the various threads around the forum, and after 24 hours I'm getting desperate to get my site back on line.
All help/suggestions gratefully received.

you do probably have cms_bbsmilies and one more table *_bbsmilies

No, I have checked. There is only one cms_bbsmiliesm and no other *-smilies table. I have checked and double checked.
But thank you for your prompt reply.
Any other ideas?

Correction: it should read cms_smilies. Sorry - fingers too fat!

You mean cms_bbsmilies, right?

It's trying to add a field to that table which it already added when you ran the installer previously. Apparently the previous upgrade didn't complete, or else it should just say you're already running 9.1.2.1.

Drop the pos column from cms_bbsmilies and try running the installer again.

Thanks for your help, the deleting of the field worked and the Installer worked.
However, I am now back at square one as I can't access my site through the admin.php page.
I have tried all the suggestions that were offered in other threads and I'm still unable to get to my site.
Any other suggestions gratefully received

Did you set for the admin.php to be named something else?

What happens if you just turn maintenance off in the databalse?

Code::

UPDATE cms_config_custom SET cfg_value = 1 WHERE cfg_name = "global" AND cfg_field = "maintenance";

Quote::

Did you set for the admin.php to be named something else?

No, it is admin.php

Quote::

What happens if you just turn maintenance off in the databalse? Code:: UPDATE cms_config_custom SET cfg_value = 1 WHERE cfg_name = "global" AND cfg_field = "maintenance";

Still nothing, admin.php shows up as a maintainance page.
The full URL if you want to check is iancharlesphotos.net/admin.php

Now I am scared to upgrade

Any time you update configuration data directly in the database, you need to delete your website cache/config_MAIN_CFG.php so that it can re-generate with your changed settings.

Now it is getting worse, I now have a screen saying Database error when I try to log into the admin, and I'm receiving e-mails every two minutes telling me the following:

Quote::

On / While executing query "SELECT * FROM cms_security_flood WHERE flood_ip = 'Zò%è/'" the following error occured: Table 'conkers_icp150107.cms_security_flood' doesn't exist In: /home/conkers/public_html/includes/classes/security.php on line: 202

I am now beginning to regret upgrading!
I've checked the database for the file cms.security_flood which doesn't exist.
I'm currently checking an old database from a previous installation to see if it's there, but now I'm totally lost.
Please help me!!!!

I've checked a couple of old databases and I can't find any table called "*_security_flood" in any of them.
And every few minutes the e-mails telling me I have an error are filling up my inbox.

_security_flood exists since 9.1 so... How did it get lost, did you delete tables ?

I've not deleted it, and I can't find it in my 9.1.1 backup copy.
How do I create it?

heliown wrote:

Now I am scared to upgrade

from what i can see db was screwed before the upgrade OR you are upgrading using a different (so wrong) prefix for you tables OR you are sharing different versions of DragonflyCMS or any other CMS on the same database.