shortcode is not working - How-to and Troubleshooting - wpForo 2.0

RE: shortcode is not working

Robert — Tue, 14 Mar 2017 10:41:08 +0000

Please add this line above all SQL and try it again:

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";

Also please read this support topic:

https://wpforo.com/community/faq/topic-add-error-2/

RE: shortcode is not working

gobz004 — Tue, 14 Mar 2017 10:20:19 +0000

why its getting error even i changed

RE: shortcode is not working

gobz004 — Fri, 10 Mar 2017 07:16:54 +0000

i've changed as you said while uploading am getting below error

Table structure for table `adh_wpforo_topics` -- CREATE TABLE IF NOT EXISTS `adh_wpforo_topics` ( `topicid` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `forumid` int(10) unsigned NOT NULL, `first_postid` bigint(20) unsigned NOT NULL DEFAULT '0', `userid` int(10) unsigned NOT NULL, `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `modified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `last_post` bigint(20) unsigned NOT NULL DEFAULT '0', `posts` int(11) NOT NULL DEFAULT '0', `votes` int(11) NOT NULL DEFAULT '0', `answers` int(11) NOT NULL DEFAULT '0', `views` int(10) unsigned NOT NULL DEFAULT '0', `meta_key` text COLLATE utf8mb4_unicode_ci, `meta_desc` text COLLATE utf8mb4_unicode_ci, `type` tinyint(4) NOT NULL DEFAULT '0', `closed` tinyint

MySQL said:

#1067 - Invalid default value for 'created'

RE: shortcode is not working

Robert — Thu, 09 Mar 2017 12:09:24 +0000

It's already explained if you click on text. Before MySQL 5.6 Full-Text Search is supported only with MyISAM Engine. Therefore either change the engine for your table InnoDB to MyISAM or upgrade to 5.6 and use InnoDB Full-Text Search.

Open backup file, replace all InnoDB words to MyISAM, save and import in empty database. Or upgrade your MySQL to 5.6 > .

RE: shortcode is not working

gobz004 — Thu, 09 Mar 2017 12:00:41 +0000

when i was moving my site from localhost to liveserver db getting error because of this plugin

error is

The used table type doesn't support FULLTEXT indexes that table is wp_foro_posts and all wp_foro_*

why its showing like this error.

RE: shortcode is not working

Robert — Mon, 06 Mar 2017 16:47:13 +0000

wpForo shortcodes are only designed for post types. You can't use them in widgets.

shortcode is not working

gobz004 — Mon, 06 Mar 2017 08:43:24 +0000

shortcode is not working on text widget on sidebar.

i would like to show the forum titles with counts in sidebar like browse by forums.

and i want to list only the recent topics with Q&A layout home page , not the forum titles in the home page ?

how to do?