sample categories data for download

[seothatworks]

I have made a basic categories structure for a general topics directory available for download at:
{url removed because it is no longer active}

It is in sql format, I think over 200 cats, make sure you have the pld_category and pld_category_seq tables emptied before inserting these.

Would you ever decide to use it besides for testing purposes, remember to at least change few things here and there, it helps not to have the same structure as everybody else....

[David]

Excellent! :)
I still haven't figured out how to grant the priviledge to use the attachment feature, but I will go ahead and add that as an attachment here as a backup as well.

[KoverPL]

hi, how to crete this in mysql ? what do i need to do ? :) thx.

[David]

Go into phpmyadmin and paste the contents of the .sql file as a "sql" statement and hit submit.

Make sure you have a backup of your database before doing anything.

[KoverPL]

i get error:
{url removed because it is no longer active}

what now ? :/

[David]

try deleting
PLD_CATEGORY
PLD_CATEGORY_SEQ
before running the code
(please backup first if above tables contain important data)

[KoverPL]

now this:
{url removed because it is no longer active}

:(

[ccnetz]

New to the phpld world and very happy with it so far.

Has anyone had any luck dumping this into their tables? I did exactly what this post says and it will not work for me. I have deleted the tables and tryed copy/paste, no work. I have tried emptying the tables and then adding the file. Still no luck.

Any help/suggestions would be greatly appreciated.

[KoverPL]

i ded the same things and also error :(

[Optimit]

Wouldn't you have just spent less time making your own unique category stucture?

[KoverPL]

hmmm i think this will be the best way :)

[Neticus]

From what i have experienced:

In phpld pld_category_seq table is not created until you have at least one category created manually.
If you do not have a pld_category_seq table then create a test category in admin. Then delete.
You should have a pld_category_seq table after this.

Also try changing in download file all:

pld_category_seq
pld_category

to

PLD_CATEGORY_SEQ
PLD_CATEGORY

-

[KoverPL]

I cahnged php.. to PHP... and now should it work, but there is a problem with the code i think:
{url removed because it is no longer active}

[Neticus]

error: Column dosen't match value count at row 1

I see this mod was posted in july 2005
Since then extra rows have been added for 'symbolic categories' feature.
These extra row values have to be added to the download code as you can see below two extra '0' '0' have been added at the end.

Old code
(1, 'Arts and Culture', 'arts_and_culture', '', 0, 2, '0000-00-00 00:00:00', 1);

New:
(1, 'Arts and Culture', 'arts_and_culture', '', 0, 2, '0000-00-00 00:00:00', 1, 0, 0);

Unfortunately you are going to have to do this for every line in the download.

If this is all a bit too much, i suppose you could find someone with current v2 categories installation and ask them to copy their pld_categories and pld_categories_seq by sql to you. This way all relevant rows will be filled and perhaps no conflict. My directory is not a general so I can't help you there.

[KoverPL]

ah ok thx for info :)

[ccnetz]

Content visible to registered users only.

Yes, it now appears so. But, I liked a lot of the categories listed and was going to add to it. Plus, I am trying to learn - not copy.

Thanks to all who replied and helped. Very nice community here.

[Burt]

I have a working file if you want, updated to the new code but I don't see a way of attaching it.

[ccnetz]

Thank you for the offer. Not sure how to attach. You can email me at:

ccnetz at gmail.com

Once I get a good working copy and add to it, I will share it.

[ccnetz]

Got it and thanks. I am still having probs though. Get this error when trying to add:

Content visible to registered users only.

Will not give up though :=)

[anon]

Content visible to registered users only.

[ccnetz]

I am entering the ";" at the end of the line when trying, the example I gave above is a direct quote from phpMyAdmin page.

Thanks for the sharp eye though.

[kwbrayton]

Hope I'm not violating forum policy here, but for those interested in using the current beta version 3.04 of phpLinkDirectory, I have created an updated version of a sample PLD_Categories table that I found on another forum. This is a modification to the categories originally posted someone calling themself "soul-hedger" on the Digital Point forum. You can grab a copy of the updated SQL code to create the files from my web site:

http://www.checkcollectionsguide.com/index.php/about_us/link_exchange/phplinkdirectory.html

Enjoy!

[arindra]

@ anon the " ; " was :D

[anon]

hahaha
:p

[shzor]

did anyone use this?

[technomatters]

its is having problems, please upload once again with sql "drop if exist" option in phpmyadmin.