Polraudio 122 Report post Posted June 21, 2009 It wont let me edit my Profile Information. Every time i submit it i get the error. Share this post Link to post Share on other sites
Wyzrd 12 Report post Posted June 21, 2009 I get the same error, it saves what you change. But still gives you the error, unless you edit it from your profile page and not through the User CP. Share this post Link to post Share on other sites
Marked 197 Report post Posted June 23, 2009 Also, everyone's information has been erased. In my profile it says no information for anything. why does this happen........................................... I've known about this error for a while, but didnt realize it was for every single member. When I banned the spammers this happened, but they were banned. There is a problem in the database, something has happened with the member tables. It is extremely difficult to fix because I dont have direct access to the tables and I cant alter them. I can use the phpmyadmin on my forum to get query syntax, but one wrong move and the live site and it may not be fixable. I did notice an abnormality in the of the tables. The total entries in the member forum wasn't equal to the total entries in the member_extra table(where this info is stored). That could be it. What I can do is look at the ISP Drive Error logs and see what I can. I'll also make an offline replica of the forum on my computer and fix it there first, or at least identify the issue. The problem is that its extremely time consuming. It can take more than 2 hours just to get the replica working.... Thanks for reporting the error though. I'm glad someone does. Share this post Link to post Share on other sites
Polraudio 122 Report post Posted June 23, 2009 Thanks, and Take your time. I know your busy with lots of other things. Share this post Link to post Share on other sites
Wyzrd 12 Report post Posted June 23, 2009 Also, everyone's information has been erased. In my profile it says no information for anything. Not entirely true because it didn't erase the information on my page. Share this post Link to post Share on other sites
Marked 197 Report post Posted June 24, 2009 Oh, i meant under Other Information. On your profile it's gone as well. Share this post Link to post Share on other sites
Wyzrd 12 Report post Posted June 24, 2009 Oh I see that now. Your right. Sorry, misunderstanding on my part. Share this post Link to post Share on other sites
Marked 197 Report post Posted June 24, 2009 Well I meant to say under that section, so it would be assumed I was talking about everything. I just thought of something. This error may be related to that duplicating member I've mentioned several times. I learnt today about how members ID's are created in the database, its a thing called auto increment. When I banned the spam member today, I got an error saying security mismatch, please submit the form again. I know that the form is trying to alter exiting data in the database(is this case, the members group, which is just changing a value), so therefor it must be having trouble with identifying which member is being edited, and there is something wrong with the ID. WAIT, i know what must be wrong! Each member MUST have a different id, i've got duplicated member errors in on my test board(using this database). There must a member or a database entry in the members table that has identical id's. I'll test my theory out tomorrow and I'll check out a backup and see if I can pinpoint this member. However, last time i deleted a suspected duplicate entry, it duplicated itself continuously. Share this post Link to post Share on other sites
Wyzrd 12 Report post Posted June 24, 2009 Well I hope it works :). Share this post Link to post Share on other sites
Polraudio 122 Report post Posted June 25, 2009 I hope everything works right. *Crosses fingers hoping forum don't break* Share this post Link to post Share on other sites
Marked 197 Report post Posted June 25, 2009 originalOkay guys, this is really really strange. Unfortunately it is not a duplicate member. But I did find him, his id is 7465(posting it here so i dont have to find it again). The problem is so strange. It is all to do with the custom profile fields. I should have known, that is what "Other Information" is. Oh wait, I just figured it out!(just deleted my whole post...). Okay, in the database cleanup(guess) the profile field columns in the database were deleted. So every time you go to update your profile, information is trying to be inserted into a column that does not exist. Fortunately, I may have a solution. By huge coincidence, I figured how I can solve the issue just yesterday. The solution of course is to add the columns back. The problem with that is, how is that done? Well, I heard in phpmyadmin that if you manually create a column it will print out the sql query for you, paste that in the ipb database toolbox, and you have your columns back. The only issue with that is, each column has specific informtion required that was deleted, but I think I can find it. I'll post back with my results from this. EDIT: it worked! Now that wasn't so challenging :P Just had to create the columns again with the exact same query, just changing the column name each time. I would have never been able to do this if i hadnt been recently learning mysql. Can you guys test it and confirm that it is infact working? Share this post Link to post Share on other sites
Wyzrd 12 Report post Posted June 25, 2009 It worked Marked, your a genius. :) I wish you knew vB lol I keep getting a mysql database error on my site I have no clue about. Share this post Link to post Share on other sites
Marked 197 Report post Posted June 26, 2009 It worked Marked, your a genius. :) I wish you knew vB lol I keep getting a mysql database error on my site I have no clue about. Haha, well all these errors make good practice. Especially when you're guessing because you have to test your theories. Does your vb board keep any logs of your errors? PM me the log and i'll see if i can help. If you do, make sure you get the error and then immediately after send the log so the last entry on the log is that specific error. Mysql reads like english, so its pretty easy to identify whats gone wrong. Fixing it is the difficult part. Not having access to phpmyadmin for rmxp unlimited is giving me a lot of practice, as well as writing the script archive submission form. Thanks you guys for reporting the error also :) Share this post Link to post Share on other sites
