我想你在product_categoy_url varchar(500) NOT NULL

如果仍然不起作用，请注意register_activation_hook( __FILE__, \'gg_create_table\'); 只有放在主插件文件中，而不是放在包含的文件中，才能工作。

要从主文件中定义的其他文件执行激活功能，请执行以下操作：define(\'MY_PLUGIN_PATH\',__FILE__);

然后，您可以在要运行激活函数的任何点使用常数：register_activation_hook( MY_PLUGIN_PATH, \'gg_create_table\');

我详细介绍了在dbDelta失败时记录错误和显示通知的功能：

function gg_create_table(){
  global $wpdb;
  $table_name = $wpdb->prefix . \'plugin\';
  $charset_collate = $wpdb->get_charset_collate();

    $sql[] = "CREATE TABLE $table_name (
      id mediumint(9) NOT NULL AUTO_INCREMENT,
      product_id mediumint(9) NOT NULL,
      product_name tinytext NOT NULL,
      product_description text NOT NULL,
      product_details text NOT NULL,
      product_url varchar(500) DEFAULT \'\' NOT NULL,
      product_category varchar(30) NOT NULL,
      product_categoy_url varchar(500) NOT NULL 
      PRIMARY KEY  (id)
    ) $charset_collate;";
   //I\'ve left the missing comma error after \'product_categoy_url varchar(500) NOT NULL\' to test the failure

    //more queries here sql[]="......"

    require_once( ABSPATH . \'wp-admin/includes/upgrade.php\' );

    $file=WPsCRM_DIR."/dbDeltaLog.txt";
    $messages=array();
    $hasErrors=false;
    foreach($sql as $q){
      $messages[]="Output printed on : ". date("Y-m-d h:i:sa")."\\n";
      $messages[]=dbDelta( $q );// execute the query
      if($wpdb->last_error !== \'\') {
        $messages[]=$wpdb->last_error;
        $hasErrors=true;
      }
      else{
        $messages[]=$wpdb->last_query;
      }
    }
    ob_start();
    echo "XXXXXXX DB DELTA RESULT XXXXXX\\n";
    foreach($messages as $message){
      if(is_array($message))
        foreach($message as $m)
          echo $m."\\n";
      else
        echo $message."\\n";
    }
    echo "XXXXXXXXXXXXXXXXXXXXX\\n\\n";
    file_put_contents ($file,ob_get_clean(),FILE_APPEND ); //log file wit all the information

    if($hasErrors==false)// add the option only if no error were thrown
      add_option( \'plugin_db_version\', \'1.0\' ); 
    else{
      set_transient( \'myPluginFailed\', true, 5 );
      // set a transient for the error notification once page reloaded 
      // it shouldn\'t happen of course
    }
}
register_activation_hook( WPsCRM_PATH, \'gg_create_table\');   
add_action( \'admin_notices\', \'myPluginActivationFailed\' );

function myPluginActivationFailed(){
  if( get_transient( \'myPluginFailed\' ) ){
        ?>
        <div class="notice notice-error">
           <p>MY Plugin installation failed, please contact the plugin author!</p>
        </div>
        <?php
        /* Delete transient, only display this notice once. */
        delete_transient( \'myPluginFailed\' );
    }
}