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

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.