Advertisement:

Author Topic: Odd SQL error when I click on my profile  (Read 444 times)

Offline dbovine

  • Newbie
  • *
  • Posts: 5
Odd SQL error when I click on my profile
« on: September 07, 2017, 11:34:54 PM »
I recently upgraded to the 2.0 platform and for the most part things are working well. However when I click on my profile or any users profile I get the following:

"Unknown column 'mem.pm_receive_from' in 'field list'
File: /home/content/26/6886526/html/Sources/Load.php
Line: 1039

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

I searched for a while, tried the repair settings php suggestion, but that was unsuccessful.

Any suggestions would be appreciated

Offline sǝๅqɯɐɥS

  • SMF Hero
  • ******
  • Posts: 4,423
  • Gender: Male
    • i30 Owners Club
Re: Odd SQL error when I click on my profile
« Reply #1 on: September 08, 2017, 03:06:07 AM »
Please list any modifications applied to your forum and identify which theme you are using, plus your current version of SMF and the version from which you upgraded.

Offline @rjen

  • Jr. Member
  • **
  • Posts: 157
  • Gender: Male
    • FJR-club Nederland
Running SMF 2.0 with Tinyportal 1.3R at www.fjr-club.nl
Testing SMF 2.1 beta 3 with Tinyportal 2.0 at http://test2.fjr-club.nl/

Offline dbovine

  • Newbie
  • *
  • Posts: 5
Re: Odd SQL error when I click on my profile
« Reply #3 on: September 08, 2017, 10:55:57 AM »
Please list any modifications applied to your forum and identify which theme you are using, plus your current version of SMF and the version from which you upgraded.

Im running SMF 2.0.13, I have run all the upgrades from the 2.0 base upgrade install

using the default theme

here is a list of my mods

Offline dbovine

  • Newbie
  • *
  • Posts: 5
Re: Odd SQL error when I click on my profile
« Reply #4 on: September 08, 2017, 01:48:22 PM »
I just updated the PHP on my site and upgraded to 2.0.14. Still getting the error but it says you have SMF 2.0.14 now instead of 2.0.13.

Offline dbovine

  • Newbie
  • *
  • Posts: 5
Re: Odd SQL error when I click on my profile
« Reply #5 on: September 10, 2017, 11:39:06 PM »
any thoughts?

is re running upgrade.php my best bet?

Offline dbovine

  • Newbie
  • *
  • Posts: 5
Re: Odd SQL error when I click on my profile
« Reply #6 on: September 12, 2017, 10:53:10 AM »
I copied the latest upgrade.php and the SQL files, ran it and everything is working now

Offline @rjen

  • Jr. Member
  • **
  • Posts: 157
  • Gender: Male
    • FJR-club Nederland
Re: Odd SQL error when I click on my profile
« Reply #7 on: September 12, 2017, 11:41:40 AM »
That is exactly what was in the link that I referred to....
Running SMF 2.0 with Tinyportal 1.3R at www.fjr-club.nl
Testing SMF 2.1 beta 3 with Tinyportal 2.0 at http://test2.fjr-club.nl/