Okay
  Public Ticket #3240104
Bug after update
Closed

Comments

  •  1
    Thomas started the conversation

    Hi,

    after the latest plugin update I get the error " Unknown column 'file_location' in 'field list'" when trying to save changes


    Can you help please?

  •  1,849
    Miloš replied

    Hi, Thomas.

    Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.

    -

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

    which was also added to the database as new column(s) in the 'wp_wpdatatables' plugin 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 the columns, which resulted in the error - the plugin tried pulling the data,   while the columns were never created. 

    To fix this now and to prevent this from happening again in the future, 

    you can run this SQL Query on your database ( via your Database Management software, such as PHPMyAdmin),

    ALTER TABLE `wp_wpdatatables` ROW_FORMAT=DYNAMIC;

    As mentioned before, the wp_  table prefix might be different in your WordPress database, and if so, the Query would be

    ALTER TABLE `yourDBprefix_wpdatatables` ROW_FORMAT=DYNAMIC;

    This should allow our plugin to add new columns for this table during updates ( when needed).

    We can run this Query for you, if you are not familiar with using PhPMyAdmin.

    -

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

    1. The easy way first :

    Please deactivate wpDataTables plugin,

    purge cache on your site;

    reactivate the plugin;

    purge cache again,

    and see if the issue goes away, let me know.

    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.

    Let me know how it goes. Thank you.

    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

  •   Thomas replied privately
  •   Miloš replied privately
  •   Miloš replied privately