Extension talk:WikiForum/Archive

Please report WikiForum bugs on the Bugzilla rather than on this page.

is there a way to Move the WikiForum link out from the Toolbox area —The preceding unsigned comment was added by Lynxcub (talk • contribs) . Please sign your posts with ~~~~!

Not really. If you don't like it, you can always comment out the appropriate $wgHooks line in WikiForum.php. --Jack Phoenix _(Contact) 21:40, 20 May 2011 (UTC)Reply

I'm on godaddy hosting and they do not allow access to their mysql database from outside their network, as i've been told by a representative. I've never had to add tables to a mysql database via the phpMyAdmin interface.

What should i enter for the field name and number of entries in the 'Create new table on database' section? -June 5, 2011 —The preceding unsigned comment was added by 24.140.145.42 (talk • contribs) . Please sign your posts with ~~~~!

You don't need to create a new database. Instead, open phpMyAdmin and go to the existing MediaWiki database. Select the "SQL" tab and paste the queries from wikiforum.sql into that input field, replacing /*_*/ with the value of $wgDBprefix (or if you don't use $wgDBprefix, you can just delete the /*_*/ comment, it doesn't matter) and /*$wgDBTableOptions*/ with the value of $wgDBTableOptions and then press the submit button. --Jack Phoenix _(Contact) 14:31, 8 June 2011 (UTC)Reply

I've gotten the tables installed, but i get this error on the Special:WikiForum page

Database error A database query syntax error has occurred. This may indicate a bug in the software. The last attempted database query was: (SQL query hidden) from within function "WikiForumClass::showOverview". Database returned error "1146: Table 'MYDATABASE.mw_wikiforum_category' doesn't exist (MYDATABASE.db.6835840.hostedresource.com)".

-22:50 EST 6/7/2011 —The preceding unsigned comment was added by 24.140.145.42 (talk • contribs) . Please sign your posts with ~~~~!

Apparently you didn't do it correctly. My guess is that you forgot the $wgDBprefix from the queries. --Jack Phoenix _(Contact) 14:31, 8 June 2011 (UTC)Reply

Maybe? Problem Solved! The tables were improperly named when they were created, and needed to have 'mw_' added to the beginning of each. Seems to be working now. 24.140.145.42 23:01, 9 June 2011 (UTC)Reply

Hi. I'm having this problem too with a MW/ SemanticBundle - It says "A database query syntax error has occurred. This may indicate a bug in the software. The last attempted database query was: (SQL query hidden) from within function "SMWSqlStore2IdCache::getId". Database returned error "1146: Table 'sbundle.smw_ids' doesn't exist (localhost)". Could someone explain (to a newbie) how you solved this problem? Perhaps I need a smw_ on the front of my tables - if so, how do I do this? Its running locally using MAMP at the moment. Yours hopefully, Open Research (talk) 20:56, 9 October 2012 (UTC)Reply

in the original wikiforum there is a link "show list of smiles/icons", which shows the smiles if the ones have been configured. how can i do the same with this wikiforum? --Erithion 08:56, 17 June 2011 (UTC)Reply

You can't, at least not at the moment. WikiForum's smiley support is something that I need to clean up and test; I really want to get rid of that $wgWikiForumSmilies global variable, as it's not a flexible way to configure smilies (since it means that site administrators cannot edit them). --Jack Phoenix _(Contact) 14:08, 30 June 2011 (UTC)Reply

ok, I see. thanks for your reply --Erithion 21:40, 30 June 2011 (UTC)Reply

I've noticed that there's no email notification on any replies, no way to watch the thread etc. Is it something that I missed in config or notifications are just absent indeed? --Erithion 21:57, 30 June 2011 (UTC)Reply

For now, e-mail notifications are indeed absent. --Jack Phoenix _(Contact) 17:32, 19 December 2011 (UTC)Reply

Hello Jack,
are there any news on the email notification?
Your extension is great - but to make a really usable forum we would need some sort of notification...
Thanks!
--Stefahn (talk) 18:17, 3 September 2012 (UTC)Reply

I wish I had, but nope. As much as I hate to admit this, WikiForum is — more or less — bitrotting for the time being. There are some rather annoying bugs that are yet to be fixed (as you can see by just reading this very page), I don't have the time to focus on WikiForum right now due to various other (both online and offline) projects and, in true open source spirit, no-one else seems to have any interest in bugfixing and/or developing the extension, not even the author of the original extension. --Jack Phoenix _(Contact) 21:48, 3 September 2012 (UTC)Reply

