PDA

View Full Version : import not working


allenmur
Tue 28th Feb '06, 8:31pm
i have config my file so it looks like this

# The following settings allow ImpEx to connect to the vBulletin 3
# database into which you will be importing data.
# If impex is installed in vBulletin you can ignore the target details
# as includes/config.php
$impexconfig['target']['databasetype'] = 'mysql';
$impexconfig['target']['server'] = 'localhost';
$impexconfig['target']['user'] = 'allenmur_allen';
$impexconfig['target']['password'] = 'password';
$impexconfig['target']['database'] = 'allenmur_VB';
$impexconfig['target']['tableprefix'] = '';

# If the system that is being imported from uses a database,
# enter the details for it here and set 'sourceexists' to TRUE.
# If the source data is NOT stored in a database, set 'sourceexists' to FALSE
$impexconfig['sourceexists'] = TRUE;
# mysql / mssql
$impexconfig['source']['databasetype'] = 'mysql';
$impexconfig['source']['server'] = 'localhost';
$impexconfig['source']['user'] = 'allenmur_allen';
$impexconfig['source']['password'] = 'password';
$impexconfig['source']['database'] = 'allenmur_Ipod';
$impexconfig['source']['tableprefix'] = '';

# Error logging will log import errors to a database table impexerror
# for use with support.
# Language file is the file of phrases to be used, default is english.
# pagespeed is the second(s) wait before the page refreshes.
$impexconfig['system']['errorlogging'] = true;
$impexconfig['system']['language'] = 'impex/impex_language.php';
$impexconfig['system']['pagespeed'] = 1;

*note the username and passords are not that this is a example lol when i add my username to access it i get to a blank page with this

Database cleanup & restart ||| Online manual

nothing else i uploaded everything and i did get the other menu but i had wrong username in so i corrected it now i get just the blank page with that at the top?

Jerry
Tue 28th Feb '06, 8:36pm
Which OS ? Which web server ? Have you deleted the system folders you don't need ?

allenmur
Tue 28th Feb '06, 8:46pm
Which OS ? Which web server ? Have you deleted the system folders you don't need ?

i have manged to get the option back but it still does not work i get the error msg

ImpEx Database errormysql error: Invalid SQL:
SELECT ID_MEMBER, memberName
FROM members
ORDER BY ID_MEMBER
LIMIT 0,25
mysql error: Table 'allenmur_Ipod.members' doesn't exist
mysql error number: 1146
Date: Wednesday 01st of March 2006 12:44:34 AM
Database: allenmur_Ipod
MySQL error: Table 'allenmur_Ipod.members' doesn't exist

i aint sure if its because i have SMF 1.1 RC2 but it just aint working!

allenmur
Tue 28th Feb '06, 9:09pm
i just thought i did convert from phpbb - smf would this be a problem?

Jerry
Tue 28th Feb '06, 9:33pm
i just thought i did convert from phpbb - smf would this be a problem?

I don't understand what you are asking.

Your error is because you don't have the correct table prefix, that's why all your tables were read on the first page.

allenmur
Wed 1st Mar '06, 8:14am
I don't understand what you are asking.

Your error is because you don't have the correct table prefix, that's why all your tables were read on the first page.

what info do i put in for the prefix tables then?

i was not sure what the error was.

Jerry
Wed 1st Mar '06, 6:49pm
what info do i put in for the prefix tables then?

i was not sure what the error was.

You put in what ever the source board's table prefix is, the details on 001 will tell you what it most likely is.

allenmur
Thu 2nd Mar '06, 9:12am
right i have got it working but i am not sure on 1 thing i dont know what th put in here?

"Put the exsisting vbulletin user id next to the eve user that you wish to associate them with"

Jerry
Thu 2nd Mar '06, 5:34pm
right i have got it working but i am not sure on 1 thing i dont know what th put in here?

"Put the exsisting vbulletin user id next to the eve user that you wish to associate them with"

Only use this if have to manual associate users, 99.99% of the time you can skip this module, if its a fresh import defiantly skip it.