MySQL Error: Unknown column 'foreignFieldNum' in 'where clause'

5 posts by 3 authors in: Forums > CMS Builder
Last Post: May 15, 2012 (RSS)

Archived
Reply
Reply

By Rewmer - May 12, 2012 - edited: May 12, 2012

Im getting the above error when trying to add another record to DB. Anyone got any pointers.

Re: [Rewmer] MySQL Error: Unknown column 'foreignFieldNum' in 'where clause'

Archived
Reply
Reply

By Jason - May 14, 2012

Hi,

The error looks like a relatedRecords field that wasn't set up correctly. If you just added a relatedRecords field, you should go into this field and change "foreignFieldNum" to the name of the field in the foreign table that you are related records on.

Hope this helps

---------------------------------------------------
Jason Sauchuk - Project Manager
interactivetools.com

Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/

Re: [Rewmer] MySQL Error: Unknown column 'foreignFieldNum' in 'where clause'

Archived
Reply
Reply

By Rewmer - May 15, 2012

Thanks Jason, Ive had a play around but to be honest I dont know what Im doing. Damon set up a sort field for me and its since he did this that I have been having problems.Im also now getting errors on a new editor I set up "Shows" when I click on the section I just get "getRecords(shows): Unknown field 'title' in filenameFields or titleField options!"

Any guidance ?

Re: [Rewmer] MySQL Error: Unknown column 'foreignFieldNum' in 'where clause'

Archived
Reply
Reply

By Damon - May 15, 2012

Hi,

It sounds like you have "title" in some fields for the "Shows" section editor but are no longer using the "title" field.

Go to Admin > Section Editors > Shows, then under the General tab, replace "title" with another field name you want to use.

Next, click on the Viewer URLs tab and for the Filename Fields, replace "title" with another fieldname.

If you can send in a Support Request with the site details, I can look into this and the 'foreignFieldNum' in 'where clause' issue.

Here is the link:
https://www.interactivetools.com/support/email_support_form.php?priority=free&message=for%20this%20forum%20post%20http://www.interactivetools.com/forum/gforum.cgi?post=93297#93297

Cheers,
Damon Edis - interactivetools.com

Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/

Re: [Damon] MySQL Error: Unknown column 'foreignFieldNum' in 'where clause'

Archived
Reply
Reply

By Damon - May 15, 2012

Update:

The MySQL error was caused because the DragSortOrder field was set as Related Records.

I deleted it and then recreate the DragSortOrder field and that solved the issue.

If any other issues come up, please let me know.

Cheers,
Damon Edis - interactivetools.com

Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/