Unlimited number of categories

[5websearch]

Well, this surprised me a lot! Today I got 2153 categories in my directory, and the number will not change at all. When I try to add a new category, it overwrites an existing category.

This is now a huge problem for me, and I will not add any new category until this is solved.
What type of code need to be changed in what file?

Please give me response on this. A part of the directory is now a completely mess! :roll:

And beside, there is no information about number of categories limit on this page:
{url no longer in service}

[Ap0s7le]

That's because we don't limit them.

Sounds like your SEQ table is off. Find the highest number ID in the LINK table, and add 1 to it and add that number into the LINK SEQ table.

Know what I mean?

If not, I can do it for you.

-Casey

[5websearch]

Ok. Then you got no limit then.. sorry! :oops:

Well, what do you mean with "add 1 to it"

I will give you some screenshots from my phpMyAdmin panel:



Here you got the PLD_LINK wirth the hightest link ID ("98")


Here you got the PLD_LINK_SEQ


Use the field name, so I know what to type in where. phpMyAdmin is not a small program :wink:

[Ap0s7le]

Haha, block out the name of the site, we all know that served a real purpose.

Anyhow. I messed up and rather than your LINK table, do it in your CATEGORY table.

If your highest CATID is 98 (for example), then open up the CAT SEQ table, and edit the numeric row and add 1 to 98, which would make 99.

Then save your change.

Try inserting a new CAT through PHPLD and see if it overwrites anything.

-Casey

[5websearch]

My hightest category_ID is 2169, thank you! :lol:

And my PLD_CATEGORY_SEQ contain 7 fields:

- Field
- Type
- Lenght/Values
- Attributes
- Null
- Default
- Extra

SO... where do i type the [***] number :P

Sorry, but I did not understand this 1 to 98... pardon my knowledge in MySQL, but it's very bad :wink:

[5websearch]

Beside, in the PLD_CATEGORY_SEQ table, i did change the id to be 202...

I hope it will work now, after I have cleaned up the mess from this overwrite error "thing". :twisted:

[Ap0s7le]

So you like know nothing I take it.

Once looking at the table where you gave me the FIELD list, hit browse and then EDIT the only ROW in the table, change the ID's value to whatever the highest # was in your CAT table plus 1.

Let me know if you're lost and if so I'll just write a dang script for this.

-Casey