RadioDJ Reports Errors

[roybaum]

Hi All...looking for some guidance.

When I run certain reports (specifically Sound Exchange, in this case) I get an error instead of results. I'm only running it for a week or so and have "music" checked. It doesn't seem to make a difference what "sort by" is set to. I've attached a screenshot of the error since I couldn't copy/paste the text from the error.

Any idea what's missing that would give me these errors? Thanks in advance for any help you can provide...

[stevewa]

which database server and version?
which version of radiodj?

everybody recommends using MariaDB and not MySQL.
if you are using MySQL, the error might be related to that..


can you copy the query selection from \templates\reports\sound exchange...

and put it into heidiSQL, to see the results / errors you get?