6 replies to this topic

[simsmart]

SQL/DB Error -- [Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause]

SQL/DB Error -- [Invalid use of group function]

Warning: Invalid argument supplied for foreach() in /home/airlinee/public_html/sim2/alliancejoin.php on line 181

Getting that after clicking on the "Join Alliance" button in Administration.

[Yuxi]

We're working on it, still trying to figure out what the problem is because the sql query seems perfectly legal.

[rickc1000]

There is an error in the list of alliance page. The list of alliances don't come up. The page with all the statistics of each alliance.

[flightvision]

SQL/DB Error -- [Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause]

SQL/DB Error -- [Invalid use of group function]

[rickc1000]

Thanks for that flightvision. Why do you need to check out the alliance page Flightvision, you thinking of joining an alliance. lol!

[flightvision]

Thanks for that flightvision. Why do you need to check out the alliance page Flightvision, you thinking of joining an alliance. lol!

well, sometimes... But in the end I mostly feel on the right way on my own. Just wanted to be a good community member and report any bugs.

[Yuxi]

The sim2 server uses an older version of mysql, and neither Tobias and I can figure out the problem. I will restore the older one without detailed statistics for now while we continue to work on it.