Author Topic: Ooops!  (Read 3347 times)

Offline Julian

  • Administrator
  • Oil baron
  • *******
  • Posts: 6377
    • Used Cooking Oil Collection website
  • Location: East Surrey, UK.
Ooops!
« on: July 24, 2017, 02:51:33 PM »
Went to look at my sent messages today and got the following warning ....

Quote
Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'bioforum.pm.id_pm' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
File: /var/www/biopowered/forum/Sources/PersonalMessage.php
Line: 702

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

Not a major issue if its just sent messages, but could the version mismatch start effecting other things?
Used Cooking Oil Collection website ... http://www.surreyusedcookingoilcollection.palmergroup.co.uk

Offline Keef

  • Administrator
  • Oil obsessive
  • *****
  • Posts: 543
    • Adur Cooking Oils
  • Location: Sussex
Re: Ooops!
« Reply #1 on: July 24, 2017, 04:47:47 PM »
That's odd, mine are working ok.

Offline Julian

  • Administrator
  • Oil baron
  • *******
  • Posts: 6377
    • Used Cooking Oil Collection website
  • Location: East Surrey, UK.
Re: Ooops!
« Reply #2 on: July 24, 2017, 06:23:46 PM »
Still the same for me, but then one of my few areas excellence is to break things just by looking.
Used Cooking Oil Collection website ... http://www.surreyusedcookingoilcollection.palmergroup.co.uk

Offline photoman290

  • Wiki Editor
  • Oil obsessive
  • *****
  • Posts: 803
  • Location: west cornwall
Re: Ooops!
« Reply #3 on: July 24, 2017, 07:15:21 PM »
that reminds me of an old girlfriend who  blamed me when her hairdryer let out the magic smoke whilst i was using it. "it must have been your fault you know about these things "::) now buy me another one.

Offline Tony

  • Administrator
  • Oil baron
  • *******
  • Posts: 5104
  • Fo' shizzle, biodizzle
    • Southampton Waste Oil Collection
  • Location: Southampton
Re: Ooops!
« Reply #4 on: July 25, 2017, 08:46:30 AM »
Is appears from http://www.biopowered.co.uk/forum/index.php?action=admin;area=maintain;sa=routine;activity=version that we have a mixture of revisions... and applying the latest patch seems to fail.

Sounds like we need to take a backup of the site, then try applying successive patches for each revision and see if we can get it all up to date.

That or apply a clean install and figure out the local modifications we've made over the years.

Might have a crack at that this evening if I get the time.

Offline Julian

  • Administrator
  • Oil baron
  • *******
  • Posts: 6377
    • Used Cooking Oil Collection website
  • Location: East Surrey, UK.
Re: Ooops!
« Reply #5 on: July 25, 2017, 04:04:47 PM »
Tony, you're a star!
Used Cooking Oil Collection website ... http://www.surreyusedcookingoilcollection.palmergroup.co.uk

Offline Tony

  • Administrator
  • Oil baron
  • *******
  • Posts: 5104
  • Fo' shizzle, biodizzle
    • Southampton Waste Oil Collection
  • Location: Southampton
Re: Ooops!
« Reply #6 on: July 25, 2017, 04:42:12 PM »
Not this evening I'm afraid. My brother is visiting and will be sampling Vince's cider.  If I touch any code after that it could end badly!