Re: [GNC] "No suitable backend" error for database backed gnucash file
> On Apr 15, 2018, at 11:12 AM, coolnodje wrote: > > Sorry for being unresponsive, this email ended up in my spam box for > some reason. > > Thanks for pointing this bug to me. Sounds exactly like the problem I have. > Adding the line to my environment file didn't help unfortunately. > > I've subscribed to the bug report, will see how it unfolds. > If fixing the environment file (please check carefully to ensure that you made the change correctly) didn't do it for you then please file a new bug; you have a different problem from the one on that one. Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] "No suitable backend" error for database backed gnucash file
Sorry for being unresponsive, this email ended up in my spam box for some reason. Thanks for pointing this bug to me. Sounds exactly like the problem I have. Adding the line to my environment file didn't help unfortunately. I've subscribed to the bug report, will see how it unfolds. Thanks On 10/04/2018 15:41, Geert Janssens wrote: > Op maandag 9 april 2018 11:13:16 CEST schreef coolnodje: >>sqlite is still installed and available on my machine. >>I can't make sure which version is used though, as there are several >>and I don't quite get which PATH Gnucash is using on MacOS. >> >>It's very likely that it uses the MacOS pre-installed version and that >>it hasn't changed. >> >>If Gnucash has access to the specific "brew" installed binaries then it >>may be that a newer version isn't compatible. >> >>-nodje > Did you try as suggested in the bug report to add a line to your environment > file ? > That advice was the first suggestion in comment one > https://bugzilla.gnome.org/show_bug.cgi?id=794933#c1 > and this fixed the backend issue for the other reporters. > > Geert > > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] "No suitable backend" error for database backed gnucash file
Op maandag 9 april 2018 11:13:16 CEST schreef coolnodje: >sqlite is still installed and available on my machine. >I can't make sure which version is used though, as there are several >and I don't quite get which PATH Gnucash is using on MacOS. > >It's very likely that it uses the MacOS pre-installed version and that >it hasn't changed. > >If Gnucash has access to the specific "brew" installed binaries then it >may be that a newer version isn't compatible. > >-nodje Did you try as suggested in the bug report to add a line to your environment file ? That advice was the first suggestion in comment one https://bugzilla.gnome.org/show_bug.cgi?id=794933#c1 and this fixed the backend issue for the other reporters. Geert ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] "No suitable backend" error for database backed gnucash file
All right, so that's one less reason to get the "No suitable backend" error. The sqlite backend shouldn't possibly be missing. Then I just have no lead anymore as for why I could possibly get this problem. Unless you have any advice to debug this I guess I'll just recreate the file with the logs. It's very small but I have a company, a customer and an invoice recorded in it, which I wish I could keep. -nodje On 09/04/2018 16:33, John Ralls wrote: > The Mac bundle has its own copy of sqlite3 along with almost everything else > it needs. It does use some frameworks from /System/Library/Frameworks > (notably AppKit and CoreFoundation) and one or two from /usr/lib. It does not > and cannot use anything from Homebrew; the Homebrew “recipe” for GnuCash just > retrieves and downloads one of our distribution dmgs. > > Regards, > John Ralls > > >> On Apr 9, 2018, at 2:13 AM, coolnodje wrote: >> >> sqlite is still installed and available on my machine. >> I can't make sure which version is used though, as there are several >> and I don't quite get which PATH Gnucash is using on MacOS. >> >> It's very likely that it uses the MacOS pre-installed version and that >> it hasn't changed. >> >> If Gnucash has access to the specific "brew" installed binaries then it >> may be that a newer version isn't compatible. >> >> -nodje >> >> On 08/04/2018 14:33, David Carlson wrote: >> >> Did you verify that you had the back end installed? see >> [1]https://wiki.gnucash.org/wiki/FAQ#SQL_Database >> David C >> >> On Sun, Apr 8, 2018 at 7:10 AM, coolnodje <[2]coolno...@gmail.com> >> wrote: >> >> Using Gnucash on MacOS, I got this error trying to open a recently >> created file which I think I based on a database back-end instead of >> the >> standard. >> I have upgraded to 3.0 in the meantime and thought it was the >> problem. >> But I realized when I finally was able to start a v2.6.20 on an >> older >> MacOS10.12 virtual machine that I still had the problem. >> Which means that this is all unrelated to the 3.0 upgrade. >> I've tried to revert the file to an older version (prior to the last >> modification, so prior to the last successful opening) but got the >> same >> error. >> This really confuses me: >> - the file as it was the last time it was successfully modified >> cannot >> be opened (which should exclude file corruption problem) >> - the latest version on latest MacOS can't open it because "No >> suitable >> backend", but 2.6.20 on MacOS10.12 also can't open it because "No >> suitable backend". >> So if the file itself is not the problem, and if version that used >> to be >> able to open it can't anymore, where could the problem come from? >> Only I wasn't able to reproduce the error with the exact same setup >> I >> had when last successfully modified: trying to reinstall 2.6.20 on >> MacOS10.13 I realized it can't be started anymore (Gnucash can't be >> opened because of a problem - DYLD, [0x4] Symbol missing) >> Is there anything I can do to try to save the file in question? >> - nodje >> ___ >> gnucash-user mailing list >> [3]gnucash-user@gnucash.org >> To update your subscription preferences or to unsubscribe: >> [4]https://lists.gnucash.org/mailman/listinfo/gnucash-user >> If you are using Nabble or Gmane, please see >> [5]https://wiki.gnucash.org/wiki/Mailing_Lists for more information. >> - >> Please remember to CC this list on all your replies. >> You can do this by using Reply-To-List or Reply-All. >> >> References >> >> 1. https://wiki.gnucash.org/wiki/FAQ#SQL_Database >> 2. mailto:coolno...@gmail.com >> 3. mailto:gnucash-user@gnucash.org >> 4. https://lists.gnucash.org/mailman/listinfo/gnucash-user >> 5. https://wiki.gnucash.org/wiki/Mailing_Lists >> ___ >> gnucash-user mailing list >> gnucash-user@gnucash.org >> To update your subscription preferences or to unsubscribe: >> https://lists.gnucash.org/mailman/listinfo/gnucash-user >> If you are using Nabble or Gmane, please see >> https://wiki.gnucash.org/wiki/Mailing_Lists for more information. >> - >> Please remember to CC this list on all your replies. >> You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] "No suitable backend" error for database backed gnucash file
The Mac bundle has its own copy of sqlite3 along with almost everything else it needs. It does use some frameworks from /System/Library/Frameworks (notably AppKit and CoreFoundation) and one or two from /usr/lib. It does not and cannot use anything from Homebrew; the Homebrew “recipe” for GnuCash just retrieves and downloads one of our distribution dmgs. Regards, John Ralls > On Apr 9, 2018, at 2:13 AM, coolnodje wrote: > > sqlite is still installed and available on my machine. > I can't make sure which version is used though, as there are several > and I don't quite get which PATH Gnucash is using on MacOS. > > It's very likely that it uses the MacOS pre-installed version and that > it hasn't changed. > > If Gnucash has access to the specific "brew" installed binaries then it > may be that a newer version isn't compatible. > > -nodje > > On 08/04/2018 14:33, David Carlson wrote: > > Did you verify that you had the back end installed? see > [1]https://wiki.gnucash.org/wiki/FAQ#SQL_Database > David C > > On Sun, Apr 8, 2018 at 7:10 AM, coolnodje <[2]coolno...@gmail.com> > wrote: > > Using Gnucash on MacOS, I got this error trying to open a recently > created file which I think I based on a database back-end instead of > the > standard. > I have upgraded to 3.0 in the meantime and thought it was the > problem. > But I realized when I finally was able to start a v2.6.20 on an > older > MacOS10.12 virtual machine that I still had the problem. > Which means that this is all unrelated to the 3.0 upgrade. > I've tried to revert the file to an older version (prior to the last > modification, so prior to the last successful opening) but got the > same > error. > This really confuses me: > - the file as it was the last time it was successfully modified > cannot > be opened (which should exclude file corruption problem) > - the latest version on latest MacOS can't open it because "No > suitable > backend", but 2.6.20 on MacOS10.12 also can't open it because "No > suitable backend". > So if the file itself is not the problem, and if version that used > to be > able to open it can't anymore, where could the problem come from? > Only I wasn't able to reproduce the error with the exact same setup > I > had when last successfully modified: trying to reinstall 2.6.20 on > MacOS10.13 I realized it can't be started anymore (Gnucash can't be > opened because of a problem - DYLD, [0x4] Symbol missing) > Is there anything I can do to try to save the file in question? > - nodje > ___ > gnucash-user mailing list > [3]gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > [4]https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > [5]https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > > References > > 1. https://wiki.gnucash.org/wiki/FAQ#SQL_Database > 2. mailto:coolno...@gmail.com > 3. mailto:gnucash-user@gnucash.org > 4. https://lists.gnucash.org/mailman/listinfo/gnucash-user > 5. https://wiki.gnucash.org/wiki/Mailing_Lists > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] "No suitable backend" error for database backed gnucash file
sqlite is still installed and available on my machine. I can't make sure which version is used though, as there are several and I don't quite get which PATH Gnucash is using on MacOS. It's very likely that it uses the MacOS pre-installed version and that it hasn't changed. If Gnucash has access to the specific "brew" installed binaries then it may be that a newer version isn't compatible. -nodje On 08/04/2018 14:33, David Carlson wrote: Did you verify that you had the back end installed? see [1]https://wiki.gnucash.org/wiki/FAQ#SQL_Database David C On Sun, Apr 8, 2018 at 7:10 AM, coolnodje <[2]coolno...@gmail.com> wrote: Using Gnucash on MacOS, I got this error trying to open a recently created file which I think I based on a database back-end instead of the standard. I have upgraded to 3.0 in the meantime and thought it was the problem. But I realized when I finally was able to start a v2.6.20 on an older MacOS10.12 virtual machine that I still had the problem. Which means that this is all unrelated to the 3.0 upgrade. I've tried to revert the file to an older version (prior to the last modification, so prior to the last successful opening) but got the same error. This really confuses me: - the file as it was the last time it was successfully modified cannot be opened (which should exclude file corruption problem) - the latest version on latest MacOS can't open it because "No suitable backend", but 2.6.20 on MacOS10.12 also can't open it because "No suitable backend". So if the file itself is not the problem, and if version that used to be able to open it can't anymore, where could the problem come from? Only I wasn't able to reproduce the error with the exact same setup I had when last successfully modified: trying to reinstall 2.6.20 on MacOS10.13 I realized it can't be started anymore (Gnucash can't be opened because of a problem - DYLD, [0x4] Symbol missing) Is there anything I can do to try to save the file in question? - nodje ___ gnucash-user mailing list [3]gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: [4]https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see [5]https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. References 1. https://wiki.gnucash.org/wiki/FAQ#SQL_Database 2. mailto:coolno...@gmail.com 3. mailto:gnucash-user@gnucash.org 4. https://lists.gnucash.org/mailman/listinfo/gnucash-user 5. https://wiki.gnucash.org/wiki/Mailing_Lists ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] "No suitable backend" error for database backed gnucash file
Oh, I found it. Here’s the link to the bug with a possible solution: https://bugzilla.gnome.org/show_bug.cgi?id=794933 Regards, Adrien > On Apr 8, 2018, at 9:41 AM, Adrien Monteleone > wrote: > > If the backend is installed (as it was for me, I simply upgraded GC) then you > might need to modify the environment file in the 3.0 app’s bundle. Look in > this month’s archives on the list for a post by me on the same topic. I > didn’t get a reply, but I found that solution via a bug report that JohnR > offered. Sorry I don’t have the link handy or the info on the tip of my > tongue to save you the searching trouble. > > Regards, > Adrien > >> On Apr 8, 2018, at 7:33 AM, David Carlson >> wrote: >> >> Did you verify that you had the back end installed? see >> https://wiki.gnucash.org/wiki/FAQ#SQL_Database >> >> >> David C >> >> On Sun, Apr 8, 2018 at 7:10 AM, coolnodje wrote: >> >>> Using Gnucash on MacOS, I got this error trying to open a recently >>> created file which I think I based on a database back-end instead of the >>> standard. >>> >>> I have upgraded to 3.0 in the meantime and thought it was the problem. >>> >>> But I realized when I finally was able to start a v2.6.20 on an older >>> MacOS10.12 virtual machine that I still had the problem. >>> Which means that this is all unrelated to the 3.0 upgrade. >>> >>> I've tried to revert the file to an older version (prior to the last >>> modification, so prior to the last successful opening) but got the same >>> error. >>> This really confuses me: >>> >>> - the file as it was the last time it was successfully modified cannot >>> be opened (which should exclude file corruption problem) >>> >>> - the latest version on latest MacOS can't open it because "No suitable >>> backend", but 2.6.20 on MacOS10.12 also can't open it because "No >>> suitable backend". >>> >>> So if the file itself is not the problem, and if version that used to be >>> able to open it can't anymore, where could the problem come from? >>> >>> Only I wasn't able to reproduce the error with the exact same setup I >>> had when last successfully modified: trying to reinstall 2.6.20 on >>> MacOS10.13 I realized it can't be started anymore (Gnucash can't be >>> opened because of a problem - DYLD, [0x4] Symbol missing) >>> >>> Is there anything I can do to try to save the file in question? >>> >>> - nodje >>> >>> >>> ___ >>> gnucash-user mailing list >>> gnucash-user@gnucash.org >>> To update your subscription preferences or to unsubscribe: >>> https://lists.gnucash.org/mailman/listinfo/gnucash-user >>> If you are using Nabble or Gmane, please see >>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information. >>> - >>> Please remember to CC this list on all your replies. >>> You can do this by using Reply-To-List or Reply-All. >>> >> ___ >> gnucash-user mailing list >> gnucash-user@gnucash.org >> To update your subscription preferences or to unsubscribe: >> https://lists.gnucash.org/mailman/listinfo/gnucash-user >> If you are using Nabble or Gmane, please see >> https://wiki.gnucash.org/wiki/Mailing_Lists for more information. >> - >> Please remember to CC this list on all your replies. >> You can do this by using Reply-To-List or Reply-All. > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] "No suitable backend" error for database backed gnucash file
If the backend is installed (as it was for me, I simply upgraded GC) then you might need to modify the environment file in the 3.0 app’s bundle. Look in this month’s archives on the list for a post by me on the same topic. I didn’t get a reply, but I found that solution via a bug report that JohnR offered. Sorry I don’t have the link handy or the info on the tip of my tongue to save you the searching trouble. Regards, Adrien > On Apr 8, 2018, at 7:33 AM, David Carlson wrote: > > Did you verify that you had the back end installed? see > https://wiki.gnucash.org/wiki/FAQ#SQL_Database > > > David C > > On Sun, Apr 8, 2018 at 7:10 AM, coolnodje wrote: > >> Using Gnucash on MacOS, I got this error trying to open a recently >> created file which I think I based on a database back-end instead of the >> standard. >> >> I have upgraded to 3.0 in the meantime and thought it was the problem. >> >> But I realized when I finally was able to start a v2.6.20 on an older >> MacOS10.12 virtual machine that I still had the problem. >> Which means that this is all unrelated to the 3.0 upgrade. >> >> I've tried to revert the file to an older version (prior to the last >> modification, so prior to the last successful opening) but got the same >> error. >> This really confuses me: >> >> - the file as it was the last time it was successfully modified cannot >> be opened (which should exclude file corruption problem) >> >> - the latest version on latest MacOS can't open it because "No suitable >> backend", but 2.6.20 on MacOS10.12 also can't open it because "No >> suitable backend". >> >> So if the file itself is not the problem, and if version that used to be >> able to open it can't anymore, where could the problem come from? >> >> Only I wasn't able to reproduce the error with the exact same setup I >> had when last successfully modified: trying to reinstall 2.6.20 on >> MacOS10.13 I realized it can't be started anymore (Gnucash can't be >> opened because of a problem - DYLD, [0x4] Symbol missing) >> >> Is there anything I can do to try to save the file in question? >> >> - nodje >> >> >> ___ >> gnucash-user mailing list >> gnucash-user@gnucash.org >> To update your subscription preferences or to unsubscribe: >> https://lists.gnucash.org/mailman/listinfo/gnucash-user >> If you are using Nabble or Gmane, please see >> https://wiki.gnucash.org/wiki/Mailing_Lists for more information. >> - >> Please remember to CC this list on all your replies. >> You can do this by using Reply-To-List or Reply-All. >> > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] "No suitable backend" error for database backed gnucash file
Did you verify that you had the back end installed? see https://wiki.gnucash.org/wiki/FAQ#SQL_Database David C On Sun, Apr 8, 2018 at 7:10 AM, coolnodje wrote: > Using Gnucash on MacOS, I got this error trying to open a recently > created file which I think I based on a database back-end instead of the > standard. > > I have upgraded to 3.0 in the meantime and thought it was the problem. > > But I realized when I finally was able to start a v2.6.20 on an older > MacOS10.12 virtual machine that I still had the problem. > Which means that this is all unrelated to the 3.0 upgrade. > > I've tried to revert the file to an older version (prior to the last > modification, so prior to the last successful opening) but got the same > error. > This really confuses me: > > - the file as it was the last time it was successfully modified cannot > be opened (which should exclude file corruption problem) > > - the latest version on latest MacOS can't open it because "No suitable > backend", but 2.6.20 on MacOS10.12 also can't open it because "No > suitable backend". > > So if the file itself is not the problem, and if version that used to be > able to open it can't anymore, where could the problem come from? > > Only I wasn't able to reproduce the error with the exact same setup I > had when last successfully modified: trying to reinstall 2.6.20 on > MacOS10.13 I realized it can't be started anymore (Gnucash can't be > opened because of a problem - DYLD, [0x4] Symbol missing) > > Is there anything I can do to try to save the file in question? > > - nodje > > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] "No suitable backend" error for database backed gnucash file
Using Gnucash on MacOS, I got this error trying to open a recently created file which I think I based on a database back-end instead of the standard. I have upgraded to 3.0 in the meantime and thought it was the problem. But I realized when I finally was able to start a v2.6.20 on an older MacOS10.12 virtual machine that I still had the problem. Which means that this is all unrelated to the 3.0 upgrade. I've tried to revert the file to an older version (prior to the last modification, so prior to the last successful opening) but got the same error. This really confuses me: - the file as it was the last time it was successfully modified cannot be opened (which should exclude file corruption problem) - the latest version on latest MacOS can't open it because "No suitable backend", but 2.6.20 on MacOS10.12 also can't open it because "No suitable backend". So if the file itself is not the problem, and if version that used to be able to open it can't anymore, where could the problem come from? Only I wasn't able to reproduce the error with the exact same setup I had when last successfully modified: trying to reinstall 2.6.20 on MacOS10.13 I realized it can't be started anymore (Gnucash can't be opened because of a problem - DYLD, [0x4] Symbol missing) Is there anything I can do to try to save the file in question? - nodje ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.