On Wed, Nov 16, 2016 at 3:38 PM, Martin Juhl <mj(a)casalogic.dk> wrote:
Hi
When trying to access the build and package pages I get:
ProgrammingError: (psycopg2.ProgrammingError) function
status_to_order(integer) does not exist LINE 8: ...LECT
build_chroot.build_id, started_on, ended_on, status_to_... ^ HINT: No
function matches the given name and argument types. You might need to add
explicit type casts. [SQL: '\nSELECT build.id, MAX(package.name) AS
pkg_name, build.pkg_version, build.submitted_on,\n MIN(statuses.started_on)
AS started_on, MAX(statuses.ended_on) AS ended_on, order_to_status(MIN(
statuses.st)) AS status,\n build.canceled, MIN("group".name) AS
group_name, MIN(copr.name) as copr_name, MIN("user".username) as
user_name\nFROM build\nLEFT OUTER JOIN package\n ON build.package_id =
package.id\nLEFT OUTER JOIN (SELECT build_chroot.build_id, started_on,
ended_on, status_to_order(status) AS st FROM build_chroot) AS statuses\n ON
statuses.build_id=build.id\nLEFT OUTER JOIN copr\n ON copr.id =
build.copr_id\nLEFT OUTER JOIN "user"\n ON copr.user_id =
"user".id\nLEFT
OUTER JOIN "group"\n ON copr.group_id = "group".id\nWHERE
build.copr_id =
%(copr_id)s\nGROUP BY\n build.id;\n'] [parameters: {'copr_id': 1}]
Seems like the function "status_to_order" is missing.. I have tried
upgrading to python-psycopg2-2.6.1-1.. no change...
Any suggestions???
You need to run:
~/copr/frontend/coprs_frontend $ COPR_CONFIG=/etc/copr/copr.conf alembic
downgrade 3ec22e1db75a
~/copr/frontend/coprs_frontend $ COPR_CONFIG=/etc/copr/copr.conf alembic
upgrade head
"./manage.py create_db --alembic alembic.ini" installation instruction from
copr-setup.txt is creating db according to COPR flask models but this db
function is defined purely in alembic revisions. In the next release, this
will be fixed.
/Martin
_______________________________________________
copr-devel mailing list -- copr-devel(a)lists.fedorahosted.org
To unsubscribe send an email to copr-devel-leave(a)lists.fedorahosted.org