Support Forum

Advanced Search
Forum Scope


Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
plugins-topic
Importer says "Sorry, you are not allowed to access this page."
Avatar
Chris_Andrews
Member
sp_UserOfflineSmall Offline
Apr 4, 2017 - 10:57 am

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/

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Apr 4, 2017 - 4:53 pm

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...?

andy-signature.png
YELLOW
SWORDFISH
Avatar
Chris_Andrews
Member
sp_UserOfflineSmall Offline
Apr 4, 2017 - 6:22 pm

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/

Avatar
Chris_Andrews
Member
sp_UserOfflineSmall Offline
Apr 4, 2017 - 6:29 pm

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/

Avatar
Chris_Andrews
Member
sp_UserOfflineSmall Offline
Apr 4, 2017 - 6:33 pm

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/

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Apr 4, 2017 - 9:04 pm

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... 

Avatar
Chris_Andrews
Member
sp_UserOfflineSmall Offline
Apr 4, 2017 - 9:18 pm

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/

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Apr 5, 2017 - 3:42 am

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...

andy-signature.png
YELLOW
SWORDFISH
Avatar
Chris_Andrews
Member
sp_UserOfflineSmall Offline
Apr 5, 2017 - 9:24 am

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/

Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
Apr 5, 2017 - 3:08 pm

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 🙂

andy-signature.png
YELLOW
SWORDFISH
Forum Timezone: Europe/Stockholm
Most Users Ever Online: 1170
Currently Online:
Guest(s) 1
Currently Browsing this Page:
1 Guest(s)
Top Posters:
Mr Papa: 19448
Ike: 2086
Brandon: 864
kvr28: 804
jim: 650
FidoSysop: 577
Conrad_Farlow: 531
fiddlerman: 358
Stefano Prete: 325
Member Stats:
Guest Posters: 617
Members: 17359
Moderators: 0
Admins: 4
Forum Stats:
Groups: 7
Forums: 17
Topics: 10125
Posts: 79620