Problems importing IPB 2.0

[synax]

I am getting the following mysql error on 005 Import Forum:

The mysql db is about 10.5megs. I have backed up and restored from the server it was on to ours after trying a server to server import where I got the error at the same place. Any input would be greatly appreciated.

Database error in vBulletin:ImpEx Target 3.0.7:

Invalid SQL:
INSERT INTO forum
(
styleid, title, description,
options, daysprune, displayorder,
parentid, importforumid, importcategoryid
)
VALUES
(
'',
'California',
'',
'89795',
'30',
'7',
'-1',
'0',
'15'
)

mysql error: Duplicate entry '65535' for key 1

mysql error number: 1062

Date: Wednesday 27th of July 2005 12:40:55 PM
Script: http://forums.naes.cc/impex/index.php
Referer: http://forums.naes.cc/impex/index.php
Username: administrator
IP Address: 69.41.132.242

[Jerry]

This is caused by the index running out of room.

What was the state of your board before the import or do you have over 65535 forums ? :eek:

[synax]

I am not very familiar with buliten boards in general, looking at the SQL Toolbox on IPB, it shows 414 next to forums, so I am assuming there are 414 forums on this IPB install.

Under System overview it shows,
Total Unique Topics: 1280
Total Replies to Topics: 1753
Total Members: 809

[synax]

Don't know if this will cause issues or not but the IPB is installed on a server with Mysql 4.1.8-Standard and vBulletin is installed on a server with cPanel and Mysql 4.0.24-standard. When i did the mysql dump from the server running 4.1.8 I used the mysqldump --opt -Q -u --compatible=mysql40 xxxx_xxxx -p xxxx_xxxx > /home/xxxx/xxxx/xxxx.sql hoping that that would work. But as I said in the previous post, its giving me the same error wether I try to import from the backup on my server or a import from a server to server transfer.

[Jerry]

I can see an issue with the size of the board or your mysqldump.

Are you importing into a fresh vBulletin install ?

[synax]

Yes, just installed.

[Jerry]

Can you check your forum table in the vBulletin database and see how many entries there are ?

[synax]

Three entries

Forumid 1, 2 and 65535

[Jerry]

Then there must be an issue with the auto_inc column as the next forumid should of been 3.

What happens if you delete all the entries in that table and run the module ?

[synax]

Okay, that worked for a little bit now I am getting this error:

Looks like 65478 entries: Showing rows 0 - 29 (65478 total

Database error in vBulletin:ImpEx Target 3.0.7:

Invalid SQL:
INSERT INTO forum
(
styleid, title, options,
displayorder, parentid, importforumid,
importcategoryid, description, replycount,
lastpost, lastposter, lastthread,
lastthreadid, lasticonid, threadcount,
daysprune, newpostemail, newthreademail,
parentlist, password, link, childlist
)
VALUES
(
'',
'Interrogatories',
'89799',
'64',
'65383',
'200',
'306',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
''
)

mysql error: Duplicate entry '65535' for key 1

mysql error number: 1062

Date: Wednesday 27th of July 2005 03:06:45 PM
Script: http://forums.naes.cc/impex/index.php
Referer: http://forums.naes.cc/impex/index.php
Username: administrator
IP Address: 69.41.132.242

[Jerry]

Ok, then your forum table is full for some reason, when you are importing is it just constantly refreshing on the import forum page with the same forums untill it crashes ?

[synax]

Yes, thats what it was doing, then it crashed.

[Jerry]

Ok, clean out the database, start again.

When it asks for how many forums per page put in 500, so it dose them all in one page and see what happens ?

[synax]

New Error:


Database error in vBulletin:ImpEx Target 3.0.7:

Invalid SQL: UPDATE forum SET parentid= WHERE forumid =732
mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE forumid =732' at line 1

mysql error number: 1064

Date: Wednesday 27th of July 2005 03:48:37 PM
Script: http://forums.naes.cc/impex/index.php
Referer: http://forums.naes.cc/impex/index.php
Username: administrator
IP Address: 69.41.132.242

[Jerry]

What exact version are you importing from and what hacks do you have ?

[synax]

No hacks, just basic forum usage.

Here is the info from the IPB Server:

PHP VERSION: 4.3.10 (apache), SQL: (MYSQL) 4.1.8-standard
IPB Version v2.0.4 (ID: 20014)

[Jerry]

Ok then this must be a bug or an impex issue as it should work with that.

Can you start a support ticket in the members area and ask for me so i can sort it out, cheers.