|
||||||
| FAQ | Members List | Calendar | Today's Posts | Search |
Topic Review (Newest First)
|
| Jul 29th, 2003 09:20 PM | |||
| Cosmo Electrolux | I thought I was... | ||
| Jul 29th, 2003 09:05 PM | |||
| Mockery |
Haha no, I just removed those so it didn't look like you went loco and were talking to yourself for about 3-4 posts in a row. 
|
||
| Jul 29th, 2003 08:57 PM | |||
| Cosmo Electrolux |
cosmo's posts = Chimps spam
|
||
| Jul 29th, 2003 05:41 PM | |||
| Mockery | Ha... don't ask me man, I just had phade help me install the board. I still don't know shit about SQL. I just want the board to stop breaking. :/ | ||
| Jul 29th, 2003 05:39 PM | |||
| AChimp |
 That version is almost a year old. It's stable, but they're not adding to 3.23 anymore except when they find a major bug. The new 4.0 version is a lot faster and more efficient. Of course, the database version probably isn't the cause of any problems, but it couldn't hurt for them to get with the times. :l33t |
||
| Jul 29th, 2003 04:43 PM | |||
| Mockery | "MySQL 3.23.54" is what it says | ||
| Jul 29th, 2003 04:43 PM | |||
| AChimp | Have you ever run "check table" to see what the error was before you fixed it? | ||
| Jul 29th, 2003 04:36 PM | |||
| AChimp |
Hmm... okay. The MySQL resource says that you shouldn't have to run that command all the time, but it'll make no difference for the script. Check the version of MySQL that you're using, though. It should say right after the "Welcome to phpMyAdmin 2.X.X" message when you log in. |
||
| Jul 29th, 2003 04:32 PM | |||
| Mockery | Nope, actually I'm selecting all the tables at once in phpmyadmin and then selecting "repair table". Chojin had me talk to this guy "phade" who runs a really large anime board (he's the guy who helped me get this php board up 'n running in the first place, and he told me use the "repair table" function and select all of the tables when I do it whenever the board gives me those errors. | ||
| Jul 29th, 2003 04:30 PM | |||
| AChimp |
Yeah, you'd have to make it from scratch. I can do it for you in a few minutes. Of course, you'd have to edit the password, username, database name, etc. Like I said, it's really simple. Before I start, though, all you're doing is just "optimize table" on the broken ones, right? |
||
| Jul 29th, 2003 04:21 PM | |||
| KILLADEUCE | Might have to make one from scratch... I'll look into it tho, I dont blame ya, going in and manually editing that shit can be a pain in the ass to say the least... | ||
| Jul 29th, 2003 04:18 PM | |||
| Mockery |
Quote:
 Quote:
|
||
| Jul 29th, 2003 04:10 PM | |||
| AChimp |
 I knew you'd delete half this thread.You should maybe see if your server admin people can set up a script that will automatically repair the tables for the entire board. It's a fairly simple script: 1. Lock all the tables (the board will not work at all for the duration of the script). 2. Optimize each table one by one. 3. Unlock the tables. Just have it run at, like, 2:00 AM or something when there's no one on the board. It should only take a minute or so, I think. EDIT: Alternatively, you could bitchslap them for messing up MySQL... I've had a few problems with my database, but they're almost always caused by something I've done. Do you know what version they're running, and on what platform? I'm not sure if the Windows version is as stable as the Unix one. The latest version is 4.0.13, I believe. Also, have you done any modifications to the board regarding the databases? You might find this link helpful, but I'm not sure if you have this kind of server access. http://www.mysql.com/doc/en/Crashing.html |
||
| Jul 29th, 2003 02:08 PM | |||
| Mockery | Originally the board was down a lot because of the host, and that still happens here 'n there, but lately there have been a lot of problems with the board itself. I thought the sql databases were supposed to be a lot more stable, but so far I'm not seeing that. :/ I'm constantly having to go into the database to repair all the tables. That's the only thing that ever seems to get the board working again each time (if it's not down because of the host). | ||
| Jul 29th, 2003 01:30 PM | |||
| ItalianStereotype | but what IS surprising is that nobody has stabbed you in the face yet. | ||
| Jul 29th, 2003 12:52 PM | |||
| KILLADEUCE | Yeah i notcied periodically there are php errors or Sql errors it looks like. With the high load of these forums it's not real surprising. | ||
| Jul 29th, 2003 12:39 PM | |||
| mburbank |
|
||
| Jul 29th, 2003 12:10 PM | |||
| AChimp |
Yes, they are down a lot. 
|
||
| Jul 29th, 2003 12:04 PM | |||
| Dole | These boards fall over more than Grandma Dole after an afternoon on the pink gins. | ||
| Jul 29th, 2003 11:59 AM | |||
| mburbank |
CRITICAL ERROR Is it me, or is this board down a whole Christ of a lot lately? |
||
