10,000,000 entries and going strong

[avva]

Hurray LiveJournal!

Comments

Cheater!!

[brad.livejournal.com]

mysql> select itemid, posterid, logtime, security from log 
       where itemid between 9999998 and 10000002;
+----------+----------+---------------------+----------+
| itemid   | posterid | logtime             | security |
+----------+----------+---------------------+----------+
|  9999998 |   301145 | 2001-09-03 20:32:36 | public   |
|  9999999 |   111931 | 2001-09-03 20:32:36 | private  |
| 10000000 |   111931 | 2001-09-03 20:32:37 | public   |
| 10000001 |   111931 | 2001-09-03 20:32:37 | private  |
+----------+----------+---------------------+----------+
4 rows in set (0.02 sec)

Re: Cheater!!

[onefish.livejournal.com]

Yeah, there's something fishy about that.

http://www.livejournal.com/go.bml?itemid=10000000&dir=prev will take you to entry #9944158, but http://www.livejournal.com/go.bml?itemid=9944158&dir=next will take you to entry #9999999 and give you a protected entry error. Is this "skipped entry" a bug report, BTW? :p

Re: Cheater!!

[bradfitz.livejournal.com]

*shrug*

Maybe.

Fix it. :P

Re: Cheater!!

[onefish.livejournal.com]

Ah, but I've only ever messed around with the MySQL/Apache/PHP trio.. afraid you'll need someone with more programming experience to handle that. ;)

Re: Cheater!!

[avva.livejournal.com]

Yeah, there's something fishy about that.

yer'all just jealous ;)