Manual downgrade from Joomla 3.2 to 3.1.6

Need help upgrading your Joomla! website or converting to Joomla! 3.x? Please consider the availability of third-party templates and extensions when deciding which Joomla version to use.

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.
davemurph24
Joomla! Apprentice
Joomla! Apprentice
Posts: 27
Joined: Thu Jun 13, 2013 12:43 pm

Manual downgrade from Joomla 3.2 to 3.1.6

Postby davemurph24 » Fri Dec 13, 2013 8:17 pm

Hi,

Is it possible to downgrade to joomla v 3.1.5 from 3.2 by ftp as v3.2 wont allow me backend access to my joomla site.
If so can you please tell me which folders to replace by ftp without destroying my site.
Thanks,
Dave
Last edited by davemurph24 on Wed Dec 18, 2013 3:55 pm, edited 1 time in total.

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

Re: Manual downgrade from Joomla 3.2 to 3.1.6

Postby leolam » Sat Dec 14, 2013 6:46 am

No you cannot !!! Do not even attempt this. This issue is fixed in the forthcoming 3.2.1 but to be able to login do the following:

go to PHPMyAdmin and open your database and find table xxx_users

here you see your username. Click edit and change the password to

Code: Select all

$2y$10$RnBFrtPNFRZxCr1yJPO08uDZsgBsuHjgFPU6.1LfA31n88WvbcpHm
Now you can login and your admin with your username and use as password
admin


Than go to user manager and change your password to something different and issue is resolved

Leo 8)
-- Joomla Professional Support Services : https://gws-desk.com --
-- Joomla Specialized Hosting Solutions: https://gws-host.com --
-- Joomla Professional Web Development & Design :www.gws-studio.com
-- Member Joomla Bug Squad --

davemurph24
Joomla! Apprentice
Joomla! Apprentice
Posts: 27
Joined: Thu Jun 13, 2013 12:43 pm

Re: Manual downgrade from Joomla 3.2 to 3.1.6

Postby davemurph24 » Sat Dec 14, 2013 9:33 am

@ leolam. Thanks for your reply.
I can log in now, but i get another error and control panel wont work.

0 SQL=INSERT INTO yurzk_user_usergroup_map (user_id,group_id) VALUES (140),(8)
A table in my database seems to be causing the problem. There seems to be no function set in that table....

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

Re: Manual downgrade from Joomla 3.2 to 3.1.6

Postby leolam » Sat Dec 14, 2013 9:47 am

What do you mean by "CTRL-Panel won't work?" Be specific pls? Look if this will resolve

go to extension manager ==> discover ==> select all that don't show up and hit the install button. When done ==> ext. manager ==> database ==> fix

Leo 8)
-- Joomla Professional Support Services : https://gws-desk.com --
-- Joomla Specialized Hosting Solutions: https://gws-host.com --
-- Joomla Professional Web Development & Design :www.gws-studio.com
-- Member Joomla Bug Squad --

davemurph24
Joomla! Apprentice
Joomla! Apprentice
Posts: 27
Joined: Thu Jun 13, 2013 12:43 pm

Re: Manual downgrade from Joomla 3.2 to 3.1.6

Postby davemurph24 » Sat Dec 14, 2013 10:11 am

Sorry, what i meant is the backend joomla panel wont do anything after logging in, the error above comes up and wont allow me to access any of the menus or options.
The last step i performed before this was a database fix like you suggested.
Thanks again for your reply, i have searched the net for 2 days and this seems to be the first error of this kind
Dave

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

Re: Manual downgrade from Joomla 3.2 to 3.1.6

Postby leolam » Sat Dec 14, 2013 10:20 am

Run the query in phpMyAdmin as given by the system

Leo 8)
-- Joomla Professional Support Services : https://gws-desk.com --
-- Joomla Specialized Hosting Solutions: https://gws-host.com --
-- Joomla Professional Web Development & Design :www.gws-studio.com
-- Member Joomla Bug Squad --

davemurph24
Joomla! Apprentice
Joomla! Apprentice
Posts: 27
Joined: Thu Jun 13, 2013 12:43 pm

Re: Manual downgrade from Joomla 3.2 to 3.1.6

Postby davemurph24 » Sat Dec 14, 2013 10:33 am

Hi Leo, response below after running query:

Error
SQL query:

0 SQL = INSERT INTO yurzk_user_usergroup_map( user_id, group_id )
VALUES ( 140 ) , ( 8 )

MySQL said: Documentation

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '0 SQL=INSERT INTO yurzk_user_usergroup_map (user_id,group_id) VALUES (140),(8)' at line 1

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

Re: Manual downgrade from Joomla 3.2 to 3.1.6

Postby leolam » Sat Dec 14, 2013 5:56 pm

query should be

Code: Select all

INSERT INTO yurzk_user_usergroup_map (user_id,group_id) VALUES (140),(8)


Leo 8)
-- Joomla Professional Support Services : https://gws-desk.com --
-- Joomla Specialized Hosting Solutions: https://gws-host.com --
-- Joomla Professional Web Development & Design :www.gws-studio.com
-- Member Joomla Bug Squad --

davemurph24
Joomla! Apprentice
Joomla! Apprentice
Posts: 27
Joined: Thu Jun 13, 2013 12:43 pm

Re: Manual downgrade from Joomla 3.2 to 3.1.6

Postby davemurph24 » Mon Dec 16, 2013 1:42 pm

Ran that query and below is the response.

Error
SQL query:

INSERT INTO yurzk_user_usergroup_map( user_id, group_id )
VALUES ( 140 ) , ( 8 )

MySQL said: Documentation

#1136 - Column count doesn't match value count at row 1

davemurph24
Joomla! Apprentice
Joomla! Apprentice
Posts: 27
Joined: Thu Jun 13, 2013 12:43 pm

Re: Manual downgrade from Joomla 3.2 to 3.1.6

Postby davemurph24 » Wed Dec 18, 2013 10:27 am

It was actually an issue with RSfirewall. Once this was disabled i was able to log in.
Now i have a new issue where my user manager panel wont work, i get an error: An error has occurred.
404 Component not found.

User avatar
dtarver
Joomla! Explorer
Joomla! Explorer
Posts: 300
Joined: Fri Oct 28, 2005 3:48 pm
Location: NYC
Contact:

Re: Manual downgrade from Joomla 3.2 to 3.1.6

Postby dtarver » Thu Jan 23, 2014 2:38 am

leolam wrote:...This issue is fixed in the forthcoming 3.2.1 ...



I just install 3.2.1 and am getting the same error "The most recent request was denied because it contained an invalid security token. Please refresh the page and try again.".

How do I fix this in Joomla 3.2.1 please?
Free Project Management Templates & Successful Project Management Resources
http://www.e-ProjectManagers.com Ready To Help You!

User avatar
sugarandspice35
Joomla! Intern
Joomla! Intern
Posts: 63
Joined: Thu May 16, 2013 6:37 pm

Re: Manual downgrade from Joomla 3.2 to 3.1.6

Postby sugarandspice35 » Thu Jan 23, 2014 3:25 am

lol joomla cmon team


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

Who is online

Users browsing this forum: No registered users and 12 guests