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

Home » FUDforum » FUDforum Installation Issues » post attachments don't work
Show: Today's Messages :: Polls :: Message Navigator
Return to the default flat view Create a new topic Submit Reply
Re: post attachments don't work [message #33404 is a reply to message #33369] Wed, 30 August 2006 21:55 Go to previous messageGo to previous message
newnumbertwo is currently offline  newnumbertwo   United States
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
[Message index]
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Trouble with TestFORUM in new eGroupware install
Next Topic: Error message
Goto Forum:
  

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

Current Time: Sat Nov 30 10:18:58 GMT 2024

Total time taken to generate the page: 0.04813 seconds