Func_Msgboard: Site Help

Posted by metlslime on 2002/12/23 18:26:17

This is the forum to ask questions about this website, report things that are broken, request features, etc.

Be sure to check out the FAQ as well.

First | Previous | Next | Last

Big Database Change:

#990 posted by metlslime on 2006/12/12 03:00:45

so i made a big database change which basically split the threads and posts into seperate tables. There are about 50,000 posts on the board, and 800 threads. This means that all SQL queries used to have to read a 50000-row table just to get thread data. Now threads are in a seperate, 800-row table, which is much faster to query :)

Pages that should load faster: news page, forum, thread archives. Pages that should be about the same: view_thread, people, faq, etc.

Anyway, please let me know if anything appears to have broken during this change. Things seem to work fine from what I've tested.

(Moderators will notice that they cannot reject a news submission. I will revive this feature soon. Just leave them in the queue for now and we can reject them later.)

Big Database Change:

#991 posted by metlslime on 2006/12/12 03:00:55

Big Database Change:

#992 posted by metlslime on 2006/12/12 03:01:02

Big Database Change

#993 posted by metlslime on 2006/12/12 03:21:37

Oh...

#994 posted by metlslime on 2006/12/12 03:22:15

And i might have gotten just rid of the RECURSIVE ERROR message. Maybe.

Umm..

#995 posted by metlslime on 2006/12/12 03:22:32

Er, Test?

#996 posted by metlslime on 2006/12/12 03:25:16

...

I Think I May Have Spotted An Error...

#997 posted by Kell on 2006/12/12 03:39:37

Testes...

#998 posted by metlslime on 2006/12/12 03:39:45

Okay, Another Freaking Test

#999 posted by metlslime on 2006/12/12 03:45:47

Yay 1000!

#1000 posted by neg!ke on 2006/12/12 03:50:42

err... test

Okay, Maybe It Works Now?

#1001 posted by metlslime on 2006/12/12 03:55:07

Is Posting Always Slow Now?

#1002 posted by metlslime on 2006/12/12 03:57:29

OKay, Since It's 4am

#1003 posted by metlslime on 2006/12/12 04:02:35

and things seem to be mostly working, i'm going to bed. Let me know how it goes :)

Lmbo

#1004 posted by Kinn on 2006/12/12 15:12:50

ZzZZZZzzz

#1005 posted by JPL on 2006/12/12 22:57:59

"fait dodo cola mon p'tit frere"
"fait dod t'auras du lolo"

French lullaby for metlslime ;)

Fight_Msgclub

#1006 posted by R.P.G. on 2006/12/13 18:26:37

RECURSIVE ERROR:
Error 1: There was a SQL error.
Error 2: There was a SQL error.

The first error of Func_Msgboard is, there was a SQL error.

The second error if Func_Msgboard is, there was a SQL error.

RPG:

#1007 posted by metlslime on 2006/12/13 21:33:04

I finally edited the "recursive error" message so that it would actually show BOTH errors. Too bad both errors are still completely vague. :P

(also, i almost typed your nickname as "RGB")

RGB?

#1008 posted by HeadThump on 2006/12/13 22:38:51

Wished you hadn't told me. I've been calling in to the office for years telling them, 'I don't know where he is. You know those replicants, they can be tricky. Could you wire another ten grand, I'm running low on peanut butter.'

Test

#1009 posted by metlslime on 2006/12/13 23:28:59

SQL Errors

#1010 posted by metlslime on 2006/12/14 00:02:09

all SQL errors should now give an error code and a filename and a line number, which means that if you get an error and tell me about it, i might actually be able to do something about it.

SQL Error

#1011 posted by aguirRe on 2006/12/14 00:58:28

RECURSIVE ERROR:
Error 1: SQL error 1045 on line 12 of view_thread.php. Please tell metlslime about this.
Error 2: SQL error 1045 on line 24 of _display.php. Please tell metlslime about this.

Request was: http://www.celephais.net/board/view_thread.php?id=35374

Another One

#1012 posted by aguirRe on 2006/12/14 01:05:19

After adding the above post, I retrieved the whole sitehelp thread, but then that last post wasn't there. After another attempt, it showed up, though.

Hmm

#1013 posted by metlslime on 2006/12/14 01:47:54

okay, it's as i suspected.

the "RECURSIVE" errors are the ones where a second error occurs while trying to display an error page -- since the error page still has a header and stuff, there are still SQL commands required to see if you're logged in or not, and these must also be causing an error.

Since it's the same error number on both, and that error is "access denied for user" then I think there's nothing wrong with my SQL queries, and instead there's some intermittent problem with the server, like too many connections or something. Which means I can't fix it but at least I know WTF was going on all this time.

Also...

#1014 posted by metlslime on 2006/12/14 01:55:10

as for the second error, if you see that more often then let me know. Otherwise it might just be a one-time hiccup.

First | Previous | Next | Last

You must be logged in to post in this thread.