cancel XML export
-
- Posts: 243
- Joined: Sat Aug 01, 2015 5:15 am
- Contact:
cancel XML export
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.
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 186 times
- CintaNotes Developer
- Site Admin
- Posts: 5001
- Joined: Fri Dec 12, 2008 4:45 pm
- Contact:
-
- Posts: 243
- Joined: Sat Aug 01, 2015 5:15 am
- Contact:
Re: cancel XML export
Yesterday it was, but not anymore. Odd...
- CintaNotes Developer
- Site Admin
- Posts: 5001
- Joined: Fri Dec 12, 2008 4:45 pm
- Contact:
-
- Posts: 243
- Joined: Sat Aug 01, 2015 5:15 am
- Contact:
Re: cancel XML export
When the error was there, it was repeatable.
But can't be helped. Perhaps it was the weather...
But can't be helped. Perhaps it was the weather...
- CintaNotes Developer
- Site Admin
- Posts: 5001
- Joined: Fri Dec 12, 2008 4:45 pm
- Contact:
-
- Posts: 243
- Joined: Sat Aug 01, 2015 5:15 am
- Contact:
Re: cancel XML export
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.
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.
- CintaNotes Developer
- Site Admin
- Posts: 5001
- Joined: Fri Dec 12, 2008 4:45 pm
- Contact:
Re: cancel XML export
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?
![Sad :(](./images/smilies/icon_e_sad.gif)
How large is your DB btw?
Alex
-
- Posts: 243
- Joined: Sat Aug 01, 2015 5:15 am
- Contact:
Re: cancel XML export
The circumstances for this bug to manifest itself are getting more and more out of the ordinary every time...
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.)
![Shocked :shock:](./images/smilies/icon_eek.gif)
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.)
- CintaNotes Developer
- Site Admin
- Posts: 5001
- Joined: Fri Dec 12, 2008 4:45 pm
- Contact:
-
- Posts: 243
- Joined: Sat Aug 01, 2015 5:15 am
- Contact:
Re: cancel XML export
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.
The bug is there with 'Windows 7 Basic' or the 'Windows Classic' theme, but not with 'Windows 7' and other Aero-themes.
- CintaNotes Developer
- Site Admin
- Posts: 5001
- Joined: Fri Dec 12, 2008 4:45 pm
- Contact:
Re: cancel XML export
Thanks for the extra info! Does the bug still manifest if you change datetime settings in Control Panel to US?
Alex
-
- Posts: 243
- Joined: Sat Aug 01, 2015 5:15 am
- Contact:
Re: cancel XML export
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.![Smile :)](./images/smilies/icon_e_smile.gif)
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.
![Smile :)](./images/smilies/icon_e_smile.gif)
- CintaNotes Developer
- Site Admin
- Posts: 5001
- Joined: Fri Dec 12, 2008 4:45 pm
- Contact:
Re: cancel XML export
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
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
-
- Posts: 243
- Joined: Sat Aug 01, 2015 5:15 am
- Contact:
Re: cancel XML export
You sound very happy to find a bug!
- CintaNotes Developer
- Site Admin
- Posts: 5001
- Joined: Fri Dec 12, 2008 4:45 pm
- Contact:
- CintaNotes Developer
- Site Admin
- Posts: 5001
- Joined: Fri Dec 12, 2008 4:45 pm
- Contact:
Re: cancel XML export
Hi date,
please try the new beta where this issue should be fixed: viewtopic.php?f=3&t=2277
please try the new beta where this issue should be fixed: viewtopic.php?f=3&t=2277
Alex
-
- Posts: 243
- Joined: Sat Aug 01, 2015 5:15 am
- Contact:
Re: cancel XML export
Yes, better.
- CintaNotes Developer
- Site Admin
- Posts: 5001
- Joined: Fri Dec 12, 2008 4:45 pm
- Contact: