Joomla 2.5.6: SQL error while Enable User

Moderators: mandville, PhilD, General Support Moderators

Locked
webspot
Joomla! Apprentice
Joomla! Apprentice
Posts: 18
Joined: Mon Aug 13, 2012 9:36 am

Joomla 2.5.6: SQL error while Enable User

Post by webspot » Fri Sep 14, 2012 10:22 am

I disabled a user from User Manager & then tried to enabled that user but Joomla said

Code: Select all

jtableuser: :store failed
Unknown column 'resetCount' in 'field list' SQL=UPDATE `ngi_users` SET `name`='John',`username`='john',`email`='john@gmail.com',`password`='fc04534d9987946e1f871ab6b1792150:roUz15SDlv5saLOg49Sw9ABLOo60vp3u',`usertype`='',`block`='0',`sendEmail`='0',`registerDate`='2012-09-10 08:07:27',`lastvisitDate`='2012-09-10 11:35:19',`activation`='',`params`='{\"admin_style\":\"\",\"admin_language\":\"\",\"language\":\"\",\"editor\":\"\",\"helpsite\":\"\",\"timezone\":\"\"}',`resetCount`='0' WHERE `id`='47'

User avatar
toivo
Joomla! Master
Joomla! Master
Posts: 11165
Joined: Thu Feb 15, 2007 5:48 am
Location: Oxford, UK

Re: Joomla 2.5.6: SQL error while Enable User

Post by toivo » Sun Sep 23, 2012 9:24 am

Two new fields need to be added into the users table. Go to Extension Manager and click Database. You will probably see a message that the database structure is not uptodate. Click Fix in the top right hand corner and that should update the users table.
Toivo Talikka, Global Moderator

daddygluv
Joomla! Fledgling
Joomla! Fledgling
Posts: 2
Joined: Mon Mar 28, 2011 3:05 pm

Re: Joomla 2.5.6: SQL error while Enable User

Post by daddygluv » Thu May 16, 2013 1:30 pm

Thank you. That worked perfectly for us.


Locked

Return to “Access Control List (ACL) in Joomla! 2.5”