Thanks for your quick reply! I understand that you have more important things to do...
Can you maybe recommend another forum solution for MediaWiki that offers notification mails?
I already searched for bridges to common forum softwares such as phpbb but couldn't find any uptodate solution...
--Stefahn (talk) 08:45, 4 September 2012 (UTC)Reply

To the best extent of my knowledge, there really aren't any. That's why I ended up hacking the original WikiForum. In my humble opinion, duplicating efforts is just silly, which is why I'd strongly recommend you to at least try to get some people interested in bugfixing and developing WikiForum further. There is a strong demand for some kind of a discussion thingy inside MediaWiki and LiquidThreads (LQT) hasn't succeeded in its mission.
Therefore I imagine that spreading the word about WikiForum would gather interest and maybe someone with sufficient PHP (& (My)SQL) skills...then again that could just be my wishful thinking. --Jack Phoenix _(Contact) 20:54, 6 September 2012 (UTC)Reply

Thanks for the info. Was LQT supposed to be a forum? I think it is a good tool for discussion pages. I don't understand/know why its development is on hold...
Yes, it would be great if any people extended WikiForum. Unfortunately I only have little PHP skills up2now.
I think I will try to integrate WordPress with MediaWiki. WordPress offers proper forum extensions. Only question is how good the bridge between WordPress and MediaWiki will work...
--Stefahn (talk) 23:21, 6 September 2012 (UTC)Reply

Stefahn, you might check out AWC's Forum extension. It's got the features you're looking for (a few too many features imo). Not as clean as WikiForum, but pretty good. - Lbillett (talk) 03:47, 18 November 2012 (UTC)Reply

Thanks for the hint, Lbillett. I already tried AWC Forum a while ago and wasn't happy with it. Its settings were confusing and it doesn't seem to be maintained... Currently I'm trying to combine MediaWiki and MyBB. If anyone can help regarding a working bridge between MediaWiki and MyBB please help. --Stefahn (talk) 10:50, 18 November 2012 (UTC)Reply

Is there a way to config the <WikiForumList> tag? I need a smaller, unobtrusive output for the main page (i.e. a link with the title and date of the tree newest entries). Thank you in advance! --129.206.90.2 15:18, 14 July 2011 (UTC)Reply

I had to make the following updates create the necessary tables in SQLite 3.7.5 (via the Firefox SQLite Manager extension)

• Change int(10) to INTEGER
• Change AUTO_INCREMENT to AUTOINCREMENT

--74.70.123.165 18:07, 26 August 2011 (UTC)Reply

Hi

We have MW 1.17 installed and we want to use this cool extension. Unfortunately the following error message appears, after we deleted a thread:

Non-string key given

Backtrace:

#0 C:\wrs\www\w\includes\GlobalFunctions.php(781): MessageCache->get(NULL, true, Object(Language))
#1 C:\wrs\www\w\includes\GlobalFunctions.php(902): wfMsgGetKey(NULL, true, Object(Language), false)
#2 C:\wrs\www\w\languages\Language.php(513): wfMsgExt(NULL, Array)
#3 C:\wrs\www\w\languages\Language.php(525): Language->getMessageFromDB(NULL)
#4 C:\wrs\www\w\languages\Language.php(799): Language->getMonthName(false)
#5 C:\wrs\www\w\languages\Language.php(1560): Language->sprintfDate('H:i, j F Y', false)
#6 C:\wrs\www\w\extensions\WikiForum\WikiForumClass.php(1187): Language->timeanddate('2147483647????')
#7 C:\wrs\www\w\extensions\WikiForum\SpecialWikiForum.php(321): WikiForumClass->showOverview()
#8 C:\wrs\www\w\includes\SpecialPage.php(578): WikiForum->execute(NULL)
#9 C:\wrs\www\w\includes\Wiki.php(251): SpecialPage::executePath(Object(Title))
#10 C:\wrs\www\w\includes\Wiki.php(63): MediaWiki->handleSpecialCases(Object(Title), Object(OutputPage), Object(WebRequest))
#11 C:\wrs\www\w\index.php(114): MediaWiki->performRequestForTitle(Object(Title), NULL, Object(OutputPage), Object(User), Object(WebRequest))
#12 {main}

What could be the problem? Thx, Dorian & Erwan --193.247.250.35 10:59, 4 September 2011 (UTC)Reply

Problem resolved by us - this is no issue any more! Dorian & Erwan --91.137.20.132 07:36, 8 September 2011 (UTC)Reply

