Users and groups missing for no apparent reason.

[tim18]

Help.

For some reason yet to be discovered, my coppermine photo gallery just... 'broke'. Appologies for not using more detailed terms, but this came out of nowhere. i haven't been on for days, neither has the other administrator. Here are as many details as i can find.

i logged on today to find all but 6 users missing from the user table.

However. when you try and log in as one of the missing users, it still welcomes you... however then just takes you back to the log in page. This to me, implies that the users are still there, but that coppermine just cant access it.

My unique groups are also gone, leaving only the coppermine defaults "administrators, registered, guests and banned".

There may be other issues, but im not sure at this stage.

I enabled debug mode and it came up with the following notices.

Code Select Expand

/include/logger.inc.php

    * Warning line 155: unlink(logs/global.log.php) [function.unlink]: Permission denied
    * Warning line 155: unlink(logs/database.log.php) [function.unlink]: Permission denied
    * Warning line 51: fopen(logs/global.log.php) [function.fopen]: failed to open stream: Permission denied
    * Warning line 53: fwrite(): supplied argument is not a valid stream resource
    * Warning line 54: fclose(): supplied argument is not a valid stream resource
    * Warning line 51: fopen(logs/global.log.php) [function.fopen]: failed to open stream: Permission denied
    * Warning line 53: fwrite(): supplied argument is not a valid stream resource
    * Warning line 54: fclose(): supplied argument is not a valid stream resource

/bridge/udb_base.inc.php

    * Notice line 114: Undefined variable: row

/include/themes.inc.php

    * Notice line 2724: Undefined variable: loginFormHtml

/login.php

    * Notice line 29: Undefined index: referer

Please, if you can, help. I'm really incredibly out of my depth on this one, and have no idea where to start trouble shooting.

Test accounts and debug info can be supplied if necessary.

Thankyou
Tim

[Nibbler]

Restore the usergroups table from a backup.

[tim18]

I was afraid you would say that. Thanks for the speedy reply 

It worked, i restored the database and everything is fine. However I'm still curious as to how this could have possibly happened. Is it one of those issues with a thousand variables or is there something i can do to avoid this happening again.

Thanks
Tim