FUDforum: Bug Reports » SQL errors when fetching mailing list messages

Home » FUDforum Development » Bug Reports » SQL errors when fetching mailing list messages

Show: Today's Messages :: Unread Messages :: Polls :: Message Navigator
| Unsubscribe from topic | Bookmark topic

SQL errors when fetching mailing list messages [message #188167]

Mon, 16 August 2021 11:03

JeanAbouSamra

Messages: 7
Registered: July 2021

Karma: 0

Junior Member

add to buddy list
ignore all messages by this user

Hello,

When attempting to load a large number of mailing list messages
into a FUDforum via IMAP synchronization, I am getting errors
such as

Mon Aug 16 14:08:04 GMT 2021	(/homepages/20/d353705993/htdocs/FUDforum/include/theme/default/db.inc:112
/homepages/20/d353705993/htdocs/FUDforum/include/theme/default/isearch.inc:100
/homepages/20/d353705993/htdocs/FUDforum/include/theme/default/imsg_edt.inc:459
/homepages/20/d353705993/htdocs/FUDforum/scripts/maillist.php:348
) 1062: Duplicate entry '585-11' for key 'PRIMARY'
Query: INSERT INTO fud30_index (word_id, msg_id, frequency) SELECT id, 11,1 FROM fud30_search WHERE word = 'matières'
Database version: 5.7.33-log

Many empty topics with "(no subject)" as title are created.

Any thoughts?

Thanks,
Jean Abou Samra (again!)

Report message to a moderator

Rate author: +1 -1

Re: SQL errors when fetching mailing list messages [message #188170 is a reply to message #188167]

Mon, 16 August 2021 15:29

naudefj

Messages: 3771
Registered: December 2004

Karma: 28

Senior Member
Administrator
Core Developer

add to buddy list
ignore all messages by this user

Errors on INSERT INTO fud30_index can be ignored, it just means that a particular word is already indexed.

If you import a message with a subject, but it shows "(no subject)" after importing, please post or PM the message to me for testing.

Report message to a moderator

Rate author: +1 -1