Ultimate Profile

[Skinnymojo]

Glad to see this mod available for RC 2.0. Just installed it hxxp:www.skinnymojo.com/mojoforum/ [nonactive]. Works (almost) the way I remember from 1.1.11. However, on the profiles themselves, where there would normally be a member's name/link under their avatar, there is nothing. It's a minor thing, and something I'm sure that's easily fixed, but my PHP knowledge (what little there is to speak of) won't cut it. Any ideas?

[Smartflight]

The idea is awesome.

However, after uninstalling Profile Comments, and installing this mod, I get this error on clicking on "Profile"

Database Error

Unknown column 'com.time' in 'field list'
File: /home/ruppi/public_html/Sources/Profile-View.php
Line: 283

Any idea how to solve this?
I'm on SMF 2 RC 2 with Simple Portal 2.3.1

[PatrickPriest]

I get this error on profiles:
Unknown column 'com.time' in 'field list'
File: /home/othforum/public_html/Sources/Profile-View.php
Line: 257

[[unplugged]]

@Skinnymojo
If you mean on the profile summary page, the username is off to the right and not directly underneath it. I could look at moving some code around for you if you'd like to have it underneath.

@Smartflight and PatrickPriest
It looks like both of you have uninstalled Profile Comments and that the uninstall did not remove everything as it should have. Attach your Profile-View.php here and I will try to clean out the leftover code for you.

[PatrickPriest]

thank you for your help.

i did uninstall Profile Comments.

Question... will all the comments from Profile Comments show up in this new Mod... or will they all be deleted?

[[unplugged]]

@PatrickPriest

That's odd. I do not see any code in there that has been left from Profile Comments. As far as wanting to know if Ultimate Profile will display existing comments, I honestly do not know as I did not have profile comments before installing Ultimate Profile.

[PatrickPriest]

So what do you think the problem might be now?

[[unplugged]]

Well, I just uploaded your file to my test site and I do not receive that error. Are you sure you've attached the Profile-View.php as it is on your site currently?

[PatrickPriest]

maybe i grabbed the wrong one.  let's try this one.

[[unplugged]]

That is the correct file.  All of the code in it actually looks like it's supposed to when compared to my file. I again uploaded your file to my test site and it works. Can you go into your database and verify that the three tables for the profile stuff are there and have the correct prefix (typically smf_)? They should look something like smf_profile_albums, smf_profile_comments, and smf_profile_pictures.

[PatrickPriest]

They are all there.

[[unplugged]]

Hmm. Does the table structure for smf_profile_comments look like this:

[PatrickPriest]

the "time" one is missing.

[[unplugged]]

Aha. And that would 100% explain the error you are getting then. Now at least, we know the cause. Let me dig around a bit and see if I can find a solution.

[PatrickPriest]

Yeah when I saw that, I was like "there is the problem!".  Hopefully a solution will come quick.

[[unplugged]]

Inside the mod package is a file called database.php. Upload the database.php to your forum's root folder (the same folder containing the SSI.php) and then navigate to it in your browser. It probably won't have any dialog saying it's complete, but it should add the needed columns to the tables.

[PatrickPriest]

Didn't work.

[gbsothere]

Just mentioning this to Patrick on my way to bed....   

There is a "table fix" attachment at the bottom of the post linked below and, within that post, instructions on how to use it, which might help.  It is for version 2.0 rc2.  If you're running 1.1.x, I'll attach one for that.  (But the one on this link is the 2.0 rc2 version.)

http://www.simplemachines.org/community/index.php?topic=298641.msg2430651#msg2430651

If it does not help, something I have found helpful with this error on my test forum is to upload the upgrade files (that are in the folder of your version of SMF) to your forum's root and point your browser to upgrade.php.  This has corrected the error for me, when the table fix did not.  Worth a try.  Remove those upgrade files from your server, when you're done.

Goodnight and good luck.   

[[unplugged]]

OK. You need to run this SQL query:

ALTER TABLE `smf_profile_comments` ADD `time`  int(11) NOT NULL AFTER `approved`;

If you use PHPMyAdmin, highlight the appropriate database and then click on the SQL tab. In the textbox, copy/paste the above code exactly as you see it. smf_ needs to be the same as your prefix for your site.

EDIT:  There also seems to be a fix for it already set up as pointed out by gbsothere, which seems to do the same thing.

[PatrickPriest]

PERFECT!!!  It worked.  Thank you for your help guys!