Support Forum

Importer says "Sorry, you are not allowed to access this page."

57 Answers

New Answer

MP Mr Papa
Mr Papa
Member

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… 

CA Chris_Andrews
Chris_Andrews
Member

Yep, that’s the one. Hopefully he can jump in tomorrow and help get this resolved 🙂 

YS Yellow Swordfish
Yellow Swordfish
Member

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…

CA Chris_Andrews
Chris_Andrews
Member

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! 

YS Yellow Swordfish
Yellow Swordfish
Member

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 🙂

CA Chris_Andrews
Chris_Andrews
Member

Thank you, I don’t know what would be causing that. I have transferred my files and db to a test site about a week ago and it did not require a reinstall. 

However, it is an old site that has been messed with and messed with over time. Nothing unusual has been done to the db though.

Chris

CA Chris_Andrews
Chris_Andrews
Member

Oh, dammit, this issue was another plugin conflict. I’m not sure which one, but after deactivating everything it looks like it’s loading up the simplepress tables. I had not thought to deactivate everything and try it. After I got the importer admin panel up, I thought I had gotten past the conflicts. 

Darn, sorry I had you spend time on this and then got it myself – still testing to make sure it’s working now though,

 

Chris

CA Chris_Andrews
Chris_Andrews
Member

Arrgh, ok, well at least it’s telling me it’s failing now…

———–

User/Member Data Created for Members 1 – 100

User/Member Data Created for Members 101 – 200

User/Member Data Created for Members 201 – 300

User/Member Data Created for Members 301 – 400

User/Member Data Created for Members 401 – 500

User/Member Data Created for Members 501 – 600

User/Member Data Created for Members 601 – 700

User/Member Data Created for Members 701 – 800

User/Member Data Created for Members 801 – 900

User/Member Data Created for Members 901 – 1000

User/Member Data Created for Members 1001 – 1100

User/Member Data Created for Members 1101 – 1200

User/Member Data Created for Members 1201 – 1300

User/Member Data Created for Members 1301 – 1400

User/Member Data Created for Members 1401 – 1500

User/Member Data Created for Members 1501 – 1600

User/Member Data Created for Members 1601 – 1700

User/Member Data Created for Members 1701 – 1800

User/Member Data Created for Members 1801 – 1900

Forum Group Forum Group Created

Members Post Counts Updated

IMPORTED:
   1865 Users
   1 Groups
   0 Forums
   0 Topics
   0 Posts

IMPORT FAILURES:
   Creation of Forum: Failed

YS Yellow Swordfish
Yellow Swordfish
Member

Just wanted to say that I have made a successful import on my test site. I plan to send you a slightly more up to date version of the importer . I will attach it to a post here. I just want to make a couple more test runs to make sure…

YS Yellow Swordfish
Yellow Swordfish
Member

I am attaching an updated copy of the importer to this post. This is actually a newer version that is about t be released. It uses the newer and more secure/preferred mysqli php library. WordPress has supported this for quite some time now and with the arrival of php7 the old mysql library is removed.

So you will need the mysqli library but it would be most unusual for you not to have it.

I have run several tests using your database and successfully imported the records into SP so – over to you and I hope it works for you too.

CA Chris_Andrews
Chris_Andrews
Member

smile  smile  smile  smile  smile

Whew – thank you, that did the trick!

YS Yellow Swordfish
Yellow Swordfish
Member

Yes – great news. Sorry it took so long. There were a couple of errors n the code which makes you wonder why it has worked for so many other people!

I want to thank you for allowing us to use your database for testing. It really is the only way to ensure things are running as they should. Rest assured now you have confirmed success I will delete the DB from my local machine.