Manually adding second admin account (phpMyAdmin)?

We have a site that was setup, however the person responsible for that site is currently unavailable for a couple weeks and we need to make some modifications. He is currently the only one that knows the admin password to login. I can access the phpMyAdmin and tried to add a second account to the modx_manager_users table:
id: 2
user: admin2
pass: md5(<password>)

However I can’t login using admin2/<password>
Is there other steps I need to perform to create the second account?

I’m not sure but I think that you need to set manager user attributes in ’modx_user_attributes ’ table in the DB.

Also add a record in the modx_user_roles table

Thanks, I added entries to both those tables and I appear to be able to login (havn’t tried doing anything yet).

OK, I logged in using the second admin2 account and modified the contact us email address. I clicked save at the bottom of the page and got a list of Warning messages about permissions, etc. Now when I try and access the web page I get:

« MODx Parse Error »
MODx encountered the following error while attempting to parse the requested resource:
« Execution of a query to the database 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 ’ORDER BY tv.name ASC’ at line 1 »
SQL: SELECT tv.id,tv.name, IF(tvc.value!=’’,tvc.value,tv.default_text) as value FROM `site_db`.`modx_site_tmplvars` tv INNER JOIN `site_db`.`modx_site_tmplvar_templates` tvtpl ON tvtpl.tmplvarid = tv.id LEFT JOIN `site_db`.`modx_site_tmplvar_contentvalues` tvc ON tvc.tmplvarid=tv.id AND tvc.contentid = ’1’ WHERE tv.id<>0 AND tvtpl.templateid = ORDER BY tv.name ASC

This is the Warnings I got when attempting to save:
Warning: unlink(/home/site/public_html/assets/cache/docid_1.pageCache.php) [function.unlink]: Permission denied in /home/site/public_html/manager/processors/cache_sync.class.processor.php on line 59

Warning: unlink(/home/site/public_html/assets/cache/docid_51.pageCache.php) [function.unlink]: Permission denied in /home/site/public_html/manager/processors/cache_sync.class.processor.php on line 59

Warning: unlink(/home/site/public_html/assets/cache/docid_53.pageCache.php) [function.unlink]: Permission denied in /home/site/public_html/manager/processors/cache_sync.class.processor.php on line 59

Warning: unlink(/home/site/public_html/assets/cache/docid_55.pageCache.php) [function.unlink]: Permission denied in /home/site/public_html/manager/processors/cache_sync.class.processor.php on line 59

Warning: unlink(/home/site/public_html/assets/cache/docid_56.pageCache.php) [function.unlink]: Permission denied in /home/site/public_html/manager/processors/cache_sync.class.processor.php on line 59

Warning: unlink(/home/site/public_html/assets/cache/docid_57.pageCache.php) [function.unlink]: Permission denied in /home/site/public_html/manager/processors/cache_sync.class.processor.php on line 59

Warning: unlink(/home/site/public_html/assets/cache/docid_58.pageCache.php) [function.unlink]: Permission denied in /home/site/public_html/manager/processors/cache_sync.class.processor.php on line 59

Warning: unlink(/home/site/public_html/assets/cache/docid_60.pageCache.php) [function.unlink]: Permission denied in /home/site/public_html/manager/processors/cache_sync.class.processor.php on line 59

Warning: unlink(/home/site/public_html/assets/cache/docid_61.pageCache.php) [function.unlink]: Permission denied in /home/site/public_html/manager/processors/cache_sync.class.processor.php on line 59

Warning: unlink(/home/site/public_html/assets/cache/docid_62.pageCache.php) [function.unlink]: Permission denied in /home/site/public_html/manager/processors/cache_sync.class.processor.php on line 59

Warning: unlink(/home/site/public_html/assets/cache/docid_63.pageCache.php) [function.unlink]: Permission denied in /home/site/public_html/manager/processors/cache_sync.class.processor.php on line 59

Warning: unlink(/home/site/public_html/assets/cache/docid_7.pageCache.php) [function.unlink]: Permission denied in /home/site/public_html/manager/processors/cache_sync.class.processor.php on line 59

Warning: unlink(/home/site/public_html/assets/cache/docid_74.pageCache.php) [function.unlink]: Permission denied in /home/site/public_html/manager/processors/cache_sync.class.processor.php on line 59

Warning: fopen(../assets/cache/siteCache.idx.php) [function.fopen]: failed to open stream: Permission denied in /home/site/public_html/manager/processors/cache_sync.class.processor.php on line 215
Cannot open file (../assets/cache/siteCache.idx.php)
/site

I tried changing the admin password as well after the save failure (to late?). When I then logged in as the admin and save the changes I still get the same Warnings though I seem to have access to the original site again (the attempted changes didn’t take). Maybe I am editing wrong or somehow file permissions where changed that don’t allow modifications?