Manual downgrade from Joomla 3.2 to 3.1.6

[davemurph24]

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

[leolam]

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

[davemurph24]

@ 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....

[leolam]

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

[davemurph24]

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

[leolam]

Run the query in phpMyAdmin as given by the system

Leo

[davemurph24]

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

[leolam]

query should be

Code: Select all

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

Leo

[davemurph24]

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]

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.

[dtarver]

...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?

[sugarandspice35]

lol joomla cmon team