Simple Machines Community Forum

SMF Support => SMF 2.0.x Support => Topic started by: dbovine on September 07, 2017, 11:34:54 PM

Title: Odd SQL error when I click on my profile
Post by: dbovine 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
Title: Re: Odd SQL error when I click on my profile
Post by: Shambles 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.
Title: Re: Odd SQL error when I click on my profile
Post by: @rjen on September 08, 2017, 04:03:22 AM
https://www.simplemachines.org/community/index.php?topic=358834.0
Title: Re: Odd SQL error when I click on my profile
Post by: dbovine on September 08, 2017, 10:55:57 AM
Quote from: Shambles 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.

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
Title: Re: Odd SQL error when I click on my profile
Post by: dbovine 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.
Title: Re: Odd SQL error when I click on my profile
Post by: dbovine on September 10, 2017, 11:39:06 PM
any thoughts?

is re running upgrade.php my best bet?
Title: Re: Odd SQL error when I click on my profile
Post by: dbovine 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
Title: Re: Odd SQL error when I click on my profile
Post by: @rjen on September 12, 2017, 11:41:40 AM
That is exactly what was in the link that I referred to....