Author Topic: How to upgrade the database?  (Read 223 times)

Offline Dudeson

  • Semi-Newbie
  • *
  • Posts: 22
How to upgrade the database?
« on: January 03, 2018, 01:35:45 PM »
I got this error message says "You have an error in your SQL Syntax

Where do i find upgrade.php and if i execute that, will it cause any further issues?

Offline Sir Osis of Liver

  • SMF Hero
  • ******
  • Posts: 8,444
  • Riding the endless highway in the sky.
Re: How to upgrade the database?
« Reply #1 on: January 03, 2018, 09:10:04 PM »
Ignore the version error, there've been no database changes in 2.0 branch.  The syntax error may be due to a poorly configured mariadb implementation.

Offline Kindred

  • The Mean One
  • Support Specialist
  • SMF Legend
  • *
  • Posts: 57,508
  • Gender: Male
    • Kindred-999 on GitHub
Re: How to upgrade the database?
« Reply #2 on: January 04, 2018, 08:33:02 AM »
Maria db requires some manual code changes, depending on the mariadb config...

Incidentally, mariadb is not officially supported in 2.0.x
Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.