Advertisement:

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

Offline Fat Rat

  • Semi-Newbie
  • *
  • Posts: 53
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: 59,646
  • 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.

"Loki is not evil, although he is certainly not a force for good. Loki is... complicated."

Offline Fat Rat

  • Semi-Newbie
  • *
  • Posts: 53
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: 73,189
Re: Partial Database update?
« Reply #3 on: December 09, 2018, 06:36:16 AM »
Is your forum configured to use UTF-8 or not?
No good deed goes unpunished
All helpful urges should be circumvented

Offline Fat Rat

  • Semi-Newbie
  • *
  • Posts: 53
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: 73,189
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.
No good deed goes unpunished
All helpful urges should be circumvented

Offline Fat Rat

  • Semi-Newbie
  • *
  • Posts: 53
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
  • SMF Friend
  • SMF Hero
  • *
  • Posts: 2,187
  • 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?"..."