Unable to use group by with X and Y axis

Scriptcase 9 Bugs
#1

Hi all, I just upgraded to 9.10 and a few of my reports are not running. PHP error: Fatal error : Uncaught TypeError: ksort(): Argument #1 ($array) must be of type array, string given in /Applications/Scriptcase/…/report_overview_table_new2_total.class.php(340) : eval()'d

I have narrowed it down to the group by, when used with both X AND Y axis’s. 2x X is ok, and 2x Y is also ok.

I simplified the query for testing so its just a plain select statement.

To further confuse it, it appears to only be certain combination of fields:

Any thoughts? I have submitted a bug to SC.

#2

Dear @rperrett,

When we carried out some initial tests taking into account the scenario you described, no errors were returned in the application.

You mentioned that you submitted the possible bug to the support team. Could you please confirm if it was sent to bugs@scriptcase.net?

If so, please, if possible, please also send us your application that is presenting the problem so that we can analyze its settings more accurately.

Best regards!

#3

yes that’s the address I sent it to. I will send some mysql data through tomorrow to replicate it. Thanks