[GNC] sqlite backend unavailable on MacOS in Save-As dialogue (was: Unable to add prices to some securities)

[Adrien Monteleone]

There is MySQL, and there is SQLite - 2 different things.

Yes, MacOS comes with SQLite, and the Mac version of GnuCash includes that backend as well.

It should be available to use.

Perhaps one of the developers can chime in with some troubleshooting tips...

Note, in the future, when you have an additional problem or question that isn’t part of the current thread, please start a new e-mail topic, I’ve renamed this one for you.

Regards,
Adrien

> On Mar 20, 2019, at 12:27 AM, Alan Taylor <alan.james.taylor at gmail.com> wrote:
> 
> It is the latest MacOS.
> Apologies, I should have said MySQL Lite ... this is included with GnuCash I thought ?
> It was an option previously ...
> 
> BRgds/Alan
> On Mar 20, 2019, 13:18 +0800, Adrien Monteleone <adrien.monteleone at lusfiber.net>, wrote:
>> What OS are you on?
>> 
>> I think on Windows you have to install SQLite or MySQL separately. MacOS comes with SQLite and I think (don’t remember) most Linux distributions do as well. MySQL has to be installed separately for both MacOS and some Linux distributions, a few come with it already and some substitute MariaDB. (older versions of OS X, 10.6 at least, used to come with MySQL, but they moved that to a separate installation some years ago.)
>> 
>> The are no other options in the drop down because those database drivers are not installed on the machine.
>> 
>> Regards,
>> Adrien
>> 
>>> On Mar 19, 2019, at 11:58 PM, Alan Taylor <alan.james.taylor at gmail.com> wrote:
>>> 
>>> More things not working properly …
>>> In the Save As dialogue there is no way to select sql - click on the displayed xml does not reveal any other possibilities
>>> Also the price editor dialogue does not allow selection of a namespace. There should be several, but it displays “All non-currency” with no other selections possible.
>>> 
>>> Tried a reinstallation (3.4), no change.
>>> 
>>> BRgds/Alan