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
s.bug_id='1476'
WHERE p.project_id = '10'
ORDER BY p.sequence ASC, f.name ASC
- Original Message -
From: "Florin Ochiana" <[EMAIL PROTECTED]>
To:
Sent: Thursday, November 10, 2005 2:15 PM
Subject: Problem with joins in MySQL 5.0.15
Hi all,
I get
Hi all,
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.
The select is this:
SELECT f.name,
f.type, f.access_level_r, f.default_value, f
