Differences

This shows you the differences between two versions of the page.

--- how_to:repairing_corrupted_database [2016/04/06 12:16] – [Finding the problem table/index] paul
+++ how_to:repairing_corrupted_database [2020/03/16 15:51] – paul
@@ Line 50: / Line 50: @@
 Unfortunately, there is no easy way to find which record is damaged, so you need to scan the entire table.
-Go to a command prompt in the VPOP3 directory and run 'psql' (in version 5 only). The default password is 'vpop3pass'
+Go to a command prompt in the VPOP3\pgsql\bin directory and run 'psql -U postgres -p 5433 vpop3' (in version 3 or 4 omit the '-p 5433'). The default password is 'pgsqlpass'
 ====Finding the problem message====
@@ Line 90: / Line 90: @@
   SELECT subject, messagetime, fromaddr, tolist FROM messages.msgdata WHERE msgdataid = <problem message id>;
 and
-  SELECT username, folder FROM messages.foldermessages INNER JOIN users.users ON messages.foldermessages.userid=users.users.username WHERE msgdataid= <problem message id>;
+  SELECT username, folder FROM messages.foldermessages INNER JOIN messages.folders USING(folderid) INNER JOIN users.users ON messages.folders.userid=users.users.usernumber WHERE msgdataid = <problem message id>;
 this will tell you summary information about the message which may help know which message will been deleted

PSCS Wiki