0023957: Database query failed. Error received from database was #1146: Table 'helpdesk.mantis_bug_table' doesn't exist for the query:

ID	Project	Category	View Status	Date Submitted	Last Update
0023957	mantisbt	custom fields	public	2018-02-10 07:44	2018-02-22 17:09

Reporter	sakthiugapriyan	Assigned To	cproensa
Priority	high	Severity	minor	Reproducibility	have not tried
Status	closed	Resolution	duplicate
Product Version	1.3.4

Summary	0023957: Database query failed. Error received from database was 0001146: Table 'helpdesk.mantis_bug_table' doesn't exist for the query:
Description	I just add one custom field called "UName" and allocated to one project. after click the any one bug "id" from view_all_bug_page.php page, i can't view the bug details. its show this error. APPLICATION ERROR 0000401 Database query failed. Error received from database was 0001146: Table 'helpdesk.mantis_bug_table' doesn't exist for the query: SELECT B.id AS bug_id, CF.id AS field_id, CFS.value, CFS.text FROM mantis_bug_table B LEFT OUTER JOIN mantis_custom_field_table CF ON 1 = 1 LEFT OUTER JOIN mantis_custom_field_string_table CFS ON ( B.id = CFS.bug_id AND CF.id = CFS.field_id ) WHERE B.id IN (?) AND CF.id IN (?). Please use the "Back" button in your web browser to return to the previous page. There you can correct whatever problems were identified in this error or select another action. You can also click an option from the menu bar to go directly to a new section.
Tags	No tags attached.

dregad 2018-02-10 15:38 developer ~0058812	Did you verify that the `helpdesk.mantis_bug_table` actually exists in your DB schema ? Was the system working before you added the custom field ?

sakthiugapriyan 2018-02-11 01:17 reporter ~0058821	i have two projects. create one custom field and allocate to one project. custom field allocated project only not working. another one working fine. helpdesk.mantis_bug_table not exit. but helpdesk_bug_table exist.

dregad 2018-02-11 17:36 developer ~0058832	I suspect there is something wrong with your database settings. Did you customize $g_db_table_prefix ? What is the value for $g_database_name ? According to your query, it is set to default value `mantis`, but in 0023957:0058821 you mention that the table name is helpdesk_bug_table which implies a prefix of `helpdesk`. As things stand, I am not able to reproduce the issue.

sakthiugapriyan 2018-02-12 23:27 reporter ~0058841	$g_database_name = 'helpdesk'; $g_db_table_prefix = 'helpdesk';

cproensa 2018-02-13 03:31 developer ~0058843	This was solved in 1.3.5. See 0021966

dregad 2018-02-13 14:48 developer ~0058855	@sakthiugapriyan in the future before reporting an issue please check if it has been resolved in the latest release. And I strongly suggest you upgrade to the latest 1.3.x (1.3.14 at the moment), to benefit from latest bug and security fixes.