2

I want to create a table during the activation of the plugin, so I used the code as follows:

class Database
{
    private $db_version = '1.0', $table_prefix;

    public function __construct()
    {
        global $wpdb;
        $this->table_prefix = $wpdb->prefix;
        register_activation_hook( PLUGIN_INDEX_FILE, array($this, 'dbSetup') );
    }

    public function dbSetup()
    {
        $countriesSQL = "CREATE TABLE $this->table_prefix . countries (
            id int(11) UNSIGNED NOT NULL,
            country_code varchar(2) NOT NULL DEFAULT '',
            country_name varchar(100) NOT NULL DEFAULT '',
            PRIMARY KEY  (id)
        ) $charset_collate;";
        dbDelta( $countriesSQL );
    }
}

But during the activation of plugin, it throws the fatal error as,

Fatal error: Call to undefined function dbDelta() in wp-content/plugins/myPlugin/libraries/Database.class.php on line 26

In some forums, some are suggesting to use, require_once(ABSPATH . 'wp-admin/includes/upgrade.php'); before the function call.

It is working. But I just wanted to know, if it is this the right approach? How to use the dbDelta in the correct manner to make it work?

  • 2
    dbDelta is defined in wp-admin/includes/upgrade.php file and used for updates/upgrades so it is not guaranteed that the file is always loaded and you have to require it to make sure. require_once does just fine as it will not load the file more than once.. – Samuel Elh Jan 31 '17 at 19:20
6

You answered your own question. You need to include the upgrade.php file which contains that function. Otherwise won't be loaded on your plugin update and the function won't exist.

require_once(ABSPATH . 'wp-admin/includes/upgrade.php');
| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.