Magento Forum

Help! Added new user and now I cant login to admin panel! 
 
samleaver
Member
 
Total Posts:  45
Joined:  2008-03-04
 

Hi,

I’ve just added a new user in the admin and adjusted the users access and now neither me or the other user can login, when i try it just throws up this:

Parent Role id ‘G5’ does not exist
Trace:
#0 /var/www/html/terroir/lib/Zend/Acl.php(124): Zend_Acl_Role_Registry->add(Object(Mage_Admin_Model_Acl_Role_User), ‘G5’)
#1 /var/www/html/terroir/app/code/core/Mage/Admin/Model/Mysql4/Acl.php(100): Zend_Acl->addRole(Object(Mage_Admin_Model_Acl_Role_User), ‘G5’)
#2 /var/www/html/terroir/app/code/core/Mage/Admin/Model/Mysql4/Acl.php(69): Mage_Admin_Model_Mysql4_Acl->loadRoles(Object(Mage_Admin_Model_Acl), Array)
#3 /var/www/html/terroir/app/code/core/Mage/Admin/Model/Session.php(57): Mage_Admin_Model_Mysql4_Acl->loadAcl()
#4 /var/www/html/terroir/app/code/core/Mage/Admin/Model/Observer.php(43): Mage_Admin_Model_Session->login(’admin’, ‘password’, Object(Mage_Core_Controller_Request_Http))
#5 /var/www/html/terroir/app/code/core/Mage/Core/Model/App.php(1032): Mage_Admin_Model_Observer->actionPreDispatchAdmin(Object(Varien_Event_Observer))
#6 /var/www/html/terroir/app/Mage.php(278): Mage_Core_Model_App->dispatchEvent(’controller_acti...’, Array)
#7 /var/www/html/terroir/app/code/core/Mage/Core/Controller/Varien/Action.php(377): Mage::dispatchEvent(’controller_acti...’, Array)
#8 /var/www/html/terroir/app/code/core/Mage/Adminhtml/Controller/Action.php(116): Mage_Core_Controller_Varien_Action->preDispatch()
#9 /var/www/html/terroir/app/code/core/Mage/Core/Controller/Varien/Action.php(335): Mage_Adminhtml_Controller_Action->preDispatch()
#10 /var/www/html/terroir/app/code/core/Mage/Core/Controller/Varien/Router/Admin.php(148): Mage_Core_Controller_Varien_Action->dispatch(’index’)
#11 /var/www/html/terroir/app/code/core/Mage/Core/Controller/Varien/Front.php(146): Mage_Core_Controller_Varien_Router_Admin->match(Object(Mage_Core_Controller_Request_Http))
#12 /var/www/html/terroir/app/Mage.php(427): Mage_Core_Controller_Varien_Front->dispatch()
#13 /var/www/html/terroir/index.php(40): Mage::run()
#14 {main}

The frontend still works, any help would be greatley appreciated, I’ve spent weeks on this site and now no one can login to the admin panel!

Thanks

 
Magento Community Magento Community
Magento Community
Magento Community
 
ODB
Sr. Member
 
Avatar
Total Posts:  142
Joined:  2008-02-06
London
 

These must be stored on your mysql db. Is there any way you can look at a bare install to see compare tables to modify access rights?

 
Magento Community Magento Community
Magento Community
Magento Community
 
ODB
Sr. Member
 
Avatar
Total Posts:  142
Joined:  2008-02-06
London
 

You must have a backup of the main db? Compare admin_role and admin_user tables and try to piece together what’s wrong? Take a backup of your current db before you do though.

 
Magento Community Magento Community
Magento Community
Magento Community
 
samleaver
Member
 
Total Posts:  45
Joined:  2008-03-04
 

