You must be counting wrong or not understanding that not every id in the database corresponds with an active link, because your queries show it's ordering id descending. Though really you should order it by time descending, since ids don't have to be sequential if the autoinc gets reset to a deleted spot.
Run this query in phpmyadmin: SELECT * FROM wsnlinks_links WHERE validated=1 AND hide=0 AND deleted=0 AND inhidden=0 AND (invisibleto NOT LIKE '%|1|%') AND effectivetime < 1221539865 AND alias=0 AND inalbum=0 ORDER BY id DESC LIMIT 0,10
Does that give you what you expect? If not, does SELECT * FROM wsnlinks_links WHERE validated=1 AND hide=0 AND deleted=0 AND inhidden=0 AND effectivetime < 1221539865 AND alias=0 AND inalbum=0 ORDER BY id DESC LIMIT 0,10
give you what you expect? If not, does SELECT * FROM wsnlinks_links ORDER BY id DESC LIMIT 0,10
give you what you expect? If not, your mysql is insane or you somehow have id as a non-integer field.
Since the second gives what you expect, that means #1704 is marked as not being visible to guests (and possibly other groups). Probably relates to the recent 5.0 issue, but I don't see how it could've gotten into 4.1, unless it was always that way and somehow never noticed. Backporting the 5.0 fix now.
Comments on bug in Top List
Forum Regular
Usergroup: Customer
Joined: Feb 19, 2003
Total Topics: 23
Total Comments: 106
Hi on my homepage:
http://truefresco.org/link_directory
on the bottom is a toplist with 10 latest links.
well the latest link in the list has ID of 1699, however thereare sites added after that with IDs 17XX
any advise?
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
You must be counting wrong or not understanding that not every id in the database corresponds with an active link, because your queries show it's ordering id descending. Though really you should order it by time descending, since ids don't have to be sequential if the autoinc gets reset to a deleted spot.
Forum Regular
Usergroup: Customer
Joined: Feb 19, 2003
Total Topics: 23
Total Comments: 106
this is what i have in template
links,id,10,descending,,,,0,0,0,0,0,0,,0
abou t 10 sites are added after "newest" that list shows
it only stared happening with id going over 1699
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
If you had link ids displayed anywhere I could comment, but since you don't I can't say anything beyond post #2.
Forum Regular
Usergroup: Customer
Joined: Feb 19, 2003
Total Topics: 23
Total Comments: 106
is this what you are asking about - site with link ID 1704
Modern Metal Art by Nicholas Yust
www.truefresco.org/link_dir....php?action=detail&id=1704
the site on the top of the list on the home page - "10 most recently added" in (descending) order is 1699
â—André Ponce - painter
www.truefresco.org/link_dir....php?action=detail&id=1699
as you can see the
Modern Metal Art by Nicholas Yust should be in the list above
â—André Ponce - painter
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
Run this query in phpmyadmin:
SELECT * FROM wsnlinks_links WHERE validated=1 AND hide=0 AND deleted=0 AND inhidden=0 AND (invisibleto NOT LIKE '%|1|%') AND effectivetime < 1221539865 AND alias=0 AND inalbum=0 ORDER BY id DESC LIMIT 0,10
Does that give you what you expect? If not, does
SELECT * FROM wsnlinks_links WHERE validated=1 AND hide=0 AND deleted=0 AND inhidden=0 AND effectivetime < 1221539865 AND alias=0 AND inalbum=0 ORDER BY id DESC LIMIT 0,10
give you what you expect? If not, does
SELECT * FROM wsnlinks_links ORDER BY id DESC LIMIT 0,10
give you what you expect? If not, your mysql is insane or you somehow have id as a non-integer field.
Forum Regular
Usergroup: Customer
Joined: Feb 19, 2003
Total Topics: 23
Total Comments: 106
first one gives everything just like the site - 1699 ID is on top (1704 does not show)
second one - gives correct order (however for some strange reason - fonts in phpMyadmin are larger, when i use that string..?)
last one - gives all, including deleted links - 1705 ID (deleted link) is on top and 1699 is below
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
Since the second gives what you expect, that means #1704 is marked as not being visible to guests (and possibly other groups). Probably relates to the recent 5.0 issue, but I don't see how it could've gotten into 4.1, unless it was always that way and somehow never noticed. Backporting the 5.0 fix now.
Forum Regular
Usergroup: Customer
Joined: Feb 19, 2003
Total Topics: 23
Total Comments: 106
i am not sure what do you mean by "Backporting the 5.0 fix now" - I did not get any updates in my admin.
is there a file i need to download?