Re: opening data connection in Gambas editor, now opens in Sigil after install.

[Fabien Bodard <gambas.fr@xxxxxxxxx>]

Le ven. 14 mars 2025 à 06:23, Ian Roper <westozscribe@xxxxxxxxx> a écrit :

> I Installed Sigil eBook editor this morning from the Software manager on
> Linux mint.
>
> Later I went to work on a Gambas project and found that when I click on
> the data object, It tries to open in Sigil instead.
>
> I tested opening the database (Sqlite) in the file system and it opens
> normally in the installed SqlLite browser which is the expected outcome.
>
> Assume that Sigil has overwritten something that effects the selection of
> the application that Gambas uses.
>
> The file is a [SQLite3 database (application/vnd.sqlite3)] according to
> the file manager properties.
>
> The project connection data is:
>
> [Connection]
> Type="sqlite"
> Path="Data"
> NoPassword=False
> RememberPassword=False
> IgnoreCharset=False
> DisplayMetadata=False
> RememberTemplate=False
> Database="HomeBudgetDB"
> Requests=[""]
>
>
> What can I do to restore the correct functionality?
>
> Cheers,
>
> Ian.
>
>
>
> [System]
> Gambas=3.19.90
> OperatingSystem=Linux
> Distribution=Linux Mint 21.3 (Virginia)
> Kernel=5.15.0-134-generic
> Architecture=x86_64
> Cores=12
> Memory=15906M
> Language=en_AU.UTF-8
> Platform=x11
> Desktop=CINNAMON
> DesktopResolution=96
> DesktopScale=8
> WidgetTheme=mint-y-aqua
> Font=Ubuntu,11
> [Programs]
> dpkg=Debian 'dpkg' package management program version 1.21.1 (amd64).
> gcc=gcc (Ubuntu 11.4.0-1ubuntu1~22.04) 11.4.0
> msgmerge=msgmerge (GNU gettext-tools) 0.21
> rpmbuild=RPM version 4.17.0
> [Libraries]
> Cairo=libcairo.so.2.11600.0
> Curl=libcurl.so.4.7.0
> DBus=libdbus-1.so.3.19.13
> GDK2=libgdk-x11-2.0.so.0.2400.33
> GDK3=libgdk-3.so.0.2404.29
> GStreamer=libgstreamer-1.0.so.0.2003.0
> GTK+2=libgtk-x11-2.0.so.0.2400.33
> GTK+3=libgtk-3.so.0.2404.29
> OpenGL=libGL.so.1.7.0
> Poppler=libpoppler.so.118.0.0
> QT5=libQt5Core.so.5.15.3
> RSvg=librsvg-2.so.2.48.0
> SDL=libSDL2-2.0.so.0.18.2
> SQLite3=libsqlite3.so.0.8.6
> [Environment]
> CINNAMON_VERSION=6.0.4
> DBUS_SESSION_BUS_ADDRESS=unix:path=/run/user/1000/bus
> DESKTOP_SESSION=cinnamon
> DISPLAY=:0
> GB_GUI=gb.gtk3
> GDMSESSION=cinnamon
> GDM_LANG=en_AU
> GIO_LAUNCHED_DESKTOP_FILE=/usr/share/applications/gambas3.desktop
> GIO_LAUNCHED_DESKTOP_FILE_PID=4975
> GJS_DEBUG_OUTPUT=stderr
> GJS_DEBUG_TOPICS=JS ERROR;JS LOG
> GNOME_DESKTOP_SESSION_ID=this-is-deprecated
> GPG_AGENT_INFO=/run/user/1000/gnupg/S.gpg-agent:0:1
> GTK3_MODULES=xapp-gtk3-module
> GTK_MODULES=gail:atk-bridge
> HOME=<home>
> LANG=en_AU.UTF-8
> LANGUAGE=en_AU.UTF-8
> LOGNAME=<user>
>
> PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/usr/local/games:/snap/bin
> PWD=<home>
> QT_ACCESSIBILITY=1
> QT_LOGGING_RULES=*.debug=false
> QT_QPA_PLATFORMTHEME=qt5ct
>
> SESSION_MANAGER=local/<hostname>:@/tmp/.ICE-unix/1622,unix/<hostname>:/tmp/.ICE-unix/1622
> SHELL=/bin/bash
> SHLVL=0
> SSH_AUTH_SOCK=/run/user/1000/keyring/ssh
> TZ=:/etc/localtime
> USER=<user>
> XAUTHORITY=<home>/.Xauthority
> XDG_CONFIG_DIRS=/etc/xdg/xdg-cinnamon:/etc/xdg
> XDG_CURRENT_DESKTOP=X-Cinnamon
>
> XDG_DATA_DIRS=/usr/share/cinnamon:/usr/share/gnome:<home>/.local/share/flatpak/exports/share:/var/lib/flatpak/exports/share:/usr/local/share:/usr/share
> XDG_GREETER_DATA_DIR=/var/lib/lightdm-data/<user>
> XDG_RUNTIME_DIR=/run/user/1000
> XDG_SEAT=seat0
> XDG_SEAT_PATH=/org/freedesktop/DisplayManager/Seat0
> XDG_SESSION_CLASS=user
> XDG_SESSION_DESKTOP=cinnamon
> XDG_SESSION_ID=c2
> XDG_SESSION_PATH=/org/freedesktop/DisplayManager/Session0
> XDG_SESSION_TYPE=x11
> XDG_VTNR=7
>
> The question is what is this file for Gambas.

Gambas mimetype manager not use the magic string to define the file type
but extension (if I remember well)

Does gambas open sqlite browser for this file  before your installation?

In all case the ebook reader have modified the system mime database.

One solution will be to add a '.sqlite' your to your data files

Best regards,
Fabien