Geeklog Forums

Is there a way to quickly and easily clean out a bunch of spam posts in the forums? In the regular moderation mode I have to open each post, hit delete, confim, return. I'm looking for a way to select like 100 spam posts at a time and nuke them all (and leave the real posts behind.) Or, maybe search and nuke all by keyword? Any suggestions would be greatly appreciated.

And by the way, I've already "closed the door" and now require users to login in order to post to the forums. Now I just need to cleanup the mess.

If you are using ver 2.5, then you can use the admin->messages screen to select multiple messages and delete at once.

---

Geeklog components by PortalParts -- www.portalparts.com

Ok. I've downloaded 2.5RC1.3_1.3.11.zip and the docs reflect support for GL1.3.11. I'm running GL1.4.0sr5-1. Will this RC run on 1.4?

yes

---

Geeklog components by PortalParts -- www.portalparts.com

Rockin'. Thanks for the fast reply. I'm doing the upgrade now...

Thanks. I have version 2.5 of the forum pluging installed now. But there's something going on with the formatting or css - I get this harsh dark blue background with black letters that's almost unreadable on a couple of the admin tabs.

1. (geeklog)/admin/plugins/forum/index.php - practically unreadable, dark blue background with black letters.

2. (geeklog)/admin/plugins/forum/settings.php - is fine, no problems.

3. (geeklog)/admin/plugins/forum/boards.php - is fine.

4. (geeklog)/admin/plugins/forum/mods.php - is fine.

5. (geekog)/admin/plugins/forum/migrate.php - is fine.

6. (geeklog)/admin/plugins/forum/messages.php - dark blue background, black letters, links are light blue, almost useless.

7. (geeklog)/admin/plugins/forum/ips.php - is fine, no problems.

I neet to change the color scheme for #1 and #6 without messing something else up. What's the best way to do that? Thanks.

Still having problems trying to get a good install with the forums. I'm starting to think the best thing to do is to delete everything and start over with a fresh install.

Sun 20 Aug 2006 16:23:08 EDT - Forum Plugin 2.5 update: Executing SQL => ALTER TABLE gl_forum_settings CHANGE `msgauto` `autorefresh` TINYINT(1) DEFAULT '1' NOT NULL

Sun 20 Aug 2006 16:23:08 EDT - 1054: Unknown column 'msgauto' in 'gl_forum_settings'. SQL in question: ALTER TABLE gl_forum_settings CHANGE `msgauto` `autorefresh` TINYINT(1) DEFAULT '1' NOT NULL

Looks like your trying to run the update when you are already have updated or installed ver2.5

---

Geeklog components by PortalParts -- www.portalparts.com

I still don't think I ever got a good install. On the plugins admin page I still see the following:

forum Data: 2.3.2, Code: 2.5RC1 Update! 1.3.8

Check your error.log after the initial attempt. The sql error you showed is telling me it has already renamed the field.

Scan for this message in the error.log file
Success - Completed Forum plugin version 2.5 update

If there was an error doing the initial update, the errror log file will show the sql that failed. The update can not be backed out so in this case youn will need to compare the required update SQL to your current state and see what needs to be changed.

---

Geeklog components by PortalParts -- www.portalparts.com

Here's the error log from the update;

