I am using MySQL.  When I attempt to Save As over an existing database
I see the database already exists warning then when I tell it to go
ahead I get the generic server encountered error or bad or corrupt
data message.

In gnucash.trace I see
* 15:40:07  WARN <gnc.backend.dbi>
[GncDbiBackend<Type>::session_begin()] Databse already exists, Might
clobber it.
* 15:41:37  CRIT <gnc.backend.dbi>
[GncDbiBackend<Type>::session_begin()] Unable to create database
'gnucash'

If I then look in mysql I see that the database has been dropped, and
if I try to Save As again it creates the database correctly.  So it
appears the drop database is working but then it is unable to create
the new one for some reason after dropping, but is able to create it
if it does not need to drop it.
On Fri, 12 Oct 2018 at 15:29, John Ralls <jra...@ceridwen.us> wrote:
>
>
>
> On Oct 12, 2018, at 6:03 AM, Colin Law <clan...@gmail.com> wrote:
>
> I believe that on early 3.x versions that it was not possible to Save
> As on top of an existing database of the same name.  I thought that
> had been fixed in or before 3.3 but I note that it still fails using
> 3.3 from the Ubuntu 18.10 repository.  Also I cannot find a bug
> referring to the problem.
>
> Can someone elucidate?
>
>
> Colin,
>
> The bugs were https://bugs.gnucash.org/show_bug.cgi?id=796724 for 
> MySQL/MariaDB and https://bugs.gnucash.org/show_bug.cgi?id=789594 for SQLite3.
>
> What DB Engine are you using and do you get an error or is it just refusing 
> to drop the existing DB?
>
> 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.

Reply via email to