Mike-on-Tour

Hi,
and thank you for your help by mail for my registration.

I'm having a problem with Sudoku.
When I activate the points system I get this error and the settings become inaccessible

I deactivated, deleted the data and reactivated while waiting for a solution.

Have an idea ? Thx

Hi,
right now I do not have an idea what the reason might be, it could be that it is related to the type of your SQL server. What kind of database are you using, MySQL, MariaDB, PostgreSQL, or something else?

Hi,

I don't understand why it don't work for me

Here are the statistics with all the information:

This looks good and I can't see a reason why it should produce a SQL error.
I need to take a closer look into this and come back to you.

And if this is kind of comforting: If it was working you wouldn't be able to use it anyway since I noticed today that only the settings work, I need to implement the functions to use "Ultimate Points" which will be part of the next version.

I think I've found the reason, it is the setting sql_mode = only_full_group_by which leaves two options:

First you can try to disable that setting, but if you are on a managed server you may not be permitted to do this so we refrain from that.

Secondly, you can try the following SQL query if you feel comfortable with phpMyAdmin:

Code: Select all

SELECT u.user_id, u.username FROM (phpbb_users u CROSS JOIN phpbb_user_group ug CROSS JOIN phpbb_groups g)
WHERE u.user_id = ug.user_id
AND g.group_id = ug.group_id
AND (UPPER(g.group_name) LIKE 'ADMINISTRATORS' OR UPPER(g.group_name) LIKE '%MODERATOR%')
GROUP BY u.username, u.user_id;

If this works without an error message, I can rewrite the query in the next version so it will work with your system (and others as well, of course).

I have a VPS.
In the Database Configuration, I have these settings about only_full_group_by

And in the Doc Page, I read this about only_full_group_by

Do you have an idea ? should I execute the sql query above ?

should I delete ONLY_FULL_GROUP_BY, in the line of Database Configuration ? (WHM Web interface)

Yes, this SQL setting is the reason you get an error message.

If you execute in phpMyAdmin the SQL query I gave you and not getting an error, then I know what to do. I would prefer that because I can prevent this error in the future.

Hi Mike,

ok, I will try this query this afternoon

Will the Ultimate Point system work after this?

If this SQL query which you should only run in phpMyAdmin works without giving an error I will know how to change it.

For UP working with Sudoku you have to wait for the next version on which I am working right now.

I don't know if it worked but I don't see any errors on the phpmyadmin page:

and I have not activated the points system in the sudoku settings to avoid the sql error

so I will wait for the next version

Thank you

Thanks, now I know how to write that query to prevent this error if someone else has activated that setting, great.

Hi Mike,

Thanks, I just updated the game to the 0.11.1 release and everything seems to be working fine.
But I'm waiting to see if the rewards work

I will come back to let you know if everything is good

What time are the daily rewards?

At the first call to the board after midnight AND 1 hour after the last check for a new rewards period.
The check for a new rewards period is done by a cron job which is running every 3600 seconds, its last run is displayed in the ACP settings tab.

Hi Mike,

yes it works and I received the private messages of rewards at 1:36 a.m.

Mike-on-Tour

SQL error - Points system activation

SQL error - Points system activation

Re: SQL error - Points system activation

Re: SQL error - Points system activation

Re: SQL error - Points system activation

Re: SQL error - Points system activation

Re: SQL error - Points system activation

Re: SQL error - Points system activation

Re: SQL error - Points system activation

Re: SQL error - Points system activation

Re: SQL error - Points system activation

Re: SQL error - Points system activation

Re: SQL error - Points system activation

Re: SQL error - Points system activation

Re: SQL error - Points system activation

Re: SQL error - Points system activation

Re: SQL error - Points system activation