Hi Will,
The logs below suggest that some tables are missing.
Tue Nov 5 00:55:26 2013 [23559][1][FATAL] Query Failed: (SELECT acl_actions .*, acl_roles_actions.access_override, 1 as user_role
FROM acl_actions
INNER JOIN acl_roles_users ON acl_roles_users.user_id = ‘1’ AND acl_roles_users.deleted = 0
LEFT JOIN acl_roles_actions ON acl_roles_actions.role_id = acl_roles_users.role_id AND acl_roles_actions.action_id = acl_actions.id AND acl_roles_actions.deleted=0
WHERE acl_actions.deleted=0 )
UNION
(SELECT acl_actions .*, acl_roles_actions.access_override, 0 as user_role
FROM acl_actions
INNER JOIN securitygroups_users ON securitygroups_users.user_id = '1' AND securitygroups_users.deleted = 0
INNER JOIN securitygroups_acl_roles ON securitygroups_users.securitygroup_id = securitygroups_acl_roles.securitygroup_id and securitygroups_acl_roles.deleted = 0
LEFT JOIN acl_roles_actions ON acl_roles_actions.role_id = securitygroups_acl_roles.role_id AND acl_roles_actions.action_id = acl_actions.id AND acl_roles_actions.deleted=0
WHERE acl_actions.deleted=0 )
UNION
(SELECT acl_actions.*, 0 as access_override, -1 as user_role
FROM acl_actions
WHERE acl_actions.deleted = 0 )
ORDER BY user_role desc, category,name,access_override desc: MySQL error 1146: Table 'sgr_nkonagkhkm.securitygroups_users' doesn't exist
Tue Nov 5 00:55:26 2013 [23559][1][FATAL] Query Failed: (SELECT acl_actions .*, acl_roles_actions.access_override, 1 as user_role
FROM acl_actions
INNER JOIN acl_roles_users ON acl_roles_users.user_id = ‘1’ AND acl_roles_users.deleted = 0
LEFT JOIN acl_roles_actions ON acl_roles_actions.role_id = acl_roles_users.role_id AND acl_roles_actions.action_id = acl_actions.id AND acl_roles_actions.deleted=0
WHERE acl_actions.deleted=0 )
UNION
(SELECT acl_actions .*, acl_roles_actions.access_override, 0 as user_role
FROM acl_actions
INNER JOIN securitygroups_users ON securitygroups_users.user_id = '1' AND securitygroups_users.deleted = 0
INNER JOIN securitygroups_acl_roles ON securitygroups_users.securitygroup_id = securitygroups_acl_roles.securitygroup_id and securitygroups_acl_roles.deleted = 0
LEFT JOIN acl_roles_actions ON acl_roles_actions.role_id = securitygroups_acl_roles.role_id AND acl_roles_actions.action_id = acl_actions.id AND acl_roles_actions.deleted=0
WHERE acl_actions.deleted=0 )
UNION
(SELECT acl_actions.*, 0 as access_override, -1 as user_role
FROM acl_actions
WHERE acl_actions.deleted = 0 )
ORDER BY user_role desc, category,name,access_override desc: MySQL error 1146: Table 'sgr_nkonagkhkm.securitygroups_users' doesn't exist
Tue Nov 5 00:55:39 2013 [23696][1][FATAL] Query Failed: SELECT aos_products.id , aos_products.name , aos_products.part_number , aos_products.cost , aos_products.currency_id , aos_products.price , jt0.name aos_product_category_name , aos_products.aos_product_category_id , LTRIM(RTRIM(CONCAT(IFNULL(jt1.first_name,’’),’ ‘,IFNULL(jt1.last_name,’’)))) created_by_name , jt1.created_by created_by_name_owner , ‘Users’ created_by_name_mod, aos_products.date_entered , aos_products.assigned_user_id FROM aos_products LEFT JOIN aos_product_categories jt0 ON aos_products.aos_product_category_id = jt0.id AND jt0.deleted=0 LEFT JOIN users jt1 ON aos_products.created_by=jt1.id AND jt1.deleted=0
AND jt1.deleted=0 where aos_products.deleted=0 ORDER BY aos_products.date_entered DESC LIMIT 0,21: MySQL error 1146: Table ‘sgr_nkonagkhkm.aos_products’ doesn’t exist
Tue Nov 5 00:55:40 2013 [23696][1][FATAL] Query Failed: select securitygroups_default.id, securitygroups.name, securitygroups_default.module, securitygroups_default.securitygroup_id from securitygroups_default inner join securitygroups on securitygroups_default.securitygroup_id = securitygroups.id where securitygroups_default.deleted = 0 and securitygroups.deleted = 0: MySQL error 1146: Table ‘sgr_nkonagkhkm.securitygroups_default’ doesn’t exist
Tue Nov 5 00:55:48 2013 [23814][1][FATAL] fp_event_locations_fp_events_1 for fp_event_locations_fp_events_1 failed to load
Tue Nov 5 00:55:48 2013 [23814][1][FATAL] Query Failed: SELECT fp_events.id , fp_events.name , LTRIM(RTRIM(CONCAT(IFNULL(jt0.first_name,’’),’ ‘,IFNULL(jt0.last_name,’’)))) created_by_name , jt0.created_by created_by_name_owner , ‘Users’ created_by_name_mod, fp_events.date_start , fp_events.date_end , fp_events.budget , fp_events.currency_id , LTRIM(RTRIM(CONCAT(IFNULL(jt1.first_name,’’),’ ‘,IFNULL(jt1.last_name,’’)))) assigned_user_name , jt1.created_by assigned_user_name_owner , ‘Users’ assigned_user_name_mod, fp_events.assigned_user_id FROM fp_events LEFT JOIN users jt0 ON fp_events.created_by=jt0.id AND jt0.deleted=0
AND jt0.deleted=0 LEFT JOIN users jt1 ON fp_events.assigned_user_id=jt1.id AND jt1.deleted=0
AND jt1.deleted=0 where fp_events.deleted=0 ORDER BY fp_events.date_entered DESC LIMIT 0,21: MySQL error 1146: Table ‘sgr_nkonagkhkm.fp_events’ doesn’t exist
Cheers,
Mauro