Importing from IPB 2.1.3 TO 3.5.2

[rixthemix]

I get this error on module 002

[B]Warning[/B]: mysql_query(): supplied argument is not a valid MySQL-Link resource in [B]/impex/db_mysql.php[/B] on line [B]247  [/B]
 
[B]There seems to have been a problem with the database.[/B]
 
ImpEx Database errormysql error: Invalid SQL: 
   SELECT id, name
   FROM members
   ORDER BY id
   LIMIT 0,25
mysql error: 
mysql error number: 0
Date: Wednesday 04th of January 2006 11:29:34 AM

Can anyone help me on this please

[rixthemix]

still sat here waiting for support

[Boxy]

This is generally caused by having the wrong source db info in your ImpExConfig.php correct. Recheck these details and make sure that
$impexconfig['sourceexists'] = true; and if your source database has a table prefix this is entered correctly too.

[rixthemix]

I've checked that and reistalled the forum twice - impex works fine up until that point and i get the same error - i maybe a brunette but i think im blonde moment - i know most of the basic which isn't bad for a lady !!

[Boxy]

Can you paste what you have in impexconfig file here?

[rixthemix]

<?php
#################################################################### |;
# vBulletin - Licence Number 
# ---------------------------------------------------------------- # |;
# Copyright ©2000–2006 Jelsoft Enterprises Ltd. All Rights Reserved. |;
# This file may not be redistributed in whole or significant part. # |;
# ---------------- VBULLETIN IS NOT FREE SOFTWARE ---------------- # |;
# [URL="http://www.vbulletin.com/"]http://www.vbulletin.com[/URL] | [URL="http://www.vbulletin.com/license.html"]http://www.vbulletin.com/license.html[/URL] # |;
#################################################################### |;
# 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'] = 'stloader_admin';
$impexconfig['target']['password'] = '********';
$impexconfig['target']['database'] = 'stloader_forum';
$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'] = 'stloader_admin';
$impexconfig['source']['password'] = '********';
$impexconfig['source']['database'] = 'stloader_forum';
$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;
?>

[Boxy]

The source and target databases are the same. The source database needs to be the name of your IPB database and the target will be the new vBulletin database name.

[rixthemix]

tried that, still the smae error

[Boxy]

Can you fill out a support ticket at:
http://www.vbulletin.com/members/me...contactform.php so I can take a look at what is going on.

Be sure to include the login info to your Admin CP, phpMyAdmin and FTP.

[rixthemix]

sent a ticket for your attention Boxy !!

Thanks

[Boxy]

As far as I can see the only thing that was wrong was that you had the source and target details mixed up. I've replied to your ticket with what the values should be.

[rixthemix]

sent you a reply back - it didnt work

[Dreamchaser]

did you include the prefix of your ipb, this is very very important, as without it the impex won't work, try using ibf_ or what ever you database prefix of IPB is ! I am sure you will have some luck here.

Thanks,
DC

[Dreamchaser]

by default its "ibf_" !

[rixthemix]

cheers - sorted it