Failed to set up Postgresql

[francescofeston]

Hi Cedric,

can you please take a look at this error and help me figure out what to do?

flask db_create
/root/.pyenv/versions/3.10.6/envs/myenv/lib/python3.10/site-packages/flask_sqlalchemy/__init__.py:872: FSADeprecationWarning: SQLALCHEMY_TRACK_MODIFICATIONS adds significant overhead and will be disabled by default in the future.  Set it to True or False to suppress this warning.
  warnings.warn(FSADeprecationWarning(
(psycopg2.errors.SyntaxError) ERRORE:  errore di sintassi a o presso ")"
LINE 1: CREATE INDEX user_id ON article ()
                                         ^

[SQL: CREATE INDEX user_id ON article ()]
(Background on this error at: https://sqlalche.me/e/14/f405)
(myenv) [root@projectalpha newspipe]# flask create_admin --nickname 'fra' --password '****'
/root/.pyenv/versions/3.10.6/envs/myenv/lib/python3.10/site-packages/flask_sqlalchemy/__init__.py:872: FSADeprecationWarning: SQLALCHEMY_TRACK_MODIFICATIONS adds significant overhead and will be disabled by default in the future.  Set it to True or False to suppress this warning.
  warnings.warn(FSADeprecationWarning(
(psycopg2.errors.UndefinedTable) ERRORE:  la relazione "user" non esiste
LINE 1: INSERT INTO "user" (nickname, pwdhash, automatic_crawling, i...
                    ^

[SQL: INSERT INTO "user" (nickname, pwdhash, automatic_crawling, is_public_profile, bio, webpage, twitter, date_created, last_seen, is_active, is_admin, is_api) VALUES (%(nickname)s, %(pwdhash)s, %(automatic_crawling)s, %(is_public_profile)s, %(bio)s, %(webpage)s, %(twitter)s, %(date_created)s, %(last_seen)s, %(is_active)s, %(is_admin)s, %(is_api)s) RETURNING "user".id]
[parameters: {'nickname': 'fra', 'pwdhash': 'pbkdf2:sha256:260000$XKglvFEthVXnld3M$7092ff38f5ad2edb7b4b188e18674168640d5ebaf4c83a0409b6ed082bd07265', 'automatic_crawling': True, 'is_public_profile': False, 'bio': '', 'webpage': '', 'twitter': '', 'date_created': datetime.datetime(2023, 5, 6, 18, 7, 52, 323050), 'last_seen': datetime.datetime(2023, 5, 6, 18, 7, 52, 323061), 'is_active': True, 'is_admin': True, 'is_api': True}]
(Background on this error at: https://sqlalche.me/e/14/f405)

Thanks

[cedricbonhomme]

Hello,

Thank you for the information. I have the same issue on a new database.

I have pushed a fix for this. Could you please pull the project and try like this:

$ export FLASK_DEBUG=1
$ flask db_create ; flask db_init;
$ flask create_admin --nickname admin --password password
$ flask run

[francescofeston]

Hi Cedric, Thank you for your email and Apologies for my late reply. I’ll have a try with that and let you know. Have a nice evening! Francesco

…

Il giorno 7 mag 2023, alle ore 10:37, Cédric Bonhomme ***@***.***> ha scritto:  Hello, Thank you for the information. I have the same issue on a new database. I have pushed a fix for this. Could you please pull the project and try like this: $ export FLASK_DEBUG=1 $ flask db_create ; flask db_init; $ flask create_admin --nickname admin --password password $ flask run — Reply to this email directly, view it on GitHub, or unsubscribe. You are receiving this because you authored the thread.

[francescofeston]

Hi Cedric, apologies for bothering again. There seems to be a small bug in the "category" table which appears upon adding new feeds to the database. this is the error: ERROR: The INSERT or UPDATE on the "feed" table violates the foreign key constraint "feed_category_id_fkey".DETAIL: The key (category_id)=(0) is not present in the "category" table. Could you please help me fix that? Thanks Francesco Inviato da iPhone

…

Il giorno 19 mag 2023, alle ore 21:03, Francesco Feston ***@***.***> ha scritto: Hi Cedric, Thank you for your email and Apologies for my late reply. I’ll have a try with that and let you know. Have a nice evening! Francesco >> Il giorno 7 mag 2023, alle ore 10:37, Cédric Bonhomme ***@***.***> ha scritto: >> >  > Hello, > > Thank you for the information. I have the same issue on a new database. > > I have pushed a fix for this. Could you please pull the project and try like this: > > $ export FLASK_DEBUG=1 > $ flask db_create ; flask db_init; > $ flask create_admin --nickname admin --password password > $ flask run > — > Reply to this email directly, view it on GitHub, or unsubscribe. > You are receiving this because you authored the thread.

[francescofeston]

Good afternoon Cedric, I was not able to come up with a solution for the issue below. Could you please help me out? Thanks Francesco Inviato da iPhone

…

Il giorno 1 giu 2023, alle ore 14:50, Francesco Feston ***@***.***> ha scritto: Hi Cedric, apologies for bothering again. There seems to be a small bug in the "category" table which appears upon adding new feeds to the database. this is the error: ERROR: The INSERT or UPDATE on the "feed" table violates the foreign key constraint "feed_category_id_fkey".DETAIL: The key (category_id)=(0) is not present in the "category" table. Could you please help me fix that? Thanks Francesco Inviato da iPhone >> Il giorno 19 mag 2023, alle ore 21:03, Francesco Feston ***@***.***> ha scritto: >> > Hi Cedric, > > Thank you for your email and Apologies for my late reply. > I’ll have a try with that and let you know. > Have a nice evening! > Francesco > > >>> Il giorno 7 mag 2023, alle ore 10:37, Cédric Bonhomme ***@***.***> ha scritto: >>> >>  >> Hello, >> >> Thank you for the information. I have the same issue on a new database. >> >> I have pushed a fix for this. Could you please pull the project and try like this: >> >> $ export FLASK_DEBUG=1 >> $ flask db_create ; flask db_init; >> $ flask create_admin --nickname admin --password password >> $ flask run >> — >> Reply to this email directly, view it on GitHub, or unsubscribe. >> You are receiving this because you authored the thread.

[francescofeston]

Good evening Cedric, Apologies for bothering again. Could you possibly let me know if a solution has been worked out to fix that issue? Thanks, Francesco Inviato da iPhone

…

Il giorno 19 giu 2023, alle ore 12:14, Francesco Feston ***@***.***> ha scritto: Good afternoon Cedric, I was not able to come up with a solution for the issue below. Could you please help me out? Thanks Francesco Inviato da iPhone >> Il giorno 1 giu 2023, alle ore 14:50, Francesco Feston ***@***.***> ha scritto: >> > Hi Cedric, > > apologies for bothering again. > There seems to be a small bug in the "category" table which appears upon adding new feeds to the database. > > this is the error: > > ERROR: The INSERT or UPDATE on the "feed" table violates the foreign key constraint "feed_category_id_fkey".DETAIL: The key (category_id)=(0) is not present in the "category" table. > > Could you please help me fix that? > Thanks > Francesco > > Inviato da iPhone > >>> Il giorno 19 mag 2023, alle ore 21:03, Francesco Feston ***@***.***> ha scritto: >>> >> Hi Cedric, >> >> Thank you for your email and Apologies for my late reply. >> I’ll have a try with that and let you know. >> Have a nice evening! >> Francesco >> >> >>>> Il giorno 7 mag 2023, alle ore 10:37, Cédric Bonhomme ***@***.***> ha scritto: >>>> >>>  >>> Hello, >>> >>> Thank you for the information. I have the same issue on a new database. >>> >>> I have pushed a fix for this. Could you please pull the project and try like this: >>> >>> $ export FLASK_DEBUG=1 >>> $ flask db_create ; flask db_init; >>> $ flask create_admin --nickname admin --password password >>> $ flask run >>> — >>> Reply to this email directly, view it on GitHub, or unsubscribe. >>> You are receiving this because you authored the thread.