FUDforum: FUDforum Installation Issues » sql error when writing listserv integration rule

Home » FUDforum » FUDforum Installation Issues » sql error when writing listserv integration rule

Show: Today's Messages :: Polls :: Message Navigator

sql error when writing listserv integration rule [message #30221]

Sun, 12 February 2006 01:43

Dave Stevens

Messages: 2
Registered: November 2005

Karma:

Junior Member

I'm integrating a mailing list into a forum and when I attempt to write the rule in the admin panel, the following is returned and the process dies, not adding the rule.

Quote:

(/var/www/forumdata/include/theme/default/db.inc:73
/var/www/forumdata/include/theme/default/db.inc:177
/var/www/forumdata/include/mlist.inc:76
/var/www/forum/adm/admmlist.php:41
) 1136: Column count doesn't match value count at row 1
Query: INSERT INTO fud26_mlist( forum_id, name, mlist_opt, subject_regex_haystack, subject_regex_needle, body_regex_haystack, body_regex_needle, additional_headers ) VALUES( 3, 'THEATRE-SOUND(at)LISTSERV(dot)AOL(dot)COM', 72, '', '', '', '', '', '' )
_POST: array ( 'S' => '0d3643c9d03fbd32a5712ef8562a8a69', 'SQ' => 'e827135f4f615111c195b50bd20ab7ca', 'ml_name' => 'THEATRE-SOUND(at)LISTSERV(dot)AOL(dot)COM', 'ml_forum_id' => '3', 'ml_mlist_post_apr' => '0', 'ml_allow_frm_post' => '0', 'ml_frm_post_apr' => '0', 'ml_allow_mlist_attch' => '8', 'ml_allow_mlist_html' => '0', 'ml_complex_reply_match' => '0', 'ml_create_users' => '64', 'ml_skip_non_forum_users' => '0', 'ml_subject_regex_haystack' => '', 'ml_subject_regex_haystack_opt' => '', 'ml_subject_regex_needle' => '', 'ml_body_regex_haystack' => '', 'ml_body_regex_haystack_opt' => '', 'ml_body_regex_needle' => '', 'ml_additional_headers' => '', 'ml_custom_sig' => '', 'ml_submit' => 'Add Mailing List Rule', 'edit' => '', )
Server Version: 3.23.58
[Referring Page] http://forum.roaddog.com/adm/admmlist.php?S=0d3643c9d03fbd32a5712ef8562a8a6 9&SQ=e827135f4f615111c195b50bd20ab7ca

I dumped the database, dropped it and restored it and still the same error. Forum files unlocked in the admin panel prior to running the script.

TIA
Dave

Report message to a moderator

[Message index]

		sql error when writing listserv integration rule By: Dave Stevens on Sun, 12 February 2006 01:43
		Re: sql error when writing listserv integration rule By: Ilia on Sun, 12 February 2006 19:07
		Re: sql error when writing listserv integration rule By: Dave Stevens on Sun, 12 February 2006 21:04
		Re: sql error when writing listserv integration rule By: mischa on Fri, 17 February 2006 19:27
		Re: sql error when writing listserv integration rule By: Ilia on Fri, 17 February 2006 19:56
		Re: sql error when writing listserv integration rule By: mischa on Fri, 17 February 2006 21:10

Previous Topic:	rose cant validate
Next Topic:	Mailing list integration problem

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 07:31:32 GMT 2024

Total time taken to generate the page: 0.05926 seconds