Support Forum

Invalid database query error and can't create forum

18 Answers

New Answer

YS Yellow Swordfish
Yellow Swordfish
Member

Well that is good news and gives me something specific to look for. Thanks.

Looks like InnoDB it is so I need to run some test installs by the look of it!

Here is the other table create SQL:

CREATE TABLE `wp_sftopics` (
`topic_id` bigint(20) NOT NULL AUTO_INCREMENT,
`topic_name` varchar(200) NOT NULL,
`topic_date` datetime NOT NULL,
`topic_status` int(4) NOT NULL DEFAULT '0',
`forum_id` bigint(20) NOT NULL,
`user_id` bigint(20) unsigned DEFAULT NULL,
`topic_pinned` smallint(1) NOT NULL DEFAULT '0',
`topic_opened` bigint(20) NOT NULL DEFAULT '0',
`topic_slug` varchar(200) NOT NULL,
`post_id` bigint(20) DEFAULT NULL,
`post_count` mediumint(8) DEFAULT '0',
`post_id_held` bigint(20) DEFAULT NULL,
`post_count_held` mediumint(8) DEFAULT '0',
PRIMARY KEY (`topic_id`),
KEY `forum_id_idx` (`forum_id`),
KEY `topic_slug_idx` (`topic_slug`),
KEY `user_id_idx` (`user_id`),
KEY `post_id_idx` (`post_id`)
);

hopefully will not cause any problem either…

DO dogsday
dogsday
Member

Great! That worked too.

I’ll go and have a play with the configuration now and see if I can create any fora.

I have a few test domains all running WP with the same configuration on that host. Happy to help with testing if needed.

Cheers
DD

DO dogsday
dogsday
Member

Just to close off the other point about the front end database error. That is also now resolved after manually creating those two tables.

The rest of the configuration options look straightforward enough for someone used to managing a forum 😉

Thanks for your help to get to this point. It’s much appreciated.

Kind regards
DD

YS Yellow Swordfish
Yellow Swordfish
Member

And I have opened a bug report on the install. It is clearly an InnoDB Engine issue…
Hope it all goes well from now on.