AND 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: mysql@lists.mysql.com
Sent: Thursday, November 10, 2005 2:15 PM
Subject: Problem with joins in MySQL 5.0.15
Hi all,
I get a very strange error
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
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,