Edit: Thank you one and all. I did as babjusi and coldfx sugested and got it working by doing as coldfx said "To fix it, you have two options: One, add a new column under profile_comments in the DB (Labeled com.time). Or, remove the profile_comments field in the database, then re-install the Ultimate Profile mod."
I just installed Ultimate Profile mod BETA (http://www.simplemachines.org/community/index.php?topic=183574.0) on me smf forum and got:
Database Error
Unknown column 'com.time' in 'field list'
File: /home/family-m/public_html/linlithgow-forums.org.uk/f/Sources/Profile.php
Line: 1357
Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 1.1.3, while your database is at version 1.1.1. The above error might possibly go away if you execute the latest version of upgrade.php.
Now being only 14 years of age and my Dad although being a php programer can not help me, I decided to ask the experts in smf on how to fix this.
Note: When I first installed smf it was at version 1.1.1 and recently upgraded to 1.1.3
HELP
Upload the upgrade.php and the 2 upgrade.sql files to the same directory where your smf files are located and then run the upgrade.php file, pointing your browser to it
Where are these files?
At the large upgrade package in the download section
Thank you!
You are welcome, let me know how it will go.
Wait AWWW "An Error Has Occurred!
The package you tried to upload either is not a valid package or has become corrupted."
I tried it a few times and it ain't working. This might have something to do with the fact that I'm already using smf 1.1.3
Did you try to upload it through the package manager? It doesn''t work that way. First you will have to download it to your pc and unzip it. Then log in to your ftp client and upload the files I told you about in my above posts to your forum directory and then run the upgrade.php file by pointing your favorite browser to it
No No No. don't run upgrade.php or the sql files. Your database does not need to be fixed. Its just fine. There are NO database changes in the 1.1 branch.
Edit: See my post below.
As for the error. You should contact the mod author regarding that.
If you want to update your database to the current version, simply run this query in phpmyadmin:
UPDATE `smf_settings` SET `value` = '1.1.3' WHERE `variable` = 'smfVersion' LIMIT 1;
Why not through the upgrade.php file,Matt @ ARTcom? I have done the same at my live site and I didn''t have anymore error messages of that kind. Further more I have come across some posts here where such a thing was adviced in these kind of error messages.
P.s. By the way, why did he get that error message about the database in the first place when there are NO database changes in the 1.1 branch, or me a month ago?
It's a bug in the Ultimate Profile Mod itself, if you had/have the Profile Comments mod installed.
To fix it, you have two options: One, add a new column under profile_comments in the DB (Labeled com.time). Or, remove the profile_comments field in the database, then re-install the Ultimate Profile mod.
Lainaus käyttäjältä: babjusi - elokuu 02, 2007, 04:04:47 IP
Why not through the upgrade.php file,Matt @ ARTcom? I have done the same at my live site and I didn''t have anymore error messages of that kind. Further more I have come across some posts here where such a thing was adviced in these kind of error messages.
P.s. By the way, why did he get that error message about the database in the first place when there are NO database changes in the 1.1 branch, or me a month ago?
Don't fix it if its not broken. There are no database changes in the 1.1 branch of smf, save for updating the version number in the database, as I posted above. Upgrade.php does that, sure, but it does lots of other unneeded things.
So let me clarify, there are structual or scheme changes in the database in the 1.1 branch. The only change is the updating of the version number in the settings table.
Yes, I know that there is hardly any database change among smf versions within the same series.
But why then, does the error message that some people get, say:
LainaaNote: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 1.1.3, while your database is at version 1.1.1. The above error might possibly go away if you execute the latest version of upgrade.php
.
Am I missing something here?
Lainaus käyttäjältä: babjusi - elokuu 02, 2007, 04:45:49 IP
Yes, I know that there is hardly any database change among smf versions within the same series.
But why then, does the error message that some people get, say:
LainaaNote: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 1.1.3, while your database is at version 1.1.1. The above error might possibly go away if you execute the latest version of upgrade.php
Am I missing something here?
Not missing anything, its just a poorly worded error and needs to be changed. But why hassle with upgrade.php when its not needed?
Lainaus käyttäjältä: Matt @ ARTcom - elokuu 02, 2007, 04:50:49 IP
But why hassle with upgrade.php when its not needed?
I totally agree with this Matt @ ARTcom
It LIVES!!!! Thanks all!