The Joomla! Forum ™



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.



Post new topic Reply to topic  [ 12 posts ] 
Author Message
PostPosted: Fri Dec 13, 2013 8:17 pm 
Joomla! Apprentice
Joomla! Apprentice

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

Top
 Profile  
 
PostPosted: Sat Dec 14, 2013 6:46 am 
User avatar
Joomla! Master
Joomla! Master

Joined: Mon Aug 29, 2005 10:17 am
Posts: 14020
Location: Netherlands/ UK/ S'pore/Jakarta/ North America
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:
$2y$10$RnBFrtPNFRZxCr1yJPO08uDZsgBsuHjgFPU6.1LfA31n88WvbcpHm
Now you can login and your admin with your username and use as password
Quote:
admin


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

Leo 8)

_________________
-- Joomla Professional Support Services : http://gws-desk.com --
-- Good & Cheap Joomla Sites Ready To Roll : http://gws-deals.today --
-- Joomla Specialized Hosting Solutions : www.gws-host.com --
-- Member Joomla Bug Squad --


Top
 Profile  
 
PostPosted: Sat Dec 14, 2013 9:33 am 
Joomla! Apprentice
Joomla! Apprentice

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


Top
 Profile  
 
PostPosted: Sat Dec 14, 2013 9:47 am 
User avatar
Joomla! Master
Joomla! Master

Joined: Mon Aug 29, 2005 10:17 am
Posts: 14020
Location: Netherlands/ UK/ S'pore/Jakarta/ North America
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 : http://gws-desk.com --
-- Good & Cheap Joomla Sites Ready To Roll : http://gws-deals.today --
-- Joomla Specialized Hosting Solutions : www.gws-host.com --
-- Member Joomla Bug Squad --


Top
 Profile  
 
PostPosted: Sat Dec 14, 2013 10:11 am 
Joomla! Apprentice
Joomla! Apprentice

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


Top
 Profile  
 
PostPosted: Sat Dec 14, 2013 10:20 am 
User avatar
Joomla! Master
Joomla! Master

Joined: Mon Aug 29, 2005 10:17 am
Posts: 14020
Location: Netherlands/ UK/ S'pore/Jakarta/ North America
Run the query in phpMyAdmin as given by the system

Leo 8)

_________________
-- Joomla Professional Support Services : http://gws-desk.com --
-- Good & Cheap Joomla Sites Ready To Roll : http://gws-deals.today --
-- Joomla Specialized Hosting Solutions : www.gws-host.com --
-- Member Joomla Bug Squad --


Top
 Profile  
 
PostPosted: Sat Dec 14, 2013 10:33 am 
Joomla! Apprentice
Joomla! Apprentice

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


Top
 Profile  
 
PostPosted: Sat Dec 14, 2013 5:56 pm 
User avatar
Joomla! Master
Joomla! Master

Joined: Mon Aug 29, 2005 10:17 am
Posts: 14020
Location: Netherlands/ UK/ S'pore/Jakarta/ North America
query should be
Code:
INSERT INTO yurzk_user_usergroup_map (user_id,group_id) VALUES (140),(8)


Leo 8)

_________________
-- Joomla Professional Support Services : http://gws-desk.com --
-- Good & Cheap Joomla Sites Ready To Roll : http://gws-deals.today --
-- Joomla Specialized Hosting Solutions : www.gws-host.com --
-- Member Joomla Bug Squad --


Top
 Profile  
 
PostPosted: Mon Dec 16, 2013 1:42 pm 
Joomla! Apprentice
Joomla! Apprentice

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


Top
 Profile  
 
PostPosted: Wed Dec 18, 2013 10:27 am 
Joomla! Apprentice
Joomla! Apprentice

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


Top
 Profile  
 
PostPosted: Thu Jan 23, 2014 2:38 am 
User avatar
Joomla! Explorer
Joomla! Explorer

Joined: Fri Oct 28, 2005 3:48 pm
Posts: 286
Location: NYC
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!


Top
 Profile  
 
PostPosted: Thu Jan 23, 2014 3:25 am 
User avatar
Joomla! Intern
Joomla! Intern

Joined: Thu May 16, 2013 6:37 pm
Posts: 62
lol joomla cmon team


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 12 posts ] 



Who is online

Users browsing this forum: No registered users and 36 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
Powered by phpBB® Forum Software © phpBB Group