Search Results for 'code'
-
Search Results
-
Topic: Mingle BBpress Import issue
Hi,
We had a custom forum created through a .NET application. Its a legacy application built in 2006.
Now client is migrating to wordpress / bbpress. For forum migration I have created a application to import data from .NET application (Sql Server database) in a format where I can use mingle importer to import.The tables we have created are wp_forum_forums, wp_forum_threads; wp_forum_posts;
Table definition are
CREATE TABLE wp_forum_forums (
id bigint(20) NOT NULL AUTO_INCREMENT,
name varchar(4000) NOT NULL,
parent_id bigint(20) NOT NULL,
description text,
sort int(11) DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=latin1;CREATE TABLE wp_forum_posts (
id bigint(20) NOT NULL AUTO_INCREMENT,
parent_id bigint(20) NOT NULL,
subject varchar(2000) DEFAULT NULL,
author_id bigint(20) unsigned NOT NULL,
text mediumtext,
date datetime NOT NULL,
PRIMARY KEY (id),
KEY fk_wp_forum_posts_wp_forum_threads_idx (parent_id),
KEY fk_wp_forum_posts_wp_user (author_id),
CONSTRAINT fk_wp_forum_posts_wp_forum_threads FOREIGN KEY (parent_id) REFERENCES wp_forum_threads (id),
CONSTRAINT fk_wp_forum_posts_wp_user FOREIGN KEY (author_id) REFERENCES wp_users (ID) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=69731 DEFAULT CHARSET=latin1;CREATE TABLE wp_forum_threads (
id bigint(20) NOT NULL AUTO_INCREMENT,
parent_id bigint(20) NOT NULL,
starter bigint(20) unsigned NOT NULL,
subject varchar(4000) DEFAULT NULL,
status varchar(100) NOT NULL,
date datetime NOT NULL,
last_post datetime NOT NULL,
closed varchar(50) NOT NULL,
PRIMARY KEY (id),
KEY fk_wp_forum_threads_wp_forum_forums_idx (parent_id),
KEY fk_wp_forum_threads_wp_users_idx (starter),
CONSTRAINT fk_wp_forum_threads_wp_forum_forums FOREIGN KEY (parent_id) REFERENCES wp_forum_forums (id),
CONSTRAINT fk_wp_forum_threads_wp_user FOREIGN KEY (starter) REFERENCES wp_users (ID) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=9303 DEFAULT CHARSET=latin1;Through our custom code we populated these tables.
Everything works fine, but while importing the wp_forum_posts (which has got 69K records) the importer hangs between 35600 to 35699. I tried atleast 5 / 6 times but same result every time.
Can you kindly help us in this?
Thanks and Regards
BidhanWhen i create topics from the Dashboard with greek names, the title in the link is sanitized automaticaly, and there is no problem. But when a user creates a topic from the bbpress interface then the link remains in greek and the topic returns a 404 page not found error.
I dont understand if i need to put some code in bb-post.php and bb-edit.php, where and what exactly i should change.Hi All,
I’m having some trouble getting my forum pages to be full width. If I use the shortcode to embed a forum and set my page template to “Full Width”, it works fine. But then if you click another forum topic it goes back to what looks like half width. I have tried copying my full-width.php (twenty fourteen) and calling it bbpress.php and forum.php, but it seems to have no impact. I have also tried adding some CSS, but also seemed to have no impact:
.bbpress-forums .col-2cl .main {
background: none repeat-y right 0;
padding-right: 0px;
}I’m kind of at a loss as to why the forum pages are still not full width, so would appreciate any suggestions. Thanks,
Topic: Error importing SMF forum
Hi there.
When I try to import an existing SMF forum I get the following error:
WordPress database error: [Unknown column 'members.member_name' in 'field list'] SELECT convert(members.id_member USING "utf8") AS id_member,convert(members.passwd USING "utf8") AS passwd,convert(members.member_name USING "utf8") AS member_name,convert(members.email_address USING "utf8") AS email_address,convert(members.website_url USING "utf8") AS website_url,convert(members.date_registered USING "utf8") AS date_registered,convert(members.real_name USING "utf8") AS real_name,convert(members.aim USING "utf8") AS aim,convert(members.yim USING "utf8") AS yim,convert(members.icq USING "utf8") AS icq,convert(members.msn USING "utf8") AS msn,convert(members.signature USING "utf8") AS signature,convert(members.avatar USING "utf8") AS avatar,convert(members.location USING "utf8") AS location,convert(members.personal_text USING "utf8") AS personal_text FROM smf_members AS members LIMIT 0, 100Not sure what I am doing wrong!
