New Version

[James Nordgaard]

I updated to the new version on my dev box, however, when running, I get wfs errors. I don't get anything from my database. I ran the old version and it still runs fine. No doubt there are changes to the db for the new version (discussion tables for a start). The question is, what are they? Is it documented somewhere? Is there a script for updating my db?

Thanks,
Jim

--
You received this message because you are subscribed Cyclopath Development.
To post to this group: send email to cyclop...@googlegroups.com
To read this group on the Web: http://groups.google.com/group/cyclopath-dev
To unsubscribe from this group: send email to
cyclopath-de...@googlegroups.com

[Landon Bouma]

Jim,

Yeah, the scripts are under scripts/sql

We've added two SQL scripts since the last release.

I've got cpdb aliased, i.e.,

  alias cpdb='psql -U cycling cycling'

so I can just

  cd $cp/scripts/sql

and then

  cpdb < 079-route-deeplinking.sql
  cpdb < 080-discussions.sql

to update my database.

I'm not sure if this process is properly documented in the Open Source guide (I'm pretty sure it's not).

Landon

[James Nordgaard]

Thanks. I'll give them a try when I get a chance.

[James Nordgaard]

No luck. I ran the scripts, they ran without errors. But I still get errors from the server, The last lines of the log are:
[Sat Apr 17 00:18:22 2010] [error] [client 127.0.0.1]   File "/home/jimn/cp/pyserver/conf.py", line 89, in <module>\n    route_hash_salt = cf.get('routing', 'route_hash_salt'), referer: http://localhost/main.swf
[Sat Apr 17 00:18:22 2010] [error] [client 127.0.0.1]   File "/usr/lib/python2.6/ConfigParser.py", line 321, in get\n    raise NoOptionError(option, section), referer: http://localhost/main.swf
[Sat Apr 17 00:18:22 2010] [error] [client 127.0.0.1] NoOptionError: No option 'route_hash_salt' in section: 'routing', referer: http://localhost/main.swf

I even tried the two other scripts that were new: 078-fix-tag-region-orphan.sql and 077-colors.sql. No luck.

Any ideas?

Jim

On Fri, Apr 16, 2010 at 5:59 PM, Landon Bouma <lan...@cs.umn.edu> wrote:

[Jordan]

Hi Jim,

I ran into a similar problem when I first updated to the new version. Try merging your pyserver CONFIG file with the new version of CONFIG.template from r42.

Jordan

[James Nordgaard]

That did the trick. Thanks.

On Sat, Apr 17, 2010 at 8:47 AM, Jordan <jfo...@gmail.com> wrote:

Hi Jim,

I ran into a similar problem when I first updated to the new version. Try merging your pyserver CONFIG file with the new version of CONFIG.template from r42.

Jordan

[Reid Priedhorsky]

James Nordgaard wrote:
> I updated to the new version on my dev box, however, when running, I get wfs
> errors. I don't get anything from my database. I ran the old version and it
> still runs fine. No doubt there are changes to the db for the new version
> (discussion tables for a start). The question is, what are they? Is it
> documented somewhere? Is there a script for updating my db?

Looks like Landon gave you the details for this particular upgrade.

In general, there isn't an easy way to figure out which schema update
scripts are needed. We use svn diff --summarize to see what scripts are
new between releases, but that's still kind of awkward. That seems
wrong, and fairly easy to fix, so I made a bug:

http://bugs.grouplens.org/show_bug.cgi?id=1763

Reid