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
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
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.