Thanks for your reply, I’ll have a look and see if i can see anything, I dont think I’ve got a backup tho :(

 
Magento Community Magento Community
Magento Community
Magento Community
 
samleaver
Member
 
Total Posts:  45
Joined:  2008-03-04
 

I deleted the new admin_user and admin_role that I had set up and now it works again! Thanks for your help ODB!

 
Magento Community Magento Community
Magento Community
Magento Community
 
wolfgang-kr
Jr. Member
 
Total Posts:  9
Joined:  2008-07-01
 

Hi have a simila problem and just don’t know what to do where and how can I add a user via phpmyadmin to become an admin?
Thank you, Wolfgang

Noticeunserialize() [function.unserialize]Error at offset 0 of 1 bytes  in /srv/www/vhosts/my-domain.com/httpdocs/magento/app/code/core/Mage/Admin/Model/Mysql4/User.php on line 109
Trace
:
#0 [internal function]: mageCoreErrorHandler(8, 'unserialize() [...', '/srv/www/vhosts...', 109, Array)
#1 /srv/www/vhosts/my-domain.com/httpdocs/magento/app/code/core/Mage/Admin/Model/Mysql4/User.php(109): unserialize('1')
#2 /srv/www/vhosts/my-domain.com/httpdocs/magento/app/code/core/Mage/Core/Model/Mysql4/Abstract.php(304): Mage_Admin_Model_Mysql4_User->_afterLoad(Object(Mage_Admin_Model_User))
#3 /srv/www/vhosts/my-domain.com/httpdocs/magento/app/code/core/Mage/Admin/Model/Mysql4/User.php(119): Mage_Core_Model_Mysql4_Abstract->load(Object(Mage_Admin_Model_User), '2', NULL)
#4 /srv/www/vhosts/my-domain.com/httpdocs/magento/app/code/core/Mage/Core/Model/Abstract.php(201): Mage_Admin_Model_Mysql4_User->load(Object(Mage_Admin_Model_User), '2', NULL)
#5 /srv/www/vhosts/my-domain.com/httpdocs/magento/app/code/core/Mage/Admin/Model/User.php(189): Mage_Core_Model_Abstract->load('2')
#6 /srv/www/vhosts/my-domain.com/httpdocs/magento/app/code/core/Mage/Admin/Model/Observer.php(61): Mage_Admin_Model_User->reload()
#7 /srv/www/vhosts/my-domain.com/httpdocs/magento/app/code/core/Mage/Core/Model/App.php(1032): Mage_Admin_Model_Observer->actionPreDispatchAdmin(Object(Varien_Event_Observer))
#8 /srv/www/vhosts/my-domain.com/httpdocs/magento/app/Mage.php(278): Mage_Core_Model_App->dispatchEvent('controller_acti...', Array)
#9 /srv/www/vhosts/my-domain.com/httpdocs/magento/app/code/core/Mage/Core/Controller/Varien/Action.php(377): Mage::dispatchEvent('controller_acti...', Array)
#10 /srv/www/vhosts/my-domain.com/httpdocs/magento/app/code/core/Mage/Adminhtml/Controller/Action.php(116): Mage_Core_Controller_Varien_Action->preDispatch()
#11 /srv/www/vhosts/my-domain.com/httpdocs/magento/app/code/core/Mage/Core/Controller/Varien/Action.php(335): Mage_Adminhtml_Controller_Action->preDispatch()
#12 /srv/www/vhosts/my-domain.com/httpdocs/magento/app/code/core/Mage/Core/Controller/Varien/Router/Admin.php(148): Mage_Core_Controller_Varien_Action->dispatch('index')
#13 /srv/www/vhosts/my-domain.com/httpdocs/magento/app/code/core/Mage/Core/Controller/Varien/Front.php(146): Mage_Core_Controller_Varien_Router_Admin->match(Object(Mage_Core_Controller_Request_Http))
#14 /srv/www/vhosts/my-domain.com/httpdocs/magento/app/Mage.php(427): Mage_Core_Controller_Varien_Front->dispatch()
#15 /srv/www/vhosts/my-domain.com/httpdocs/magento/index.php(40): Mage::run()
#16 {main}
 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top