Migrate from Joomla 2.5.17 to Joomla 3.2.1

[meher5252]

Hi,

I am trying to upgrade my website from Joomla 2.5.17 to Joomla 3.2.1.
The website has very few 3rd party extensions.

First I restored my website on my local computer.
Then I uninstall all the third party extensions and templates.
Then tried to upgrade using one-click Joomla Upgrade manager.
After the upgrade was completed, a blank page was displayed.

Since I did not see any error, I refreshed the page and the below error message was displayed:

Error:
1091 Can't DROP 'usertype'; check that column/key exists SQL=ALTER TABLE `xxx_users` DROP KEY `usertype`;

I checked the 'xxx_users' table to see if 'usertype' column existed or not. There was no column named usertype' in the 'xxx_users' table.

When I try to access any menu from the Joomla Administrator section, the following error message is displayed:

Error:
Notice: Undefined property: InstallerController::$input in E:\xxx\xxx\public_html\administrator\components\com_installer\controller.php on line 39 Fatal error: Call to a member function get() on a non-object in E:\xxx\xxx\public_html\administrator\components\com_installer\controller.php on line 39


What am I doing wrong?

Any help will be appreciated.

[leolam]

Yep you are missing still some extensions seemingly but you can try to install from url and paste this http://joomlacode.org/gf/download/frsre ... ackage.zip and click install.

When done go to Extension Manager ==> Database==> Hit top left FIX

Should resolve

Leo

[manishn19]

Hi,
Is this mandatory to uninstall all third party ext. for migration.

Actually I have similar problem. I am having joomla 2.5.6 and want to upgrade with joomla 3.2.1, but when I clicked on "update and install" button there is nothing happening. This message comes up "Updating your Joomla! files. Please wait " and a spinner. Nothing else is going on

Please help

[leolam]

Actually I have similar problem. I am having joomla 2.5.6

Updater works properly after J2.5.7 so you need to install this patch first. Extension Manager> Install from URL> paste this link http://joomlacode.org/gf/download/frsre ... ackage.zip and hit 'install'

This will upgrade your site to J2.5.17

Next: go to Joomlaupdate component > options==> change to "Short Term Support ==> update to J3.2.1 will appear.

Next==> check extensions and make sure you install for your extensions the version that is compatible with J2.5 and (!) J3.x. So you go to the JED, check if they are available for both versions and to make sure you have latest download and reinstall all of them. Those that do not show a compatible batch to J3.x you will need to uninstall indefinitely.

Before doing all of this install Akeebabackup (free) make a backup ==>download to your PC so you have a non-crashed version in case something goes wrong

Leo

[manishn19]

Hey! thanks for your quick reply.

I followed your all instruction but same issue is coming up. Now I am on J2.5.17

No third party ext. is there

[leolam]

extension manager==> update==> purge cache

Leo

[manishn19]

huh! no luck is there also.

message showing there "Purge updated"

[hktotoro]

disable all 3rd party extensions then uninstall them. Upgrade stopped at 86.2% and unable to "ALTER TABLE `#__users` DROP KEY `usertype`;" (above error first line in 3.0.0.sql file). tried "Migrate Me PLUS", too but no luck.

Also tied to update to 3.3.1 but same thing happen.

Would it be possible to export all contents out, wipe joomla and db, reinstall joomla 3.3.1 from scratch, import back all contents?

[Per Yngve Berg]

Did you rember to disable the "Remember Me Plugin" before upgrading?
This Plugin often cause problems.

[hktotoro]

Yes, I disabled "Remember Me" before upgrade.

[leolam]

disable all 3rd party extensions then uninstall them. Upgrade stopped at 86.2% and unable to "ALTER TABLE `#__users` DROP KEY `usertype`;" (above error first line in 3.0.0.sql file).

http://forum.joomla.org/viewtopic.php?f=710&t=793171 You still have one or more 3rd party extensions (a template is also an extension) Find the culprit and you should be good to go

Leo

[maxhoschi]

This migration stuff is so annoying. Today I have tried to update from 2.5.17 to 3.3.6 way over ten times using XAMPP 1.8.3 without any success.

While crawling through the internet found several entries but not one hint that I need to get things running. Only some guy repeating himself with "there is something 3rd party on your system" in every threat...

Last try was the migration of a fresh and clean Joomla 2.5.17 installation (no additional extensions or templates installed). No chance! Ended up on 82.7% and those well known error messages while finalising update.

Sorry Leo, I believe your intentions are good, but what now? Any ideas?

Cheers

[Per Yngve Berg]

Don't upgrade from an outdated version. The latest is 2.5.27.
There was a change in user password encryption in 2.5.18.
Update to 2.5.27 first.

[maxhoschi]

Good hint, thanks! But I just wrote the wrong version nummer in my first post.
I used the 2.5.27 for all the migrations...

What I have done so far:

• - Migration of 2.5.27 Website with all content but without 3rd party extentions (exept those included in Joomla core)
  - Migration of 2.5.27 fresh core installation without 3rd party extentions (exept those included in Joomla core)
  - Migration after manual copy and paste of necessary database tables from website database to fresh Joomla 2.5 core database
  
  Result: White screen after 82.7% an upgrade.finalize, Error messages after page reload

• - Copy and overwrite of a 3.0.1 joomla over the 2.5.27 data, then database fix button in backend, then jupgrade to 3.3.6
  
  Result: Website works fine but backend is a mess...

This is gettin weird while analyzing the error message: Can't drop 'usertype'...
This field is available in the 2.5.27 database table 'xx_users' but it is missing on an untouched J3.3.6 database

[Per Yngve Berg]

Did you increase the Max Execution Time on the server?

[maxhoschi]

Yes I did. Using a php.ini...

And a couple of minutes ago just as a final step I downgraded this damn XAMPP from 1.8.3 to 1.8.2.

Still can not believe it, but this was the solution! Migration done!

What a monday!

[saovry]

I want to upgrade my joomla 2.5.27 to joomla 3.3.6. someone know the free component to upgrade joomla.
Thanks

[jcms]

I want to upgrade my joomla 2.5.27 to joomla 3.3.6. someone know the free component to upgrade joomla.
Thanks

Browse to Components → Joomla Update
You don't see it via back-end?

[saovry]

I want to upgrade my joomla 2.5.27 to joomla 3.3.6. someone know the free component to upgrade joomla.
Thanks

Browse to Components → Joomla Update
You don't see it via back-end?

Thanks I see it.