DB connection not working after update to Mint 20 Ulyana

Post your Gambas programming questions here.
Post Reply
User avatar
Quincunxian
Posts: 171
Joined: Sunday 25th June 2017 12:14am
Location: Western Australia

DB connection not working after update to Mint 20 Ulyana

Post by Quincunxian »

Greetings all,
I upgraded to Mint 20 Ulyana which 'broke' Gambas.
Note# The pre-check that you can do before upgrading listed gambas as one of the applications that would have issues.

I was able to reinstall using the gambas-team/gambas-daily but now any program that has a sqlite db fails as the DB won't connect.
I can't see a valid reason for this at face value but wanted to check if there were any other people who have found the same issue (or a fix)
before I start pulling things apart.

Other gambas applications I use that don't have a DB still work fine.
Cheers - Quin.
I code therefore I am
User avatar
PJBlack
Posts: 184
Joined: Tuesday 9th June 2020 10:26pm
Location: Florstadt, Hessen, Germany

Re: DB connection not working after update to Mint 20 Ulyana

Post by PJBlack »

Manjaro XFCE 5.6.16 with postgreSQL

3.14.3
3.14.90

works fine, but

3.15

crashes on [Connection].Open ...

i did not change my OS so the problem is gambas
User avatar
cogier
Site Admin
Posts: 1118
Joined: Wednesday 21st September 2016 2:22pm
Location: Guernsey, Channel Islands

Re: DB connection not working after update to Mint 20 Ulyana

Post by cogier »

I upgraded to Mint 20 Ulyana which 'broke' Gambas.
If you want Gambas 3.14.3 it is in the Ubuntu 20.04 repository, therefore Mint 20 as well, but not set up properly. You will need to COMPLETELY remove Gambas, I suggest using Synaptic, then stop the ppa.

Once that's done run in Terminal: -
sudo apt-get autoremove
sudo apt-get clean
sudo apt-get update

Finally run: -

Code: Select all

sudo apt-get -y install gambas3 gambas3-gb-form-print gambas3-gb-gtk-opengl gambas3-gb-gtk3 gambas3-gb-gui-opengl gambas3-gb-gui-qt gambas3-gb-gui-qt-webkit gambas3-gb-gui-trayicon  gambas3-gb-libxml gambas3-gb-option gambas3-gb-report gambas3-gb-sdl gambas3-gb-sdl-sound gambas3-gb-v4l gambas3-templates gambas3-gb-qt5 gambas3-gb-qt5-ext  gambas3-gb-qt5-opengl  gambas3-gb-qt5-webkit
EDIT Monday 13/07/2020 4:00pm
I have just updated to Mint 20 using the upgrade path. I have just run the above and all is well
User avatar
Quincunxian
Posts: 171
Joined: Sunday 25th June 2017 12:14am
Location: Western Australia

Re: DB connection not working after update to Mint 20 Ulyana

Post by Quincunxian »

Thanks PJ & Cogier.
I did try a remove/clean install before hand but apt auto-remove failed with the error 'package broken'
Did a clean up manually using the advice from the main Gambas web site:

Edit: @PJ - that is exactly the error message I get.

How do I uninstall Gambas?

If you have installed Gambas using the packaging mechanism of your operating system, it should be easy to use the normal uninstallation procedure.
If you have installed from source as root, just remove the installation directory.
For example, if you have installed Gambas under /opt/gambas3, just enter the following as root:

$ rm -rf /opt/gambas3

If the installation prefix is /usr, or /usr/local (which is the default) then you have to remove each directory one by one.

$ rm -f /usr/local/bin/gbx3 /usr/local/bin/gbc3 /usr/local/bin/gba3 /usr/local/bin/gbi3
$ rm -rf /usr/local/lib/gambas3
$ rm -rf /usr/local/share/gambas3

-----------------------------------------------------
I'll post once I get some result one way or the other.
Cheers - Quin.
I code therefore I am
User avatar
PJBlack
Posts: 184
Joined: Tuesday 9th June 2020 10:26pm
Location: Florstadt, Hessen, Germany

Re: DB connection not working after update to Mint 20 Ulyana

Post by PJBlack »

Does it work with commit https://gitlab.com/gambas/gambas/-/comm ... 231c8cb04c?
(Note that I have no problem on my Ubuntu 20).
Benoît MINISINI
for me the fix did NOT work ... trying again tomorow
User avatar
PJBlack
Posts: 184
Joined: Tuesday 9th June 2020 10:26pm
Location: Florstadt, Hessen, Germany

Re: DB connection not working after update to Mint 20 Ulyana

Post by PJBlack »

And with commit https://gitlab.com/gambas/gambas/-/comm ... 49ad426e9d ?
Benoît MINISINI - 14/07/2020 14:49:11
this commit solved my problem!
User avatar
Quincunxian
Posts: 171
Joined: Sunday 25th June 2017 12:14am
Location: Western Australia

Re: DB connection not working after update to Mint 20 Ulyana

Post by Quincunxian »

I'm up and running too.
The problem I think was that gb.db.sqlite3 was removed as part of the upgrade and although the Gb.Db component was there the underlying sqlite3 driver was not.
It did not appear in the components list prior to the fix.

I ended up having a few other minor upgrade issues with other applications so did a full rebuild and all good.

Thanks PJ & Cogier.
Cheers - Quin.
I code therefore I am
Post Reply