Categories - some are blank: WSN Support

Version: 4.0.7.

Categories - some are blank

DR
Experienced

Usergroup: Customer
Joined: Nov 16, 2005
Location: Colorado
Total Topics: 24
Total Posts: 72

Posted 05/09/07 - 08:17 PM:	#1
Not all Categories - just one or two - that I have found - one is sub-category - and one is a top level category ... Have looked in database to see differences - but can't find any ... Changed setup to show queries etc - [ but not sure what to look for ] .... there is no source code readable for the page - but the queries do show up ...the address bar shows I am in the right spot - but no luck ... Realizing that I need to upgrade - but this just seemed to happen on its own ? Any suggestions as to what/where I should look further ?? Thanks to all in advance ... DR
...there is no finish line...

Paul
Administrator

Usergroup: Administrator
Joined: Dec 21, 2001
Location: Northern California
Total Topics: 57
Total Posts: 6339

Posted 05/11/07 - 04:11 PM:	#2
I remember seeing something of this sort a few months ago, unfortunately I can't remember what the cause was. I've a vague memory that it may have related to url rewriting. I think the situation was avoided by later releases though.
"Do things you love doing, because then it ain't work. Don't do something you don't really enjoy, because you're never going to work hard enough at it." - Bob Young, founder of Red Hat

DR
Experienced

Usergroup: Customer
Joined: Nov 16, 2005
Location: Colorado
Total Topics: 24
Total Posts: 72

Posted 05/29/07 - 04:00 PM:	#3
Thanks Paul - will be updating shortly: In Reference to the Manual - Re Blank Screen: http://scripts.webmastersite.net/wsnlinks/wsnmanu... Point #2: "Cause: You've just upgraded to a new version, but fields couldn't be added properly, and each category has become a blank page. Solution: You probably have a broken mysql table index. Use phpmyadmin to look at the structure of your wsnlinks_links table. At the bottom is a list of indexes. If 'wsnindex' lists the same field twice, delete it. Then re-run upgrade.php." Well I didn't find that specifically for wsn_links - but in "Categories" I did find this "duplication"?: - [please see attachment] Not sure how it got this way ... Could this be messing up some of the categories - so that they are not visible ? Thanks DR
Attached Files: unique and index keys.png (7 KB, 36 downloads) ...there is no finish line...

Paul
Administrator

Usergroup: Administrator
Joined: Dec 21, 2001
Location: Northern California
Total Topics: 57
Total Posts: 6339

Posted 05/31/07 - 03:58 AM:	#4
You should delete the id_2 index (can't say I've seen an index with that name before), but I don't think that would be causing blanks.
"Do things you love doing, because then it ain't work. Don't do something you don't really enjoy, because you're never going to work hard enough at it." - Bob Young, founder of Red Hat

DR
Experienced

Usergroup: Customer
Joined: Nov 16, 2005
Location: Colorado
Total Topics: 24
Total Posts: 72

Posted 06/11/07 - 01:24 PM:	#5
Ok - Thanks - I successfully deleted ID_2 in phpmyadmin: Also came across in the "wsnlinks_members" area in phpmyadmin this comment: [see attachment] Wondered if you had any thoughts on this Thanks again in advance DR
Attached Files: members.png (8 KB, 26 downloads) ...there is no finish line...

DR
Experienced

Usergroup: Customer
Joined: Nov 16, 2005
Location: Colorado
Total Topics: 24
Total Posts: 72

Posted 06/19/07 - 02:56 PM:	#6
I felt that I needed to update these posts: As I did not want others who might be looking at using WSN Links to think that this was an unresolved problem. Once again - error on my part was causing certain Categories to show blank: See this thread for the error of my ways: Post #9 http://www.webmastersite.net/forums/thread/6351 - and once again - Paul - "WSN Links is fantastic" Thanks DR
...there is no finish line...

You don't have permission to post.