<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0">
	<channel>
		<title><![CDATA[Latest posts for the topic "Lost admin"]]></title>
		<link>http://www.jforum.net/posts/list/4.page</link>
		<description><![CDATA[Latest messages posted in the topic "Lost admin"]]></description>
		<generator>JForum - http://www.jforum.net</generator>
			<item>
				<title>Lost admin</title>
				<description><![CDATA[ It seems like I've changed my admin users priviliges to non-admin. I log in as adamin but I cant get to the admin pages. Any way to recover from this? * <img src="http://www.jforum.net/images/smilies/c30b4198e0907b23b8246bdd52aa1c3c.gif" border="0">  Some days it's just not worth getting out of bed <img src="http://www.jforum.net/images/smilies/3b63d1616c5dfcf29f8a7a031aaa7cad.gif" border="0">]]></description>
				<guid isPermaLink="true">http://www.jforum.net/posts/preList/399/1735.page</guid>
				<link>http://www.jforum.net/posts/preList/399/1735.page</link>
				<pubDate><![CDATA[Thu, 30 Sep 2004 09:26:50]]> GMT</pubDate>
				<author><![CDATA[ Anonymous]]></author>
			</item>
			<item>
				<title></title>
				<description><![CDATA[ The easier way is to remove all roles and set them again. Do the following in some mysql ( or postgresql ) client":<br /> <br /> <br /> <br /> [code]<br /> DELETE FROM jforum_role_values;<br /> DELETE FROM jforum_roles;<br /> <br /> INSERT INTO jforum_roles ( group_id, name, role_type ) VALUES (2, 'perm_administration', 1);<br /> [/code]<br /> <br /> then get the Admin user_id:<br /> <br /> [code]<br /> SELECT user_id FROM jforum_users WHERE username = 'Admin';<br /> [/code]<br /> <br /> and then make sure the user is in the administrators group. The table is "jforum_user_groups".  So, if the Admin user id is 2, you must have an entry like<br /> <br /> [code]<br /> SELECT user_id, group_id FROM jforum_user_groups;<br /> [/code]<br /> <br /> this should return "2" and "2".<br /> <br /> Rafael]]></description>
				<guid isPermaLink="true">http://www.jforum.net/posts/preList/399/1736.page</guid>
				<link>http://www.jforum.net/posts/preList/399/1736.page</link>
				<pubDate><![CDATA[Thu, 30 Sep 2004 10:52:53]]> GMT</pubDate>
				<author><![CDATA[ Rafael Steil]]></author>
			</item>
			<item>
				<title></title>
				<description><![CDATA[ Perfect! Thanks!]]></description>
				<guid isPermaLink="true">http://www.jforum.net/posts/preList/399/1752.page</guid>
				<link>http://www.jforum.net/posts/preList/399/1752.page</link>
				<pubDate><![CDATA[Mon, 4 Oct 2004 07:07:01]]> GMT</pubDate>
				<author><![CDATA[ Anonymous]]></author>
			</item>
	</channel>
</rss>