Categories

Resolved 9.4.1 - My export templates no longer work if I select a display sort

  1. mmsarki
    mmsarki
  2. RO CSVI
  3. Sunday, 18 January 2026
  4.  Subscribe via email
Since version 9.4.1, my export templates with file downloads no longer work
The error displayed is "Error: SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'id' in ORDER BY is ambiguous"
After running various tests, I noticed that the problem only occurs when ascending or descending order is selected
If I do not select any sorting, I do not get any errors, and the export works
I am attaching the log file created by one of these templates
Thank's for your help
Attachments (2)
com_csvi.log.394.zip
rocsvi-941-error-after-sort.png rocsvi-941-error-after-sort.png
0
Accepted Answer
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
Thank you for the details. I was able to find the cause for the error and fixed it with attached patch file. I have also loaded patch file on your site and now there is no error in export even with sort by field added. Please test and let me know.
Attachments (1)
patch_csvi_20260126.zip
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. 2 weeks ago
  2. RO CSVI
  3. # Permalink
Sorry, the discussion is currently locked. You will not be able to post a reply or a comment at the moment.