[wp-hackers] GUID problem

[Lynne Pope]

Hi all,
The GUID *should* be unique within a blog - right? Well, I have a problem
and am hoping someone has ideas on how to solve it (apart from manually
modifying the GUID field).

I am currently working on a blog that has been using WordPress for the past
5 years. It contains over 1,000 posts. Over that time, the blog has had
several changes, including domain names, and the merger of other blogs into
this one. The GUID has five different domain names, including localhost, but
that isn't the issue (they can be easily changed with a couple of SQL
queries). The problem is, the unique identifying number isn't unique. ?p=57
occurs multiple times, for example.

They want this fixed, and also want to use the GUID as a short URL on their
new site, which makes it imperative that the GUID really is a unique
identifier.

Has anyone come across this before? Does anyone know of a way in which to
renumber the GUID's so they are unique and correctly incremental?
I'd appreciate any advice you can offer.

Thanks,

Lynne Pope