NineChime forum

Yeah, that's what worries me about the whole thing, too, the fact that stuff from a while got totally washed.  And the web host help really wasn't very useful. 
And personally, I've never had a problem before with the server.  Sure, there were times when it was down, but it's always been fast and reliable and never ate up any of my data or anything like this before. 
Anyway, here's a screen of recent logs: http://img607.imageshack.us/img607/4343/scr1320970.jpg 
I don't think there are any serious errors here, though I am curious as to what the earlier sql errors with "out of memory" might mean... does it relate to uploads perhaps?  I feel like it's not related to this current problem though, ahahaha.

But yeah, when I go to check phpMyAdmin, I scroll to the most recent comments and pictures, and it shows the stuff that was deleted and nothing after.  I'm quite sure, unless my computer is doing some weird cacheing thing. 

So Wac, I also tried to manually re-upload pictures 631 and 633 to the oekaki, since they were saved previous to the crash.  This is what the file manager reported back to me: http://img690.imageshack.us/img690/7625/scr2878930.jpg  And it doesn't seem to have fixed the broken images.
So yeah, seems liks there's something up with transferring to the ftp? 

And I did a real fast test on the oekaki with shipainter; seems like retouch works fine. 

I've e-mailed you the login information so you can take a look; thank you again for all of your hard work and your help!  You're the best, Wac.  ;v;

Last edited by arisidhe (02-06-2011 00:19:05)

Okay, I've accessed the site and have found out a few things.

First, I don't think there's anything wrong with the database.  The error log on the server has a few glitches listed for last month, but nothing major.  I wouldn't worry about comments disappearing and stuff like that.

Second, FTP access of the pictures and avatars folders didn't work.  So, I fixed them.  You should now be able to upload image directly into the pictures folder, so if you have a backup of picture 633 or whatever, you should be able to put it back.  The only catch is that if you upload an image to the pictures folder directly, you should CHMOD it to 666 (or, turn on Read and Write permissions for all groups.  You shouldn't have to enable Execute permissions, but I suppose you can do that if you want).

Third, there's one little thing that can be fixed.  Log into the oekaki, and go to the Control Panel.  At the very top look for "URL to OekakiPoteto".  Get rid of the "index.php" at the end, so it shows up as "http://arisidhe.site88.net/oekaki".  I'll fix the installer so that the "index.php" is always stripped off the end.  It's not a big deal, though.  It's certainly not causing the disappearing pictures.

As for why the images have disappeared, I haven't found out anything that can explain it.  All of your FTP permissions are fine, the oekaki log doesn't show anything, and the server log hasn't shown any database issues for the last month.  I'm tempted to write this one off as a server maintenance/backup issue.  Please keep an eye on it and if you have more problems, let me know ASAP.

the mySQL database still doesn't include the recent pictures and comments, only those before the wipe.

I'm not sure what you mean, here.  Are you saying there were comments on the affected pictures that disappeared at the same time the pictures did?  All comments newer than those pictures were all wiped out?  I see there's no comments on the board that are dated for February 3rd, so everything that was posted on February 3rd disappeared?

If that's the case, then I'm fairly certain that the server had a maintenance problem on February 3rd.  Whether that will happen again in the near future is anyone's guess.

One thing you may want to do is make a backup of your database using myPhpAdmin.  Go into that utility, and click the "Export" tab at the top.  At the bottom, click "Save as File," set the compression to "Zipped," and then click "Go."  This will allow you to download a complete backup of your database.  If something goes wrong, you can selectively restore certain information, such as only restoring the memberlist, only the mailbox, only comments posted before a certain date, etc.

I make a backup of my oekaki about once a month.  My host is good with data integrity, but I still prefer to have my own backups.  However, backing up all the pictures is impractical.  Don't bother, because most hosts are better at backing up files than databases.

If you go to "phpMyAdmin" and access the mySQL database and go to the most recent comments or pictures, you'll see the ones that were lost on the 3rd... and, what worries me much more, the fact that all of the newer pictures and comments are not there.  I don't know WHERE the data for the newer comments/pictures might be going, since there's no second mySQL database or anything.

I'm still not sure what you mean by this.  Here's what I'm doing:

1) I go to http://members.000webhost.com/login.php and log in with the information you sent to me.
2) I click "Go to C Panel", then "phpMyAdmin", then "Enter phpMyAdmin".
3) I look at the op_oekakicmt table, click "Browse", and sort by postdate descending.

Once there, I see that there's no comments dated for February 3rd.  However, I can see comments from Feb. 4th through Feb. 7th.

From what I can see, only February 3rd is missing.  Everything older and newer than that day is showing up in the database just fine.

Are you sure you're using the same login that you sent me in that e-mail?

In the "Account information" section of your CPanel, the specific server listed is server9.000webhost.com and the IP address is 173.212.215.234.  I'm hoping we're both looking at the SQL data on the same server.

Oh, yeah... that's a database maintenance issue, all right.  It looks like the data ended up going into the wrong SQL account.

I doubt this will happen again, but if it does, let me know pronto.

Microsoft SQL Server is a reliable and advanced database management system that provides you various database management and SQL database recovery algorithms. DBCC CHECKDB is one of the most advanced SQL Server commands that helps you repair corrupt database.