error backing up label

[GoogleCodeExporter]

What steps will reproduce the problem?
1. C:\gyb>gyb --email gregg@realestatersca.com --search "label:002-roland" 

What is the expected output? What do you see instead?

Using backup folder GYB-GMail-Backup-name@realestatersca.com
using Gmail search: label:002-roland
GYB needs to examine 86 messages
GYB already has a backup of 0 messages
GYB needs to backup 86 messages
Traceback (most recent call last):
  File "gyb.py", line 921, in <module>
  File "gyb.py", line 667, in main
sqlite3.IntegrityError: columns message_num, label are not unique

What version of the product are you using? On what operating system?

GYB Alpha 17 Windows  Windows XP

Please provide any additional information below.

None that I can think of

Original issue reported on code.google.com by gr...@realestatersca.com on 2 Oct 2011 at 8:43

[GoogleCodeExporter]

As a follow-up, I was able to avoid this error by using version 16.

Original comment by tabata.d...@gmail.com on 3 Oct 2011 at 5:36

[GoogleCodeExporter]

+1

Here is the error I received:

backed up 31700 of 114788 messagesTraceback (most recent call last):
  File "gyb.py", line 921, in <module>
    main(sys.argv)
  File "gyb.py", line 667, in main
    (message_num, label))
sqlite3.IntegrityError: columns message_num, label are not unique

Original comment by joshnewman on 2 Nov 2011 at 10:57

[GoogleCodeExporter]

I also got the same error message as in the first post, after GYB had backed up 
3 000 messages out of the user's 10 148 messages. This is strange, since I have 
successfully backed up all mail from over a dozen other users without this 
error.

Is it because of a duplicate mail label in some way? I use GYB alpha 17 on 
Windows 7.

Original comment by thomas.d...@eyetrackshop.com on 16 Jan 2012 at 4:19

[GoogleCodeExporter]

Getting the same error, GYB Alpha 17 linux.

Original comment by b...@charlestonpr.com on 21 Jan 2012 at 2:27

[GoogleCodeExporter]

And this bug appears to be fixed in the current svn code

Original comment by b...@charlestonpr.com on 21 Jan 2012 at 2:51

[GoogleCodeExporter]

maybe not: this is what I am getting (see attached file)

I have labels like:
banche
banche/barclays

I am using version 17 for windows, just downloaded

Original comment by sluch...@gmail.com on 23 Jan 2012 at 10:37

Attachments:

• [gyb label error.ppt](https://storage.googleapis.com/google-code-attachments/got-your-back/issue-15/comment-6/gyb label error.ppt)

[GoogleCodeExporter]

hi. getting the same error. using GYB Alpha 17 on Mac OS X 10.7 (Lion)

Using backup folder GYB-GMail-Backup-name@gmail.com
GYB needs to examine 49819 messages
GYB already has a backup of 200 messages
GYB needs to backup 49619 messages
Traceback (most recent call last):
  File "gyb.py", line 921, in <module>
    main(sys.argv)
  File "gyb.py", line 667, in main
    (message_num, label))
sqlite3.IntegrityError: columns message_num, label are not unique

Original comment by hemayat....@gmail.com on 23 Jan 2012 at 3:36

[GoogleCodeExporter]

sorry. just realized that my error is caused not by searching but from the 
backup process itself.
getting the error after i try and execute:

python gyb.py --email hemayat.f.nabiel@gmail.com --backup --resume

Original comment by hemayat....@gmail.com on 23 Jan 2012 at 3:42

[GoogleCodeExporter]

I cannot figure out which was the last file backed up and which should have 
been the next one but caused the error message. Attached is the file list in 
the backup folder, sorted by decreasing date.
Do you know the file backup order ?

Original comment by sluch...@gmail.com on 24 Jan 2012 at 2:45

Attachments:

• [backup file list sm.jpg](https://storage.googleapis.com/google-code-attachments/got-your-back/issue-15/comment-9/backup file list sm.jpg)

[GoogleCodeExporter]

This is the error message I receive:

GYB needs to examine 11214 messages
GYB already has a backup of 3000 messages
GYB needs to backup 8214 messages
Traceback (most recent call last):
  File "gyb.py", line 921, in <module>
  File "gyb.py", line 667, in main
sqlite3.IntegrityError: columns message_num, label are not unique

I have still only received this error when trying to backup from one specific 
user's account. Doesn't really give much good information to solve the problem.

Original comment by thomas.d...@eyetrackshop.com on 2 Feb 2012 at 12:13

[GoogleCodeExporter]

I got the same message and solved the problem eliminating all non
alphanumeric characters from labels

Original comment by sluch...@gmail.com on 2 Feb 2012 at 1:18

[GoogleCodeExporter]

I got the same message. t seems that GYB cannot handle spaces in the label 
names. It seems to be a serious issue.

Original comment by dlux.hu on 11 Feb 2012 at 4:07

[GoogleCodeExporter]

It seems that the latest trunk has this issue fixed.

Original comment by dlux.hu on 11 Feb 2012 at 4:24