Where was the data inserted to?

[mycolumbus]

I'm using DMOZ Extractor and have just imported 10 rows to my database, but can't find them. I didn't import the categories as I already have categories setup. I just would like to populate my existing categories with links.

My links text file has rows looking like:

80 Top/Arts/Movies/Titles/1/10_Rillington_Place British Horror Films: 10 Rillington Place http://www.britishhorrorfilms.co.uk/rillington.shtml Review which looks at plot especially the shocking features of it.
80 Top/Arts/Movies/Titles/1/10_Rillington_Place MMI Movie Review: 10 Rillington Place http://www.shoestring.org/mmi_revs/1...ton-place.html "Review includes plot, real life story behind the film and realism in the film."

plus another 8 rows.

The above 5 fields are link_id, category_id, title, url, description.

As you can see, the link_id should be increasing from 1 and category_id should be 80. I forgot to add link_id and remove category_path.

When I went to Import Table in the Control Panel I filled in the following fields as:

Table: Link
File Format: Extreme DMOZ Extractor
Start ID: 1

Then I clicked the Import button. Can anyone help me as to where the data was imported to? Or was it not imported at all?

The following response was then given in the control panel:


insert into idx_link (category_id, title, url, description, date, password, suspended) values (Top/Arts/Movies/Titles/1/10_Rillington_Place, 'http://www.britishhorrorfilms.co.uk/rillington.shtml', 'Review which looks at plot especially the shocking features of it.', '', now(), '8070',0)

I've looked thru the `idx_link` table, but can't find the data. I have noticed though 1 of my categories indicates more links than it contains when viewing it thru the browser. I've clicked on Update Number of Links in the control panel, but this doesn't fix the problem.

Any ideas??

[mycolumbus]

On a further note, whenever I now add a link, the link count increases by 1 in the category it is supposed to and a further category which seems to be corrupt.

[mycolumbus]

Well, the only solution I found was emptying the category and link tables directly from the database. Then I uploaded the data using the correct format. Took me a while to work out all the fields and so forth... But finally done. Now I can start using DMOZ Extractor.