PHPbb inport, not going well at all.

SouthDevonFishing · Sep 28, 2012

I am currently trying to import the data from my PHPbb install. I so far have made the old forum inaccessible with a error message and cant get past the configure importer stage. Instant disaster to be honest.

MySQL Server. I have to use anglingukorg.fatcowmysql.com as localhost does nothing.
My SQL port. I have no idea.
My SQL username. Is it the same one I used to upload XF?
Password. Think I have that one.
My SQL Database Name. The name for the folder in My SQL for the phpbb install?
Table Prefix. No idea.

Can anyone help me past this stage please?

Adam Howard · Sep 28, 2012

MySQL Server: localhost

You could also try, 127.0.0.1

MySQL Port: Keep as is (most host do not change this, but you may need to contact your host)

MySQL username: This may vary, but typically for most shared accounts who use cPanel or Direct Admin it will be ACCOUNT_MySQL-NAME You should be able to find this in cPanel or Direct Admin. If you have neither, contact your host.

You should find this in the config file for phpBB

Password: You should be able to find that in the config file. In fact, most everything can be found in the config file for phpBB

My SQL Database Name: Check the config file for phpBB

Chris D · Sep 28, 2012

Yeah, quick answer is to find your PHPBB config file.

This form is asking you to fill in the details of your PHPBB database connection.

That will contain all of the above details.

It will look something like this:

The details in red are relevant to the XenForo import.

Rich (BB code):

<?php
// phpBB 3.0.x auto-generated configuration file
// Do not change anything in this file!
$dbms = 'mysql';
$dbhost = 'localhost';
$dbport = '';
$dbname = 'your_db_name';
$dbuser = 'your_db_username';
$dbpasswd = 'your_db_password';
 
$table_prefix = 'phpbb3_';
$acm_type = 'file';
$load_extensions = '';
 
@define('PHPBB_INSTALLED', true);
// @define('DEBUG', true);
// @define('DEBUG_EXTRA', true);
?>

SouthDevonFishing · Sep 28, 2012

Obviously, as per the past, I am struggling. I haven't even got off the ground with this one. If I go into my file manager, there are three config files relative to my phpbb install. I called the folder for the install /forum. Anyway, I digress. There are three files in the config folder,
Config.php which has a 404 error if I open it
config txt which contains nothing like your example
index html which takes me to my website.

I think I have all the right info except the table prefix. Thinking is probably my downfall though

Adam Howard · Sep 28, 2012

SouthDevonFishing said:
Obviously, as per the past, I am struggling. I haven't even got off the ground with this one. If I go into my file manager, there are three config files relative to my phpbb install. I called the folder for the install /forum. Anyway, I digress. There are three files in the config folder,
Config.php which has a 404 error if I open it
config txt which contains nothing like your example
index html which takes me to my website.

I think I have all the right info except the table prefix. Thinking is probably my downfall though

log into phpMyAdmin (found inside your control panel of cPanel or Direct Admin)

Go to the database

You should notice a lot of tables which start with

X_users
X_post
X_thread
x_profiles

The X value is the prefix. If there is no value and its all just

users
post
threads
profiles

There is no prefix and you can leave that blank.

404 error? ........ You need to have FTP access and download the file.

SouthDevonFishing · Sep 29, 2012

Sorry for being a pain but I am slowly getting somewhere I think...
So I have been on to Fatcow (My host) and they have provided some details and you guys have done the rest to get me this far...

Obviously the password I know now.
So I run that (with the password in) and then get this...

I think this means I need to change the path on the custom avatar bit?
This could be a mission as I have looked for anything relating to avatars and so far drawn a blank.

Adam Howard · Sep 29, 2012

SouthDevonFishing said:
Sorry for being a pain but I am slowly getting somewhere I think...
So I have been on to Fatcow (My host) and they have provided some details and you guys have done the rest to get me this far...
View attachment 34801
Obviously the password I know now.
So I run that (with the password in) and then get this...
View attachment 34802
I think this means I need to change the path on the custom avatar bit?
This could be a mission as I have looked for anything relating to avatars and so far drawn a blank.

You may need to put the full server path into that. Some setups are a little more picky.

Adam Howard · Sep 29, 2012

Another thought....

Make sure that your attachments and avatars in phpBB are all 777 (folder, sub folder, and files) for the import.

melbo · Sep 29, 2012

I forget but does he need a / before those paths?
/images/avatars/upload
/files

Adam Howard · Sep 29, 2012

melbo said:
I forget but does he need a / before those paths?
/images/avatars/upload
/files

