#5 Missing Data table?

[Gary Lawrence Murphy]

First off, I am happy to see I am not the only one still on SourceForge! I have been a regular user of astrolog for years, and on a whim today thought I'd see what might have been invented since!

I am running UbuntuStudio 24.04 and used the current .deb file, then apt install -f to pick up the missing pieces. When I run skydmin and do the Install/Upgrade, the log reports success, I select Access and assign a user and pw and it exits, but when I use those credentials in the app, I get the following:

The Database returned
ERROR:  relation "data" does not exist
LINE 1: SELECT idx FROM Data WHERE Name = 'ZeroGMT'
                        ^
(42P01) QPSQL: Unable to create query
Sorry, this SQL request can't be completed!
Retry or contact your system administator.

but unfortunately I am that administrator! I am not at all familiar with postgresql commands, but when I look with sudo -p psql and select the db, \dS only shows system pg_ tables, and here there is only

skylendar=# \d
         List of relations
 Schema |  Name   | Type |  Owner   
--------+---------+------+----------
 public | version | view | postgres
(1 row)

[Gary Lawrence Murphy]

(that should read sudo -u postgres psql - there's no edit button?)

Also I do see my user in pg_users which suggests skydmin does connect to psql.
This is using psql (PostgreSQL) 16.4 (Ubuntu 16.4-0ubuntu0.24.04.2)

another correction: I had run the installskylendar.sh after apt install -f

[Gary Lawrence Murphy]

I purged the .deb version and compiled from the latest sources. For UbuntuStudio 24.04 I needed to install two additional postgresql packages:

 sudo apt-get install libpq-dev
 sudo apt-get install postgresql-server-dev-16

The install then fails on a silly typo: COPYING is sought as COPYINĜso I just made a copy with the strange G and the install goes through.

Next, with sudo skydminI ran the Install, but then Access was empty; after the install I had to select the skylendar database and login, I see a confirmation and then Access shows the users. Double click overwrites itself, but the drop down let me select true, I then get to set the pw and click ok -- at this point there is a segfault, but gdb bt suggests it just couldn't handle this pw being in the db from previous attempts. When I then run skylendar, it comes up beautifully.

It is a bit precarious though: closing any panel exits the app completely, no debug messages other than the sql statements.