FUDforum

Post Form

Logged in user:

CommonCrawl [Bot] [logout]

Forum:

Bug Reports

Title:

Poll:

[CREATE POLL]

Message Icon:

No Icon

Smiley Shortcuts:
[ list all smilies ]

Formatting Tools:

Body:

Forum Options:
HTML code is off
BBcode is on
Images are on
Smilies are on
Editing Time Limit: Unlimited

File Attachments:

Allowed File Extensions: jpg jpeg png gif txt doc gz bz2 inc php zip diff
Maximum File Size: 1024KB
Maximum Files Per Message: 5

Options:

	Post Notification
	Notify me when someone replies to this message.
	Include Signature
	Include your profile signature.
	Disable smilies in this message

Topic View

Re: SQL errors when fetching mailing list messages

Thu, 19 August 2021 17:24

JeanAbouSamra

Karma:

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.

Re: SQL errors when fetching mailing list messages

Mon, 16 August 2021 15:29

naudefj

Karma:

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.

SQL errors when fetching mailing list messages

Mon, 16 August 2021 11:03

JeanAbouSamra

Karma:

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!)

Current Time: Tue Sep 10 19:12:54 EDT 2024

Total time taken to generate the page: 0.04403 seconds