punbb to vBulletin 3.6 (mysql error)

[wowwKorea]

Clean Import
PunBB 1.2.10
vBulletin 3.6
Issue: Users Importing Incorrectly
ImpEx Database errormysql error: Invalid SQL:
SELECT title
FROM profilefield
WHERE title = 'realname'


mysql error: Unknown column 'title' in 'field list'I figured I would post this here since my ticket hasn't been responded to within 12 hours. :(

[Jerry]

This has been fixed in 1.61 and will be released in the next few hours.

[wowwKorea]

Thanks =)

[Jerry]

It's ready.

[framer]

Hi All, HELP

Please see below I tried 1.61 and have a new problem.

This is old problem maybe fixed with 1.61
impex 1.60
Clean import
Source - UBB.classic 6.7 about 4000 users
Target - vBulletin 3.6.0
Module - 003 - Import Users 003.php
Mysql - Server version: 5.0.22
PHP - Version 5.1.4


error shown:
************************************************** ************

ImpEx Database errormysql error: Invalid SQL:
SELECT title
FROM profilefield
WHERE title = 'displayname'


mysql error: Unknown column 'title' in 'field list'

mysql error number: 1054

Date: Sunday 20th 2006f August 2006 07:40:05 PM
Database: forum
MySQL error: Unknown column 'title' in 'field list'

************************************************** ******************
If I run the script I get this as a read out:

Got user Laura and DID NOT imported to the mysql database
Got user Ozglass and DID NOT imported to the mysql database
Got user kevg and DID NOT imported to the mysql database
Got user LifeSaver and DID NOT imported to the mysql database
Got user Bernie and DID NOT imported to the mysql database
Got user scfny and DID NOT imported to the mysql database
Got user Snawt and DID NOT imported to the mysql database

It did that for all users, no users got imported.


I was able on a previous attempt import all the threads and replies +200,000 without a problem but without the users.

The only thing stopping me from completing the import is this one gotta.

Thanks for any help-insight, you-anyone can give...

framer

XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX XXXXXXX
I see that you just released 1.61 tonight. I now have a new problem.
I can't try it out because it now fails at module 001.php, Get paths and alter database.

new error this worked under 1.60

error with impex 1.61
************************************************** **********************************
ImpEx Database errormysql error: Invalid SQL:
SELECT fieldname, vbmandatory, defaultvalue, dictionary
FROM vbfields
WHERE tablename = 'usergroup'
AND product='vbulletin'
ORDER BY vbmandatory


mysql error: Unknown column 'product' in 'where clause'

mysql error number: 1054

Date: Sunday 20th 2006f August 2006 09:00:55 PM
Database: forum
MySQL error: Unknown column 'product' in 'where clause'
************************************************** **************************************

For the record when I hit this I did a clean install of VB with a clean DB I still have a problem with the 1st module.

Thanks again,
framer

[wowwKorea]

I am also having a new problem



Now I'm getting an error on the first module. Before I didn't get an error
'till the part I listed in the previous e-mail.

Here is the new error:

ImpEx Database errormysql error: Invalid SQL:
SELECT fieldname, vbmandatory, defaultvalue, dictionary
FROM vbfields
WHERE tablename = 'usergroup'
AND product='vbulletin'
ORDER BY vbmandatory


mysql error: Unknown column 'product' in 'where clause'

This is in the first module.

[Jerry]

The new vbfields.php file was missing from the build, its there now.

Download ImpEx again and upload and overwrite that file, then delete the ImpEx session and try again.

[framer]

yippee ky aye...

It's slicing and dicing as I type...

Thank for your hard work Jerry and on a Sunday Wow. I expected tomorrow at best.

Now tell the boss you deserve a day off to enjoy.

framer

[Jerry]

Thanks :)

1.62 imports the usergroups and keeps the user association with them now ;)