Codezwiz >> Forums >> General PHP Nuke Help >> Missing posts after changing servers

Hi

We have recently changed servers and now have the problem that some of the old posts are missing.

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.

We are running nuke version 7.7

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

Dean

Any ideas on this one anybody?