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

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\''>

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\''>



-- 
Steve Webb | System Administrator
Beatport | Play With Music
------------------------------------------
2399 Blake Street, Suite 170
Denver, Colorado USA 80205
tel: [phone]
fax: [phone]
noc: +1.303.565.2710
mobile: [phone]

[Mike Bonnet]

On 01/24/2011 12:37 PM, steve.webb(a)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\''>

>  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. 
Yup.  That was it.  Thanks!

- Steve

-- 
Steve Webb | System Administrator
Beatport | Play With Music
------------------------------------------
2399 Blake Street, Suite 170
Denver, Colorado USA 80205
tel: [phone]
fax: [phone]
noc: +1.303.565.2710
mobile: [phone]