Okay
  Public Ticket #1305212
Bug in foreign key
Closed

Comments

  •  11
    Issac started the conversation

    Hi, I am sorry to bother again, this is not a pre-purchase questions but rather finding bugs in the plugin to make the plugin better. 

    [In wpdatatables 2.0.2] 
    So basically when you are trying to use foreign key but the column name in foreign table is not one word , for example, like 'contact name' stuff like that, then the foreign key inserting is going to fail. The workaround without changing the title of the foreign column name to single word is to make the change as below in this file:

      /assets/js/wpdatatables/admin/table-settings/table_config_object.js

    at line 635, change the display_header to orig_header, then the sql command will not fail. 

    You are welcome and where's my cookie? :)

  • [deleted] replied

    Hi Issacchua,

    Thank you for reporting this.

    We spotted this bug already and we are working on a fix. Your proposition is good one and we will definitely consider implementing it when we checked all aspects.