I just went ahead and installed the latest beta, tried to import my SQL1 data, and the form tries importing with a file named "import.cgi", which was not installed with this version. I have found a file called "nph-import.cgi", should I be trying this one from telnet?

Basically what happens when you try to import data is just a page not found error message.

If someone could e-mail me a copy of the latest import.cgi file it would be greatly appreciated! (rob@aaainternet.com)

Rob Bartlett
AAA Internet Publishing, Inc.
http://www.AAAInternet.com

I thought i was the only one....

Yeah I'm confirming this ....

Hi,

I can't belive that got by. Yes, you should use nph-import.cgi. I've updated the distribution so the action tags point properly.

Cheers,

Alex

--
Gossamer Threads Inc.

Well, in the latest release, import.cgi has been changed to nph-import.cgi. Unfortunately, not everything was updated properly to reflect the change! :(

The text interface to it should work correctly. will show you the options to use it.

The fix to nph-import.cgi is the following:

admin/Links/Import/Interface/CGI.pm:

On lines 154, 168, 300, and 330 change "import.cgi" to "nph-import.cgi". (A simply global replace of "import.cgi" to "nph-import.cgi" will work too).

Jason Rhinelander
Gossamer Threads

Ok, kewl, the import works now, but I got the following error message when I imported some of my categories. The categories producing the error message appear to be contiguous:

Import error: WARNING: No father row found for Regional/Oceania/Art and Culture! This may be a serious error as Regional/Oceania/Art and Culture should probably have a father category

Does this message mean that the categories may be corrupt?



Rob Bartlett
AAA Internet Publishing, Inc.
http://www.AAAInternet.com

If you can, look at your old category list.

Select for all the categories begining with Regional/Oceania

If you don't see a category with that name, or just Regional, what it probably means is you had what are technically "orpan" categories floating around.

If not.... it probably means the program is having problems with " " <G>

PUGDOG®
PUGDOG® Enterprises, Inc.
FAQ: http://postcards.com/FAQ

I just ran the "rebuild tables" command, and for some reason it thinks that all of those categories producing errors are root categories now. So you are right, they became orphans somehow... =P At least there aren't that many to fix I guess.

Rob Bartlett
AAA Internet Publishing, Inc.
http://www.AAAInternet.com

If you imported from Dmoz, this is a problem I've hit. I don't know if the original .rdf was bad, or confusing, or if the import script goofed. But, you get a few orphans.

The problem is they look like they are there in the 1.1x versions, but they just don't build properly. Sometimes you would get the error the directory didn't exist, sometimes you wouldn't. For some reason some of the "orphans" got built. If you deleted the pages directory then rebuilt compeletly, sometimes you'd see more errors.

Anyway, it's good that Links 2.0 is catching this... _BUT_ the correct behaviour should be to create the missing category, and move that "tree"to a problem category, so it can be evaluated then moved back into the main tree. Otherwise, you could end up with 250 root categories that should have been sub-categories of missing category.

PUGDOG®
PUGDOG® Enterprises, Inc.
FAQ: http://postcards.com/FAQ

Actually, all I was doing was importing my categories/links from SQL1, the categories are even empty, I am not sure exactly how this happened.

Well, I got a chance to get some experience with the browser so I could fix things anyway. Works pretty slick!

I figured out what the problem was. Somehow, the "father" category for those three trees of links managed to get shoved under a different category...which is what stuffed them all into the root.


Rob Bartlett
AAA Internet Publishing, Inc.
http://www.AAAInternet.com

I meant the original import from dmoz to your SQL 1.

In the sql monitor of your old links, issue:

select * from Category where Name LIKE "Regional/Oceana%" order by Name

ANd see what you get. You might find the missing category level there.

PUGDOG®
PUGDOG® Enterprises, Inc.
FAQ: http://postcards.com/FAQ

No, the links were all done manually, they were not imported from dmoz. The links were all done with Links 2.0, then I imported them into SQL1.13 (before the import for 2.0 was working), then into SQL2.0beta.

On the subject of dmoz, are there any kind of copyright issues to worry about? Also, where can I find some instructions on how to import from dmoz?

Thanks,



Rob Bartlett
AAA Internet Publishing, Inc.
http://www.AAAInternet.com

Yeah Pugdog, I think that this is what is happening with my database as well (the rdf dmoz problem). Alex, is it possible to have the import script overcome this problem? I don't even know where to start to correct this problem manually.

This is the error I am getting now that I upgraded to the latest beta...

Import error: CRITICAL ERROR OCCURED: Unable to insert category `Arts and Entertainment' (SQL query: `INSERT INTO Category (ID, Name, FatherID, Full_Name, Description, Meta_Description, Meta_Keywords, Header, Footer, Number_of_Links, Has_New_Links, Has_Changed_Links, Newest_Link) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)'): Unknown column 'FatherID' in 'field list' at Links/Import/S1S2.pm line 15

Hi,

We'll add this into the import.

Cheers,

Alex

--
Gossamer Threads Inc.