I have a toplist in my wrapper and it has always worked well on all my sites.
<!-- BEGIN TOPLIST --> <CONFIG>links,rand(),1,descending,longbanner !='',,,0,0,0,0,0,0,,0</CONFIG> <a href="link.php?id={LINKID}" {EXTERNALLINKS}>{LINKLONGBANNER}</a>&# 60;br > <!-- END TOPLIST -->
I have just noticed that this no longer displays on the details page. In checking, it appears that it has ignored longbanner not null, and is in fact trying to display that field for the link it is on. This isn't too bad (although not what I want) when that link had a longbanner, but when it doesn't there is of course nothing displayed.
I am not sure when this stopped working but, going through my sites, definitely from 5.0.41
Check wsnlinks_links in phpmyadmin. Does the longbanner field have NOT NULL set, and a default value of blank... or NULL set with a default value of NULL? It should be the former, the latter woudl cause the condition to not work.
Paul wrote: Check wsnlinks_links in phpmyadmin. Does the longbanner field have NOT NULL set, and a default value of blank... or NULL set with a default value of NULL? It should be the former, the latter woudl cause the condition to not work.
The former - Null is set to NotNull and default2 is blank
Comments on Toplist no longer works on details page
Expert
Usergroup: Customer
Joined: Aug 19, 2005
Location: England
Total Topics: 391
Total Comments: 1303
I have a toplist in my wrapper and it has always worked well on all my sites.
<!-- BEGIN TOPLIST -->
<CONFIG>links,rand(),1,descending,longbanner !='',,,0,0,0,0,0,0,,0</CONFIG>
<a href="link.php?id={LINKID}" {EXTERNALLINKS}>{LINKLONGBANNER}</a>&# 60;br >
<!-- END TOPLIST -->
I have just noticed that this no longer displays on the details page. In checking, it appears that it has ignored longbanner not null, and is in fact trying to display that field for the link it is on. This isn't too bad (although not what I want) when that link had a longbanner, but when it doesn't there is of course nothing displayed.
I am not sure when this stopped working but, going through my sites, definitely from 5.0.41
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
Check wsnlinks_links in phpmyadmin. Does the longbanner field have NOT NULL set, and a default value of blank... or NULL set with a default value of NULL? It should be the former, the latter woudl cause the condition to not work.
Expert
Usergroup: Customer
Joined: Aug 19, 2005
Location: England
Total Topics: 391
Total Comments: 1303
Check wsnlinks_links in phpmyadmin. Does the longbanner field have NOT NULL set, and a default value of blank... or NULL set with a default value of NULL? It should be the former, the latter woudl cause the condition to not work.
The former - Null is set to NotNull and default2 is blank
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
If I understood you, you're seeing something when there's nothing in the longbanner field. I'm not.
sandbox.webmastersite.net/w...operating-days-test-8.html
Created an admin login for you at your forum profile email.