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

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

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 ?

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

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.