Link Counter stuck at 152

[NRLMedia]

I know there are more than 152 links in my directory, however, when people submit links, it subtracts from 152 (ie. 30 pending so it says 122) and then adds back up to 152. Also, the link count in the actual link section is stuck at 148.

Any ideas?

{old non working urls removed}

[David]

I'm going to assume your PLD_LINK_SEQ is missing from mySQL

The sql to insert the table would be like this:
Content visible to registered users only.

Where you see 2751, change the value to the highest id in your phd_links table (id field), and this should solve your problem.

[NRLMedia]

Thanks fixed, let's just hope it didn't delete any links when it was doing that!

[David]

You probably lost a couple.
I think in 3.0 we will create a tool in admin to auto solve this problem.
You probably need a Category_SEQ table too.

Usually, this problem occurs when someone imports links or categories.

[meniac2000]

Thanks to all of you. This thread has been very helpful to me, as I have uploaded/imported tons of links over the last few days that are now constantly disappearing by each new link. :(

I did not use the "add link" button, but created manual sql queries in the database without knowing to increment link_seq as well.


Does this make the problem, as you have outlined in your last post, David?
If I increment the seq_id, will this allow manual sql then?
Hope that you can solve this "annoying feature" soon, :)

Looking forward to receive your comment, as this might be a problem to hundreds of users...

[David]

We need to add a feature to "sync" the counts.

[meniac2000]

> We need to add a feature to "sync" the counts.

Does that mean the following being correct:
If I increment the seq_id, it will allow manual sql until you release the next version with sync feature.

Regards
Michael

[David]

Once the table is in place and with the correct value, you should not have any problems ever again. I would use the sync feature to check the value, especially, for example, after importing links or categories.

[meniac2000]

What do you mean by saying "I would use the sync feature"?
Since which version is this feature available?

[temporarily lost umts connection. hope that I have not created a double-post]

[David]

Content visible to registered users only.

So lets suppose you are importing a large list of links from another application. If you do not update the link_seq table, you will have a problem, and therefore would need to sync the number with the total number of links.

[meniac2000]

> If you do not update the link_seq table, you will have a problem, and therefore would need to sync the number with the total number of links.

Okidoki, :) That's what I have manually done myself. Well, not exactly, I have not taken the number of links, as you have said, but took the highest ID of the link table into the link_seq table! Eg 500 links between 1 and 800 [deleted a few of them]. In this case, I would update to 800 within link_seq, correct?

Anyway, I thought that you have implemented an automatic sql query in your phpld interface, as you were talking about a feature. Sorry for the little misunderstanding!

I do have one more question:
Why does the number within the links listing on the administration module differ from the link number quoted underneith the link directory in public?

Thank you very much for your quick support in advance.
Cheers Michael

[David]

It sounds like you have solved the problem. So this problem ONLY occurs when importing links through phpmyadmin and bypassing the admin panel of the directory.

[meniac2000]

Content visible to registered users only.
Correct. It only happens if you bypass the admin panel. However, who wants to create 1000 step by step, :)

Can you please shortly comment on my last question within my last post:
Content visible to registered users only.
As far as I am concerned, this has nothing to do with the bypass...

[David]

That is a nice looking directory you have! :)

I didn't see where it listed the number of links of the front end of the site.

I guess we are dealing with 2 tables, so we would need to identify which count is incorrect. If there are no problems, maybe it is not worth worrying about it?

[meniac2000]

Content visible to registered users only.
Phone home? User tracking? How do you know my sitename?
I absolutely do not mind, but I am just curious...
Content visible to registered users only.
Down at the bottom! :)
Content visible to registered users only.
I only know of one. Which is the second?

Cheers
Michael

[David]

I may have got my conversations crossed.
I was referring to other site.
Sorry! :oops: