We're Moving to a New Support Platform – Starting June 1st!

We’re excited to let you know that starting June 1st, we’ll be transitioning to a new support system that will be available directly on our product websites – Amelia, wpDataTables, and Report Builder. In fact, the new support platform is already live for Amelia and wpDataTables, and we encourage you to reach out to us there.

You'll always be able to reach us through a widget in the bottom right corner of each website, where you can ask questions, report issues, or simply get assistance.

While we still do not offer live support, a new advanced, AI-powered assistant, trained on our documentation, use cases, and real conversations with our team, is there to help with basic to intermediate questions in no time.

We're doing our best to make this transition smooth and hassle-free. After June 1st, this current support website will redirect you to the new "Contact Us" pages on our product sites.

Thanks for your continued support and trust – we’re excited to bring you an even better support experience!

Okay
  Public Ticket #3214426
Failure to create table
Closed

Comments

  • Zachary Kann started the conversation

    I'm trying to create a table from a Google spreadsheet. I published and shared the spreadsheet as indicated in the docs. However, when I hit "save changes" to create the table, I get a popup with this error message:

    Unknown column 'file_location' in 'field list'

    6799754177.png

    And the table does not get created. What do I do?

  •  1,894
    Miloš replied

    Hi, Zachary 

    Thanks for reaching out ot us.

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

    which was also added to the database as new columns 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.

    And you can run this SQL Query on your database ( via PhPMyAdmin for example),

    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;

    We can do that 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.

    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

  • Zachary Kann replied

    Running the alter table command you suggested, combined with the deactivate/purge/reactive/purge process, seems to have solved the problem. Thanks!

  •   Miloš replied privately