Error when trying to add directory

[derEremit]

Failed to add directory: Impossible to insert. An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'is_open' in 'field list'

NC 25.0.1

I already tried occ update again

[julien-nc]

It seems the database migration step was not executed when upgrading GpxPod.

• Which version of GpxPod is now installed?
• How did you upgrade?
• Could you run this SQL query? SELECT * FROM oc_migrations WHERE app="gpxpod";
• And SELECT * FROM oc_gpxpod_directories LIMIT 1;

[umgfoin]

There seems to be an issue with db-schema upgrades, if you already upgraded to 5.0.1.

As a workaround,, you can correct the schema manually from the db-ci-client:
ALTER TABLE oc_gpxpod_directories RENAME COLUMN open TO is_open;
++umgfoin

[umgfoin]

@julien-nc (I had the same issue)

nc=# SELECT * FROM oc_migrations WHERE app='gpxpod';
  app   |         version
--------+--------------------------
 gpxpod | 040200Date20200317173846
 gpxpod | 040200Date20200317174315
 gpxpod | 040202Date20200602143603
 gpxpod | 050000Date20220730004531
(4 rows)

[derEremit]

Which version of GpxPod is now installed?
5.0.2

How did you upgrade?
I am not 100% sure but I think this could be the first time install for me, about 2 weeks ago. ( after already upgraded to nextcloud 25 )
so I do not have tried it before today actually

MariaDB [nextcloud]> SELECT * FROM oc_migrations WHERE app="gpxpod";
+--------+--------------------------+
| app | version |
+--------+--------------------------+
| gpxpod | 040200Date20200317173846 |
| gpxpod | 040200Date20200317174315 |
| gpxpod | 040202Date20200602143603 |
| gpxpod | 050000Date20220730004531 |
+--------+--------------------------+

SELECT * FROM oc_gpxpod_directories LIMIT 1;
Empty set (0.000 sec)

[julien-nc]

Thank you both for the feedback.

• Was there any error displayed during install/upgrade?
• Are you sure you didn't install any nightly build?

I think the only explanation for this issue is that the 050000Date20220730004531 migration has run before it was released (most likely because a nightly was installed). I should have renamed it to make sure the "final" migration would run.

[julien-nc]

As none of the data stored in GpxPod's tables is really important, could one of you:

• uninstall/disable GpxPod v5.0.2
• delete the oc_gpxpod_* tables
• run DELETE FROM oc_migrations WHERE app="gpxpod" AND version="050000Date20220730004531";
• install/enable GpxPod
• check if adding a directory works

I want to know if the issue is related with something specific in your setup or if I was right about the nightly 😁.

[umgfoin]

Bonjour Julien,

I think the only explanation for this issue is that the 050000Date20220730004531 migration has run before it was released (most likely because a nightly was installed).

Yes this was the case with my installation: I had installed nightly builds.

As none of the data stored in GpxPod's tables is really important, could one of you:

Yes, fails with Error: Database error when running migration 050000Date20220730004531 for app gpxpod There is no table with name 'nc.oc_gpxpod_directories' in the schema.

I renamed tables instead of deleting them, but this should not be the cause for the migration-failure.

# occ app:disable gpxpod
gpxpod 5.0.2 disabled

psql nc foo
psql (15.1 (xxxxxx15.1-1.xxxx))
Type "help" for help.
nc=# \dt oc_gpxpod_*
                   List of relations
 Schema |           Name           | Type  |   Owner
--------+--------------------------+-------+-----------
 public | oc_gpxpod_directories    | table | foo
 public | oc_gpxpod_options_values | table | foo
 public | oc_gpxpod_pictures       | table | foo
 public | oc_gpxpod_tile_servers   | table | foo
 public | oc_gpxpod_tracks         | table | foo
(5 rows)
nc=#ALTER TABLE oc_gpxpod_directories RENAME TO oc_gpxpod_directories_;
ALTER TABLE 
nc=#ALTER TABLE oc_gpxpod_options_values RENAME TO oc_gpxpod_options_values_;
ALTER TABLE 
nc=#ALTER TABLE oc_gpxpod_pictures RENAME TO oc_gpxpod_pictures_;
ALTER TABLE 
nc=#ALTER TABLE oc_gpxpod_tile_servers RENAME TO oc_gpxpod_tile_servers_;
ALTER TABLE 
nc=#ALTER TABLE oc_gpxpod_tracks RENAME TO oc_gpxpod_tracks_;
ALTER TABLE 

nc=# DELETE FROM oc_migrations WHERE app='gpxpod' AND version='050000Date20220730004531';
DELETE 1
nc=#\q

occ app:remove gpxpod
gpxpod disabled
gpxpod 0 removed

occ app:install gpxpod
Error: Database error when running migration 050000Date20220730004531 for app gpxpod
There is no table with name 'nc.oc_gpxpod_directories' in the schema.

[julien-nc]

Sorry you need to remove all oc_migrations entries for gpxpod:
DELETE FROM oc_migrations WHERE app="gpxpod";
Then you will run all the migration steps again.

[julien-nc]

@derEremit Could you try upgrading to v5.0.3 which I just released? It will appear in an hour or so in the app settings of your NC instance.

[umgfoin]

DELETE FROM oc_migrations WHERE app="gpxpod";

Yes, this worked - app install was successful and db-schema is correct.
++umgfoin.

[derEremit]

@julien-nc just seen the upgrade

i can add the directory now

another thing
with 5.0.2 ../old-ui did not work

now only ../old-ui works

[julien-nc]

another thing
with 5.0.2 ../old-ui did not work

@derEremit What do you mean? It didn't display anything?
So you confirm everything works now?

[laurensbl]

I don't know if this is related:
I just upgraded from NC 24.0.7 to 25.0.1 and GpxPod automatically updated to 5.0.3 during the process.

Now, no tracks and/or pictures are displayed anymore in the old UI, but they do in the new UI. This is for a user that had dirs added prior to upgrading to NC 25.
I tried removing and re-adding the dirs to no avail. Same problem, nothing with old UI, all visible in new UI.

After adding the same dirs under a user (dedicated admin user) that didn't had any dirs added prior to upgrading to NC 25 however, the tracks and pictures are shown in both old and new UI.

I tried steps outlined above: Removed app, deleted oc_gpxpod_* tables, ran DELETE FROM oc_migrations WHERE app="gpxpod";, downloaded and installed app again. Didn't fix it either.

[julien-nc]

@laurensbl Yes this might be related. I need more information:

• any error displayed in the old-ui when loading a track?
• any network error?
• any error in the javascript console?

I don't get how directories added before the upgrade are problematic after in the old-ui and then you delete the tables, reinstall the app and you still havve issues. This means even the directories added after the upgrade are problematic...right?

[umgfoin]

@derEremit
now only ../old-ui works

If you were on a nightly-build before, it should resolve with #7 .