Problem w/Links manager 3.0.2 w/zen 1.3.7

I updated my current version of Links manager with the new one 3.0.2 but still have the same problem I had with the old one. I created catagories, created links from admin, and have had others add links from customer login and for some reason the links are not showing up after I approve them. Only 2 of the links are showing and I don't understand what's wrong.

the site is here; http://www.digitaleyours.com

any help would be greatly appreciated. My link partners are getting frustrated with me.

Sorry, about this behaivor.

I'm fairly sure it some hitch with the database (which I'm tracking down and will get fixed asap.)

in the meantime, if you can access your database with phpmyadmin you can do the fix.

in phpmyadmin select your database:

scroll through and find the table zen_links_to_link_categories

Click on the table to open it and then click the browse button at the top of the screen.

you'll see two columns:

links_id and link_category_id

You can edit the table and manually add the correct links_id to match the appropriate link_category_id.

If you'd rather not do this yourself PM me.

It's a great module! However, I have exactly the same problem. I managed to display the links by changing the data in the database. I also found that if I add a link directly in admin not from the store website, the link is displayed ok without changing the database.

I wonder why the links_id is always set to '0' in links_to_link_categories when submit a link through the website. Is there any way to let the database set it to the number in accordance with the exact links id once the link is approved in admin?

Hizen:

It's a great module! However, I have exactly the same problem. I managed to display the links by changing the data in the database. I also found that if I add a link directly in admin not from the store website, the link is displayed ok without changing the database.

I wonder why the links_id is always set to '0' in links_to_link_categories when submit a link through the website. Is there any way to let the database set it to the number in accordance with the exact links id once the link is approved in admin?
I'm not sure why it behaves like that.

This happens when you go to the admin and edit/approve any of your links then they disappear(don't show up) from the links listing.

I'm working on trying to fix this problem. but in the mean time .. If editing/approving a link in the admin MAKE SURE THAT YOU SELECT A CATEGORY it can be the same as the original, you just have to select it before hitting the update button.

Good news. I found the solution! :-)

If link manager has been installed, go to the database, find links_to_link_categories, the default value for links_id '0' should be deleted, then select 'auto_increment' under 'Extra'.

For new install, part of the links SQL should be changed:

Find ->
DROP TABLE IF EXISTS links_to_link_categories;
CREATE TABLE links_to_link_categories (
links_id int(11) NOT NULL default '0',
link_categories_id int(11) NOT NULL default '0',
PRIMARY KEY (links_id,link_categories_id)
) TYPE=MyISAM;

INSERT INTO links_to_link_categories VALUES (1, 1);

change to ->
DROP TABLE IF EXISTS links_to_link_categories;
CREATE TABLE links_to_link_categories (
links_id int(11) NOT NULL auto_increment,
link_categories_id int(11) NOT NULL default '0',
PRIMARY KEY (links_id,link_categories_id)
) TYPE=MyISAM;

INSERT INTO links_to_link_categories VALUES (1, 1);

The solution is based on the idea of making the id value ( in links_to_link_categories ) generated automatically as the id value in links_description. Hope this will fix the problem.

Thanks, I'll run some test links and see how it works.