I am working on a site that most of the items were created using the default Super Administrator ID of 42.

I was hoping to find a solution where I can go into the database and change author id from 42 to the new user id.

Modifying the database would save lots of time rather than having to open up all the items, change the author, and same them. Plus it would mess with the last modified times.

Any suggestions?

Thanks! -- Steven

Well if what you want is exchange users' IDs, just look for the tabl k2_users, then go to the structure so then you can either edit user by user or open them all together to do various changes at one.

do you have access to phpmyadmin, or something similar? if so:

open phpmyadmin, click on the database name on the left side, click on xxxxx_users, then click the 'search' tab on the top of the right side, enter '42'' in the 'id' box, and click 'go' below (don't change any options) and it should show that user on the page, click edit, then you can change the name, username, email, from there, then click go again, and you should be done

(replace xxxxx with whatever it needs to be for you)