I’ve been trying to import some SQL queries from one discourse forum to another. Worked fine for the last few years. However, now when I try to import a query it allows me to select it and then nothing happens. Thoughts?
إعجاب واحد (1)
You’ll need to share more information like what the query was.
How are you trying to import them?
إعجابَين (2)
This is an example for one of the queries:
--[params]
-- integer :page = 0
SELECT topic_views.*, single_sign_on_records.external_id, topics.title
from topic_views
left join single_sign_on_records
on topic_views.user_id = single_sign_on_records.user_id
left join topics
on topic_views.topic_id = topics.id
OFFSET :page * 1000
LIMIT ALL
I try to import it using the import button and selecting the file (attached)
topic-views.dcquery.json (605 Bytes)
Edit:
Using this button:
I hadn’t remembered that was a feature. When I try clicking import and selecting a file, nothing seems to happen.
It worked fine up until about October, you could export the json file and import no problem. Now as you say, nothing happens. Its much quicker than copying and pasting because I have a large number of files.
إعجاب واحد (1)
You might move this to bug
إعجاب واحد (1)
This is a side effect of this change (in pick-files-button.js):
By removing this.onFilesPicked(files);, you remove the action call defined here:
3 إعجابات
So this was a change made by Discourse so there isn’t a way for me personally to fix?
إعجابَين (2)
That’s right; it’s best to wait for a fix.
إعجابَين (2)
Thanks for reporting this! It should now be resolved 
3 إعجابات
This topic was automatically closed after 42 hours. New replies are no longer allowed.