Plugin can't create table
-
Good evening.
I am newbie @ wordpress plugin programming.
Briefly..
In my index plugin file i am requiring once for functions file in which i have writen IF function for “if installation file (setup.php) exists -> include setup.php and register_activation_hook for table installation function”.
Here is setup.php code:// Setting up table version for later upgrades global $sarsauto_version; $sarsauto_table_version = "0.1."; // Creating table function sarsauto_table_setup() { global $wpdb; global $sarsauto_table_version; $table_name = $wpdb->prefix . "sarsauto"; if( $wpdb->get_var( "show tables like '$table_name'" ) != $table_name ){ $sql = "CREATE TABLE " . $table_name . " ( id int(11) NOT NULL AUTO_INCREMENT, UNIQUE KEY id (id) );"; } // The dbDelta function examines the current table structure, // compares it to the desired table structure, and either adds // or modifies the table as necessary. require_once( ABSPATH . "wp-admin/includes/upgrade.php" ); dbDelta( $sql ); add_option( "sarsauto_table_version", $sarsauto_table_version ); }
And here is IF function of functions.php:
// Asking for setup.php file and if exists create function if( file_exists( dINCLUDES . "setup.php" ) ){ // Require setup.php file include( dINCLUDES . "setup.php" ); // On plugin activation ask for table setup function register_activation_hook( __FILE__, "sarsauto_table_setup" ); }else{ echo "Error: file doesn't exists!"; }
THE PROBLEM is whenever i am refreshing my database’s list of tables, no new table is added (in this case ‘sarsauto’ table).
I have done everything like in wordpress plugin creation documentation.
Please help. This issue is making me crazy.
Thanks in advance,
Ricards
- The topic ‘Plugin can't create table’ is closed to new replies.