Gossamer Forum
Home : Products : Gossamer Links : Development, Plugins and Globals :

Bad columns / column clash.

Quote Reply
Bad columns / column clash.
Hi there Smile,

I wrote a very simple DB statement, that will fetch 5 rows from the database where link_id_fk = 31322.
When I tried to run the code, the following error messages was displayed:

Code:
GT::SQL::Relation (24222): Bad columns / column clash: columns named 'link_id_fk' have
been found in current relation, please qualify your expression at /path/to/admin/root/Common.pm line 93.

All I would like to know is, what does this error mean? I have looked on the internet doing a full text
search using Google, but the only results are Newspaper columns Unsure

I will try my best to add more information about this error as you request it. At the moment I'm more
concerned about the meaning of the error, than a solution...

Thank you for your help Wink


Sacrifice is not about what you lose,
it is about what you gain in the process.
Quote Reply
Re: [EZFrag] Bad columns / column clash. In reply to
Hi,

What happens if you rename that field to something else, make LinkID_FK or something? Sounds like it *may* calshing with one of the built in foreign keys in the glinks_Links table (just a stab in the dark, as I can't say I've ever come across that error)

Hope that helps.

Cheers

Andy (mod)
andy@ultranerds.co.uk


IMPORTANT: I've now moved to ultranerds.co.uk, and the .com will no longer work!
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500)
Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Compare our different Plugin packages *new* Free CSS Templates
Quote Reply
Re: [Andy] Bad columns / column clash. In reply to
Yes, I also believe that may be the case...

The core of the function I wrote, utilizes custom code someone else wrote.
So I created a global, bypassing that custom code, for now...

Thanks for your input, AndySmile


Sacrifice is not about what you lose,
it is about what you gain in the process.