Advertisement:

Author Topic: Help with error message  (Read 201 times)

Offline trippyfool

  • Newbie
  • *
  • Posts: 4
Help with error message
« on: Yesterday at 06:56:08 PM »
Get this message when making a post, any help would be appreciated.

Expression #7 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'thecornf_forum.ln.sent' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
File: /home/thecornf/public_html/Sources/Subs-Post.php
Line: 1410

Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 1.1.11, while your database is at version 1.1.4. The above error might possibly go away if you execute the latest version of upgrade.php.


Thanks

Online shadav

  • Support Specialist
  • SMF Hero
  • *
  • Posts: 1,438
  • Gender: Female
    • shadav on Facebook
    • leashadav on GitHub
    • Ask The Muslims: A Place To Ask Honest Questions and Receive Respectful Answers
Re: Help with error message
« Reply #1 on: Yesterday at 07:08:30 PM »
um well, other than the normal advice, update to 2.0.18
1.x is eol (has been for awhile) and most hosting companies are getting rid of older php versions

I'm not sure if vbgamer's advice here would help or not as it was for smf 2.0.x

Might require a code change edit your Settings.php and put

Code: [Select]
$mysql_set_mode = 1;
Opps actually needs to be
Code: [Select]
$mysql_set_mode = true;

Offline trippyfool

  • Newbie
  • *
  • Posts: 4
Re: Help with error message
« Reply #2 on: Today at 01:05:39 AM »
Thanks. Where would I place that code in my Settings.php?

I've been wanting to upgrade for awhile, but health issues have kept me from tackling it. Does anyone do upgrades for others?

Thanks again.

Online shadav

  • Support Specialist
  • SMF Hero
  • *
  • Posts: 1,438
  • Gender: Female
    • shadav on Facebook
    • leashadav on GitHub
    • Ask The Muslims: A Place To Ask Honest Questions and Receive Respectful Answers
Re: Help with error message
« Reply #3 on: Today at 01:25:40 AM »
you could post in the Help Wanted (not for support) board

to be honest, as far behind as you are, it'd be better to just do the 2.0.18 large upgrade
since any mods that you might have installed would all be outdated as well and need updated and any themes in use
the large upgrade would install clean files and update the database, so no data would be lost but any themes and mods installed would be gone, you can then download the latest versions of any mods you were using or wanted to use so that everything would now be up to date

Offline Aleksi "Lex" Kilpinen

  • A Peculiar Finn
  • Project Manager
  • SMF Super Hero
  • *
  • Posts: 20,077
  • Gender: Male
  • Don't worry, I'm n00b friendly
    • Aleksi.Kilpinen on Facebook
    • LexArma on GitHub
    • aleksi-kilpinen on LinkedIn
    • Aleksi Kilpinen
Re: Help with error message
« Reply #4 on: Today at 01:29:13 AM »
Definitely would suggest getting up to date and go to the large upgrade to 2.0.18.
It's a big jump, as it means losing all modifications and custom themes - but at this point in time, it's past due time to go there really.
A Finnish Project Manager (Support Specialist)
Happily running multiple SMF 2.x installations.
 Fooling around with an i7-10700 @ 2,90GHz-4.80GHz / 16Gb / RTX-2070 Super / 3840x2160 / Win 10 x64


How you can help SMF

"Before you allow people access to your forum, especially in an administrative position, you must be aware that that person can seriously damage your forum.
Therefore, you should only allow people that you trust, implicitly, to have such access." -Douglas

Offline trippyfool

  • Newbie
  • *
  • Posts: 4
Re: Help with error message
« Reply #5 on: Today at 06:06:47 AM »
I will just go for the large upgrade then. The forum is huge and is very old. Lots of themes and mods have come and gone. I'm sure the large upgrade is much needed for a multitude of reasons.

Thanks for the advice and the heads up to the help wanted forum.