Advertisement:

Author Topic: Partial Database update?  (Read 278 times)

Offline Fat Rat

  • Semi-Newbie
  • *
  • Posts: 52
Partial Database update?
« on: December 08, 2018, 01:26:03 PM »
Whilst playing around with the search facility at v-strom.co.uk/smf the following error is returned. Is it possible that I am running with a partially updated database? If so, how to resolve please?

Offline Kindred

  • The Mean One
  • Support Specialist
  • SMF Legend
  • *
  • Posts: 57,365
  • Gender: Male
    • Kindred-999 on GitHub
Re: Partial Database update?
« Reply #1 on: December 08, 2018, 10:29:54 PM »
No... the database version is an incorrect error.,ignore it.

Just fix the collation
Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

Offline Fat Rat

  • Semi-Newbie
  • *
  • Posts: 52
Re: Partial Database update?
« Reply #2 on: December 09, 2018, 05:29:44 AM »
Can you offer any help on fixing the collation?

Offline Arantor

  • Resident Overthinker
  • SMF Friend
  • SMF Legend
  • *
  • Posts: 69,630
    • StoryBB/StoryBB on GitHub
Re: Partial Database update?
« Reply #3 on: December 09, 2018, 06:36:16 AM »
Is your forum configured to use UTF-8 or not?
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 Fat Rat

  • Semi-Newbie
  • *
  • Posts: 52
Re: Partial Database update?
« Reply #4 on: December 09, 2018, 06:51:15 AM »
I don't think so no, I have always been nervous of the  update because of the database size.

I was looking at the file versions today and saw this mismatch, is this likely to be causing trouble? I have downloaded the 2.015 language files but that doesn't seem to have addressed the mismatch.

index.english_british-utf8.php   2.0.10   2.0.14

Offline Arantor

  • Resident Overthinker
  • SMF Friend
  • SMF Legend
  • *
  • Posts: 69,630
    • StoryBB/StoryBB on GitHub
Re: Partial Database update?
« Reply #5 on: December 09, 2018, 06:54:56 AM »
I wouldn't worry about that part - but you have UTF-8 language files. The question... when you installed SMF, did you tell it to use UTF-8? Did you later convert afterwards?

Right now, there's two different ways data is being stored in the database, and we need to know which it *should* be to be able to get it there.
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 Fat Rat

  • Semi-Newbie
  • *
  • Posts: 52
Re: Partial Database update?
« Reply #6 on: December 09, 2018, 09:23:23 AM »
I'm honestly not sure, the site has been up ten years and in that time was converted to SMF from phpBB3.

I have the option within the Admin panel to convert to UTF-8, would that suggest it hasn't  been converted already? Also, some UTF-8 language files appear to be there.

Offline GigaWatt

  • The Smiley Guy
  • Support Specialist
  • SMF Hero
  • *
  • Posts: 1,467
  • Gender: Male
    • Macedonian electronics forum
Re: Partial Database update?
« Reply #7 on: December 13, 2018, 12:42:50 AM »
It might be partially converted.

Could you check your table collation in phpMyAdmin?
"This is really a generic concept about human thinking - when faced with large tasks we're naturally inclined to try to break them down into a bunch of smaller tasks that together make up the whole."

"A 500 error loosely translates to the webserver saying, "WTF?"..."