User Tools

Site Tools


how_to:repairing_corrupted_database

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
how_to:repairing_corrupted_database [2018/11/14 10:45]
127.0.0.1 external edit
how_to:repairing_corrupted_database [2020/03/16 15:51] (current)
paul
Line 90: Line 90:
   SELECT subject, messagetime,​ fromaddr, tolist FROM messages.msgdata WHERE msgdataid = <problem message id>;   SELECT subject, messagetime,​ fromaddr, tolist FROM messages.msgdata WHERE msgdataid = <problem message id>;
 and 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 this will tell you summary information about the message which may help know which message will been deleted
how_to/repairing_corrupted_database.1542192349.txt.gz ยท Last modified: 2018/11/14 10:45 by 127.0.0.1