This one has me pretty much stumped... I had been testing my Links SQL install, and finally decided to switch it into use this evening. I emptied all of the link and category info from the tables (through phpMyAdmin), uploaded all of the Links 2 db and def files, and imported it without problems.

I then went and built the database (first trying it through cron). It built ok, except for one very odd aspect -- none of the links are showing up on the pages! All of the category and subcategory link totals show up correctly, and the grand total is fine, but there are no links...

I didn't make any changes to the templates since last testing a smaller database without troubles, so I can't figure out what's causing this. I tried deleting all of the old category directories in case the new build script didn't have ownership permissions, but that didn't change anything. It just recreated teh directories and still didn't add links to any of the pages...

Any ideas what could be wrong? Does something have to be done after importing to index the links/categories when the database is a certain size? I can't figure out what else would have changed.

You can see what's going on here:
http://www.run-down.com/links/

I'll be rebuilding the Links 2 setup at www.run-down.com until I can figure out what's going on.

Thanks,
Dan

Baffling...

After:

<!-- Links in this category. -->

in all your templates, do you have a:

<%links%>

tag?

Looking at your HTML, it's not inserting the links, so either you've left it out, or you are jumping past it in the nph_build.

Do you have a _VALID_ link.html file? It has to be there, or you'd have gotten an error, but it could be blank....

If you do figure it out, let us know, it's a good one for the fAQ





------------------
POSTCARDS.COM -- Everything Postcards on the Internet www.postcards.com
LinkSQL FAQ: www.postcards.com/FAQ/LinkSQL/

Glad you agree!

Here's what I've got in category.html:

<!-- Links in this category. -->
<%if links%>
<font face="Arial" size="3"><b>Links in <%category_clean%>:</b></font><br>
<%links%>
<%endif%>

I first tested the new Links SQL install with a full database of 4,500 or so links, and all the links showed up fine. I then redid things with a mini database of 87 links to make it easier to experiment with different aspects. Everything was working fine, so I cleared out the links and categories and imported the entire database. That's where I am now. I've tried clearing it and reimporting three or four times, building to two different locations (at different times), through cron and directly through nph-build.cgi, and still it refused to build the links into the pages???

I had to add this line at the start of nph-build.cgi:

use lib '/path/to/admin';

per Alex's suggestion in another thread to allow it to be run from a cron job. That worked for running it from cron, but whether or not that line is added doesn't seem to make a difference as far as including the links when nph-build.cgi is run directly.

I'm not getting any errors while building. It goes through the whole process, it just has (0) links everywhere. But the built category pages somehow know how many links should be there, and the links are correctly identified with their categories through both the admin and phpMyAdmin...

Can you tell that I'm thoroughly confused?

Dan

Call off the cavalry, I figured it out.

I just re-read your post and it hit me... Since it wasn't answered before, and it ties into what I just realized, I'll re-ask my question from this thread:

http://www.gossamer-threads.com/...um9/HTML/000718.html


Ok, so here's what happened. I had removed the Priority field from the tables before re-importing. However, I have this at the start of link.html:

<%if Priority < '1'%>
<IMG SRC="/images/run.gif" BORDER="0" WIDTH="15" HEIGHT="13" ALT="Priority <%Priority%>">
<%endif%>
<%if Priority > '0'%>
<IMG SRC="/images/runred.gif" BORDER="0" WIDTH="15" HEIGHT="13" ALT="Priority <%Priority%>">
<%endif%>

Gives a nice visual representation of priority listings. For some reason, having the priority tag with no priority field keeps it from building but does not throw any errors. I just added the priority field back in and re-built, and everything worked fine.

Good thing I don't have a big ego.

Thanks for the help,
Dan