missing posts

Hi

We are running Nuke version 7.7 and have recently changed servers, however we now have the problem that some of the old posts are missing. To try and rectify this;

in MYSQL I ran the following query;

SELECT * FROM nuke_bbposts
WHERE poster_id = "-1" ;

giving;

poster_id username
-1 Sparky
-1 andymac
-1 andymac
-1 Old Bird
-1 andymac

although the table is over 200 rows in length.

The users who have posted over the history of the current database but who no longer exist have been set to -1 when from what I understand should have been set to 1.

To fix this I ran the following;

UPDATE nuke_bbposts
SET poster_id = '1'
WHERE poster_id = '-1'

still to no avail.

Any ideas would be greatly appreciated so that I am able to restore the missing posts.

Dean

i belive every user needs a different user id, which then needs to match settings, groups and posts.

__________________
www.MonsterCoding.com - Website Programming and Development Services

Correct.

i mixed in a CMS i wrote with phpbb, and if anything gets out of line i generally just let the user account or post go to pot because its such a pain to fix.

__________________
www.MonsterCoding.com - Website Programming and Development Services

If that's how you work, then frankly, I think you're beyond help.

What I do not understand is how the posts were viewable with the previous host but are no longer so. All we have done is transfer the site from one server to another.

Dean