Private messages don't import

[Renada]

Hi,

I've just redone my forum from scratch using 3.6.8.

Impex reports that all the private messages are supposedly imported but they don't show up.

Impex also states that the avatars were all imported but they too don't show up and people are having to re-add them.

I'm not too worried about the avatars but any idea where the private messages are hiding?

Regards,
Renada

[Steve Machol]

<Moved to Import forum>

First, check the database. Are they there? You can also try rebuilding all the user-related counters.

[Renada]

<Moved to Import forum>

First, check the database. Are they there? You can also try rebuilding all the user-related counters.

Hi Steve,

Not entirely sure how to check the database but I had a quick look:

pm = 1,196 records
pmreceipt = 0 records
pmtext = 692 records

Does that help? I've rebuilt the user-related counters several times, it doesn't help.

Regards,
Renada

[Jerry]

Is this a vBulletin to vBulletin import ?

http://www.vbulletin.com/forum/showthread.php?t=161907

[Renada]

Is this a vBulletin to vBulletin import ?

http://www.vbulletin.com/forum/showthread.php?t=161907

• Type of import = Clean. I created a new database, installed vb then used Impex to import settings
• Source board system and version. = 3.6.7
• Target version. = 3.6.8
• Module issue occurred on. = Private messages and avatars
• Any SQL error reported. = none

Regards,
Renada

[Jerry]

Have you dealt with the usergroups ?

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

Is there a reason you can't just upgrade ?

[Renada]

Have you dealt with the usergroups ?

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

Is there a reason you can't just upgrade ?

Hi Jerry,

Yes I've sorted out all the usergroups (just remembered that two members didn't import too).

I started again because I've upgraded and upgraded since 3.06, added hacks, deleted hacks etc. and recently I've had a problem with new users trying to register. This is a sample of the error they receive:

Database error in vBulletin 3.6.7:

Invalid SQL:
INSERT INTO userfield
        (field9, field2, field5, field6, field15, field19, field21, userid)
VALUES
        ('qsqsqs', 'uk', 'United Kingdom', 'Female', 'Rat', 'Amazed', 'Private Message', 122);

MySQL Error  : Duplicate entry '122' for key 1
Error Number : 1062
Date         : Saturday, August 4th 2007 @ 11:58:21 PM
Script       : http://www.mysite.com/community/boards/register.php?do=addmember
Referrer     : http://www.mysite.com/community/boards/register.php?do=register
IP Address   : xxxxxxxxxx
Username     : xxxxxxx
Classname    : vb_database

It appears to be a profile field error but I haven't been able to solve it so decided to create the new database and rebuild from scratch.

If you could solve the above error for me - I've tried turning off all hacks, reuploading all original non-image files etc and nothing has rid me of that error - then I could just carry on with my old database.

Regards,
Renada

[Jerry]

The user table and the userfield table should have the same amount of entries.

i.e. one in the userfield for each user.

By the looks of it, they have gotten out of sync.

What are the results of these SQL statments :

SELECT `userid` FROM `user` ORDER BY userid DESC LIMIT 0,1

SELECT `userid` FROM `userfield` ORDER BY userid DESC LIMIT 0,1

[Renada]

Hi Jerry,

>>What are the results of these SQL statments :<<

SELECT `userid` FROM `user` ORDER BY userid DESC LIMIT 0,1

Result:

122 121 117 116 115 113 112 111 110 100 96 95 94 93 91 90 85 84 83 82

SELECT `userid` FROM `userfield` ORDER BY userid DESC LIMIT 0,1

Result:
212 211 210 209 208 207 206 205 204 203 202 201 200 199 198 197 196 195 194 193

Regards,
Renada

[Renada]

Hi Jerry,

Have you had a chance to look over the results of the queries you asked me to run and is there a cure?

Regards,
Renada

[Jerry]

There should only be one id returned from either SQL statement.

Though it does look like userfield table is 90 entries too high for the user table.

As it's claiming that you have a user id 212 where as your user table is claiming the highest is 112.

Looks like there are way too many entries in the userfield table in the source (hence your error).

Is the origional source the product of an import ?

Have you started a support ticket and asked a member of the support team to check it out ?

[Renada]

There should only be one id returned from either SQL statement.

Though it does look like userfield table is 90 entries too high for the user table.

As it's claiming that you have a user id 212 where as your user table is claiming the highest is 112.

Looks like there are way too many entries in the userfield table in the source (hence your error).

Is the origional source the product of an import ?

Have you started a support ticket and asked a member of the support team to check it out ?

Hi Jerry,

Thanks, I'll open a support ticket and see if anyone can fix this

Regards,
Renada

[Jerry]

Ensure to post a link to this thread as and the history of what happened to your board.