Plugin development

• 

  tjframes · Member · Feb 24, 2021 at 8:53 am

  • Copy link
  • Add topic to favorites

  table create issue

• 

  aleone89 · Staff · Feb 24, 2021 at 10:48 am

  • Copy link

  Hello there,

  Many thanks for reaching out.

  Are you able to confirm the URL of the website that you need assistance with please?

  Can you also detail more about the issue you’re having please.

• 

  tjframes · Member · Feb 24, 2021 at 11:30 am

  • Copy link

  I am developing a plugin for our company. The plugin requires a database on the WordPress site. The initial phase works best. But the last step is it doesn’t work. I tried the recommended method from the WordPress site. It shows this error.
  `
  WordPress database error: [Table ‘wordpress07.wp_beaglescandata’ doesn’t exist]
  SELECT * FROM wp_beaglescandata
  `

  this is the code

  `
  $charset_collate = $wpdb->get_charset_collate();

  $sql = “CREATE TABLE IF NOT EXISTS $Beagle_WP_scan_table( id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, access_token VARCHAR(50) NOT NULL, application_token VARCHAR(50) NOT NULL, status VARCHAR(50) NOT NULL, result_token VARCHAR(50), verified BOOLEAN NOT NULL,title VARCHAR(20),url VARCHAR(50),runningStatus VARCHAR(10), autoVerify BOOLEAN)DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;”;
  require_once(ABSPATH . “wp-admin/includes/upgrade.php”);
  dbDelta($sql);
  `

• 

  aleone89 · Staff · Feb 24, 2021 at 12:02 pm

  • Copy link

  Hello there,

  Many thanks for that extra information.

  WordPress.com is a support forum for those who have their sites hosted or managed by WordPress.com.

  For help with plugin development, you would need to reach out to the WordPress.org forums: https://wordpress.org/support/forum/wp-advanced/

  Please also see this developers handbook for further assistance: https://developer.wordpress.org/plugins/

  I hope this helps.

• 

  tjframes · Member · Feb 24, 2021 at 12:08 pm

  • Copy link

  Thanks bro.