• Resolved Phillip Burger

    (@phillipburger)


    I am getting this error:

    [pid 857440] fcgid_bucket.c(153): mod_fcgid: stderr: PHP Fatal error: Uncaught Exception: Unknown column ‘settings’ in ‘field list’ in /…../wp-content/plugins/ninja-tables/vendor/wpfluent/framework/src/WPFluent/Database/Query/WPDBConnection.php:342

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Support Syed Numan

    (@annuman)

    Hello @phillipburger,

    Thanks for reporting this, and sorry for the trouble.

    The error indicates that the ninja_table_items database table on your site is missing the internal settings column that the current version of Ninja Tables expects.

    We have not been able to reproduce this on a normal installation. This type of database mismatch can sometimes happen after a site migration, cloning, database restore, or when a database upgrade is interrupted or blocked by server/database permissions.

    You can restore the missing column with the following steps:

    1. Please take a database backup first as a precaution.
    2. Open phpMyAdmin or your preferred database management tool.
    3. Select your WordPress database and run the following SQL query:
    ALTER TABLE wp_ninja_table_items
    ADD COLUMN
    settings LONGTEXT NULL AFTER value;

    If your WordPress database prefix is different from wp_, please replace it accordingly.

    After adding the column, reload the page and check whether the error still occurs.

    If you are not comfortable making database changes directly, your hosting provider should also be able to add the missing column for you.

    To help us understand how the database reached this state, could you also share:

    • What action you were performing when the error occurred
    • Your current Ninja Tables version
    • Your Ninja Tables Pro version, if installed
    • Whether the site was recently migrated, cloned, restored, upgraded, or moved between servers
    • Your hosting provider

    This information will help us investigate the scenario further.

    Thank You

    Thread Starter Phillip Burger

    (@phillipburger)

    Thank you ,that fixed it.

Viewing 2 replies - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.