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.