Most often, yes.

I say most often because I recall 2 web host who wouldn't work with / add (go figure as to why)

Jake Bunce · Sep 29, 2012

Yeah do a full server path.

SouthDevonFishing · Sep 29, 2012

I kind of abandoned the mission last night. I was getting more frustrated by the minute. So I have looked at it again this morning and still cant get any further.
I have tried just about everything in my capabilities to get pretty much nowhere. My lack of knowledge and understanding obviously is not helpful here but I do try.
Surely it can't be this hard? I have spent 4 hours to get as far as I have

I am guessing a bit here but is that the server path? I have looked about for a description but there is not a definitive answer.
I have even given up on the avatars thing and read in a another thread that if I create an empty file and point it to that it will effectively bypass the avatars bit but not for me!
I am seriously lost/out of my depth/losing the battle here!

Jake Bunce · Sep 29, 2012

That looks like the web path, not the server path. Visit admin.php?tools/phpinfo and search the page for "DOCUMENT_ROOT". That will reveal the full server path.

SouthDevonFishing · Sep 29, 2012

Ok. I have gone back to the the acp for Fatcow, which is where I think all the stuff I need is?
I have gone... ACP>My SQL database>Acces Myphp database and resulted in the following...

No where on there is the option for images or avatars and the php side of things is a list of instruction containing many words/phrases that I have no idea of the meaning.

SouthDevonFishing · Sep 29, 2012

OK. I found the answer in the 'Server Information' folder... Now a new error to work on

SouthDevonFishing · Sep 29, 2012

Dealing with this now...

Admin Control Panel - SouthDevonFishing
Server Error

Mysqli statement execute error : Duplicate entry '12' for key 1

Zend_Db_Statement_Mysqli->_execute() in Zend/Db/Statement.php at line 297
Zend_Db_Statement->execute() in Zend/Db/Adapter/Abstract.php at line 479
Zend_Db_Adapter_Abstract->query() in Zend/Db/Adapter/Abstract.php at line 574
Zend_Db_Adapter_Abstract->insert() in XenForo/DataWriter.php at line 1591
XenForo_DataWriter->_insert() in XenForo/DataWriter.php at line 1580
XenForo_DataWriter->_save() in XenForo/DataWriter.php at line 1381
XenForo_DataWriter->save() in XenForo/Model/Import.php at line 580
XenForo_Model_Import->_importData() in XenForo/Model/Import.php at line 1478
XenForo_Model_Import->importThread() in XenForo/Importer/PhpBb3.php at line 1791
XenForo_Importer_PhpBb3->stepThreads() in XenForo/Importer/Abstract.php at line 77
XenForo_Importer_Abstract->runStep() in XenForo/ControllerAdmin/Import.php at line 180
XenForo_ControllerAdmin_Import->_runStep() in XenForo/ControllerAdmin/Import.php at line 232
XenForo_ControllerAdmin_Import->_startStep() in XenForo/ControllerAdmin/Import.php at line 175
XenForo_ControllerAdmin_Import->actionStartStep() in XenForo/FrontController.php at line 310
XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 132
XenForo_FrontController->run() in /hermes/waloraweb013/b1293/moo.anglingukorg/xenforo/admin.php at line 13

Jake Bunce · Sep 29, 2012

That error usually means you selected the checkbox to preserve the source ids during the import, but your database isn't "empty". You can only preserve source ids on a brand new XF install (no extra users, threads, groups, etc), otherwise you will get duplicate entry errors.

SouthDevonFishing · Sep 29, 2012

So I should start again without checking the box? I thought that was needed to keep the id's relative to the threads/posts. If I start again, what will happen to the data already transferred?

SouthDevonFishing · Sep 29, 2012

There were no threads, nodes or anything on the XF database. I had deleted all that beforehand. The only user in there is one I created to have access to the ACP but it is a username/email that isn't registered on the old PHPbb install.

Jake Bunce · Sep 29, 2012

You would start over. Reinstall the XF database by emptying data and internal_data, then run /install again in your browser.

Preserving the same ids isn't necessary for redirects. See this post for instructions:

http://xenforo.com/community/threads/phpbb-import-url-redirect.32123/#post-366972

PHPbb inport, not going well at all.

Member

Well-known member

XenForo developer

Member

Well-known member

Member

Well-known member

Well-known member

Well-known member

Well-known member

Well-known member

Member

Well-known member

Member

Member

Member

Well-known member

Member

Member

Well-known member

Similar threads

We value your privacy