<class 'pg.DatabaseError'>: error 'ERROR: relation "win_builds" does not exist

[Mike Bonnet]

On 01/24/2011 12:37 PM, steve.webb at beatport.com wrote:
> When I click on one of my packages in the web interface, I'm getting this 
> python backtrace:
> 
> An error has occurred while processing your request.
> Fault: <Fault 1: '<class \'pg.DatabaseError\'>: error \'ERROR: relation "win_builds" does not exist\nLINE 3: FROM win_builds\n ^\n\' in \'\nSELECT build_id, platform\n FROM win_builds\n\n WHERE (build_id = 1)\n \n\n \n\''>

When did you create your initial database?  If it was a few releases
ago, you probably need to load:

/usr/share/doc/koji-1.6.0/docs/schema-upgrade-1.4-1.5.sql

into your koji database to create the new tables.

> Traceback (most recent call last):
>    File "/usr/share/koji-web/lib/kojiweb/publisher.py", line 16, in publish_object
>      return old_publish_object(req, object)
>    File "/usr/lib64/python2.7/site-packages/mod_python/publisher.py", line 425, in publish_object
>      return publish_object(req,util.apply_fs_data(object, req.form, req=req))
>    File "/usr/lib64/python2.7/site-packages/mod_python/util.py", line 554, in apply_fs_data
>      return object(**args)
>    File "/usr/share/koji-web/scripts/index.py", line 1040, in buildinfo
>      winbuild = server.getWinBuild(buildID)
>    File "/usr/lib/python2.7/site-packages/koji/__init__.py", line 1510, in __call__
>      return self.__func(self.__name,args,opts)
>    File "/usr/lib/python2.7/site-packages/koji/__init__.py", line 1761, in _callMethod
>      raise err
> Fault: <Fault 1: '<class \'pg.DatabaseError\'>: error \'ERROR:  relation "win_builds" does not exist\nLINE 3:   FROM win_builds\n               ^\n\' in \'\nSELECT build_id, platform\n  FROM win_builds\n\n WHERE (build_id = 1)\n \n\n \n\''>