Manual downgrade from Joomla 3.2 to 3.1.6
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.
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.
-
- Joomla! Apprentice
- Posts: 31
- Joined: Thu Jun 13, 2013 12:43 pm
Manual downgrade from Joomla 3.2 to 3.1.6
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
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.
- leolam
- Joomla! Master
- Posts: 20652
- Joined: Mon Aug 29, 2005 10:17 am
- Location: Netherlands/ Germany/ S'pore/Bogor/ North America
- Contact:
Re: Manual downgrade from Joomla 3.2 to 3.1.6
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 Now you can login and your admin with your username and use as password
Leo
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
Than go to user manager and change your password to something different and issue is resolvedadmin
Leo
Joomla's #1 Professional Services Provider:
#Joomla Professional Support: https://gws-desk.com -
#Joomla Specialized Hosting Solutions: https://gws-host.com -
#Joomla Professional Support: https://gws-desk.com -
#Joomla Specialized Hosting Solutions: https://gws-host.com -
-
- Joomla! Apprentice
- Posts: 31
- Joined: Thu Jun 13, 2013 12:43 pm
Re: Manual downgrade from Joomla 3.2 to 3.1.6
@ 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....
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....
- leolam
- Joomla! Master
- Posts: 20652
- Joined: Mon Aug 29, 2005 10:17 am
- Location: Netherlands/ Germany/ S'pore/Bogor/ North America
- Contact:
Re: Manual downgrade from Joomla 3.2 to 3.1.6
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
go to extension manager ==> discover ==> select all that don't show up and hit the install button. When done ==> ext. manager ==> database ==> fix
Leo
Joomla's #1 Professional Services Provider:
#Joomla Professional Support: https://gws-desk.com -
#Joomla Specialized Hosting Solutions: https://gws-host.com -
#Joomla Professional Support: https://gws-desk.com -
#Joomla Specialized Hosting Solutions: https://gws-host.com -
-
- Joomla! Apprentice
- Posts: 31
- Joined: Thu Jun 13, 2013 12:43 pm
Re: Manual downgrade from Joomla 3.2 to 3.1.6
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
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
- leolam
- Joomla! Master
- Posts: 20652
- Joined: Mon Aug 29, 2005 10:17 am
- Location: Netherlands/ Germany/ S'pore/Bogor/ North America
- Contact:
Re: Manual downgrade from Joomla 3.2 to 3.1.6
Run the query in phpMyAdmin as given by the system
Leo
Leo
Joomla's #1 Professional Services Provider:
#Joomla Professional Support: https://gws-desk.com -
#Joomla Specialized Hosting Solutions: https://gws-host.com -
#Joomla Professional Support: https://gws-desk.com -
#Joomla Specialized Hosting Solutions: https://gws-host.com -
-
- Joomla! Apprentice
- Posts: 31
- Joined: Thu Jun 13, 2013 12:43 pm
Re: Manual downgrade from Joomla 3.2 to 3.1.6
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
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
- leolam
- Joomla! Master
- Posts: 20652
- Joined: Mon Aug 29, 2005 10:17 am
- Location: Netherlands/ Germany/ S'pore/Bogor/ North America
- Contact:
Re: Manual downgrade from Joomla 3.2 to 3.1.6
query should be
Leo
Code: Select all
INSERT INTO yurzk_user_usergroup_map (user_id,group_id) VALUES (140),(8)
Joomla's #1 Professional Services Provider:
#Joomla Professional Support: https://gws-desk.com -
#Joomla Specialized Hosting Solutions: https://gws-host.com -
#Joomla Professional Support: https://gws-desk.com -
#Joomla Specialized Hosting Solutions: https://gws-host.com -
-
- Joomla! Apprentice
- Posts: 31
- Joined: Thu Jun 13, 2013 12:43 pm
Re: Manual downgrade from Joomla 3.2 to 3.1.6
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
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
-
- Joomla! Apprentice
- Posts: 31
- Joined: Thu Jun 13, 2013 12:43 pm
Re: Manual downgrade from Joomla 3.2 to 3.1.6
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.
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.
- dtarver
- Joomla! Explorer
- Posts: 302
- Joined: Fri Oct 28, 2005 3:48 pm
- Location: NYC
- Contact:
Re: Manual downgrade from Joomla 3.2 to 3.1.6
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!
http://www.e-ProjectManagers.com Ready To Help You!
- sugarandspice35
- Joomla! Intern
- Posts: 63
- Joined: Thu May 16, 2013 6:37 pm
Re: Manual downgrade from Joomla 3.2 to 3.1.6
lol joomla cmon team