DMOZ Import Mod bug fix

[f1gm3nt]

Sorry to all, but it seems that the latest release of the DMOZ Imort mod had a major bug in it. It was a basic typo and is my fault. If you have used it and tried to run convert.php you've noticed an error. Here's how to fix this error. Goto line 10 or so where you should see
Content visible to registered users only.
Now all you will have to do is add $dmoz like this
Content visible to registered users only.
And it will now work. Sorry it's my fault and I should have tested it more before releasing that version. I'm working on a newer version right now and hope to have it more integrated into phpLD in the future. If you guys find any more bugs/my screw ups let me know here. Thanks

- Joshua

[David]

Thanks, f1gm3nt

I need to try it again. I didn't get it working last time.
Can we see again a good example url where you completed the import?

[latino]

Hi:

Convert.php now runs BUT I am receiving this error:

SQL ERROR:1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's Bay','St._Ann%27s_Bay','','230','2',NOW(),'0')' at line 1

I am trying the Regional/Caribbean from dmoz...

Thanks again.

:wink:

[f1gm3nt]

Not sure I've looked at the code and it should have escaped all the ' I'm still looking into it and see if I can find you a solution.

[porl]

The Dmoz import mod - it is basic but very good as far as function goes.
Problem is - I cannot make it work - all it ever does is say 'crawl complete' - inside 2 seconds. I pit in the caregory in the correct format, database details are in.

What possibly am I doing wrong?

I can see how it works - basically strips the info out of the page, copies it and writes it into the database.

In advance - thanks.

[f1gm3nt]

What category are you trying to crawl? Also be sure to insert a row into the table dmoz. This should be the url you want to crawl. Also inside class.dmoz.php place that same link/category. I'm not sure what you could be doing wrong.

It is a very basic script and sort of a pain to get to work if you are a bit of a noob. If you can post as much info here or just send me a PM. What is your web site's URL? Does it even say that it has added anything else to crawl? After running crawl.php it's pretty much useless until you've emptied the tables and and started over again.

-Joshua

[amar]

Convert seems to have a problem with categories made up of more than one word. It makes multiple copies with no sub-categories or links and the PID is 0.

[kiwifella]

Content visible to registered users only.

Anyone know a fix for this? Its got me beat:(

[ad1]

f1gm3nt...can you help me...

I am not quite sure of the way to insert the directory into dmoz table.

From phpmyadmin - I tried to add default value with the directory as "http://www.dmoz.org/heath"

I would like to copy dmoz.org/health/

Crawl.php seems to load too quicky (1-2 sec then completed)...i think the path is wrongly inserted???



help would be much appreciated.

[ad1]

ahh....i found the way to do it.

Here is my way:

login to phpmyadmin
click on "dmoz" table
click insert

Insert "http://www.dmoz.org/Health" to Field "url" (twice)
Without changing any other thing

[webwriter]

I've added the url to the DMOZ table twice as suggested and it still doesn't crawl anything.

When adding the URL to the DMOZ table, I added the full URL, not just the part after dmoz.org. Maybe it just needs the suffix instead of the full http: URL?

[ad1]

I think there is bug still..

it can't import category with apostrophe like (men's health)

[Magic_Maccaroni]

I am very intrested in this Dmoz import thing, but does it work?
Where do I find instructions??
Is it worth trying? Everybody saying that there isn´t an stable version.
plz let me know if there is one.
mail me {email address removed} and I´ll give you a featured link or two in my directory for your effort.

[jminscoe]

I am getting this error SQL ERROR:1054: Unknown column 'crawled' in 'where clause'