#1877 Restoring users and messages from backup - needs slight impr

v4.1.3
open
nobody
None
5
2008-11-17
2008-01-12
Meliza Amity
No

My users DB table was corrupted.
I used the PGV backup and the "User Information Migration tool" import to restore it.

1. I copied only the authenticate.php to my index directory. This caused the data of the news, messages, favorites and blocks to be deleted.
I think that if the files are not in the index directory and there is data in the DB tables, then the data should remain in the tables.

2. I then copied from the backup also the ...dat files to the index directory and imported again the data.
My new messages are normally shown in PGV with the newest first.
The restored messages are shown with the oldest first.

Discussion

  • Meliza Amity
    Meliza Amity
    2008-01-12

    Logged In: YES
    user_id=959928
    Originator: YES

    It turns out that the restored users were created with "Visible to other users when online" No. Originally all, or at least most, were defined with the value Yes.
    This means that users do no longer see who is online.

    The few users I have looked at have also " Allow this user to edit his account information" No.

    I am not at home for a couple of days.
    Could someone tell me what else was lost and if the backup file contains the original values.

    Thanks,
    Meliza

     
  • Meliza Amity
    Meliza Amity
    2008-01-14

    Logged In: YES
    user_id=959928
    Originator: YES

    The authenticate.php in the backup has the following values:
    $user["visibleonline"] = '1';
    $user["editaccount"] = '1';

    The user DB table has
    u_visibleonline = 'Y'
    u_editaccount = 'Y'.

    The backup or the import does not work as expected.

    I have not yet tried to export the data.

    Meliza

     
  • Meliza Amity
    Meliza Amity
    2008-01-14

    Logged In: YES
    user_id=959928
    Originator: YES

    The tool export creates also the following values
    $user["visibleonline"] = '1';
    $user["editaccount"] = '1';

     
  • Greg Roach
    Greg Roach
    2008-02-25

    Logged In: YES
    user_id=1466942
    Originator: NO

    Just seen this bug. I fixed the "1"<=>"Y" issue a few days ago as part of my user-table access tables. This fixes your "visible online problem".

    The issue of only restoring particular tables is still outstanding.

     
  • Greg Roach
    Greg Roach
    2008-11-17

    • milestone: --> v4.1.3