Gossamer Forum
Home : Products : Gossamer Forum : Discussion :

Possbile bug with archive.pl

Quote Reply
Possbile bug with archive.pl
I'm having a problem using the mail archive script to archive a mailing list into Gossamer Threads. Here is what happens:

Code:
bash-2.05a$ /var/www/systems2/lib/perl/Plugins/GForum/archive.pl --forum=10 --pop-host=somehost.foo.com --pop-user=user --pop-pass=password


names: post_message,post_latest_poster,post_father_id,post_subject,post_email_id,post_time,forum_id_fk,post_root_id,post_depth,user_id_fk,post_latest_reply,post_style,post_username,post_ip,post_sticky,post_deleted,post_has_attachments,post_unique_id,post_replies,post_keep, values: ?,?,?,?,?,?,?,?,?,?,?,?,?,?,'0','0','0','0','0','0',
names: post_views,post_thread_views,post_id_fk, values: ?,?,?,
names: post_message,post_latest_poster,post_father_id,post_subject,post_email_id,post_time,forum_id_fk,post_root_id,post_depth,user_id_fk,post_latest_reply,post_style,post_username,post_ip,post_sticky,post_deleted,post_has_attachments,post_unique_id,post_replies,post_keep, values: ?,?,?,?,?,?,?,?,?,?,?,?,?,?,'0','0','0','0','0','0',
Plugins::GForum::MailArc (3048): Error: Failed to execute query: 'INSERT INTO gforum_Post (post_message,post_latest_poster,post_father_id,post_subject,post_email_id,post_time,forum_id_fk,post_root_id,post_depth,user_id_fk,post_latest_reply,post_style,post_username,post_ip,post_sticky,post_deleted,post_has_attachments,post_unique_id,post_replies,post_keep,post_id) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,'0','0','0','0','0','0',NEXTVAL('gforum_Post_seq'))' Reason: ERROR: value too long for type character varying(50) at /var/www/systems2/lib/perl/Plugins/GForum/archive.pl line 25.

bash-2.05a$


Is it because the forum is just too large (1732 posts in 1129 threads)? Is there something else going on?
--jaga

Subject Author Views Date
Post Possbile bug with archive.pl jaga 2336 Oct 6, 2004, 8:09 AM