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 :: Polls :: Message Navigator

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

Mon, 16 August 2021 15:03

JeanAbouSamra

Messages: 7
Registered: July 2021

Karma: 0

Junior Member

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

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

Mon, 16 August 2021 19:29

naudefj

Messages: 3771
Registered: December 2004

Karma: 28

Senior Member
Administrator
Core Developer

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

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

Thu, 19 August 2021 21:24

JeanAbouSamra

Messages: 7
Registered: July 2021

Karma: 0

Junior Member

Sorry for the lack of response here. I'll be unable to debug for 2 weeks or so and will get back to it afterwards.

Report message to a moderator

Previous Topic:	Unlocking then locking files results in wrong permissions
Next Topic:	IP lookup admin feature seems broken

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 21 12:01:14 GMT 2024

Total time taken to generate the page: 0.01975 seconds