Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Unable to add Link - Help!

Quote Reply
Unable to add Link - Help!
I just upgraded from Links SQL 1.13 to 2.0.3. Everything went fairly until I tried to add a new link.

I get the following error:
"Unable to add link - Column LinkOwner breaks foreign key relation with the L3Users Table".

What does this mean and how can I correct it?

Thanks in advance!!

Quote Reply
Re: Unable to add Link - Help! In reply to
It means that your LinkOwner is not in your L3Users table.
For example, before you add a link by a LinkOwner named "admin", you must have a Username named "admin" in your L3Users table.
So if you use "admin" as a LinkOwner and you don't have a Username named "admin", try to add a user named "admin" (in your L3Users table).

Quote Reply
Re: Unable to add Link - Help! In reply to
hmm I f I have right, the LinkOwner is related to the Users table
LinkOwner is foreign key to Username.
username is primary key of the Users table.
you are talking about L3Users.
I think it should be Users in your case,
add.cgi can't find the Users table, and have no idea to place content in Contact_Name & Contact_Email.
This contect will be placed directly into the Users Table (after validation)


Quote Reply
Re: Unable to add Link - Help! In reply to
Fortune,

Thanks so much for your help!!

Your advice solved the problem.

Mark Geyman
OhioBiz

Quote Reply
Re: Unable to add Link - Help! In reply to
Thanks for your help!


Mark Geyman
OhioBiz