Glitch City Laboratories Archives

Glitch City Laboratories closed on 1 September 2020 (announcement). This is an archived copy of a thread from Glitch City Laboratories Forums.

You can join Glitch City Research Institute to ask questions or discuss current developments.

You may also download the archive of this forum in .tar.gz, .sql.gz, or .sqlite.gz formats.

Wiki Discussion

[FIXED] Another blog bug - Page 1

[FIXED] Another blog bug

Posted by: Bent`
Date: 2007-11-01 20:45:03
[18:39] <_2marc> i think there's another bug in the blog system
[18:39] <_2marc> http://forums.glitchcity.info/index.php?action=viewblog;u=1;id=2
[18:39] <blitzer> !engrishsentence Rockman
[18:39] <fivequestionmarks> Engrishsentence: Rockman is drumming a house!
[18:39] <XD003> what
[18:39] <_2marc> what do you guys see under "recent blogs"?
[18:39] <blitzer> where is "recent blogs?"
[18:39] <XD003>  So I'm haxing Pocket Monsters Red. by IIMarckus
[18:39] <_2marc> left
[18:39] <XD003> Today at 09:28:50 pm
[18:39] <XD003> So I'm haxing Pocket Monsters Red. by IIMarckus
[18:39] <XD003> Today at 09:28:50 pm
[18:39] <XD003> So I'm haxing Pocket Monsters Red. by IIMarckus
[18:39] <XD003> Today at 09:28:50 pm
[18:39] <XD003> So I'm haxing Pocket Monsters Red. by IIMarckus
[18:39] <XD003> Today at 09:28:50 pm
[18:39] <XD003> So I'm haxing Pocket Monsters Red. by IIMarckus
[18:39] <XD003> Today at 09:28:50 pm
[18:39] <XD003> So I'm haxing Pocket Monsters Red. by IIMarckus
[18:39] <XD003> Today at 09:28:50 pm
[18:40] <XD003> So I'm haxing Pocket Monsters Red. by IIMarckus
[18:40] <XD003> Today at 09:28:50 pm
[18:40] <XD003> So I'm haxing Pocket Monsters Red. by IIMarckus
[18:40] <XD003> Today at 09:28:50 pm
[18:40] *** XD003 has left #glitchcity
[18:40] *** XD003 has joined #glitchcity
[18:40] <fivequestionmarks> XD003 is all powerfull, and for the hell of it 7545961 is your lucky number, also 3.14159265358979323846
[18:40] <_2marc> i figure it's only supposed to display once

Also the view counters don't seem to be incrementing on anyone's blog entries.

Re: Another blog bug

Posted by: Abwayax
Date: 2007-11-01 20:56:23
Fixed. Not sure what the hell was wrong with the query in the first place, but making it a SELECT DISTINCT query instead of a regular SELECT query seems to do the trick.