mysql error when importing forums

[Cactus]

When importing the forums I get this mysql error.
I am importing from IPB 2.0.

I tried this solution from another post, but it didn't work.. I don't have a clue what I'm doing :eek:
DELETE FROM vb3_forum WHERE styleid = '65535';
What to do now?

Database error in vBulletin:ImpEx Target 3.0.3:

Invalid SQL:
INSERT INTO vb3_forum
(
styleid, title, options,
displayorder, parentid, importforumid,
importcategoryid, description, replycount,
lastpost, lastposter, lastthread,
lastthreadid, lasticonid, threadcount,
daysprune, newpostemail, newthreademail,
parentlist, password, link, childlist
)
VALUES
(
'',
'The rules',
'89799',
'2',
'65519',
'2',
'3',
'<font color=\"red\">Please read the rules before posting</font>
<br />Some very simple rules and ethics for the Downline4All forums. ',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
'',
''
)

mysql error: Duplicate entry '65535' for key 1

mysql error number: 1062

[Steve Machol]

For some unknown reason your forumid numbers have exceeded the smallint(5) limit of '65535'. I can't imagine how that could have happened.

I would suggest changing the forumin field to INT(10) but (a) you would need to change thius in every table that forumid appear in, and (b) I'm not sure if this will cause unintended problems later on.

Do you have any idea why you have used so many forumind numbers? Have you installed any hacks?

[Cactus]

mmm... I had a guy make a mod, and he also installed it, so that could be the problem.. How can I check if the forumid numbers in IBF isn't declared as smallint(5)

if it is the ibf_forums row, then the id field is smallint(5)
And also where can I find the data of that field it is trying to import..
I have one forum I can delete before importing if the bad ID is there..

[Steve Machol]

The error is in the vB database, not the IBF one. As I said you have used up 65535 forumids. Unless you've added that many forums (including ones you later deleted) then something else caused the forumid number to jump like this.

Fill out a support ticket at:

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

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