Error when running env CCHQ_IS_FRESH_INSTALL=1 ./manage.py migrate --noinput

Developers
1

hey folks:

i'm trying to install commcare-hq from github. I've made it quite far, but
am stumbling on this command:

$ env CCHQ_IS_FRESH_INSTALL=1 ./manage.py migrate --noinput

The above command results in the following error (omitting the stack trace)

django.db.utils.ProgrammingError: function to_regclass(unknown) does not
exist
LINE 1: SELECT (SELECT to_regclass('"phonelog_devicereportentry_doma...
^
HINT: No function matches the given name and argument types. You might
need to add explicit type casts.
QUERY: SELECT (SELECT
to_regclass('"phonelog_devicereportentry_domain_10959f20fea53534_idx"') is
NULL)
CONTEXT: PL/pgSQL function "inline_code_block" line 1 at IF

I've tried reading the documentation on to_regclass in psql and could not
really figure things out. executing the same command in psql shell gives an
error also

am using psql 9.4.7, ubuntu 15.10

any help would be great. A big tip of hat to dimagi to having all its code
open source. this is really awesome :slight_smile:

lobo

2

Hi Donald,

Good to hear that you're finding HQ useful! 9.4.7 may be the version of the
psql application, which I believe is usually the same as the postgres
server but may not be. What command are you using to get the version of
postgres? Try: pg_config --version. If that's not 9.4 then that is probably
the issue.

Also, if you continue to have difficulties, I'd recommend using our docker
setup which will ensure the correct versions of all the services are being
used. You can read more about it here:
commcare-hq/docker at master · dimagi/commcare-hq · GitHub.

Ben

··· On Thu, May 12, 2016 at 5:48 PM, Donald Lobo wrote:

hey folks:

i'm trying to install commcare-hq from github. I've made it quite far, but
am stumbling on this command:

$ env CCHQ_IS_FRESH_INSTALL=1 ./manage.py migrate --noinput

The above command results in the following error (omitting the stack trace)

django.db.utils.ProgrammingError: function to_regclass(unknown) does not
exist
LINE 1: SELECT (SELECT to_regclass('"phonelog_devicereportentry_doma...
^
HINT: No function matches the given name and argument types. You might
need to add explicit type casts.
QUERY: SELECT (SELECT
to_regclass('"phonelog_devicereportentry_domain_10959f20fea53534_idx"') is
NULL)
CONTEXT: PL/pgSQL function "inline_code_block" line 1 at IF

I've tried reading the documentation on to_regclass in psql and could not
really figure things out. executing the same command in psql shell gives an
error also

am using psql 9.4.7, ubuntu 15.10

any help would be great. A big tip of hat to dimagi to having all its code
open source. this is really awesome :slight_smile:

lobo

--

You received this message because you are subscribed to the Google Groups
"CommCare Developers" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to commcare-developers+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

3

you were right, the postgres server version was 9.1.x

i fixed that and things proceeded smoothly

lobo

··· On Thursday, May 12, 2016 at 7:54:46 PM UTC-7, Ben Rudolph wrote: > > Hi Donald, > > Good to hear that you're finding HQ useful! 9.4.7 may be the version of > the psql application, which I believe is usually the same as the postgres > server but may not be. What command are you using to get the version of > postgres? Try: pg_config --version. If that's not 9.4 then that is probably > the issue. > > Also, if you continue to have difficulties, I'd recommend using our docker > setup which will ensure the correct versions of all the services are being > used. You can read more about it here: > https://github.com/dimagi/commcare-hq/tree/master/docker. > > Ben > > On Thu, May 12, 2016 at 5:48 PM, Donald Lobo <donal...@gmail.com > wrote: > >> >> hey folks: >> >> i'm trying to install commcare-hq from github. I've made it quite far, >> but am stumbling on this command: >> >> $ env CCHQ_IS_FRESH_INSTALL=1 ./manage.py migrate --noinput >> >> The above command results in the following error (omitting the stack >> trace) >> >> >> django.db.utils.ProgrammingError: function to_regclass(unknown) does not >> exist >> LINE 1: SELECT (SELECT to_regclass('"phonelog_devicereportentry_doma... >> ^ >> HINT: No function matches the given name and argument types. You might >> need to add explicit type casts. >> QUERY: SELECT (SELECT >> to_regclass('"phonelog_devicereportentry_domain_10959f20fea53534_idx"') is >> NULL) >> CONTEXT: PL/pgSQL function "inline_code_block" line 1 at IF >> >> >> I've tried reading the documentation on to_regclass in psql and could not >> really figure things out. executing the same command in psql shell gives an >> error also >> >> am using psql 9.4.7, ubuntu 15.10 >> >> any help would be great. A big tip of hat to dimagi to having all its >> code open source. this is really awesome :) >> >> lobo >> >> -- >> >> --- >> You received this message because you are subscribed to the Google Groups >> "CommCare Developers" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to commcare-developers+unsubscribe@googlegroups.com . >> For more options, visit https://groups.google.com/d/optout. >> > >