Mistoffeles wrote: Having a little problem with my phpbb ater installing this mod, when I try to add a forum it generates this error:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Couldn't insert row in forums table
DEBUG MODE
SQL Error : 1136 Column count doesn't match value count at row 1
INSERT INTO phpbb_forums (forum_id, forum_name, cat_id, forum_desc, forum_order, forum_status, prune_enable, auth_view, auth_read, auth_post, auth_reply, auth_edit, auth_delete, auth_sticky, auth_announce, auth_vote, auth_pollcreate) VALUES ('20', '2007', 2, 'Discussion of the 2007 tournament and announcements from the organizers. ', 30, 0, 0, 0, 0, 0, 0, 1, 1, 3, 3, 1, 1, 0, allow_spam_words)
Line : 412
File : admin_forums.php
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
As you can see, the fields added to the "values" part of the SQL statement have not been added to the list of fields to be inserted.
Joe Belmaati wrote:Mistoffeles wrote:Having a little problem with my phpbb ater installing this mod, when I try to add a forum it generates this error:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Couldn't insert row in forums table
DEBUG MODE
SQL Error : 1136 Column count doesn't match value count at row 1
INSERT INTO phpbb_forums (forum_id, forum_name, cat_id, forum_desc, forum_order, forum_status, prune_enable, auth_view, auth_read, auth_post, auth_reply, auth_edit, auth_delete, auth_sticky, auth_announce, auth_vote, auth_pollcreate) VALUES ('20', '2007', 2, 'Discussion of the 2007 tournament and announcements from the organizers. ', 30, 0, 0, 0, 0, 0, 0, 1, 1, 3, 3, 1, 1, 0, allow_spam_words)
Line : 412
File : admin_forums.php
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
As you can see, the fields added to the "values" part of the SQL statement have not been added to the list of fields to be inserted.
You have edited the line wrongly. Please go over the installation for that edit one more time (allow_spam_words) is not supposed to be inside the VALUES parenthesis.
Joe Belmaati wrote:No, but you can do that with the word censor that comes standard with phpBB.nims wrote:Hi looks like a great MOD. Can we replace urls and email addresses in the posts using this MOD. If yes how ?
Thanks
Mistoffeles wrote: As you can see if you read the entire original error, there are three more fields in your version of the admin_forums.php file on lines 408 and 409, so your suggestion regarding one single field being moved out of the parenthesis would not only not account for the three fields, but also create an invalid SQL statement.
Code: Select all
, auth_pollcreate, allow_spam_word)
Hi,mrrobbit wrote: Joe, thanks for the update, it certainly getting better.
I have a couple of suggestions for the next version if possible?
1. In the log listing, would it be possible to have an option to add logged words and user names to the banned words/users list?
2. Be able to export/import the spam word lists so we can share them with everyone?
Thanks
Joe Belmaati wrote:Hi,mrrobbit wrote:Joe, thanks for the update, it certainly getting better.
I have a couple of suggestions for the next version if possible?
1. In the log listing, would it be possible to have an option to add logged words and user names to the banned words/users list?
2. Be able to export/import the spam word lists so we can share them with everyone?
Thanks
the next version has a mass import feature. (It is currently in validation and will hopefully be available sometime soon).
Logged words are already in the words list (otherwise they wouldn't be logged - that is if I'm understanding you correctly). .
clawed wrote: On a side note I would like to create a mod like this but use a bayesian filter (PHP bayesian filter) and have 2 bottons on every post that only moderators only see "spam" and "not spam" and automatically move spam posts to a certain section of the forum (that only moderators can see). Has anyone tried anything like this? does anyone want to help me?