Advertisement:

Author Topic: Move to VPS has created a database error  (Read 570 times)

Offline North East Man

  • Semi-Newbie
  • *
  • Posts: 32
Move to VPS has created a database error
« on: February 01, 2019, 03:03:22 AM »
My host moved my site from shared hosting to a VPS yesterday.  All apparently went well except that there was this error thrown up after login
-------------------------------------------------------------------------------------------------
Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'xxxxxx_smf225.mes.subject' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
File: /home/xxxxx/forum.mysite.co.uk/Sources/BoardIndex.php
Line: 133
---------------------------------------------------------------------------

The central list of all discussion boards did not show.  Essemntially all i had was the top row of tabs.

They logged in and fixed the problem by "Turning off the ONLY_FULL_GROUP_BY functionality in sql_mode".  Everything worked as it should.

The problem is, it has come back again this morning.  Same error.  As I am on day one of having this VPS I am at a loss as to where to go and what to do to fix this.  I have messaged the hosts support team, but they have not got back to me yet.

In very simple terms, can anyone advise what steps I need to take to solve this?  How do I turn off ONLY_FULL_GROUP_BY functionality in sql mode?



Offline Arantor

  • Resident Overthinker
  • SMF Friend
  • SMF Legend
  • *
  • Posts: 71,383
    • StoryBB/StoryBB on GitHub
Re: Move to VPS has created a database error
« Reply #1 on: February 01, 2019, 03:22:27 AM »
You change the my.cnf file to not include it. Where that will be and exactly how to change it is dependent mostly on your server distro...
Don’t try to tell me that some power can corrupt a person. You haven’t had enough to know what it’s like.

No good deed goes unpunished / No act of charity goes unresented.

Offline North East Man

  • Semi-Newbie
  • *
  • Posts: 32
Re: Move to VPS has created a database error
« Reply #2 on: February 01, 2019, 05:10:24 AM »
Many thanks.  The hosting company have just gone in and made that adjustment for me.  Now I just need to learn how to do that for myself as part of the learning process.