#3126 Edit after joined select fails

3.5.5
out-of-date
nobody
5
2013-07-27
2010-10-08
Axel Gebauer
No

After select of this kind
SELECT a.* FROM Article AS a, Tag AS t, Tag2Object AS t2o
WHERE t.name = 'Foo'
AND t.id = t2o.tagId
AND t2o.parentObjId = a.id
links to edit each row are given. Clicks on them fail with the message:
SELECT * FROM `ArticleJW` WHERE `a`.`id` =1877;
#1054 - Unknown column 'a.id' in 'where clause'
The solution seems to be just cut the alias "a" off which is only defined in the first SQL statement.
Many thanks in advance,

Discussion

  • Marc Delisle
    Marc Delisle
    2013-01-22

    • milestone: 3.3.5 --> 3.5.5
     
  • Marc Delisle
    Marc Delisle
    2013-07-27

    In 4.0, there are no longer such links.

     
  • Marc Delisle
    Marc Delisle
    2013-07-27

    • status: open --> out-of-date