Problems with Database

[wasn325]

I am gettings these Error messages.

game setup:

Failed to query for games: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'gpx.d.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

creating a server:
Failed to query for games: Expression #8 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'gpx.n.ip' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

when I log in:

Login Failed: Failed to query for plugins: Expression #1 of ORDER BY clause is not in SELECT list, references column 'gpx.plugins.name' which is not in SELECT list; this is incompatible with DISTINCT

[will2therich]

Hi @wasn325

What database are you using?
and what PHP version?

Ta

[wasn325]

Mysql: 5.7.20
PHP: 5.6.30

[will2therich]

You seem to have the Setting in sql sql_mode=only_full_group_by
are you able to change this?
https://stackoverflow.com/questions/23921117/disable-only-full-group-by

[wasn325]

Changed it and it works. Thank you :)

But if I try to make a Template this happenes: Failed: Failed to insert template and I don't know the reason

[will2therich]

Hmm @wasn325

That seems to be an error when the template is inserted into the database.
Could you try reinstalling the panel to ensure the database has been created correctly?

[wasn325]

@will2therich

There is only a problem: Error: Failed to create user: Field 'last_updated' doesn't have a default value

[wasn325]

@will2therich Are you still here?

[will2therich]

Hi @wasn325

My apologies, Ive been trying to figure out what can cause this.
I will have a look through the code.

[will2therich]

@wasn325
Are you able to use php7 and use my php7 branch?
https://github.com/will2therich/GamePanelX-V3/tree/PHP7.0

[wasn325]

The Problem is not PHP. I tested freemysqlhosting.net and it worked, but I do not want anyone to have access to the data

[wasn325]

Ou and your php7 Branch has a problem at adding a server: Failed: Failed to insert server: Field 'simplecmd' doesn't have a default value

And if I add a template the sites is like frozen : starting...

[devryan]

The current code base hasn't been tested much on anything past Percona/MySQL 5.6. Past that the defaults do change - after @will2therich fix, @wasn325 did you cleanly drop the database and reinstall the panel from scratch? If not it'd have half it's stuff not properly setup

[wasn325]

I dropped the tables and the database and created a new one, reinstalled it and so on...

[wasn325]

@will2therich @devryan are you still here?

[will2therich]

Hi @wasn325

Sorry for the late reply (I help for free nothing to do with GPX!)
Can you possible give me a DB dump from your install?
And log the issue in the issue tracker on my repo?

Thanks!