Hi Florin,
I get a very strange error from a join in Mantis and this started after I
upgraded from Mysql4 to Mysql5. I know there were some changes regarding the
joins but this error doesn't say anything about the join.
And the error I get is
ERROR 1054 (42S22): Unknown column 'p.field_id' in
in MySQL 5.0.15
u must do like this:
SELECT f.name,
f.type, f.access_level_r, f.default_value, f.type,
s.value
FROM mantis_custom_field_project_table AS p
LEFT JOIN mantis_custom_field_table AS f
ON p.field_id = f.id
LEFT JOIN mantis_custom_field_string_table AS s
ON p.field_id=s.field_id AND s.
