Ultimate Profile

[TwitchisMental]

My db name is twitch_smf1 so it is not working :[.

[tyty1234]

If that is the case, you can change the prefix.

[TwitchisMental]

If that is the case, you can change the prefix.

I kinda don't want too as some other stuff is using that prefix and I forget which those are lol.

[tyty1234]

That's actually not what I meant.
I meant change the prefix in the sql file.

[TwitchisMental]

That's actually not what I meant.
I meant change the prefix in the sql file.

Oh lol.. I open the sql with notepad++ I assume?

[tyty1234]

That would be correct, yes.

[TwitchisMental]

That would be correct, yes.

Humm where is it located <.<.

Edit: I cannot figure out what to edit.

I am getting an error like this -

Code Select Expand


SQL query:     
          ------------------------------------------------ --
-- File: "ult-profile_tablefix.sql" --
-- Created by: tyty1234 --
-- Date Created: Jul 26 2009 at 3:40pm PST --
------------------------------------------------ --
-- Create table for Ultimate Profile Buddies --
CREATE  TABLE  IF  NOT  EXISTS  `smf_buddies` ( `id_member` mediumint( 8  )  NOT  NULL default  '0',
`buddy_id` mediumint( 8  )  NOT  NULL default  '0',
`approved` smallint( 1  )  NOT  NULL default  '0',
`position` tinyint( 4  )  NOT  NULL default  '0',
`time_updated` int( 11  )  NOT  NULL default  '0',
`requested` mediumint( 8  )  NOT  NULL default  '0') ENGINE  =  MYISAM  DEFAULT CHARSET  = latin1;

     
     MySQL said:    #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '--------------------------------------------------
-- File: "ult-profile_tablef' at line 1

[tyty1234]

In notepad++, hit CTRL + F, click on the replace tab, in the Find field, insert "smf_" (without the quotes) and in the replace field, insert your db prefix. Then hit Replace All.

[TwitchisMental]

In notepad++, hit CTRL + F, click on the replace tab, in the Find field, insert "smf_" (without the quotes) and in the replace field, insert your db prefix. Then hit Replace All.

I am still getting the error.

[tyty1234]

did you use the right prefix?

[TwitchisMental]

did you use the right prefix?

Yes

[tyty1234]

Can you post a screenshot of the profile_comments table?

[TwitchisMental]

Can you post a screenshot of the profile_comments table?

Sure here ya go -

http://tinypic.com/view.php?pic=2rp615z&s=3

[tyty1234]

Since you are using SMF 2.0 RC1.2, click on Check All, then hit the edit button. (the pencil) Then change the column names to lowercase instead of uppercase, and hit save.

[excon]

Can you provide me a link to one of the profiles on your site with permission for guests to see user's profiles?

Hi Tyty,
please see this link. it will show you the profile of one of my member.
thanks again 

[tyty1234]

Hmm, can you attach your Profile.template.php file?

[excon]

Hi Tyty, please see attached profile.template.php
thanks a lot!

[tyty1234]

I apologize, can you attach your UltimateProfile.template.php file as well? 

[excon]

ok..no problem..

[tyty1234]

hm..somehow, $context['categories'] is passing as empty, the way I see it. I see $context is globalized, but maybe 'categories' is seen as an undefined index somehow, which is strange, because UltimateProfile uses Profile.php. Just out of curiosity, does your Forum Error Log contain a "Undefined index 'categories'" error?