quality@glassfish.java.net

Re: SJSU Student Querry::Cannot view profile in SocialSite

From: Jamey Wood <Jamey.Wood_at_sun.com>
Date: Tue, 07 Oct 2008 09:41:29 -0600

Hi Atreyee,

Your socialsite.log file shows has errors like this one:

  Internal Exception: java.sql.SQLSyntaxErrorException: Table/View
'SOCIALSITE_PERMISSIONGRANT' does not exist.

...which means you're probably running with an old database schema and a
new build of the SocialSite code.

To address this, you can do one of two things:

  1. Reinstall SocialSite from scratch (using the Milestone 1 installer)

  2. Manually connect to your database and adjust the schema

I would recommend the first option. If you really need to go with the
second option, read these entries from our SocialSite FAQ:

  
http://wikis.glassfish.org/socialsite/Wiki.jsp?page=FAQ#section-FAQ-HowCanIRecreateTheSchemaForMySocialSiteDatabase
  
http://wikis.glassfish.org/socialsite/Wiki.jsp?page=FAQ#section-FAQ-HowCanISelectivelyUpdateTheSchemaForMySocialSiteDatabase

--Jamey

atreyee dhar wrote:
> Hi Davis
> Thanks for the prompt reply.
> I have done the steps and still facing the same problem
> Attached is server.log and socialsite.log
> Thanks
> Atreyee
>
>
> On Mon, Oct 6, 2008 at 4:01 PM, Davis Nguyen <Davis.Nguyen_at_sun.com
> <mailto:Davis.Nguyen_at_sun.com>> wrote:
>
> Hi Atreyee,
>
> Can you do another thing here? Restart the Derby database and
> AppServer
> Go to .../<AppServer-Install>/bin directory and type
> asadmin stop-database
> asadmin stop-domain
> asadmin start-database
> asadmin start-domain
> Then retry your procedure. If it's still not working for you, can
> you please attach the server.log and socialsite.log files to this
> email and send it back? The log files should be located under
> ../<AppServer-Install>/domains/domain1/logs directory.
>
>
> Thanks,
> -davis
>
> atreyee dhar wrote:
>> Davis
>> Thanks for the reply
>> When i click on profile a pop up window should come up which will
>> let me fill in the profile details like contact ..personal ...etc ..
>> However I do not have any popups coming .
>> My popup blocker is not enabled.
>> Tried in IE, Chrome and Mozilla.
>> Please advise.
>> Thanks
>> Atreyee
>>
>> On Mon, Oct 6, 2008 at 11:04 AM, Davis Nguyen
>> <Davis.Nguyen_at_sun.com <mailto:Davis.Nguyen_at_sun.com>> wrote:
>>
>> Hi Atreyee,
>>
>> Thanks for using the SocialSite product.
>> I review your ProfilePage.jpg screenshoot and saw that you
>> have "profile" and "gadgets" links appear on the upper page.
>> 1. To view and edit Profile, you should click at the
>> "profile" link.
>> 2. For a group since there is no default group so you need to
>> create one before you can search for it. Or, click at "Browse
>> All Groups" to view existing groups on the system if you have
>> some.
>> 3. For people, you can type you login ID then click search,
>> or [Browse All People] page
>>
>> For document on how to use "SosialSite," please visit this
>> link http://blogs.sun.com/socialsite/
>> Please let us know if it's help
>>
>> Thanks,
>> -davis
>>
>> atreyee dhar wrote:
>>> Hi
>>> I have logged in to SocialSite but cannot see any profile.
>>> I am trying to edit my profile properties.
>>> But can see nothing
>>> Attached is a screenshot of what I see.
>>> Please adise on what to do ?
>>> Thanks a ton
>>> Atreyee
>>> Note: Similarly when i click on search for people/groups I
>>> can see nothing .
>>> It is a simple blank page
>>> Also a blank page for create groups/browse groups and all
>>> the rest
>>> ------------------------------------------------------------------------
>>> ---------------------------------------------------------------------
>>> To unsubscribe, e-mail:
>>> quality-unsubscribe_at_glassfish.dev.java.net
>>> <mailto:quality-unsubscribe_at_glassfish.dev.java.net> For
>>> additional commands, e-mail:
>>> quality-help_at_glassfish.dev.java.net
>>> <mailto:quality-help_at_glassfish.dev.java.net>
>>
>>
>
>
> ------------------------------------------------------------------------
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: quality-unsubscribe_at_glassfish.dev.java.net
> For additional commands, e-mail: quality-help_at_glassfish.dev.java.net