1. elisa
  2. RO CSVI
  3. Tuesday, 20 February 2024
  4.  Subscribe via email
Somehow my SQL Export stopped working, or possibly I am confused.
I added this Query:

SELECT
l.id AS list_id,
l.name AS list_name,
l.active AS list_active,
l.visible AS list_visible,
l.display_name AS list_display_name,
u.id AS user_id,
u.name AS user_name,
u.email AS user_email,
u.creation_date AS user_creation_date,
u.active AS user_active,
u.source AS user_source,
ul.status AS subscription_status,
ul.subscription_date,
ul.unsubscribe_date
FROM
#__acym_list AS l
JOIN
#__acym_user_has_list AS ul ON l.id = ul.list_id
JOIN
#__acym_user AS u ON ul.user_id = u.id
ORDER BY
l.id, ul.subscription_date;

But when I want to run it, ROCSVI asks me to add fields. But in the field Section there are no fields. Also not if I update the list of available fields.
What am I doing wrong?

Also, formerly working SQL Exports somehow have been reverted to custom table exports and the query is gone?

Elisa
Accepted Answer
Accepted Answer Pending Moderation
Hello Elisa,
But when I want to run it, ROCSVI asks me to add fields. But in the field Section there are no fields. Also not if I update the list of available fields.
What am I doing wrong?

There was a semicolon(;) at the end of the query and that was causing the problem. I removed it and now available fields show up. Please check.

Also, formerly working SQL Exports somehow have been reverted to custom table exports and the query is gone?

That is strange. I guess that is Acymailing User Export template you are talking about. If so this template is still a SQL export template but query is missing. Was there any backup/restore operation used on this template? If you can give more details I can see if I can reproduce the issue.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month 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.