I was able to get past this by upgrading to a MySQL 5 database. I generally
upgrade by coping the new roller codebase over my old one. This is because I
have a lot of symlinks and other files in my "ROOT" directory and like to
keep those. In doing this, I found I had to do a couple things after copying
everything over:
1. Delete WEB-INF/lib and recopy from RC4's WEB-INF/lib.
2. Delete WEB-INF/classes and recopy from RC4's WEB-INF/classes.
3. Copy Lucene 1.4.3 into WEB-INF/lib for the JSPWiki plugin. Otherwise, I
get the following error:
Exception in thread "Thread-44" java.lang.NoSuchMethodError:
org.apache.lucene.document.Field.Keyword(Ljava/lang/String;Ljava/lang/String;)Lorg/apache/lucene/document/Field;
at
com.ecyrd.jspwiki.search.LuceneSearchProvider.luceneIndexPage(LuceneSearchProvider.java:437)
at
com.ecyrd.jspwiki.search.LuceneSearchProvider.doFullLuceneReindex(LuceneSearchProvider.java:191)
at
com.ecyrd.jspwiki.search.LuceneSearchProvider.access$000(LuceneSearchProvider.java:70)
at
com.ecyrd.jspwiki.search.LuceneSearchProvider$1.run(LuceneSearchProvider.java:352)
Two issues I'm now dealing with:
1. Search doesn't seem to work. See
http://raibledesigns.com/rd/search?q=jquery
2. My archives page's calendar doesn't work. It shows the following:
$calendarModel.showWeblogEntryCalendarBig($weblog, $cat)
http://raibledesigns.com/rd/page/archives
3. Favicon doesn't shop up in Firefox.
On Wed, Mar 2, 2011 at 10:57 AM, Matt Raible <[email protected]> wrote:
> When trying to upgrade my production database (which is 3.23.56), I get the
> following error from dbscripts:
>
> $ mysql -u raible -p raible < 400-to-500-migration.sql
> Enter password:
> ERROR 1064 (00000) at line 42: You have an error in your SQL syntax near
> 'as w set
> lastmodified = lastmodified,
> datecreated = datecreated,
> cr' at line 1
>
> On Feb 27, 2011, at 1:32 PM, Dave wrote:
>
> > Apache Roller 5.0 Release Candidate RC4 is now available for testing.
> > Note that this is NOT a release of the Apache Software Foundation or
> > anybody else; this release candidate is for testing purposes only and
> > not recommended for production.
> >
> > What's new in Roller 5.0:
> >
> https://cwiki.apache.org/confluence/display/ROLLER/What's+new+in+Roller+5.0<https://cwiki.apache.org/confluence/display/ROLLER/What%27s+new+in+Roller+5.0>
> >
> > Change list (issues resolved since 4.0)
> > http://bit.ly/gAhDWR
> >
> > Issues resolved since last release candidate (RC4)
> > http://bit.ly/iaLKyt
> >
> > Signed binary and source files. Also, documentation in PDF form
> > http://people.apache.org/~snoopdave/apache-roller-5.0/
> >
> > Could this be the one?
> >
> > There were only minor fixes made since RC3 and RC4 is deployed
> > at blogs.apache.org (and my own blog), so hope to call for release
> > vote on this build depending how initial feedback goes.
> >
> > If you would like to help out then please test RC4, discuss the
> > problems you encounter here and file specific bugs with steps to
> > reproduce in the Roller JIRA bug tracking system.
> >
> > Thanks,
> > Dave
>
>
