Database error

Started by bigguy, April 01, 2018, 08:37:58 PM

Previous topic - Next topic

bigguy

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. ??

Chen Zhen


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.
 

bigguy

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.

bigguy

I just tried the version from here and it has the same error.

Ronald

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

bigguy

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. :)

Ronald

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..

Chen Zhen


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



bigguy

Got it and will upload it now and see what happens.

bigguy


Chen Zhen

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?

Ronald

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

Ronald

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

Chen Zhen


Not errors from the package itself after installation.
I was referring to other errors from SMF source files during install.

Ronald

No errors installing the Arcade mod.