How do you resolve the problem?? 10:57, 3 November 2011 (UTC)

I analyzed a little bit why this error appears, and I noticed that in WikiForumClass.php the timestamp value of wff_last_post_timestamp was converted in an intval. When I removed that, it worked (see below):

			$row = $dbw->fetchRow( $new );
			// Update the forum table so that the data shown on
			// Special:WikiForum is up to date
			$dbw->update(
				'wikiforum_forums',
				array(
					"wff_reply_count = wff_reply_count - $replyCount",
					'wff_thread_count = wff_thread_count - 1',
					'wff_last_post_user' => intval( $row['wft_last_post_user'] ),
					// 'wff_last_post_timestamp' => intval( $row['wft_last_post_timestamp'] ) // OLD
					'wff_last_post_timestamp' => $row['wft_last_post_timestamp'] // NEW
				),
				array(
					'wff_forum' => intval( $thread->wft_forum )
				),
				__METHOD__
			);

Cheers, Dorian --85.4.133.156 12:39, 26 December 2011 (UTC)Reply

I got the same problem, and when I tried fixing it like above it now just gives me a server error (even after reverting the change). Any ideas? Ajraddatz (Talk) 23:14, 3 March 2013 (UTC)Reply

Prompt how to install please WikiForum having database PostgreSQL if it generally is possible.

Excuse for the bad English. —The preceding unsigned comment was added by 89.179.33.86 (talk • contribs) 

WikiForum doesn't have PostgreSQL support right now, someone needs to write the PostgreSQL schemas first. --Jack Phoenix _(Contact) 21:48, 3 September 2012 (UTC)Reply

My wiki was recently found by a number of spam bots. While there were plugins to stop them from generating lots of spam topics and editing articles, these plugins did not stop them from adding junk topics in the forums. How might I stop this? 164.107.85.71 17:54, 14 September 2011 (UTC)Reply

I beleive that setting

$wgWikiForumAllowAnonymous = false;

in the LocalSettings.php disables annonymous posting, which should bring down spam posts with a user verification system. I cannot confirm this as my forums are 'broken'. Jacobcia 01:04, 10 November 2011 (UTC)Reply

WikiForum currently doesn't support any CAPTCHA methods, such as Extension:ConfirmEdit, but it probably should. Feel free to file a bug ticket on Bugzilla about this. --Jack Phoenix _(Contact) 17:32, 19 December 2011 (UTC)Reply

Adding a new thread I get this error:

Fatal error: Using $this when not in object context in /var/wwwwiki/includes/Linker.php on line 175

Line 175 is: $target = $this->normaliseSpecialPage( $target ); Can some one help me?

I got the same error here, can anybody help? --193.16.163.243 11:27, 7 November 2011 (UTC)Reply

I also have the same problem. I am using mediawiki 1.17. Any suggestions? --87.202.73.87 12:27, 14 November 2011 (UTC)Reply

