Import Issue - Need Help!!

[Monk707]

I am trying an import from groupee into a clean board.
Version info is:
Infopop Eve 1.2.6 (Forum UBB.x 4.0.3) (http://www.infopop.com/eve_platform/)
Importing to vbulletin 3.5.4

When I start the import everything seemd like it is going to go fine.
001 Check and update database - Works Fine
002 Associate Users - I get the following Error:

There seems to have been a problem with the database.
ImpEx Database errormysql error: Invalid SQL:
SELECT USER_OID, LOGIN
FROM IP_USERS
ORDER BY USER_OID
LIMIT 0,25

mysql error:

mysql error number: 0

Date: Wednesday 24th of May 2006 04:47:24 PM
Database:
MySQL error:

Both the database I am importing from and to are on the same server.
I have looked at the table IP_USERS and don't seem to see anthying wrong with it.

Any ideas??

[Steve Machol]

You can skip the Assoicate Users module. I would try repairing both the databases then try this again.

[Monk707]

Hmmmmm...ok.
I just tried step 3 and got the following erroe"
ImpEx Database errormysql error: Invalid SQL:
SELECT *
FROM IP_USERS
ORDER BY USER_OID
LIMIT 0, 5000


mysql error:

mysql error number: 0

Date: Wednesday 24th of May 2006 06:15:52 PM
Database:
MySQL error:

[Monk707]

I tried repairing both databases first as well.

[Steve Machol]

When MyySQL reports a '0' error, this means there is something wrong with the database, but it doesn't know how to categorize the problem. Unfortunately if repairing doesn't work, then I have no idea what the specific problem is.

Did all the tables report 'ok'?

[Monk707]

Yes all tables reported OK.
Is it possible to send someone SQL dumps?
Or give FTP to the test site??

[Monk707]

The original site is located here:
http://www.ifacollege.com/
Demo site to import into is located here:
http://ifacollege.com.whsites.net/board/index.php

[Steve Machol]

I've never heard of this type or error persisting after repairing the dbs. You should have your host check the server logs to see if they can find any MySQL errors. I really don't know what else to recommend. Sorry.

[Jerry]

You can start a support ticket with a URL to the SQL dump and I'll have a look at it, just ask for Jerry.

[Monk707]

Thanks for the reply. Where can I open a support ticket?
Whats interesting is if I run the sql query using phpmyadmin....I get back the data I should:
SELECT * FROM IP_USERS ORDER BY USER_OID

Seems more like an error in the import software.

Thanks again!!

[Jerry]

Just here :)

http://members.vbulletin.com/membersupport_contactform.php

[completec]

It looks like I'm getting the exact same error, using IPB2.1.6.

Has this issue been resolved?

My other post is at http://www.vbulletin.com/forum/showthread.php?t=189305