When I use a fill-in (sign-up) profile on a browser where I am logged in, there is no problem filling in the forms and saving. However, when I try the form on another browser where I am not logged in (or on the same browser after I log out), I get this error message: DB error: No such table exists.
The debugging text shows that civicrm_acl is missing and in fact, when I examine the database, there is no table with that name. This problem did not exist before so I am wondering what happened.
Below is the debugging text:
Sorry but we are not able to provide this at the moment. DB Error: no such table Error Details Database Error Code: Table 'xxxxx_civicrm.civicrm_acl' doesn't exist, 1146 Additional Details:
Array ( [callback] => Array ( [0] => CRM_Core_Error [1] => handle )
[code] => -18
[message] => DB Error: no such table
[mode] => 16
[debug_info] => SELECT civicrm_acl.*
FROM civicrm_acl
INNER JOIN civicrm_option_group og
ON og.name = 'acl_role'
INNER JOIN civicrm_option_value ov
ON civicrm_acl.entity_table = 'civicrm_acl_role'
AND ov.option_group_id = og.id
AND civicrm_acl.entity_id = ov.value
AND ov.is_active = 1
INNER JOIN civicrm_acl_entity_role
ON civicrm_acl_entity_role.acl_role_id = civicrm_acl.entity_id
AND civicrm_acl_entity_role.is_active = 1
INNER JOIN civicrm_group_contact
ON civicrm_acl_entity_role.entity_id = civicrm_group_contact.group_id
AND civicrm_acl_entity_role.entity_table = 'civicrm_group'
WHERE civicrm_acl.entity_table = 'civicrm_acl_role'
AND civicrm_acl.is_active = 1
AND civicrm_group_contact.contact_id = 0
AND civicrm_group_contact.status = 'Added' [nativecode=1146 ** Table 'xxxxx_civicrm.civicrm_acl' doesn't exist]
[type] => DB_Error
[user_info] => SELECT civicrm_acl.*
FROM civicrm_acl
INNER JOIN civicrm_option_group og
ON og.name = 'acl_role'
INNER JOIN civicrm_option_value ov
ON civicrm_acl.entity_table = 'civicrm_acl_role'
AND ov.option_group_id = og.id
AND civicrm_acl.entity_id = ov.value
AND ov.is_active = 1
INNER JOIN civicrm_acl_entity_role
ON civicrm_acl_entity_role.acl_role_id = civicrm_acl.entity_id
AND civicrm_acl_entity_role.is_active = 1
INNER JOIN civicrm_group_contact
ON civicrm_acl_entity_role.entity_id = civicrm_group_contact.group_id
AND civicrm_acl_entity_role.entity_table = 'civicrm_group'
WHERE civicrm_acl.entity_table = 'civicrm_acl_role'
AND civicrm_acl.is_active = 1
AND civicrm_group_contact.contact_id = 0
AND civicrm_group_contact.status = 'Added' [nativecode=1146 ** Table 'xxxxx_civicrm.civicrm_acl' doesn't exist]
[to_string] => [db_error: message="DB Error: no such table" code=-18 mode=callback callback=CRM_Core_Error::handle prefix="" info=" SELECT civicrm_acl.*
FROM civicrm_acl
INNER JOIN civicrm_option_group og
ON og.name = 'acl_role'
INNER JOIN civicrm_option_value ov
ON civicrm_acl.entity_table = 'civicrm_acl_role'
AND ov.option_group_id = og.id
AND civicrm_acl.entity_id = ov.value
AND ov.is_active = 1
INNER JOIN civicrm_acl_entity_role
ON civicrm_acl_entity_role.acl_role_id = civicrm_acl.entity_id
AND civicrm_acl_entity_role.is_active = 1
INNER JOIN civicrm_group_contact
ON civicrm_acl_entity_role.entity_id = civicrm_group_contact.group_id
AND civicrm_acl_entity_role.entity_table = 'civicrm_group'
WHERE civicrm_acl.entity_table = 'civicrm_acl_role'
AND civicrm_acl.is_active = 1
AND civicrm_group_contact.contact_id = 0
AND civicrm_group_contact.status = 'Added' [nativecode=1146 ** Table 'xxxxx_civicrm.civicrm_acl' doesn't exist]"]
)
Return to home page.
Blockquote