Re: post attachments don't work [message #33404 is a reply to message #33369] |
Wed, 30 August 2006 21:55 |
newnumbertwo
Messages: 38 Registered: June 2004
Karma:
|
Member |
|
|
ilia |
What was the SQL error?
|
I sorted it out. I wasn't quite sure what you meant when you asked me to insert a single entry of ''. for fl_ext (a dot? nothing? space character?) but figured out that entering a space character would do the trick. The SQL error was related to trying to create an entry in the fud26_mime table without a value for fl_ext (obvious as the column had a restraint of NOT NULL in the table definition). Inserting a space as a value did the trick, although I'm all ears (er, eyes) if it should be something else.
That being said, I'm not completely out of the water yet. I've stated before that our install integrates Fud with Mailman mailing lists. While I can make a post via the forum and attach an attachment via the web interface, posts that come in via the mailing list are missing their attachments when they make it to the forum. The attachment does make it to list recipients though. This used to work. I imported over 30,000 messages, attachments included, before we launched the site, but at some point it just stopped working.
I'm not sure what the problem is. Attachments are turned on in the mailing list config in Fud. Here's the mysql log entries for the maillist.php insertion:
1079123 Connect test@localhost on
1079123 Init DB qatestfud
1079123 Query SELECT * FROM fud26_mlist WHERE id=7
1079123 Query SELECT id, forum_opt, message_threshold, (max_attach_size * 1024) AS max_attach_size, max_file_attachments FROM fud26_forum WHERE id=7
1079123 Query SELECT lang, locale FROM fud26_themes WHERE theme_opt=1|2 LIMIT 1
1079123 Query SELECT id FROM fud26_msg WHERE mlist_msg_id='44F60607(dot)9000808(at)test(dot)com'
1079123 Query SELECT id FROM fud26_users WHERE email='test(at)test(dot)com'
1079123 Query SELECT with_str, replace_str FROM fud26_replace WHERE replace_str IS NOT NULL AND with_str IS NOT NULL AND LENGTH(replace_str)>0
1079123 Query LOCK TABLES fud26_fl_7 WRITE
1079123 Query UNLOCK TABLES
1079123 Query INSERT INTO fud26_msg (
1079123 Query INSERT INTO
1079123 Query UPDATE fud26_msg SET thread_id=19650 WHERE id=69694
1079123 Query SELECT
1079123 Query UPDATE fud26_msg SET apr=1 WHERE id=69694
1079123 Query SELECT MAX(id),count(*) FROM fud26_msg WHERE poster_id=2543 AND apr=1
060830 15:41:33 1079123 Query SELECT id FROM fud26_level WHERE post_count <= 332 ORDER BY post_count DESC LIMIT 1
1079123 Query UPDATE fud26_users SET u_last_post_id=69694, posted_msg_count=332, level_id=1 WHERE id=2543
1079123 Query SELECT seq FROM fud26_tv_7 ORDER BY seq DESC LIMIT 1
1079123 Query SELECT fud26_thread.id FROM fud26_tv_7
1079123 Query DELETE FROM fud26_thread WHERE forum_id=7 AND moved_to>0 AND last_post_date<1156714892
1079123 Query LOCK TABLES fud26_tv_7 WRITE
1079123 Query SELECT seq,iss FROM fud26_tv_7 ORDER BY seq DESC LIMIT 1
1079123 Query INSERT INTO fud26_tv_7 (thread_id,iss,seq) VALUES(19650,0,1137)
1079123 Query UNLOCK TABLES
1079123 Query UPDATE fud26_forum SET post_count=post_count+1, thread_count=thread_count+1, last_post_id=69694 WHERE id=7
1079123 Query INSERT IGNORE INTO fud26_search (word) VALUES ('test'),('blah')
1079123 Query INSERT INTO fud26_title_index (word_id, msg_id) SELECT id, 69694 FROM fud26_search WHERE word IN('test','blah')
1079123 Query INSERT INTO fud26_index (word_id, msg_id) SELECT id, 69694 FROM fud26_search WHERE word IN('test','blah')
1079123 Query SELECT u.email
1079123 Query SELECT p.total_votes, p.name AS poll_name, m.reply_to, m.subject, m.id, m.post_stamp, m.poster_id, m.foff, m.length, m.file_id, u.alias, m.attach_cnt, m.attach_cache, m.poll_cache FROM fud26_msg m LEFT JOIN fud26_users u ON m.poster_id=u.id LEFT JOIN fud26_poll p ON m.poll_id=p.id WHERE m.id=69694 AND m.apr=1
1079123 Quit
There's nothing popping up in FUDForum/errors/fud_errors, sql_errors or errors/.mlist. Honestly, I'm not seeing anything attachment related in the SQL log. The version of maillist.php I'm running is 1.63.
Any ideas?
thx
|
|
|