Open the file with a text editor, if sqlite, you’ll see: "SQLite format 3"
at the beginning of the file, otherwise, you’re looking at a compressed (or uncompressed) XML. Regards, Adrien > On Mar 15, 2020 w12d75, at 4:33 PM, Adrien Monteleone > <adrien.montele...@lusfiber.net> wrote: > > sqlite files also have a .gnucash extension. > > Regards, > Adrien > >> On Mar 15, 2020 w12d75, at 4:19 PM, David H <hell...@gmail.com> wrote: >> >> Hi Eric, >> >> You may need to provide further info on this, i.e what version of gnucash >> are you using and on what OS ? >> >> You say your file is saved as xml so I'm a bit surprised to see sql dbi >> related error messages in your trace file. So just to remove all doubt - >> your file is definitely xml and has a ".gnucash" suffix on the file name >> ??? Seems that it doesn't like your date of 2020/2/6 - 6th Feb 2020 ? >> >> If your file is definitely xml it's probably compressed so can't be >> searched. You can go to Preferences >>General >> Files and uncheck >> "Compress Files" and save it as an uncompressed file which will allow you >> to open it with a text editor and search for the 2020/2/6 and compare it >> with other dates and see if they look the same. If you do this copy your >> data file and work on a copy until you find the problem. >> >> Regards David. > _______________________________________________ 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.