I installed the arcade for someone on a clean install of SMF 2.1. While trying to access any part of the arcade I get this message:
QuoteNon-grouping field 'champion_duration' is used in HAVING clause
File: /home/*****/rebelsarcade.com/Sources/ArcadeStats.php
Line: 285
Any ideas at all. ??
That's the latest file from here?
It's due to the latest mysql default strict setting for GROUP BY.
I thought I fixed all of them but perhaps I missed something.
I will test a fresh install to duplicate the error.
Thanks for the report.
No problem at all. It is version 2.56 I believe. Not sure when he got it from here. I didn't get it it was already in the admin panel.
I just tried the version from here and it has the same error.
This is where I downloaded the SMF Arcade.. The Arcade was working until we upgrade the forum..
I have or had probably over 500 games installed at the time.
If you by chance wish to look in the forum, I'll give you my info.
Ron
I just uninstalled the arcade and deleted it. Just to get ready for what comes next. Sorry. I'll bow out now as it seems everything is being taken care of in good hands. :)
Quote from: bigguy on April 01, 2018, 10:57:16 PMI just uninstalled the arcade and deleted it. Just to get ready for what comes next. Sorry. I'll bow out now as it seems everything is being taken care of in good hands. :)
I don't follow, why bow out, and never be sorry.. Geoff you were a big help for me..so hang around for maybe another 10 years..
Your games aren't going anywhere so I wouldn't worry about that.
Uninstalling/reinstalling the arcade mod itself does not delete any games.
I just tested this and the version in the download section here looks fine.
This forum & my test forum have ONLY_FULL_GROUP_BY enabled in mysql and the source file that was referenced has everything in the GROUP BY clause.
Atm I can't duplicate the error using the file that was available from the download section.
I have uploaded a new file just in case.
There is no version changes... delete the file you have and download/use the current one from here:
https://web-develop.ca/index.php?action=downloads;area=stable_smf_arcade;file=1;download
Got it and will upload it now and see what happens.
Same error as before..
The error you guys are reporting should be fixed with the update from a few weeks ago.
What is the PHP version?
Does it show errors when installing any package from the package source file?
Quote from: Chen Zhen on April 02, 2018, 02:46:50 PMThe error you guys are reporting should be fixed with the update from a few weeks ago.
What is the PHP version?
Does it show errors when installing any package from the package source file?
I am running with version 5.6
Removed the Arcade, got a new download from your link, installed that one, still get the error. The install went in with no problems.
QuoteNon-grouping field 'champion_duration' is used in HAVING clause
File: /home/theoverg/rebelsarcade.com/Sources/ArcadeStats.php
Line: 285
Line 285 is ): all there is in the line
Not errors from the package itself after installation.
I was referring to other errors from SMF source files during install.
No errors installing the Arcade mod.
I will likely need admin access to have a look for myself if that's ok.
The error being reported is related to sql mode of ONLY_FULL_GROUP_BY which was fixed weeks ago.
It should not be showing that error when using the latest file and I can no longer duplicate the error after the last arcade update.
Quote from: Chen Zhen on April 02, 2018, 04:03:00 PMI will likely need admin access to have a look for myself if that's ok.
The error being reported is related to sql mode of ONLY_FULL_GROUP_BY which was fixed weeks ago.
It should not be showing that error when using the latest file and I can no longer duplicate the error after the last arcade update.
I'll send it to you by pm.
Ok thanks.
There must be some other strict sql mode causing that error to come up.
Not a big deal because I was able to remove the HAVING clause & substitute a PHP condition in its stead.
Your Arcade should be working now.
Please let me know if you come across any other issues.
Btw - you can upload icons for the categories from editing a category in the arcade admin.
[Choose File] ... [Upload] ... after it uploads you can use [edit] (<- this means save)
Quote from: Chen Zhen on April 02, 2018, 04:30:44 PMOk thanks.
There must be some other strict sql mode causing that error to come up.
Not a big deal because I was able to remove the HAVING clause & substitute a PHP condition in its stead.
Your Arcade should be working now.
Please let me know if you come across any other issues.
Btw - you can upload icons for the categories from editing a category in the arcade admin.
[Choose File] ... [Upload] ... after it uploads you can use [edit] (<- this means save)
Thanks Chen for doing the work repairing this error. I sure do appreciate the help. I will check the Icons out.. Do I need my own Icons for this.
I will let you know..
Ron..
Yes you need to find your own icons for the arcade categories.
Just find images you like and resize them to approx. 20x20.
The arcade should actually resize images that are too large.
Quote from: Chen Zhen on April 02, 2018, 11:00:51 PMYes you need to find your own icons for the arcade categories.
Just find images you like and resize them to approx. 20x20.
The arcade should actually resize images that are too large.
Found some and copied them..
Quote from: bigguy on April 01, 2018, 10:57:16 PMI'll bow out now as it seems everything is being taken care of in good hands. :)
I didn't mean for good, lol. Just cause I didn't want to dirty up the thread with chatter when you were getting help. ;)
Quote from: bigguy on April 03, 2018, 02:15:49 PMQuote from: bigguy on April 01, 2018, 10:57:16 PMI'll bow out now as it seems everything is being taken care of in good hands. :)
I didn't mean for good, lol. Just cause I didn't want to dirty up the thread with chatter when you were getting help. ;)
Thanks and understood, I was the one who actually started the clutter, because you were the one to open the Thread.. More advice or help is always appreciated..
Just need someone now who know the beta to figure out the Smiley's why they don't work, and the Profile Moods I put in..
I couldn't find anything about moods in the admin panel. I have no idea about the smileys either. For that (smileys) I would post at SMF. Not me, lol. I mean you. ;) It may not be something they know about. I didn't see it on github
Quote from: bigguy on April 03, 2018, 05:54:08 PMI couldn't find anything about moods in the admin panel. I have no idea about the smileys either. For that (smileys) I would post at SMF. Not me, lol. I mean you. ;) It may not be something they know about. I didn't see it on github
The "Mood" is under Profile, It's a code I put in and uploaded 100 small icons to images, but for some reason the icons didn't go into the mood file..
Oh ok. I'll check that in a bit.