Ticket #68 (closed defect: fixed)

Opened 3 years ago

Last modified 3 years ago

"order by" with datedesc should not use positional arguments in SQL

Reported by: julien Owned by: mbonetti
Priority: normal Milestone: Gregarius 0.4.4
Component: BUGS Version: 2.0
Severity: minor Keywords:
Cc:

Description

There're two problems in the way the "rss.config.datedesc" config value is handled in the cls/items.php file. First, it uses positional arguments in the order by clause to access the "ts" column, which will prove to be difficult to maintain in further evolutions. Second, in one occasion it uses the "ts" column and on another occasion it uses the column "i.added".

I will attach a patch that corrects both problems.

Attachments

bug_datedesc.patch (1.0 kB) - added by julien 3 years ago.
the promised patch that address both problems

Change History

Changed 3 years ago by julien

the promised patch that address both problems

Changed 3 years ago by mdodoo

  • status changed from new to closed
  • resolution set to fixed

Fixed by [650]. Thanks for the patch!

Changed 3 years ago by julien

  • status changed from closed to reopened
  • resolution fixed deleted

Reopened ticket because the fix in [650] is incorrect for feed.php. On line 512, it has "ts desc" where it should be "ts asc".

Changed 3 years ago by mbonetti

  • status changed from reopened to closed
  • resolution set to fixed

Fixed in [655] (I hope this is correct)

Changed 3 years ago by kkkkoaaa

  • summary changed from "order by" with datedesc should not use positional arguments in SQL to "order by" with datedesc should not use positional arguments in SQL
  • version set to 2.0
  • milestone set to Gregarius 0.4.4
Note: See TracTickets for help on using tickets.