<?xml version="1.0" encoding="UTF-8"?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/">
<channel>
  <title>aC forum: Owner company or administrators are missing!!! How can I fix this?</title>
  <link>http://www.activecollab.com/forums/topic/1657/</link>
  <description>Recent posts on topic: Owner company or administrators are missing!!! How can I fix this?</description>
  <dc:language>en-us</dc:language>
  <pubDate>Sat, 30 Aug 2008 12:36:21 UTC</pubDate>
  
  <item>
    <link>http://www.activecollab.com/forums/post/7872/#post7872</link>
    <guid>http://www.activecollab.com/forums/post/7872/#post7872</guid>
    <title>Post #1 by Ilija Studen</title>
    <dc:creator>Ilija Studen</dc:creator>
    <description><![CDATA[<p><b>Q: Owner company or administrators are missing!!! How can I fix this?</b><br />
<br />
<b>A:</b> If activeCollab sais that owner company or administrator are missing you will need to manually create them. Use &quot;phpMyAdmin&quot;:http://www.phpmyadmin.net/home_page/index.php or any other MySQL management tool to work with the database directly.<br />
<br />
Start by inserting company row in companies table (may have prefix, usually ac_). Make sure that fields have following values:<br />
<br />
id =&gt; 1<br />
name =&gt; Your company name (use your organization name)<br />
client_of_id =&gt; 0<br />
created_by_id =&gt; 1<br />
created_on =&gt; pick current date<br />
<br />
Now create a new user in users table:<br />
<br />
id =&gt; 1<br />
company_id =&gt; 1<br />
username =&gt; Your username<br />
email =&gt; Your email address<br />
token =&gt; 0a92df346e3a833cae214d65af35e69b3cf4e5ab<br />
salt =&gt; 6d093346fa02f<br />
twister =&gt; 4982716305<br />
is_admin =&gt; 1<br />
auto_assign =&gt; 1<br />
created_on =&gt; pick current date<br />
updated_on =&gt; pick current date<br />
<br />
That should do the trick. Your password will be '123' (without quotes).</p>]]></description>
    <pubDate>Tue, 05 Jun 2007 07:56:40 UTC</pubDate>
  </item>
</channel>
</rss>