Tags table is full

TalkBug Collectors

Join LibraryThing to post.

Tags table is full

This topic is currently marked as "dormant"—the last message is more than 90 days old. You can revive it by posting a reply.

1bertilak
Sep 6, 2015, 8:59 am

On trying to add tags:

INSERT INTO tags (tag_textkey, tag_bookid, tag_usernum) VALUES (89874, 121408617, 49848), (55, 121408617, 49848), (8180678, 121408617, 49848), (3306471, 121408617, 49848), (7189477, 121408617, 49848), (631258, 121408617, 49848), (53740, 121408617, 49848), (63263, 121408617, 49848)The table 'tags' is full - fatal error (tag2)

2vivir
Sep 6, 2015, 9:18 am

Same here:
When trying to add a book (isbn 951119769x) with tags in "tags to add" field I got:
"INSERT INTO tags (tag_textkey, tag_bookid, tag_usernum) VALUES (1050836, 121408638, 232033), (1036031, 121408638, 232033), (720761, 121408638, 232033) - fatal error (tag2)"

Adding the same book without tags was successful, but the add books result said:
"There is another version of this work in Your books; 17 other members; Tags: None"
However, the book page (main page) and my catalogue don't show another copy.

When trying to add tags in book page:
"INSERT INTO tags (tag_textkey, tag_bookid, tag_usernum) VALUES (1050836, 121408660, 232033), (1036031, 121408660, 232033), (720761, 121408660, 232033)The table 'tags' is full - fatal error (tag2) (edit)"

Edit book with tags gives same error:
"INSERT INTO tags (tag_textkey, tag_bookid, tag_usernum) VALUES (1050836, 121408660, 232033), (1036031, 121408660, 232033), (720761, 121408660, 232033)The table 'tags' is full - fatal error (tag2)"

Editing book information with empty tags field seems to go all right.

3Cynfelyn
Sep 6, 2015, 9:23 am

Same here when using Add books / Add manually, e.g.

INSERT INTO tags (tag_textkey, tag_bookid, tag_usernum) VALUES (11781651, 121408844, 1501587), (8269498, 121408844, 1501587), (235, 121408844, 1501587) - fatal error (tag2)

4Karin_J_Lee
Sep 6, 2015, 9:25 am

Just to confirm that I am also having this problem; I have an unpaid account with 165 books and about 68 tags

5Luisali
Sep 6, 2015, 9:30 am

Same here, when adding a tag to an already tagged book:
INSERT INTO tags (tag_textkey, tag_bookid, tag_usernum) VALUES (684800, 121307100, 1486712), (951679, 121307100, 1486712), (1057091, 121307100, 1486712), (10305204, 121307100, 1486712), (39, 121307100, 1486712)The table 'tags' is full - fatal error (tag2)

and the old tags were removed.

6bluepiano
Sep 6, 2015, 9:31 am

I'm getting much the same when trying to edit a tag on a book page. Different jumble of digits than above, though.

7Merryann
Edited: Sep 6, 2015, 9:38 am

Me too. Perhaps it's LT's automatic 'it's time for you to stop entering books and go eat breakfast' sensor. If so, gee, thanks.

8electrice
Sep 6, 2015, 9:39 am

Same here

9Cynfelyn
Sep 6, 2015, 9:39 am

Like >2 vivir: , I succeeded in adding the books without the tags.

However, when I then tried to add the tags using the 'Tags None (edit)' function on one of the books' main page, and in the Tags column of 'My books', I got the same sort of error message:

INSERT INTO tags (tag_textkey, tag_bookid, tag_usernum) VALUES (130484, 121408865, 1501587), (11781651, 121408865, 1501587), (235, 121408865, 1501587) - fatal error (tag2)

10rainerc
Sep 6, 2015, 9:40 am

error: "table tags is full" when editing and saving a book with tags

11intres
Sep 6, 2015, 10:40 am

I have the same:

INSERT INTO tags (tag_textkey, tag_bookid, tag_usernum) VALUES (11175666, 121409356, 365870)The table 'tags' is full - fatal error (tag2)

12RobertDay
Edited: Sep 6, 2015, 10:43 am

Same here - even though the edit I've done doesn't involve adding any new tags. The edit didn't save, either.

13starbox
Sep 6, 2015, 10:45 am

Same here: I'm a paid-up member. In fact I was trying to DELETE a current tag ('currently reading'), not adding more.

14Helenliz
Sep 6, 2015, 10:59 am

Same for me too
INSERT INTO tags (tag_textkey, tag_bookid, tag_usernum) VALUES (64214, 121341918, 1661253), (438775, 121341918, 1661253), (1036107, 121341918, 1661253) - fatal error (tag2)

Feel better that it's NOT just me...

16paradoxosalpha
Sep 6, 2015, 11:15 am

INSERT INTO tags (tag_textkey, tag_bookid, tag_usernum) VALUES (631317, 67672261, 104779), (3353, 67672261, 104779), (3912, 67672261, 104779), (277, 67672261, 104779)The table 'tags' is full - fatal error (tag2)

17ghr4
Sep 6, 2015, 11:47 am

I can add books, but same problem with the tags all morning...

INSERT INTO tags (tag_textkey, tag_bookid, tag_usernum) VALUES (6728, 121409871, 1977897), (33208, 121409871, 1977897)The table 'tags' is full - fatal error (tag2)

18bluepiano
Sep 6, 2015, 11:50 am

Can edit tag with no problem now. Thanks.

19sryder
Sep 6, 2015, 11:50 am

Sorry about the trouble everyone, hopefully this issue should be cleared up now. But please let me know if it continues.

20starbox
Sep 6, 2015, 1:50 pm

many thanks!

21Karin_J_Lee
Sep 6, 2015, 1:53 pm

Yup, it's working now. Thanks for that speedy, holiday weekend, fix!

22Merryann
Sep 6, 2015, 2:00 pm

Thank you!

23Jarandel
Edited: Sep 6, 2015, 3:56 pm

At around the same time the tag snaffu was occurring I tried to add a book, which resulted in this :

http://www.librarything.com/work/252649/book/121409493

Visible from my homepage as next to last book I added, but that I can't see any data for or load the page of, because it's apparently private and I'm not the owner (?). It doesn't appear at all on my profile or in my catalog view of last books added.

Feel free to dissect as needed, wasn't intended to be private at all.

24paradoxosalpha
Sep 6, 2015, 5:33 pm

Thanks for the fix.