WebDev

SMF Arcade => SMF Arcade Support + Plugins => Topic started by: bigguy on April 01, 2018, 08:37:58 PM

Title: Database error
Post by: bigguy on April 01, 2018, 08:37:58 PM
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. ??
Title: Re: Database error
Post by: Chen Zhen on April 01, 2018, 09:57:27 PM

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.
 
Title: Re: Database error
Post by: bigguy on April 01, 2018, 10:06:16 PM
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.
Title: Re: Database error
Post by: bigguy on April 01, 2018, 10:19:54 PM
I just tried the version from here and it has the same error.
Title: Re: Database error
Post by: Ronald on April 01, 2018, 10:48:19 PM
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
Title: Re: Database error
Post by: bigguy on April 01, 2018, 10:57:16 PM
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. :)
Title: Re: Database error
Post by: Ronald on April 01, 2018, 11:01:48 PM
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..
Title: Re: Database error
Post by: Chen Zhen on April 02, 2018, 12:21:53 AM

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


Title: Re: Database error
Post by: bigguy on April 02, 2018, 02:37:36 AM
Got it and will upload it now and see what happens.
Title: Re: Database error
Post by: bigguy on April 02, 2018, 02:44:18 AM
Same error as before..
Title: Re: Database error
Post by: Chen Zhen on April 02, 2018, 02:46:50 PM
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?
Title: Re: Database error
Post by: Ronald on April 02, 2018, 03:38:13 PM
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
Title: Re: Database error
Post by: Ronald on April 02, 2018, 03:45:41 PM
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
Title: Re: Database error
Post by: Chen Zhen on April 02, 2018, 03:59:02 PM

Not errors from the package itself after installation.
I was referring to other errors from SMF source files during install.
Title: Re: Database error
Post by: Ronald on April 02, 2018, 04:00:47 PM
No errors installing the Arcade mod.
Title: Re: Database error
Post by: Chen Zhen on April 02, 2018, 04:03:00 PM
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.

Title: Re: Database error
Post by: Ronald on April 02, 2018, 04:06:03 PM
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.
Title: Re: Database error
Post by: Chen Zhen on April 02, 2018, 04:30:44 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)
Title: Re: Database error
Post by: Ronald on April 02, 2018, 05:45:55 PM
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..
Title: Re: Database error
Post by: Chen Zhen on April 02, 2018, 11:00:51 PM

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.
Title: Re: Database error
Post by: Ronald on April 03, 2018, 07:55:25 AM
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..
Title: Re: Database error
Post by: bigguy on April 03, 2018, 02:15:49 PM
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. ;)
Title: Re: Database error
Post by: Ronald on April 03, 2018, 02:19:21 PM
Quote from: bigguy on April 03, 2018, 02:15:49 PM
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. ;)

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..
Title: Re: Database error
Post by: bigguy on April 03, 2018, 05:54:08 PM
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
Title: Re: Database error
Post by: Ronald on April 03, 2018, 06:59:18 PM
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..
Title: Re: Database error
Post by: bigguy on April 04, 2018, 11:19:55 AM
Oh ok. I'll check that in a bit.
EhPortal 1.29 © 2021, WebDev