FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum Development » Bug Reports » SQL errors when fetching mailing list messages
Show: Today's Messages :: Unread Messages :: Polls :: Message Navigator
| Subscribe to topic | Bookmark topic 
Switch to threaded view of this topic Create a new topic Submit Reply
SQL errors when fetching mailing list messages [message #188167] Mon, 16 August 2021 11:03 Go to next message
JeanAbouSamra is currently offline  JeanAbouSamra   France
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!)
Re: SQL errors when fetching mailing list messages [message #188170 is a reply to message #188167] Mon, 16 August 2021 15:29 Go to previous messageGo to next message
naudefj is currently offline  naudefj   
Messages: 3768
Registered: December 2004
Karma: 27
Senior Member
Administrator
Core Developer
remove from 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.
Re: SQL errors when fetching mailing list messages [message #188173 is a reply to message #188170] Thu, 19 August 2021 17:24 Go to previous message
JeanAbouSamra is currently offline  JeanAbouSamra   France
Messages: 7
Registered: July 2021
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
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.
Quick Reply
Formatting Tools:   
  Switch to threaded view of this topic Create a new topic
Previous Topic: Unlocking then locking files results in wrong permissions
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Sep 23 02:18:06 EDT 2021

Total time taken to generate the page: 0.00730 seconds