Support Forum
I don't have any errors related to the importer in the error log.
It looks like the forum posts from bbpress are stored in the wp_posts table, is that what you would expect?
I'm moving from bbPress 2.5.12. Annoying thing is I don't really have very many posts in it, but would like to save what I do have - I'm not migrating a huge amount of data,
Chris
***
News For Shoppers is seeking consumer reporters,
consumer advocates, and entertainment writers:
visit: NewsForShoppers.com/write/
Apologies for taking so long to get back to you. We were out babysitting out twin 3 year old grandchildren at my son's house when the power suddenly went out and there goes the internet!
Right - the first query that te importer runs against bbPress is basically:
SELECT ID, post_title AS forum_name, post_name AS forum_slug
FROM (the)posts(table) WHERE post_type='forum' AND post_status='publish'
Can you check your posts table to ensure we should find records...?
YELLOW
SWORDFISH
|
On to something here...
Running this in phpmyadmin on my db, I get:
SQL query: [Image Can Not Be Found]
SELECT ID, post_title AS forum_name, post_name AS forum_slug
FROM (the)posts(table) WHERE post_type=’forum’ AND post_status=’publish’
LIMIT 0, 25
MySQL said:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'posts(table) WHERE post_type=’forum’ AND post_status=’publish’
LIMIT 0,' at line 2
The "LIMIT 0, 25" part must be added by phpmyadmin.
Despite what others say, three is a great age 🙂 Fourteen (my daughter, currently) is a lot tougher 🙂
***
News For Shoppers is seeking consumer reporters,
consumer advocates, and entertainment writers:
visit: NewsForShoppers.com/write/
Oh, duh, you meant for me to change "(the)posts(table)", hang on, adjusting that and running again.
***
News For Shoppers is seeking consumer reporters,
consumer advocates, and entertainment writers:
visit: NewsForShoppers.com/write/
Ok, if I run:
SELECT ID, post_title AS forum_name, post_name AS forum_slug
FROM wp_posts WHERE post_type='forum' AND post_status='publish'
I get:
[Image Can Not Be Found] Showing rows 0 - 0 (1 total, Query took 0.0007 seconds.)
and it found the bbpress forum I set up:
ID | forum_name | forum_slug | ||||
---|---|---|---|---|---|---|
46855 | NFS Consumer Help Forum | consumer |
***
News For Shoppers is seeking consumer reporters,
consumer advocates, and entertainment writers:
visit: NewsForShoppers.com/write/
afraid I cannot be much help as to where @yellow-swordfish was going... this indicates that you have 1 forum in bbpress... is that correct?
that query I believe is our query in the importer to get your forums... so it should have found 1...
guessing andy is going to walk through the logic and see where it eventually dies...
Visit Cruise Talk Central and Mr Papa's World
Yep, that's the one. Hopefully he can jump in tomorrow and help get this resolved 🙂Â
***
News For Shoppers is seeking consumer reporters,
consumer advocates, and entertainment writers:
visit: NewsForShoppers.com/write/
Let's take a sideways step for a moment. Would you consider letting me have a copy of the database so that I can do some clinical testing on the importer to try and pin down what is happening? We have done this a couple of times before with much quicker success than trying to diagnose remotely...
YELLOW
SWORDFISH
|
That would be great, thank you! I will send the link to you via pm in just a moment. It's kinda a big db, and like I said not a whole lot to import from bbpress, but I would like to move what I can 🙂
Thanks again!
***
News For Shoppers is seeking consumer reporters,
consumer advocates, and entertainment writers:
visit: NewsForShoppers.com/write/
Just to let you know I am looking at this. Your db is not playing ball at the moment. Normally I can search and replace a few things in the sql file; create a user and get ot working with a Wp install so that I can run an import but everything I have tried so far and with your DB, it wants to run a full WP install! Most odd. But not giving up on it yet 🙂
YELLOW
SWORDFISH
|
1 Guest(s)