Re: Error at login after upgrading standalone to 1.8

communities@jivesoftware.com — Tue, 04 Dec 2007 00:30:27 GMT

The schema is actually included in the database files in the clearspace distribution (clearspacedir\database) Just do a search for jivePluginProp in the sql file for the database you're using.

I'm currently looking into what might have caused this table to be missed in the upgrade process so we can get that fixed.

Cheers,

Chase

Re: Error at login after upgrading standalone to 1.8

communities@jivesoftware.com — Tue, 04 Dec 2007 00:27:28 GMT

OK I got it to work.

The schema is:

CREATE TABLE jivePluginProp (

pluginName VARCHAR(100) NOT NULL,

propName VARCHAR(100) NOT NULL,

propValue TEXT NOT NULL,

CONSTRAINT jivePluginProp_pk PRIMARY KEY (pluginName,propName)

);

Re: Error at login after upgrading standalone to 1.8

communities@jivesoftware.com — Tue, 04 Dec 2007 00:05:21 GMT

We're seeing this same problem.

Re: Error at login after upgrading standalone to 1.8

communities@jivesoftware.com — Thu, 29 Nov 2007 16:25:25 GMT

Do you have any plugins installed?

This error looked very similar to an error I got after upgrading from 1.6 to 1.8 and installing any plugin. It was caused by the database not having the jivePluginProp table, which for some odd reason wasn't added by the upgrade scripts (nor was it even documented in the DB Schema guide, for that matter!)

I added created the table manually and restarted Clearspace. Now everything is working fine.

Re: Error at login after upgrading standalone to 1.8

communities@jivesoftware.com — Mon, 26 Nov 2007 23:20:39 GMT

Hi,

Is there any information in your jiveHome logs when this issue occurs? Are you able to install a clean version of 1.8 successfully (not an upgrade, just a clean install)?

thanks,

Scott

Re: Error at login after upgrading standalone to 1.8

communities@jivesoftware.com — Tue, 20 Nov 2007 18:49:52 GMT

FYI, I was able to successfully roll back to 1.7, so as far as I can tell there's nothing wrong with the machine, Java config, etc.

(by the way, kudos to Jive's technical writers, who manage to remind the admin to back up pre-upgrade enough times to actually get them to do it, while not becoming annoying...

Error at login after upgrading standalone to 1.8

communities@jivesoftware.com — Tue, 20 Nov 2007 17:32:20 GMT

After upgrading my 1.7 standalone install (Mac OS X 10.4.11) to 1.8, I'm getting an error after login...

System Error

We're sorry but a serious error has occurred in the system. If you are a system administrator please click "more details" below for more information about this error.

More Details

Status Code: 500

Exception Type:

Error Message:

Request URI: /clearspace/index.jspa

Stack Trace:

o freemarker.ext.beans.BeanModel.get(BeanModel.java:223)

o freemarker.core.Dot._getAsTemplateModel(Dot.java:76)

o freemarker.core.Expression.getAsTemplateModel(Expression.java:89)

o freemarker.core.Expression.getStringValue(Expression.java:93)

o freemarker.core.DollarVariable.accept(DollarVariable.java:76)

o freemarker.core.Environment.visit(Environment.java:196)

o freemarker.core.MixedContent.accept(MixedContent.java:92)

o freemarker.core.Environment.visit(Environment.java:196)

o freemarker.core.IfBlock.accept(IfBlock.java:82)

o freemarker.core.Environment.visit(Environment.java:196)

o freemarker.core.MixedContent.accept(MixedContent.java:92)

o freemarker.core.Environment.visit(Environment.java:196)

o freemarker.core.IteratorBlock$Context.runLoop(IteratorBlock.java:160)

o freemarker.core.Environment.visit(Environment.java:351)

o freemarker.core.IteratorBlock.accept(IteratorBlock.java:95)

o freemarker.core.Environment.visit(Environment.java:196)

o freemarker.core.MixedContent.accept(MixedContent.java:92)

o freemarker.core.Environment.visit(Environment.java:196)

o freemarker.core.IfBlock.accept(IfBlock.java:82)

o freemarker.core.Environment.visit(Environment.java:196)

o freemarker.core.MixedContent.accept(MixedContent.java:92)

o freemarker.core.Environment.visit(Environment.java:196)

o freemarker.core.IfBlock.accept(IfBlock.java:82)

o freemarker.core.Environment.visit(Environment.java:196)

o freemarker.core.MixedContent.accept(MixedContent.java:92)

o freemarker.core.Environment.visit(Environment.java:196)

o freemarker.core.Environment.process(Environment.java:176)

o freemarker.template.Template.process(Template.java:232)

o com.opensymphony.webwork.views.freemarker.FreemarkerResult.doExecute(FreemarkerResult.java:153)

o com.jivesoftware.community.web.webwork.FreemarkerResult.doExecute(FreemarkerResult.java:130)

o com.opensymphony.webwork.dispatcher.WebWorkResultSupport.execute(WebWorkResultSupport.java:143)

o com.opensymphony.xwork.DefaultActionInvocation.executeResult(DefaultActionInvocation.java:313)

o com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:208)

o com.jivesoftware.community.web.webwork.FlashInterceptor.intercept(FlashInterceptor.java:40)