| sql error when writing listserv integration rule [message #30221] |
Sun, 12 February 2006 01:43  |
Dave Stevens
Messages: 2
Registered: November 2005
Karma: 0
|
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
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]