I believe that I may have located the problem and found a simple solution. The problem is in line 175 of Linker.php : Line 175 is: $target = $this->normaliseSpecialPage( $target ); which is inside public function link of class Linker. That function is called by WikiForumClass.php on line 2349. That part is as follows

		if ( $username ) {
			$retVal = Linker::link(
				Title::newFromText( $wgContLang->getNsText( NS_USER ) . ':' . $username ),
				htmlspecialchars( $username ) // @todo FIXME/CHECKME: double-escaping or not?
			);

From what I understand, that part of the code calls function link of Linker class without creating a Linker instance. Hence the error Using $this when not in object context. I changed the code to

		if ( $username ) {
			$linker = new Linker;
			$retVal = $linker->link(
				Title::newFromText( $wgContLang->getNsText( NS_USER ) . ':' . $username ),
				htmlspecialchars( $username ) // @todo FIXME/CHECKME: double-escaping or not?
			};

This way a new instance of Linker class gets created and its link function is called. So now you do have an object and you are using $this in object context. I haven't tested it fully yet but so far it seems to do the trick. Please try it out give feedback. by sf42--87.202.73.87 12:52, 14 November 2011 (UTC)Reply

Just update your MediaWiki to 1.18.0 and WikiForum to the latest version — the Linker class is static since 1.18. :) --Jack Phoenix _(Contact) 17:32, 19 December 2011 (UTC)Reply

Is there a way to make it so that when users post, create threads, etc, that they could earn points in Extension:SocialProfile? i dont know enough about programming to make it work on my own... --24.140.146.29 00:02, 7 November 2011 (UTC)Reply

Yes, it's possible to add such support into WikiForum. You'd need to add a new column (for example, wikiforum_created_threads) into the user_stats database table, and then in the appropriate part of WikiForum, you'd call SocialProfile's UserStatsTrack class, maybe something like this:

$stats = new UserStatsTrack( /* user ID goes here */ );
$stats->incStatField( 'wikiforum_created_threads' );

Please keep in mind that the above code is somewhat pseudocode and you probably need to do something more to add a new stat into the user_stats table. While it's not exactly trivial, it's possible. --Jack Phoenix _(Contact) 17:32, 19 December 2011 (UTC)Reply

Not sure what I am doing wrong. I have not modified any of the files other than setting the anon variable to false to prevent anonymous creation of threads.

Also looked to report my error on Bugzilla, but there is no listing of WikiForum in the extensions and I don't know where else to post the error I am getting. —The preceding unsigned comment was added by Njhoudini (talk • contribs) . Please sign your posts with ~~~~!

The documentation page is — once again — out of date. WikiForum has required MediaWiki 1.18.0 since r99352 (9 October 2011). The module stuff is related to ResourceLoader, which is a new feature in MediaWiki 1.17+.

It's true that Bugzilla's MediaWiki extension list doesn't have WikiForum (that's because that listing isn't automatically updated, it's manually updated every now and then by the people who have administrative rights to Bugzilla), but you can use the "General/Unknown" component instead. --Jack Phoenix _(Contact) 17:32, 19 December 2011 (UTC)Reply

Hi. Congrats for the extension, it works like a charm :) However I'm a bit worried about security. Are there any security risks that the users of the extension should be aware of? (ie XSS in post replies or similar possible attacks)? How does wikiForum extension deal with wikis having $rawHTML enabled? In my case I've been able to post html code during my testing, and immediately wondered if that could be exploited by malicious users. (just to let you know, I do not allow anonymous users posting on the forum) Thanks in advance. —The preceding unsigned comment was added by 195.235.9.98 (talk • contribs) 

Enabling $wgRawHtml on a publicly editable wiki is asking for your wiki to get cracked. WikiForum uses MediaWiki's standard parsing functions and it should have no security issues. If you do find security issues in WikiForum, please report them on the MediaWiki Bugzilla (Enter a new bug → pick "Security" as the product). --Jack Phoenix _(Contact) 21:48, 3 September 2012 (UTC)Reply

FYI: bug 33676: 'searchbox' collides with the Inputbox 'searchbox'. SPQRobin 00:19, 12 January 2012 (UTC)Reply

This was fixed in r115138. --Jack Phoenix _(Contact) 21:48, 3 September 2012 (UTC)Reply

I think it should have external images support.

--Zoglun (talk) 21:28, 1 March 2012 (UTC)Reply

It should, depending on the values of $wgAllowExternalImages and $wgAllowExternalImagesFrom. --Jack Phoenix _(Contact) 21:48, 3 September 2012 (UTC)Reply

I install wikiforum, and add my user to "forum administrator". But in Special:WikiForum page, cant add new forum; i see normal user page. Whats wrong? (Mediawiki 1.17.3, WikiForum (verzió: 1.2.2-SW) (r115615) ) --Mkepler (talk) 16:39, 18 July 2012 (UTC)Reply

But! Add manually record to wikiforum_category, everything is fine.--195.228.124.2 06:25, 19 July 2012 (UTC)Reply

I dont understand, how did you fix this? I have the same problem, i am forum admin but cannot figure out how to add places to post in the Special:WikiForum page. Crazy Jake88 (talk) 16:52, 27 August 2012 (UTC)Reply

Hi, congrats to the wonderful extension. Is it possible that a registered user can write in the forum without editing the normal wiki pages?

Thanks in advance —The preceding unsigned comment was added by 141.99.224.112 (talk • contribs) 

Probably not possible right now. --Jack Phoenix _(Contact) 21:48, 3 September 2012 (UTC)Reply

Hi, is it possible that anonymous users can leave a name? Otherwise it is difficult to differ between different anonymous users. —The preceding unsigned comment was added by 141.99.224.112 (talk • contribs) 

Not really, unfortunately. This is a bug that should be fixed. --Jack Phoenix _(Contact) 21:48, 3 September 2012 (UTC)Reply

Hey, first of all - Great Job! The forum works perfectly, except:

