Page 1 of 1

Joomla 2.5.6: SQL error while Enable User

Posted: Fri Sep 14, 2012 10:22 am
by webspot
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'

Re: Joomla 2.5.6: SQL error while Enable User

Posted: Sun Sep 23, 2012 9:24 am
by toivo
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.

Re: Joomla 2.5.6: SQL error while Enable User

Posted: Thu May 16, 2013 1:30 pm
by daddygluv
Thank you. That worked perfectly for us.