Okay
  Public Ticket #3188341
Unknown column 'file_location' in 'field list'
Closed

Comments

  • Tomi started the conversation

    When I try to save changes to any of my datatables in the backend it just creates an error message:

    Unknown column 'file_location' in 'field list'

    I can't make any changes to the tables nor create new ones. Please help!

  •  1,850
    Miloš replied

    Hi, Tomi 

    Sorry for the delay

    -

    Basically, what happened is, during an update, we've included new features , 

    which was also added to the database as new columns ( in this case 'file_location') in the 'wp_wpdatatables' table. 

     ( wp_ prefix is the default WordPress table prefix,

      but on your database, the table prefix might be different) 

    For some reason, the plugin couldn't create these columns, which resulted in the error - the plugin tried pulling the data,   while the columns were never created. 

    To prevent this from happening again in the future, you can reach out to your hosting provider and have them check if the plugins have the necessary permissions to create/update database tables.

    -

    There are two ways we can fix this for you right now.

    1. The easy way :

    Please deactivate wpDataTables plugin,

    purge cache on your site;

    reactivate the plugin;

    purge cache again,

    and see if the issue goes away


    2.

    If the issue persists, i can easily add this column in your database, if you could grant me access to your WP-Admin and the database.

    -

    Please provide me a temporary WP-admin (administrator) user for your site where this happens, 

    and database access ( URL with credentials for PHPMyAdmin or cPanel access),

    so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue. 

    We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course, we do not provide login data to third parties. 

    You can write credentials here just check PRIVATE Reply so nobody can see them except us.

    Kind Regards, 

    Miloš Jovanović
    [email protected]

    Rate my support

    Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/

    wpDataTables: FAQ | Facebook | Twitter | InstagramFront-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia demo sites | Docs | Discord Community

    You can try wpDataTables add-ons before purchasing on these sandbox sites:

    Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables

  •   Miloš replied privately
  • Tomi replied

    Hi!

    Thanks for the fast and thorough answer! Deactivating and activating worked, but thanks for the recording anyway. 

    Have a great week!

    -Tomi

  •   Miloš replied privately