BlameThePixel!

[Not Logged in] - [Login] [Register] [Lost Password?]

BTForum » Main BTP Stuff » BlameTheGeneralDiscussion » FFS, I DO NOT WANT TO BE DELETED ALL THE TIME!

Page: [1] [2]
Dingbats ; Send PM Posts: 1970 Threads: 50 Mood: Optative Money: £268.57 (D) (+ Friend)	Now I've been deleted from the database twice! I don't want to have to re-signup once a month. So, fix that bug. I thought that btp repair bot fixed those things. PS. I forgot to tell you , ZoGgEr!, that my user rating was 13. Now I've been deleted from the database twice! I don't want to have to re-signup once a month. So, fix that bug. I thought that [user]BTP Repair Bot[/user] fixed those things. PS. I forgot to tell you , ZoGgEr!, that my user rating was 13.
27.03.04 18:31 Post #1	[Softbrain Games] [Hide Sig (2)] [Profile] [Quote]
C1 Looking For Status Send PM Posts: 0 Threads: 0 Money: £0.18 (D) (+ Friend)	Yes they do. But remember? BTP crashed for a few days yesterday. Wiping out everyone that was online. Usually the site would stay up when the users crash. But this time everyone just flopped making it impossible for the bot to repair the user since everything was down. This is just a guess and sum smart person will correct me and say im entirely wrong. Yes they do. But remember? BTP crashed for a few days yesterday. Wiping out everyone that was online. Usually the site would stay up when the users crash. But this time everyone just flopped making it impossible for the bot to repair the user since everything was down. This is just a guess and sum smart person will correct me and say im entirely wrong.
27.03.04 19:16 Post #2	[Hide Sig (2)] [Profile] [Quote]
Zogger! Looking For Status Send PM Posts: 3954 Threads: 62 Money: £93.82 (D) (+ Friend)	Yeh, I think you're wrong, but I'm not entirely sure why it didn't work. You could be right for all I know, but something about it doesn't sound likely. Yeh, I think you're wrong, but I'm not entirely sure why it didn't work. You could be right for all I know, but something about it doesn't sound likely. ________________ You know I'm a dancing machine
27.03.04 20:10 Post #3	[Hide Sig (8)] [Profile] [Quote]
Dingbats ; Send PM Posts: 1970 Threads: 50 Mood: Optative Money: £268.57 (D) (+ Friend)	Sorry for screaming before. Well, at least BTP is up and running again, so I guess I should be happy. Sorry for screaming before. Well, at least BTP is up and running again, so I guess I should be happy.:)
31.03.04 15:58 Post #4	[Softbrain Games] [Hide Sig (2)] [Profile] [Quote]
Archamond Statusless? Maybe Send PM Posts: 1825 Threads: 123 Mood: meh Money: £422.09 (D) User Tax: 5% (+ Friend)	Ofcourse, this is not porn lol you realy dont have lucky ding lol you realy dont have lucky ding:):)
31.03.04 17:08 Post #5	[ArchamondCOM ] [Hide Sig (20)] [Profile] [Quote]
Glenn Forsetti Send PM Posts: 4241 Threads: 98 Mood: Godly Money: £8.24 (D) (+ Friend)	Well, I'd think of it this way. If YOU can't access the site, then the BTP repair bot is probably not working either. So, of course, it wouldn't correct the error. Well, I'd think of it this way. If YOU can't access the site, then the BTP repair bot is probably not working either. So, of course, it wouldn't correct the error.
31.03.04 20:13 Post #6	[Youtube] [Hide Sig (12)] [Profile] [Quote]
tundraH Statusless Send PM Posts: 566 Threads: 20 Money: £1.26 (D) (+ Friend)	My theory: The repair bot does two things when it finds an error: 1 - repair the affected table 2 - if it was the users table, look for deleted users and restore them What actually happened was that the db crashed, deleting someone, and then effectively went down completely. I'm guessing ZoGgEr repared the database, so the repair bot didn't know to check its backup list because it wasn't the one that repaired the original error. Way too much typing. Did it make any sense? My theory: The repair bot does two things when it finds an error: 1 - repair the affected table 2 - if it was the users table, look for deleted users and restore them What actually happened was that the db crashed, deleting someone, and then effectively went down completely. I'm guessing ZoGgEr repared the database, so the repair bot didn't know to check its backup list because it wasn't the one that repaired the original error. Way too much typing. Did it make any sense?
31.03.04 20:46 Post #7	[tundraH.com] [Hide Sig (0)] [Profile] [Quote]
C1 Looking For Status Send PM Posts: 0 Threads: 0 Money: £0.18 (D) (+ Friend)	Kind of and ur probably right. Though my explination (tho it probably doesnt make sense due to bad grammar) could have been right also. Kind of and ur probably right. Though my explination (tho it probably doesnt make sense due to bad grammar) could have been right also.
31.03.04 21:00 Post #8	[Hide Sig (2)] [Profile] [Quote]
CBWhiz Looking For Status Send PM Posts: 1044 Threads: 130 Money: £1343.20 (D) (+ Friend)	Quoted :: tundraH My theory: The repair bot does two things when it finds an error: 1 - repair the affected table 2 - if it was the users table, look for deleted users and restore them What actually happened was that the db crashed, deleting someone, and then effectively went down completely. I'm guessing ZoGgEr repared the database, so the repair bot didn't know to check its backup list because it wasn't the one that repaired the original error. Way too much typing. Did it make any sense? basicly. \n <?PHP\n function ParseSQLTableError ($errorstring) {<br /> $wasusers = ""; preg_match("/.Can't open file[^']'([^.])../i",$errorstring,$it); if($it[1] != "") { $it = $it[1];<br /> SendAdminPM("Detected Table Crash in '$it' [NT]", "", "BTP SQLBot"); RepairSQLTable ($it); if ($it == 'users') { //restore users table<br /> include_once('userbackup.php'); if (deletedusers() != " ") { //need to restore some people $gone = deletedusers(); restoreusers();<br /> $wasusers = "<br><br>The following users were restored to the database:<br>$gone";<br /> } } $thedate = date("d.m.y"); /QueryDB("INSERT INTO news (author, title, date, body, category) VALUES ('BTP Repair Bot', 'Database Repair Attempted', '$thedate', 'Hello! This is your friendly PHP code letting you know that I automagicly tried to fix the '$it' database table. Chances are, if you see this, I was sucessful.$wasusers', 1)");/<br /> return true; // handled } else { return false; // not handled }<br /> } function RepairSQLTable ($tablename) { $query = "REPAIR TABLE $tablename"; $rid = QueryDB($query); $html = SQLTable($rid);<br /> SendAdminPM("Results of table repair on $tablename", $html, "BTP SQLBot"); }\n?> \n [quote=tundraH] My theory: The repair bot does two things when it finds an error: 1 - repair the affected table 2 - if it was the users table, look for deleted users and restore them What actually happened was that the db crashed, deleting someone, and then effectively went down completely. I'm guessing ZoGgEr repared the database, so the repair bot didn't know to check its backup list because it wasn't the one that repaired the original error. Way too much typing. Did it make any sense? [/quote] basicly. [php] function ParseSQLTableError ($errorstring) { $wasusers = ""; preg_match("/.Can't open file[^']'([^.])\../i",$errorstring,$it); if($it[1] != "") { $it = $it[1]; SendAdminPM("Detected Table Crash in '$it' [NT]", "", "BTP SQLBot"); RepairSQLTable ($it); if ($it == 'users') { //restore users table include_once('userbackup.php'); if (deletedusers() != " ") { //need to restore some people $gone = deletedusers(); restoreusers(); $wasusers = "<br><br>The following users were restored to the database:<br>$gone"; } } $thedate = date("d.m.y"); /QueryDB("INSERT INTO news (author, title, date, body, category) VALUES ('BTP Repair Bot', 'Database Repair Attempted', '$thedate', 'Hello! This is your friendly PHP code letting you know that I automagicly tried to fix the \'$it\' database table. Chances are, if you see this, I was sucessful.$wasusers', 1)");/ return true; // handled } else { return false; // not handled } } function RepairSQLTable ($tablename) { $query = "REPAIR TABLE $tablename"; $rid = QueryDB($query); $html = SQLTable($rid); SendAdminPM("Results of table repair on $tablename", $html, "BTP SQLBot"); }[/php]
31.03.04 23:38 Post #9	[Hide Sig (3)] [Profile] [Quote]
Zogger! Looking For Status Send PM Posts: 3954 Threads: 62 Money: £93.82 (D) (+ Friend)	I didn't do any repairing, I think. Although it was a while ago, so I might've just forgotten. I didn't do any repairing, I think. Although it was a while ago, so I might've just forgotten. ________________ You know I'm a dancing machine
01.04.04 10:10 Post #10	[Hide Sig (8)] [Profile] [Quote]
Dingbats ; Send PM Posts: 1970 Threads: 50 Mood: Optative Money: £268.57 (D) (+ Friend)	Can't you, instead of having a repair bot fix the bugs, fix the bugs in the code that must be somewhere yourselves? Can't you, instead of having a repair bot fix the bugs, fix the bugs in the code that must be somewhere yourselves?
01.04.04 11:30 Post #11	[Softbrain Games] [Hide Sig (2)] [Profile] [Quote]
Zogger! Looking For Status Send PM Posts: 3954 Threads: 62 Money: £93.82 (D) (+ Friend)	it's not a bug in the code, dingbats, it just happens, or perhaps just happened, past tense. They might not happen anywhere near as much on this host. We'll see. I think the main reason for it happening is that it gets half way through a page, then the server gives up and it crashes the table - but I'm not sure. it's not a bug in the code, dingbats, it just happens, or perhaps just happened, past tense. They might not happen anywhere near as much on this host. We'll see. I think the main reason for it happening is that it gets half way through a page, then the server gives up and it crashes the table - but I'm not sure. ________________ You know I'm a dancing machine
01.04.04 15:47 Post #12	[Hide Sig (8)] [Profile] [Quote]
C1 Looking For Status Send PM Posts: 0 Threads: 0 Money: £0.18 (D) (+ Friend)	Yeah when too many connections go to one database , as zogger said it just crashes the table. Nothing wrong with the code itself.. Yeah when too many connections go to one database , as zogger said it just crashes the table. Nothing wrong with the code itself..
01.04.04 20:54 Post #13	[Hide Sig (2)] [Profile] [Quote]
CBWhiz Looking For Status Send PM Posts: 1044 Threads: 130 Money: £1343.20 (D) (+ Friend)	Quoted :: Dingbats Can't you ... fix the bugs in the code ... yourselves? Sometimes I hate being good at things, because if your good at something everybody assumes everything is your fault and expects you to simply magicly fix every problem that is out of your control. The annoying part is that they think we are so lazy that we'd prefer a crashing server to a "simple" fix that everyone thinks this is. [quote=Dingbats] Can't you ... fix the bugs in the code ... yourselves? [/quote] Sometimes I hate being good at things, because if your good at something everybody assumes everything is your fault and expects you to simply magicly fix every problem that is out of your control. :) The annoying part is that they think we are so lazy that we'd prefer a crashing server to a "simple" fix that everyone thinks this is.
02.04.04 02:34 Post #14	[Hide Sig (3)] [Profile] [Quote]
Dingbats ; Send PM Posts: 1970 Threads: 50 Mood: Optative Money: £268.57 (D) (+ Friend)	Sorry, CBWhiz. Sorry, CBWhiz.:\|
02.04.04 07:22 Post #15	[Softbrain Games] [Hide Sig (2)] [Profile] [Quote]
Page: [1] [2]

Post Reply

Your Comments:

Donate to BlameThePixel:

[22 Queries, Page Loaded in 0.679574 Seconds]

ShoutMeUp

Xmas Greetings from waka waka waka waka ChristmasRiddle MERRY CHRISTMAS EVERYONE! Spleet Except for Spleet. TheAbdBoy Always bummin' a brother out. Spleet Happy New Year everyone! But Spleet. TheAbdBoy