Mon 14 Aug 2006 20:47:34 EDT - Forum Plugin 2.3 update: Executing Plugin Version
Mon 14 Aug 2006 20:47:34 EDT - Success - Completed Forum plugin version 2.3 update
Mon 14 Aug 2006 20:47:34 EDT - Forum Plugin 2.5 update: Executing SQL => ALTER TABLE gl_forum_settings CHANGE `msgauto` `autorefresh` TINYINT(1) DEFAULT '1' NOT NULL
Mon 14 Aug 2006 20:47:34 EDT - Forum Plugin 2.5 update: Executing SQL => ALTER TABLE gl_forum_settings ADD allow_htmlsig tinyint(1) DEFAULT '0' NOT NULL AFTER allow_notify
Mon 14 Aug 2006 20:47:34 EDT - Forum Plugin 2.5 update: Executing SQL => ALTER TABLE gl_forum_settings ADD allow_userdatefmt tinyint(1) DEFAULT '0' NOT NULL AFTER allow_htmlsig
Mon 14 Aug 2006 20:47:34 EDT - Forum Plugin 2.5 update: Executing SQL => ALTER TABLE gl_forum_settings ADD refresh_delay tinyint(1) DEFAULT '0' NOT NULL AFTER autorefresh
Mon 14 Aug 2006 20:47:34 EDT - Forum Plugin 2.5 update: Executing SQL => ALTER TABLE gl_forum_settings ADD messagesperpage int(4) DEFAULT '20' NOT NULL AFTER postsperpage
Mon 14 Aug 2006 20:47:34 EDT - Forum Plugin 2.5 update: Executing SQL => ALTER TABLE gl_forum_settings ADD searchesperpage int(4) DEFAULT '20' NOT NULL AFTER messagesperpage
Mon 14 Aug 2006 20:47:34 EDT - Forum Plugin 2.5 update: Executing SQL => ALTER TABLE gl_forum_settings ADD popular int(4) DEFAULT '0' NOT NULL AFTER searchesperpage
Mon 14 Aug 2006 20:47:34 EDT - Forum Plugin 2.5 update: Executing SQL => ALTER TABLE gl_forum_settings ADD speedlimit int(1) DEFAULT '60' NOT NULL AFTER popular
Mon 14 Aug 2006 20:47:34 EDT - Forum Plugin 2.5 update: Executing SQL => ALTER TABLE gl_forum_settings ADD use_spamxfilter tinyint(1) DEFAULT '0' NOT NULL AFTER speedlimit
Mon 14 Aug 2006 20:47:34 EDT - Forum Plugin 2.5 update: Executing SQL => ALTER TABLE gl_forum_settings ADD use_smiliesplugin tinyint(1) DEFAULT '0' NOT NULL AFTER use_spamxfilter
Mon 14 Aug 2006 20:47:34 EDT - Forum Plugin 2.5 update: Executing SQL => ALTER TABLE gl_forum_settings ADD use_pmplugin tinyint(1) DEFAULT '0' NOT NULL AFTER use_smiliesplugin
Mon 14 Aug 2006 20:47:34 EDT - Forum Plugin 2.5 update: Executing SQL => ALTER TABLE gl_forum_settings ADD cb_subjectsize tinyint(1) DEFAULT '20' NOT NULL AFTER cb_where
Mon 14 Aug 2006 20:47:34 EDT - Forum Plugin 2.5 update: Executing SQL => ALTER TABLE gl_forum_settings ADD cb_numposts tinyint(1) DEFAULT '5' NOT NULL AFTER cb_subjectsize
Mon 14 Aug 2006 20:47:34 EDT - Forum Plugin 2.5 update: Executing SQL => ALTER TABLE gl_forum_settings ADD sb_subjectsize tinyint(1) DEFAULT '20' NOT NULL AFTER cb_numposts
Mon 14 Aug 2006 20:47:34 EDT - Forum Plugin 2.5 update: Executing SQL => ALTER TABLE gl_forum_settings ADD sb_numposts tinyint(1) DEFAULT '5' NOT NULL AFTER sb_subjectsize
Mon 14 Aug 2006 20:47:34 EDT - Forum Plugin 2.5 update: Executing SQL => ALTER TABLE gl_forum_settings ADD sb_latestposts tinyint(1) DEFAULT '5' NOT NULL AFTER sb_numposts
Mon 14 Aug 2006 20:47:34 EDT - Forum Plugin 2.5 update: Executing SQL => ALTER TABLE gl_forum_settings ADD min_comment_len tinyint(1) DEFAULT '5' NOT NULL AFTER sb_latestposts
Mon 14 Aug 2006 20:47:34 EDT - Forum Plugin 2.5 update: Executing SQL => ALTER TABLE gl_forum_settings ADD min_name_len tinyint(1) DEFAULT '2' NOT NULL AFTER min_comment_len
Mon 14 Aug 2006 20:47:34 EDT - Forum Plugin 2.5 update: Executing SQL => ALTER TABLE gl_forum_settings ADD min_subject_len tinyint(1) DEFAULT '2' NOT NULL AFTER min_name_len
Mon 14 Aug 2006 20:47:34 EDT - Forum Plugin 2.5 update: Executing SQL => ALTER TABLE gl_forum_settings ADD html_newline tinyint(1) DEFAULT '0' NOT NULL AFTER min_subject_len
Mon 14 Aug 2006 20:47:34 EDT - Forum Plugin 2.5 update: Executing SQL => ALTER TABLE gl_forum_settings ADD use_geshi_formatting tinyint(1) DEFAULT '0' NOT NULL AFTER glfilter
Mon 14 Aug 2006 20:47:34 EDT - Forum Plugin 2.5 update: Executing SQL => ALTER TABLE gl_forum_settings ADD edit_timewindow int(11) DEFAULT '300' NOT NULL AFTER speedlimit
Mon 14 Aug 2006 20:47:34 EDT - Forum Plugin 2.5 update: Executing SQL => ALTER TABLE gl_forum_forums ADD is_hidden tinyint(1) DEFAULT '0' NOT NULL AFTER grp_id
Mon 14 Aug 2006 20:47:34 EDT - Forum Plugin 2.5 update: Executing SQL => ALTER TABLE gl_forum_forums ADD is_readonly tinyint(1) DEFAULT '0' NOT NULL AFTER is_hidden
Mon 14 Aug 2006 20:47:35 EDT - Forum Plugin 2.5 update: Executing SQL => ALTER TABLE gl_forum_forums ADD no_newposts tinyint(1) DEFAULT '0' NOT NULL AFTER is_readonly
Mon 14 Aug 2006 20:47:35 EDT - Forum Plugin 2.5 update: Executing SQL => ALTER TABLE gl_forum_moderators ADD mod_uid mediumint( DEFAULT '0' NOT NULL AFTER mod_id
Mon 14 Aug 2006 20:47:35 EDT - Forum Plugin 2.5 update: Executing SQL => ALTER TABLE gl_forum_moderators ADD mod_groupid mediumint( DEFAULT '0' NOT NULL AFTER mod_uid
Mon 14 Aug 2006 20:47:35 EDT - Forum Plugin 2.5 update: Executing SQL => ALTER TABLE gl_forum_userprefs ADD notify_once tinyint(1) DEFAULT '0' NOT NULL AFTER showiframe
Mon 14 Aug 2006 20:47:35 EDT - Forum Plugin 2.5 update: Executing SQL => INSERT INTO gl_blocks (is_enabled,name,type,title,tid,blockorder,onleft,phpblockfn,group_id,owner_id,perm_owner,perm_group,perm_members,perm_anon) VALUES (0, 'forum_menu', 'phpblock', 'Forum Menu', 'all', 0, 1, 'phpblock_forum_menu', 2,2,3,2,2,2)
Mon 14 Aug 2006 20:47:35 EDT - Success - Completed Forum plugin version 2.5 update

I am having the same problem when updating my forum to 2.5

Unknown column 'msgauto' in 'gl_forum_settings'. SQL in question: ALTER TABLE gl_forum_settings CHANGE `msgauto` `autorefresh` TINYINT(1) DEFAULT '1' NOT NULL

If the field 'msgauto' has already been renamed to 'autorefresh' then this sql stmt will fail.

---

Geeklog components by PortalParts -- www.portalparts.com

in my admin-->plugin it is telling me update. Should I just ignore it? or just take out the statement to complete the update?

thanx

You can manually update the plugins record if you want to remove the 'update' notice. If you are running the latest forum code and not noticing any errors, then your fine. The script did not update the plugins record since it had that update sql error which was a result of the field having already been renamed.

---

Geeklog components by PortalParts -- www.portalparts.com