Upgrading 2.5.24 to 3.3 Error 1091 [RESOLVED]

Need help upgrading your Joomla! website or converting to Joomla! 3.x?

Moderator: General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.
Windows Defender SmartScreen Issues <-- please read this if using Windows 10.
Locked
monreric
Joomla! Apprentice
Joomla! Apprentice
Posts: 10
Joined: Fri Jan 07, 2011 8:35 pm

Upgrading 2.5.24 to 3.3 Error 1091 [RESOLVED]

Post by monreric » Wed Sep 03, 2014 4:22 pm

I get to 82.6% and then get the following error:

Code: Select all

1091 Can't DROP 'usertype'; check that column/key exists SQL=ALTER TABLE `#__users` DROP KEY `usertype`;
This happens with my existing site and with a clean/empty install.

Then the site is completely broken and has to be restored from backup.
Last edited by monreric on Mon Sep 08, 2014 2:11 pm, edited 1 time in total.

monreric
Joomla! Apprentice
Joomla! Apprentice
Posts: 10
Joined: Fri Jan 07, 2011 8:35 pm

Re: Upgrading 2.5.24 to 3.3 Error 1091

Post by monreric » Thu Sep 04, 2014 8:29 pm

OK, I am able to perform the upgrade with of a clean install and other sites if i rename remember.php. But still get this same error for one of my sites. I have enabled debugging and after I get the 1091 error the site is inaccessible and I only get the following error:

Code: Select all

Notice: Undefined property: LoginController::$input in \administrator\components\com_login\controller.php on line 38

Fatal error: Call to a member function set() on a non-object in \administrator\components\com_login\controller.php on line 38

User avatar
Slackervaara
Joomla! Ace
Joomla! Ace
Posts: 1048
Joined: Sat Aug 13, 2011 6:27 am

Re: Upgrading 2.5.24 to 3.3 Error 1091

Post by Slackervaara » Fri Sep 05, 2014 8:41 pm

1091 Can't DROP 'usertype'; check that column/key exists SQL=ALTER TABLE `#__users` DROP KEY `usertype`;

I got this error this night when I tried to update from 2.5 to 3.3 for the 4th time. This fixed my problem:
your-site-url.com/administrator/index.php?option=com_installer&task=database.fix

When your on the page run the database fix and then copy all Joomla 3.3 files except installation folder, so will the site work.

I found this solution here:
http://stackoverflow.com/questions/2073 ... 2-1-failed

I have got blank page on both frontend and backend all my trials. But if I copy Joomla files over and then restart the PC it seems to work. The last time with database fix I needed no reboot.

monreric
Joomla! Apprentice
Joomla! Apprentice
Posts: 10
Joined: Fri Jan 07, 2011 8:35 pm

Re: Upgrading 2.5.24 to 3.3 Error 1091

Post by monreric » Mon Sep 08, 2014 1:34 pm

Still get the same error:
Fatal error: Call to a member function set() on a non-object in administrator\components\com_login\controller.php on line 38

monreric
Joomla! Apprentice
Joomla! Apprentice
Posts: 10
Joined: Fri Jan 07, 2011 8:35 pm

Re: Upgrading 2.5.24 to 3.3 Error 1091 [RESOLVED]

Post by monreric » Mon Sep 08, 2014 2:17 pm

1.) Delete the old .sql files at /administrator/components/com_admin/sql/updates/mysql
2.) Start the upgrade and get the error for remember.php
3.) Rename remember.php to remember.php.bak
4.) Refresh/Reload update screen
5.) Get error for controller.php
6.) Load your-site-url.com/administrator/index.php?option=com_installer&task=database.fix
7.) Update completes


Locked

Return to “Migrating and Upgrading to Joomla! 3.x”