Slow Slow Forum

From: Matt26 Jun 2006 23:33
To: Ben (BENLUMLEY) 24 of 34
Yes we do have a slow query log, but all it contains are the main thread list queries by the looks of it.

Like:

sql code:
SELECT THREAD.TID, THREAD.FID, THREAD.TITLE, THREAD.LENGTH, THREAD.POLL_FLAG, THREAD.STICKY, THREAD.VIEWCOUNT, USER_THREAD.LAST_READ, USER_THREAD.INTEREST, USER_FOLDER.INTEREST AS FOLDER_INTEREST, UNIX_TIMESTAMP(THREAD.MODIFIED) AS MODIFIED, USER.LOGON, USER.NICKNAME, USER_PEER.PEER_NICKNAME, USER_PEER.RELATIONSHIP FROM DEFAULT_THREAD THREAD LEFT JOIN DEFAULT_USER_THREAD USER_THREAD ON (USER_THREAD.TID = THREAD.TID AND USER_THREAD.UID = 21) LEFT JOIN DEFAULT_USER_FOLDER USER_FOLDER ON (USER_FOLDER.FID = THREAD.FID AND USER_FOLDER.UID = 21) LEFT JOIN USER USER ON (USER.UID = THREAD.BY_UID) LEFT JOIN DEFAULT_USER_PEER USER_PEER ON (USER_PEER.UID = 21 AND USER_PEER.PEER_UID = THREAD.BY_UID) WHERE THREAD.FID IN (1,2,3,4,5,6,7,8,9,11,12,13,14,16,20,22,23,24) AND ((USER_PEER.RELATIONSHIP & 8) = 0 OR USER_PEER.RELATIONSHIP IS NULL) AND ((USER_PEER.RELATIONSHIP & 2) = 0 OR USER_PEER.RELATIONSHIP IS NULL OR THREAD.LENGTH > 1) AND (USER_THREAD.INTEREST IS NULL OR USER_THREAD.INTEREST > -1) AND (USER_FOLDER.INTEREST IS NULL OR USER_FOLDER.INTEREST > -1) AND THREAD.LENGTH > 0 ORDER BY THREAD.STICKY DESC, THREAD.MODIFIED DESC LIMIT 0, 50;


Um. CVS problems. That looks right. It's the same as mine, except the username. What error message are you getting, assuming you're getting one?
From: Ben (BENLUMLEY)27 Jun 2006 00:00
To: Matt 25 of 34
i get

code:
In D:\web\project beehive\beehiveforum: "C:\Program Files\TortoiseCVS\cvs.exe" "-q" "checkout" "-P" "beehiveforum"
CVSROOT=:ext:benlumley@beehiveforum.cvs.sourceforge.net:/cvsroot/beehiveforum

cvs.exe [checkout aborted]: end of file from server (consult above messages if any)

Error, CVS operation failed



and i also get a red box saying connection error.

it is angering me. i've tried poking firewalls etc, and all to no avail.
From: Matt27 Jun 2006 08:45
To: Ben (BENLUMLEY) 26 of 34
You don't have PeerGuardian running do you? One of the latest updates to the P2P list includes sourceforge which you'll need to add to your allow list.
From: Ben (BENLUMLEY)27 Jun 2006 09:08
To: Matt 27 of 34

aha.

 

that phrase about nails and heads would be appropriate.

 

had a feeling it'd be something obvious.

 

ta.

From: Drew (X3N0PH0N)27 Jun 2006 17:45
To: Matt 28 of 34

Is something weird happening with character encoding? I'm seeing the usual weird shit instead of accented characters and currency symbols and stuff, like when unicode's broken.

 

Is this something you're doing to try to get the RSS working? (giggle)

From: Matt27 Jun 2006 17:58
To: Drew (X3N0PH0N) 29 of 34

It's the other way around. Unicode has never worked that well with Beehive, but it now should. In theory. Maybe.

 

So old posts will have broken unicode characters but new ones won't.

 

£€àáâãäåèéêëòóĆć

 

And so forth.

From: Drew (X3N0PH0N)27 Jun 2006 18:21
To: Matt 30 of 34
Eeeeeeeeeeeee grand. You're a marvel y'are.
From: Matt27 Jun 2006 18:55
To: Ben (BENLUMLEY) 31 of 34
Is your Sourceforge username actually benlumley? I've been trying to add both yourself and Pete as site admins but I can't add you as it reckons the user benlumley doesn't exist or you haven't activated your account.
From: Ben (BENLUMLEY)28 Jun 2006 00:35
To: Matt 32 of 34

i thought so ....

 

but i can't login, and i'm not listed on the beehive project either, was there with the list of devs before.

 

so ... errr.... unsure. finding out!

From: Matt28 Jun 2006 09:40
To: Ben (BENLUMLEY) 33 of 34
The project audit log does show Rendle adding you as a developer, but there is no entry about you being removed so I can only guess that you didn't validate your email or something like that and you've been removed automatically?
From: Ben (BENLUMLEY) 4 Jul 2006 08:12
To: Matt 34 of 34

hmm. yes. must be something like that. i validated my email though, i have an email confirming it.

 

i shall register again when i have a minute