Categories
View Replies (2)

Resolved 9.4.1 - Mes templates d'exportation ne fonctionnent plus si je sélectionne un tri d'affichage

  1. New
  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
Responses (2)
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
Since version 9.4.1, my export templates with file downloads no longer work

I guess you mean latest 9.4.1 version? There was no change in code for custom table export in RO CSVI 9.4.1 version. The error you see is from database query not knowing the table id field belongs to.

May I ask why you are using custom table export to export Joomla user details? RO CSVI Supports Joomla user export template which also supports User custom fields. So why not use this export instead of Custom table export?
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. 2 hours ago
  2. RO CSVI
  3. # 1
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
I guess you mean latest 9.4.1 version? There was no change in code for custom table export in RO CSVI 9.4.1 version. The error you see is from database query not knowing the table id field belongs to.


I meant if you are using RO CSVI 9.4.1 version as debug log shows you are on RO CSVI 9.3.0 version
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. 1 hour ago
  2. RO CSVI
  3. # 2
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!