I have just upgraded and I believe the sql queries were initiated correctly; i used easy sql and bypassed duplicate table errors; when i log into forum admin to add a category i recieve this message

DB function failed with error number 1054
Unknown column 'g.id' in 'on clause' SQL=SELECT a.*, a.name AS category, u.name AS editor, g.name AS groupname, h.name AS admingroup FROM jos_fb_categories AS a LEFT JOIN jos_users AS u ON u.id = a.checked_out LEFT JOIN jos_core_acl_aro_groups AS g ON g.id = a.pub_access LEFT JOIN jos_core_acl_aro_groups AS h ON h.id = a.admin_access GROUP BY a.id ORDER BY a.ordering, a.name

any ideas?

A search of the forums finds many references to that error.
Try this link in particular.
www.bestofjoomla.com/component/option,co...tid,65/id,5161/#5161

thanks for the quick response, however the file you refrenced no longer exist or at least it is not linked correctly; any ideas on where i can get a hold of it?

www.bestofjoomla.com/component/option,co...limitstart,20/#40032

Here you go but in the future please search. That took me all of 10 seconds to find.