Userids didn't update in users table

[bostongio]

When I did a recent upgrade and moved my users from ubb.threads to vb, then ran the upgrade scripts for photopost (including the userfix script), it appears the userids in the "users" photopost table didn't get fixed, throwing off some of my user's galleries. The users table is still showing userids from the old forum software. (I'm not clear why photopost even has a users table, since I have forum integration turned on, but apparently it still uses it for some things...?)

What's the easiest way to fix this? I tried running an SQL statement to take the importuserid from the vb users table, but ran into duplicate key errors so it wouldn't run.

Thanks!

[Chuck S]

You can clear the Photopost users table and see if that helps but userfix only updates userid's in the photos and comments tables. The software is not really designed to switch integrations.

[bostongio]

Is the photopost users table used by the program? It appears that it is, so if I clear it, will it just automatically recreate the data it needs anytime a user logs in...?

[Chuck S]

It is used to some degree but not for logins when integrated with an external program. Your userid entries will be redone if it does not exist so should be fine