I have come to find that the user id's associated to posts do not match the original poster's user id. The user id in the post table are 9 greater than the user id in the user table for the user. I have verified this for at least a dozen users. What would have caused this? This is only in my test site at the moment, but I don't want to do the conversion of the live site and have the same issue.
I am not a SQL person. Is it possible to write a query that would match the user name between the user table and the post table and replace the user id in the post table with the user id from the user table?
I am not a SQL person. Is it possible to write a query that would match the user name between the user table and the post table and replace the user id in the post table with the user id from the user table?
Comment