Update db

Hi I get this message when I try to update jos_users table.

Tableusers::store failed - 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 'WHERE id='63'' at line 1 SQL=UPDATE `jos_users` SET WHERE id='63'

When I chage "Block user" from no to yes it is working fine, but when I change from yes to no I get the error above.

Any ideas?

Regards Erik

Hi Erik,

I'm not sure what code you are usign but there should be something between SET and WHERE like SET `block` = 1 WHERE . . .

Bob

PS It's generally not a good idea to write directly to the jos_users table but to use the Joomla! User Object instead.

Bob

Can you use the Joomla user object from the frontend?

Yes

$user = JFactory::getUser();