Migrate from Joomla 2.5.17 to Joomla 3.2.1

Joomla versions 2.5, 1.7 and 1.6 are all end-of-life since December 31st 2014 and are no longer supported. Please use Joomla 3.x instead.

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.
Locked
meher5252
Joomla! Apprentice
Joomla! Apprentice
Posts: 11
Joined: Wed Jul 28, 2010 8:43 am
Contact:

Migrate from Joomla 2.5.17 to Joomla 3.2.1

Post by meher5252 » Mon Dec 23, 2013 5:53 am

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.

User avatar
leolam
Joomla! Master
Joomla! Master
Posts: 19675
Joined: Mon Aug 29, 2005 10:17 am
Location: Netherlands/ UK/ S'pore/Jakarta/ North America
Contact:

Re: Migrate from Joomla 2.5.17 to Joomla 3.2.1

Post by leolam » Wed Dec 25, 2013 5:39 am

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 8)
Joomla's #1 Professional Support Provider:
-> Joomla Professional Support: https://gws-desk.com -
-> Joomla Specialized Hosting Solutions: https://gws-host.com -
-> Joomla Webmaster Services: gws-webmaster.services

manishn19
Joomla! Fledgling
Joomla! Fledgling
Posts: 3
Joined: Thu Dec 26, 2013 6:57 am

Re: Migrate from Joomla 2.5.17 to Joomla 3.2.1

Post by manishn19 » Thu Dec 26, 2013 7:11 am

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

User avatar
leolam
Joomla! Master
Joomla! Master
Posts: 19675
Joined: Mon Aug 29, 2005 10:17 am
Location: Netherlands/ UK/ S'pore/Jakarta/ North America
Contact:

Re: Migrate from Joomla 2.5.17 to Joomla 3.2.1

Post by leolam » Thu Dec 26, 2013 7:52 am

manishn19 wrote: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 8)
Joomla's #1 Professional Support Provider:
-> Joomla Professional Support: https://gws-desk.com -
-> Joomla Specialized Hosting Solutions: https://gws-host.com -
-> Joomla Webmaster Services: gws-webmaster.services

manishn19
Joomla! Fledgling
Joomla! Fledgling
Posts: 3
Joined: Thu Dec 26, 2013 6:57 am

Re: Migrate from Joomla 2.5.17 to Joomla 3.2.1

Post by manishn19 » Thu Dec 26, 2013 8:52 am

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

:(

User avatar
leolam
Joomla! Master
Joomla! Master
Posts: 19675
Joined: Mon Aug 29, 2005 10:17 am
Location: Netherlands/ UK/ S'pore/Jakarta/ North America
Contact:

Re: Migrate from Joomla 2.5.17 to Joomla 3.2.1

Post by leolam » Thu Dec 26, 2013 9:07 am

extension manager==> update==> purge cache

Leo 8)
Joomla's #1 Professional Support Provider:
-> Joomla Professional Support: https://gws-desk.com -
-> Joomla Specialized Hosting Solutions: https://gws-host.com -
-> Joomla Webmaster Services: gws-webmaster.services

manishn19
Joomla! Fledgling
Joomla! Fledgling
Posts: 3
Joined: Thu Dec 26, 2013 6:57 am

Re: Migrate from Joomla 2.5.17 to Joomla 3.2.1

Post by manishn19 » Thu Dec 26, 2013 9:42 am

huh! no luck is there also.

message showing there "Purge updated"

hktotoro
Joomla! Fledgling
Joomla! Fledgling
Posts: 2
Joined: Tue Aug 13, 2013 4:55 am

Re: Migrate from Joomla 2.5.17 to Joomla 3.2.1

Post by hktotoro » Thu Jul 10, 2014 2:33 pm

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?

User avatar
Per Yngve Berg
Joomla! Master
Joomla! Master
Posts: 26032
Joined: Mon Oct 27, 2008 9:27 pm
Location: Akershus, Norway

Re: Migrate from Joomla 2.5.17 to Joomla 3.2.1

Post by Per Yngve Berg » Thu Jul 10, 2014 3:40 pm

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

hktotoro
Joomla! Fledgling
Joomla! Fledgling
Posts: 2
Joined: Tue Aug 13, 2013 4:55 am

Re: Migrate from Joomla 2.5.17 to Joomla 3.2.1

Post by hktotoro » Thu Jul 10, 2014 6:31 pm

Yes, I disabled "Remember Me" before upgrade.

User avatar
leolam
Joomla! Master
Joomla! Master
Posts: 19675
Joined: Mon Aug 29, 2005 10:17 am
Location: Netherlands/ UK/ S'pore/Jakarta/ North America
Contact:

Re: Migrate from Joomla 2.5.17 to Joomla 3.2.1

Post by leolam » Fri Jul 11, 2014 4:29 am

hktotoro wrote: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 8)
Joomla's #1 Professional Support Provider:
-> Joomla Professional Support: https://gws-desk.com -
-> Joomla Specialized Hosting Solutions: https://gws-host.com -
-> Joomla Webmaster Services: gws-webmaster.services

maxhoschi
Joomla! Fledgling
Joomla! Fledgling
Posts: 3
Joined: Mon Nov 17, 2014 7:46 pm

Re: Migrate from Joomla 2.5.17 to Joomla 3.2.1

Post by maxhoschi » Mon Nov 17, 2014 8:03 pm

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
Last edited by maxhoschi on Mon Nov 17, 2014 11:34 pm, edited 1 time in total.

User avatar
Per Yngve Berg
Joomla! Master
Joomla! Master
Posts: 26032
Joined: Mon Oct 27, 2008 9:27 pm
Location: Akershus, Norway

Re: Migrate from Joomla 2.5.17 to Joomla 3.2.1

Post by Per Yngve Berg » Mon Nov 17, 2014 8:19 pm

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
Joomla! Fledgling
Joomla! Fledgling
Posts: 3
Joined: Mon Nov 17, 2014 7:46 pm

Re: Migrate from Joomla 2.5.17 to Joomla 3.2.1

Post by maxhoschi » Mon Nov 17, 2014 8:50 pm

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

User avatar
Per Yngve Berg
Joomla! Master
Joomla! Master
Posts: 26032
Joined: Mon Oct 27, 2008 9:27 pm
Location: Akershus, Norway

Re: Migrate from Joomla 2.5.17 to Joomla 3.2.1

Post by Per Yngve Berg » Mon Nov 17, 2014 9:34 pm

Did you increase the Max Execution Time on the server?

maxhoschi
Joomla! Fledgling
Joomla! Fledgling
Posts: 3
Joined: Mon Nov 17, 2014 7:46 pm

Re: Migrate from Joomla 2.5.17 to Joomla 3.2.1

Post by maxhoschi » Mon Nov 17, 2014 9:40 pm

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! >:( ;D

saovry
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 226
Joined: Sat Jan 08, 2011 3:52 pm

Re: Migrate from Joomla 2.5.17 to Joomla 3.2.1

Post by saovry » Wed Dec 03, 2014 2:36 pm

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've been banned!
Posts: 2233
Joined: Wed Nov 19, 2014 9:23 am

Re: Migrate from Joomla 2.5.17 to Joomla 3.2.1

Post by jcms » Wed Dec 03, 2014 2:51 pm

saovry wrote: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
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 226
Joined: Sat Jan 08, 2011 3:52 pm

Re: Migrate from Joomla 2.5.17 to Joomla 3.2.1

Post by saovry » Wed Dec 03, 2014 4:34 pm

jcms wrote:
saovry wrote: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.


Locked

Return to “Migrating and Upgrading to Joomla! 2.5”