0006428: MySQL 5: Unknown column 'p.field_id' in 'on clause' - MantisBT

ID	Project	Category	View Status	Date Submitted	Last Update

0006428	mantisbt	custom fields	public	2005-11-22 05:54	2006-02-04 05:53

Reporter	cristic	Assigned To	ryandesign
Priority	normal	Severity	crash	Reproducibility	always
Status	closed	Resolution	duplicate
Product Version	0.19.3

Summary	0006428: MySQL 5: Unknown column 'p.field_id' in 'on clause'
Description	On MySQL 5.0.15 with: sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION,STRICT_ALL_TABLES" you have the following error: APPLICATION ERROR 0000401 Database query failed. Error received from database was #1054: Unknown column 'p.field_id' in 'on clause' for the query: SELECT f.name, f.type, f.access_level_r, f.default_value, f.type, s.value FROM mantis_custom_field_project_table AS p, mantis_custom_field_table AS f LEFT JOIN mantis_custom_field_string_table AS s ON p.field_id=s.field_id AND s.bug_id='1188' WHERE p.project_id = '6' AND p.field_id = f.id ORDER BY p.sequence ASC, f.name ASC
Additional Information	Into the custom_field_api.php at line 753: $query = "SELECT f.name, f.type, f.access_level_r, f.default_value, f.type, s.value FROM $t_custom_field_project_table AS p, $t_custom_field_table AS f LEFT JOIN $t_custom_field_string_table AS s ON p.field_id=s.field_id AND s.bug_id='$c_bug_id' WHERE p.project_id = '$c_project_id' AND p.field_id = f.id ORDER BY p.sequence ASC, f.name ASC"; should be transformed to: $query = "SELECT f.name, f.type, f.access_level_r, f.default_value, f.type, s.value FROM $t_custom_field_project_table AS p INNER JOIN $t_custom_field_table AS f ON p.field_id = f.id LEFT JOIN $t_custom_field_string_table AS s ON p.field_id=s.field_id AND s.bug_id='$c_bug_id' WHERE p.project_id = '$c_project_id' ORDER BY p.sequence ASC, f.name ASC";
Tags	No tags attached.

View Issue Details

Relationships

Activities