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.) 

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.) 

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

 

... 

 

 

 

err... test 

 

 

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

 

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

French lullaby for metlslime ;) 

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. 

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") 

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.' 

 

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. 

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 

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. 

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. 

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

i meant your second post, #1012. 

the 2nd post, the entire thread could be retrieved correctly, so maybe it was just a fluke.