cancel XML export

date
Posts: 242
Joined: Sat Aug 01, 2015 5:15 am
Contact:

cancel XML export

Postby date » Sat Jan 21, 2017 2:20 pm

When I cancelled the export to XML I got these:
SQLite error 21: bind or column index out of range
ERROR:Day of month value is out of range 1..31

+ debug log.
Attachments
log.1.txt.zip
(76.78 KiB) Downloaded 156 times
User avatar
CintaNotes Developer
Site Admin
Posts: 4690
Joined: Fri Dec 12, 2008 4:45 pm
Contact:

Re: cancel XML export

Postby CintaNotes Developer » Mon Jan 23, 2017 8:45 am

Thanks for the report, date!
Is the issue repeatable on your data?
Alex
date
Posts: 242
Joined: Sat Aug 01, 2015 5:15 am
Contact:

Re: cancel XML export

Postby date » Mon Jan 23, 2017 10:37 am

Yesterday it was, but not anymore. Odd...
User avatar
CintaNotes Developer
Site Admin
Posts: 4690
Joined: Fri Dec 12, 2008 4:45 pm
Contact:

Re: cancel XML export

Postby CintaNotes Developer » Tue Jan 24, 2017 9:37 am

I can't repeat this as well.. (
Alex
date
Posts: 242
Joined: Sat Aug 01, 2015 5:15 am
Contact:

Re: cancel XML export

Postby date » Tue Jan 24, 2017 9:57 am

When the error was there, it was repeatable.
But can't be helped. Perhaps it was the weather...
User avatar
CintaNotes Developer
Site Admin
Posts: 4690
Joined: Fri Dec 12, 2008 4:45 pm
Contact:

Re: cancel XML export

Postby CintaNotes Developer » Wed Jan 25, 2017 6:23 pm

Or the date ;)
Alex
date
Posts: 242
Joined: Sat Aug 01, 2015 5:15 am
Contact:

Re: cancel XML export

Postby date » Wed Jan 25, 2017 11:15 pm

It depends on how you pronounce date, but it was because I clicked Cancel too fast on a notebook with +- 10000 notes.

If you click Cancel very fast, CN disappears.

If you click a little bit slower:
SE_EXCEPTION_ACCESS_VIOLATION at adress 0x015BC84C inside CintaNotes.exe loaded at base address 0x01360000
Invalid operation: read at address 0x6c

Even slower:
class boost::exception_detail::clone_impl<struct
boost::exception_detail::error_info_injector<struct
boost::gregorian::bad_day_of_month> >
Day of month value is out of range 1..31

Even more slower:
SQLite error 21: bind or column index out of range
ERROR:Day of month value is out of range 1..31

This is before the blue progress bar starts filling. So it is repeatable, after all.
User avatar
CintaNotes Developer
Site Admin
Posts: 4690
Joined: Fri Dec 12, 2008 4:45 pm
Contact:

Re: cancel XML export

Postby CintaNotes Developer » Thu Jan 26, 2017 2:27 pm

So far, I still can't reproduce :( But my test DB is less than 10000 notes, or my PC is too fast... Probably will have to beef it up.
How large is your DB btw?
Alex
date
Posts: 242
Joined: Sat Aug 01, 2015 5:15 am
Contact:

Re: cancel XML export

Postby date » Thu Jan 26, 2017 6:56 pm

The circumstances for this bug to manifest itself are getting more and more out of the ordinary every time... :shock:

It is reproducable on W7 with classic theme. (Not with aero.)

(You can select 1000 notes and copy and paste them a few times in a new db until you have 10000, works like a charm.)
User avatar
CintaNotes Developer
Site Admin
Posts: 4690
Joined: Fri Dec 12, 2008 4:45 pm
Contact:

Re: cancel XML export

Postby CintaNotes Developer » Sat Jan 28, 2017 5:50 am

Are you sure about Aero? That's VERY strange..
Alex
date
Posts: 242
Joined: Sat Aug 01, 2015 5:15 am
Contact:

Re: cancel XML export

Postby date » Sat Jan 28, 2017 10:31 am

Pretty sure, I confirmed in a VM.
The bug is there with 'Windows 7 Basic' or the 'Windows Classic' theme, but not with 'Windows 7' and other Aero-themes.
User avatar
CintaNotes Developer
Site Admin
Posts: 4690
Joined: Fri Dec 12, 2008 4:45 pm
Contact:

Re: cancel XML export

Postby CintaNotes Developer » Fri Feb 03, 2017 9:10 am

Thanks for the extra info! Does the bug still manifest if you change datetime settings in Control Panel to US?
Alex
date
Posts: 242
Joined: Sat Aug 01, 2015 5:15 am
Contact:

Re: cancel XML export

Postby date » Fri Feb 03, 2017 4:58 pm

The locale settings do not seem to have anything to do with it.
It is impossible to have the error message with an Aero theme, this can't be just a coincidence?
See https://yadi.sk/i/J679EtfL3Ch4tg for an example, it is very straightforward. Don't click cancel in a nanosecond, just move the mouse over there. :)
User avatar
CintaNotes Developer
Site Admin
Posts: 4690
Joined: Fri Dec 12, 2008 4:45 pm
Contact:

Re: cancel XML export

Postby CintaNotes Developer » Mon Feb 06, 2017 7:35 am

Thanks for the video!

More than 5000 notes + Classic theme finally did the trick - I could repro the error! Hurrah!
Now the fix should arrive with the next update.
Huge thanks again
Alex
date
Posts: 242
Joined: Sat Aug 01, 2015 5:15 am
Contact:

Re: cancel XML export

Postby date » Mon Feb 06, 2017 4:15 pm

You sound very happy to find a bug!
User avatar
CintaNotes Developer
Site Admin
Posts: 4690
Joined: Fri Dec 12, 2008 4:45 pm
Contact:

Re: cancel XML export

Postby CintaNotes Developer » Tue Feb 07, 2017 3:20 am

Getting a way to reliably reproduce a bug is about 80% of fixing it :)
Alex
User avatar
CintaNotes Developer
Site Admin
Posts: 4690
Joined: Fri Dec 12, 2008 4:45 pm
Contact:

Re: cancel XML export

Postby CintaNotes Developer » Fri Mar 31, 2017 11:23 am

Hi date,
please try the new beta where this issue should be fixed: viewtopic.php?f=3&t=2277
Alex
date
Posts: 242
Joined: Sat Aug 01, 2015 5:15 am
Contact:

Re: cancel XML export

Postby date » Sat Apr 01, 2017 8:52 am

Yes, better.
User avatar
CintaNotes Developer
Site Admin
Posts: 4690
Joined: Fri Dec 12, 2008 4:45 pm
Contact:

Re: cancel XML export

Postby CintaNotes Developer » Tue Apr 04, 2017 6:03 am

Thanks for checking, date!
Alex

Return to “Bug Reports”