When a user posts a reply to a topic, it will add to the topic's post counter ; however, when a user finds a small, spelling mistake and edits one's post to change it, the action will also add to the post counter and in result the actual value of the counter will be misleading. Maybe the solution is somewhat trivial for you, as person with expert knowledge in coding, but I have merely covered the basics so far (:. Thanks in advance! 78.88.254.118 11:13, 15 September 2012 (UTC)Reply

$messages['it'] = array( 'wikiforum-desc' => 'Estensione [[Special:WikiForum|Forum]] per MediaWiki', 'wikiforum' => 'Forum di Discussione', // Configuration variables -- do not translate! 'wikiforum-day-definition-new' => '3', 'wikiforum-max-threads-per-page' => '20', 'wikiforum-max-replies-per-page' => '10', 'wikiforum-anonymous' => 'Anonimo', 'wikiforum-announcement-only-description' => 'Forum di Annunci (solo i moderatori possono aggiungere discussioni)', 'wikiforum-by' => '$1<br />da $2', 'wikiforum-description' => 'Descrizione:', 'wikiforum-forum-is-empty' => 'Il forum è vuoto. Prego contattare un amministratore che possa aggiungere categorie e forum.', 'wikiforum-forum-name' => 'Forum $1', 'wikiforum-name' => 'Nome:', 'wikiforum-button-preview' => 'Anteprima', 'wikiforum-preview' => 'Anteprima', 'wikiforum-preview-with-title' => 'Anteprima: $1', 'wikiforum-save' => 'Salva', 'wikiforum-error-search' => 'Errore di ricerca', 'wikiforum-error-search-missing-query' => 'Devi inserire un termine per la ricerca!', 'wikiforum-search-hits' => 'Trovato {{PLURAL:$1|una voce|$1 voci}}', 'wikiforum-search-thread' => 'Discussione: $1', 'wikiforum-thread-deleted' => 'discussione cancellata', 'wikiforum-topic-name' => 'Forum - $1', 'wikiforum-updates' => 'Forum aggiornato di recente', 'wikiforum-write-thread' => 'Nuova Discussione', 'wikiforum-replies' => 'Risposte', 'wikiforum-views' => 'Visite', 'wikiforum-thread' => 'Discussione', 'wikiforum-threads' => 'Discussioni', 'wikiforum-latest-reply' => 'Ultima Risposta', 'wikiforum-latest-thread' => 'Ultima Discussione', 'wikiforum-forum' => 'Forum: $1 > $2', 'wikiforum-overview' => 'Overview', 'wikiforum-pages' => 'Pagine:', 'wikiforum-thread-closed' => 'Discussione Chiusa', 'wikiforum-new-thread' => 'Nuova discussione', 'wikiforum-edit-thread' => 'Modifica discussione', 'wikiforum-delete-thread' => 'Cancella discussione', 'wikiforum-close-thread' => 'Chiude discussione', 'wikiforum-reopen-thread' => 'Riapri discussione', 'wikiforum-write-reply' => 'Rispondi', 'wikiforum-edit-reply' => 'Modifica Risposta', 'wikiforum-delete-reply' => 'Cancella Risposta', 'wikiforum-save-thread' => 'Salva discussione', 'wikiforum-save-reply' => 'Salva risposta', 'wikiforum-thread-title' => 'Titolo della discussione', 'wikiforum-no-threads' => 'Nessuna discussione3 disponibile.', 'wikiforum-posted' => 'Inviato il $1 da $2', 'wikiforum-edited' => 'Modificato il $1 da $2', 'wikiforum-closed-text' => 'La discussione è stata chiusa il $1 da $2', 'wikiforum-cat-not-found' => 'Categoria non trovata', 'wikiforum-cat-not-found-text' => 'La categoria non esiste - torna a $1', 'wikiforum-forum-not-found' => 'Forum non trovato', 'wikiforum-forum-not-found-text' => 'Il Forum non esiste - torna a $1', 'wikiforum-thread-not-found' => 'Discussione non trovata', 'wikiforum-thread-not-found-text' => 'La Discussione non esiste o è stata cancellata - torna a $1.', 'wikiforum-error-thread-reopen' => 'Errore di risposta alla discussione', 'wikiforum-error-thread-close' => 'Errore di chiusura discussione', 'wikiforum-error-general' => 'Oggetto non trovato o non hai i permessi per eseguire questa azione.', 'wikiforum-error-no-rights' => 'Non hai i permessi per eseguire questa azione.', 'wikiforum-error-not-found' => 'Oggetto non trovato.', 'wikiforum-error-no-text-or-title' => 'Titolo o testo non inseriti.', 'wikiforum-error-no-reply' => 'Manca risposta.', 'wikiforum-error-double-post' => 'Protezione da doppio click discussione già aggiunta.', // @todo FIXME: better wording 'wikiforum-error-thread-closed' => 'La discussione è chiusa. Non si possono aggiungere rispote.', 'wikiforum-error-delete' => 'Errore di cancellazione', 'wikiforum-error-sticky' => 'Errore di cambio attributi', 'wikiforum-error-move-thread' => 'Errore di spostamento discussione', 'wikiforum-error-add' => 'Errore di inserimento', 'wikiforum-error-edit' => 'Errore di modifica', 'wikiforum-add-category' => 'Aggiungi Categoria', 'wikiforum-edit-category' => 'Modifica Categoria', 'wikiforum-delete-category' => 'Cancella categoria', 'wikiforum-add-forum' => 'Aggiungi forum', 'wikiforum-edit-forum' => 'Modifica forum', 'wikiforum-delete-forum' => 'Cancella forum', 'wikiforum-sort-up' => 'ordine crescente', 'wikiforum-sort-down' => 'ordine decrescente', 'wikiforum-remove-sticky' => 'Togli Importante', 'wikiforum-make-sticky' => 'Rendi Importante', 'wikiforum-move-thread' => 'Sposta Discussione', 'wikiforum-paste-thread' => 'Incolla Discussione', 'wikiforum-quote' => 'Quota', // For Special:ListGroupRights 'right-wikiforum-admin' => 'Aggiungi, modifica e cancella categorie sul [[Special:WikiForum|Forum di Discussione]]', 'right-wikiforum-moderator' => 'Modifica e cancella discussioni sul [[Special:WikiForum|Forum di Discussione]]', // Forum admin group, as per discussion with Jedimca0 on 30 December 2010 'group-forumadmin' => 'Amministratori Forum', 'group-forumadmin-member' => 'Amministratore Forum', 'grouppage-forumadmin' => '{{ns:project}}:Amministratori Forum', );

Can someone please explain the group permissions to me? There is just a massive dropdown list.--60.241.141.102 23:38, 19 February 2013 (UTC)Reply

if needed, create the tables manually with these sqlite statements

CREATE TABLE wikiforum_category ( wfc_category INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, wfc_category_name varchar(50) NOT NULL, wfc_sortkey mediumint(5) NOT NULL DEFAULT '9', wfc_added_timestamp binary(14) NOT NULL DEFAULT , wfc_added_user INTEGER NOT NULL DEFAULT '0', wfc_edited INTEGER NOT NULL DEFAULT '0', wfc_edited_user INTEGER NOT NULL DEFAULT '0', wfc_deleted INTEGER NOT NULL DEFAULT '0', wfc_deleted_user INTEGER NOT NULL DEFAULT '0' ); COMMIT

CREATE TABLE wikiforum_forums ( wff_forum INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, wff_forum_name varchar(50) NOT NULL, wff_description varchar(255) NOT NULL, wff_category INTERGER NOT NULL, wff_sortkey mediumint(5) NOT NULL DEFAULT '9', wff_thread_count INTEGER NOT NULL DEFAULT '0', wff_reply_count INTEGER NOT NULL DEFAULT '0', wff_last_post_user INTEGER NOT NULL DEFAULT '0', wff_last_post_timestamp binary(14) NOT NULL DEFAULT , wff_added_timestamp binary(14) NOT NULL DEFAULT , wff_added_user INTEGER NOT NULL DEFAULT '0', wff_edited_timestamp binary(14) NOT NULL DEFAULT , wff_edited_user INTEGER NOT NULL DEFAULT '0', wff_deleted INTEGER NOT NULL DEFAULT '0', wff_deleted_user INTEGER NOT NULL DEFAULT '0', wff_announcement tinyint(2) NOT NULL DEFAULT '0' ); COMMIT

CREATE TABLE wikiforum_threads ( wft_thread INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, wft_thread_name varchar(255) NOT NULL, wft_text text NOT NULL, wft_sticky tinyint(1) NOT NULL DEFAULT '0', wft_posted_timestamp binary(14) NOT NULL DEFAULT , wft_user INTEGER NOT NULL DEFAULT '0', wft_deleted INTEGER NOT NULL DEFAULT '0', wft_deleted_user INTEGER NOT NULL DEFAULT '0', wft_edit_timestamp binary(14) NOT NULL DEFAULT , wft_edit_user INTEGER NOT NULL DEFAULT '0', wft_closed INTEGER NOT NULL DEFAULT '0', wft_closed_user INTEGER NOT NULL DEFAULT '0', wft_forum INTEGER NOT NULL DEFAULT '0', wft_reply_count INTEGER NOT NULL DEFAULT '0', wft_view_count INTEGER NOT NULL DEFAULT '0', wft_last_post_user INTEGER NOT NULL DEFAULT '0', wft_last_post_timestamp binary(14) NOT NULL DEFAULT ); COMMIT

CREATE TABLE wikiforum_replies ( wfr_reply_id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, wfr_reply_text text NOT NULL, wfr_posted_timestamp binary(14) NOT NULL DEFAULT , wfr_user INTEGER NOT NULL DEFAULT '0', wfr_deleted INTEGER NOT NULL DEFAULT '0', wfr_deleted_user INTEGER NOT NULL DEFAULT '0', wfr_edit_timestamp binary(14) NOT NULL DEFAULT , wfr_edit_user INTEGER NOT NULL DEFAULT '0', wfr_thread INTEGER NOT NULL ); COMMIT

Similar to an error listed above, though I tried the fix listed under that, and didn't seem to change anything.

Non-string key given
Backtrace:
#0 /var/www/wiki/includes/Message.php(641): MessageCache->get(NULL, true, Object(Language))
#1 /var/www/wiki/includes/Message.php(413): Message->fetchMessage()
#2 /var/www/wiki/includes/Message.php(476): Message->toString()
#3 /var/www/wiki/languages/Language.php(803): Message->text()
#4 /var/www/wiki/languages/Language.php(822): Language->getMessageFromDB(NULL)
#5 /var/www/wiki/languages/Language.php(1080): Language->getMonthName(false)
#6 /var/www/wiki/languages/Language.php(1949): Language->sprintfDate('H:i, j F Y', false)
#7 /var/www/wiki/extensions/WikiForum/WikiForumClass.php(1194): Language->timeanddate('2147483647????')
#8 /var/www/wiki/extensions/WikiForum/SpecialWikiForum.php(326): WikiForumClass->showOverview()
#9 /var/www/wiki/includes/SpecialPage.php(611): WikiForum->execute(NULL)
#10 /var/www/wiki/includes/SpecialPageFactory.php(494): SpecialPage->run(NULL)
#11 /var/www/wiki/includes/Wiki.php(290): SpecialPageFactory::executePath(Object(Title), Object(RequestContext))
#12 /var/www/wiki/includes/Wiki.php(536): MediaWiki->performRequest()
#13 /var/www/wiki/includes/Wiki.php(446): MediaWiki->main()
#14 /var/www/wiki/index.php(73): MediaWiki->run()
#15 {main}

Visible here and here. The odd thing is, this error only appears in two of six wikis in a farm, yet they all share the same installation of WikiForum, and the same configurations in LocalSettings.php. For wikis that these do work on, see here, here, here, and here. --GeorgeBarnick (talk) 00:24, 5 May 2013 (UTC)Reply

It's not a PHP problem directly, but rather caused by the deletion of a post or topic (I already forgot which). The timestamp handling is seriously messed up (see, for example, #7 of your backtrace — the current year is 2013, not 2147 and WF should treat timestamps the same way the rest of MediaWiki does, but it unfortunately doesn't do that).

Long story short, it's a bug, a known and a rather fatal one, sadly. I'd encourage you to either disable WikiForum for the time being, or better yet, help in fixing this (and other) bug(s)! WikiForum has more or less been abandonware for almost a year (my last edit to the extension page was in August 2012); as a result, the code has known, outstanding bugs to be fixed and the extension page — somewhat erroneously — claims that the extension is stable; stability is what we want, but currently it's pretty unstable.

It's free and open source software, your help is very much wanted, needed and appreciated. :-) --Jack Phoenix _(Contact) 13:55, 6 May 2013 (UTC)Reply

This is a fix that worked:

UPDATE `wikidb`.`wiki_wikiforum_threads` SET `wft_posted_timestamp` = '20130513173321',`wft_last_post_timestamp` = '20130513173321';

UPDATE `wikidb`.`wiki_wikiforum_forums` SET `wff_last_post_timestamp` = '20130513173321',`wff_added_timestamp` = '20130513173321',`wff_edited_timestamp` = '20130513173321'

The date was stored in epoch time when using the WikiForum/original and the current version does not deal with that. Go ahead and write some code to go in and convert every entry to the correct value; this fix above worked for our needs and demonstrates the issue.

Perhaps a silly question, but when I press on the "move thread" button at the bottom of a thread, it takes me to the Special:Wikiforum page. From here I navigate to the forum that I want the thread to move to but there aren't any buttons that allows me to place it in that forum. What should I be doing exactly? I'm using WikiForum (Version 1.2-SW) on MW 1.18.2.

Create the following tables:

Note: Make sure to append the schema name before the table.

CREATE TABLE wikiforum_category (
   wfc_category SERIAL PRIMARY KEY,
   wfc_category_name VARCHAR(50) NOT NULL,
   wfc_sortkey INTEGER NOT NULL DEFAULT 9,
   wfc_added_timestamp bytea NOT NULL DEFAULT ,
   wfc_added_user INTEGER NOT NULL DEFAULT 0,
   wfc_edited INTEGER NOT NULL DEFAULT 0,
   wfc_edited_user INTEGER NOT NULL DEFAULT 0,
   wfc_deleted INTEGER NOT NULL DEFAULT 0,
   wfc_deleted_user INTEGER NOT NULL DEFAULT 0
);

CREATE TABLE wikiforum_forums (
   wff_forum SERIAL PRIMARY KEY,
   wff_forum_name VARCHAR(50) NOT NULL,
   wff_description VARCHAR(255) NOT NULL,
   wff_category INTEGER NOT NULL,
   wff_sortkey INTEGER NOT NULL DEFAULT 9,
   wff_thread_count INTEGER NOT NULL DEFAULT 0,
   wff_reply_count INTEGER NOT NULL DEFAULT 0,
   wff_last_post_user INTEGER NOT NULL DEFAULT 0,
   wff_last_post_timestamp bytea NOT NULL DEFAULT ,
   wff_added_timestamp BYTEA NOT NULL DEFAULT ,
   wff_added_user INTEGER NOT NULL DEFAULT 0,
   wff_edited_timestamp bytea NOT NULL DEFAULT ,
   wff_edited_user INTEGER NOT NULL DEFAULT 0,
   wff_deleted INTEGER NOT NULL DEFAULT 0,
   wff_deleted_user INTEGER NOT NULL DEFAULT 0,
   wff_announcement SMALLINT NOT NULL DEFAULT 0
);

CREATE TABLE wikiforum_threads (
   wft_thread SERIAL NOT NULL PRIMARY KEY,
   wft_thread_name VARCHAR(255) NOT NULL,
   wft_text TEXT NOT NULL,
   wft_sticky SMALLINT NOT NULL DEFAULT 0,
   wft_posted_timestamp BIGINT NOT NULL DEFAULT '20130513173321',
   wft_user INTEGER NOT NULL DEFAULT 0,
   wft_deleted INTEGER NOT NULL DEFAULT 0,
   wft_deleted_user INTEGER NOT NULL DEFAULT 0,
   wft_edit_timestamp bytea NOT NULL DEFAULT ,
   wft_edit_user INTEGER NOT NULL DEFAULT 0,
   wft_closed INTEGER NOT NULL DEFAULT 0,
   wft_closed_user INTEGER NOT NULL DEFAULT 0,
   wft_forum INTEGER NOT NULL DEFAULT 0,
   wft_reply_count INTEGER NOT NULL DEFAULT 0,
   wft_view_count INTEGER NOT NULL DEFAULT 0,
   wft_last_post_user INTEGER NOT NULL DEFAULT 0,
   wft_last_post_timestamp bytea NOT NULL DEFAULT 
);

CREATE TABLE wikiforum_replies (
   wfr_reply_id SERIAL NOT NULL PRIMARY KEY,
   wfr_reply_text TEXT NOT NULL,
   wfr_posted_timestamp BIGINT NOT NULL DEFAULT '20130513173321',
   wfr_user INTEGER NOT NULL DEFAULT 0,
   wfr_deleted INTEGER NOT NULL DEFAULT 0,
   wfr_deleted_user INTEGER NOT NULL DEFAULT 0,
   wfr_edit_timestamp bytea NOT NULL DEFAULT ,
   wfr_edit_user INTEGER NOT NULL DEFAULT 0,
   wfr_thread INTEGER NOT NULL
);

Cheers. Let me know in case of any queries. Will be happy to answer.