forum import

[hed]

Hello! (I need your fast help)
When I try to import forums from vB 3.7.3 to vB 3.7.4 I receive such error:

ImpEx Database errormysql error: Invalid SQL: 
                    INSERT INTO body_build26forum
                    (
                        styleid, title, options,
                        displayorder, parentid, importforumid,
                        importcategoryid, description, replycount,
                        lastpost, lastposter, lastthread,
                        lastthreadid, lasticonid, threadcount,
                        daysprune, newpostemail, newthreademail,
                        parentlist, password, link, childlist,
                        title_clean, description_clean,
                        showprivate, lastpostid, defaultsortfield,
                        defaultsortorder
                    )
                    VALUES
                    (
                        '',
                        'Main Category',
                        86017,
                        '1',
                        '-1',
                        '1',
                        '0',
                        'Main Category Description',
                        '0',
                        '0',
                        '',
                        '',
                        '0',
                        '0',
                        '0',
                        '-1',
                        '',
                        '',
                        ',',
                        '',
                        '',
                        '',
                        'Main Category',
                        'Main Category Description',
                        '',
                        '',
                        '',
                        ''
                    )
                

mysql error: Duplicate entry '32767' for key 1

mysql error number: 1062

Date: Tuesday 31st 2009f March 2009 10:44:36 PM
Database: body_build26
MySQL error:

Where is a problem?

[Lats]

I haven't used impex, but the number 32767 in an error usually suggests the field is not big enough to hold the number.

Jerry will know for sure though

[hed]

ok thanks, but how to fix it? I tried to use this:

http://www.vbulletin.com/docs/html/mysql_duplicatekey

But it doesn't work.

[Steve Machol]

It looks like you maxed out on the number of forums you can create (all forumids are not reused).

To fix this you would have to change every 'forumid' field in the database from smallint(5) to int(10).

[Jerry]

There must be a massive amount of forums in there, or impex got stuck in a loop on forums and filled up the forum table.

I'd investigate what's going on with the table.

[hed]

To fix this you would have to change every 'forumid' field in the database from smallint(5) to int(10).

It has helped me. Thanks Steve!

[Steve Machol]

You can't get the exact same error if you made that change to all those fields. What is the exact error?