Open wasn325 opened 6 years ago
Hi @wasn325
What database are you using? and what PHP version?
Ta
Mysql: 5.7.20 PHP: 5.6.30
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
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
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?
@will2therich
There is only a problem: Error: Failed to create user: Field 'last_updated' doesn't have a default value
@will2therich Are you still here?
Hi @wasn325
My apologies, Ive been trying to figure out what can cause this. I will have a look through the code.
@wasn325 Are you able to use php7 and use my php7 branch? https://github.com/will2therich/GamePanelX-V3/tree/PHP7.0
The Problem is not PHP. I tested freemysqlhosting.net and it worked, but I do not want anyone to have access to the data
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...
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
I dropped the tables and the database and created a new one, reinstalled it and so on...
@will2therich @devryan are you still here?
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!
@will2therich here? https://github.com/will2therich/GamePanelX-V3/issues
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