Hướng dẫn what is uncaught mysqli_sql_exception?

Question

When I run the following code, I get the error saying

Fatal error: Uncaught exception 'mysqli_sql_exception' with message 'No index used in query/prepared statement'

$mysql = new mysqli(DB_SERVER, DB_USER, DB_PASSWORD, DB_NAME) or die('There was a problem connecting to the database');
        if (mysqli_connect_errno()) {
            printf("DB error: %s", mysqli_connect_error());
            exit();
        }

    $get_emp_list = $mysql->prepare("SELECT id, name FROM calc");
    if(!$get_emp_list){
        echo "prepare failed\n";
        echo "error: ", $mysql->error, "\n";
        return;
    }
    $get_emp_list->execute();
    $get_emp_list->bind_result($id, $emp_list);

And this is the able schema --

--
-- Table structure for table `calc`
--

CREATE TABLE IF NOT EXISTS `calc` (
  `id` int(12) NOT NULL,
  `yr` year(4) NOT NULL,
  `mnth` varchar(12) NOT NULL,
  `name` varchar(256) NOT NULL,
  `paidleave` int(12) NOT NULL,
  `balanceleave` int(12) NOT NULL,
  `unpaidleave` int(12) NOT NULL,
  `basesalary` int(12) NOT NULL,
  `deductions` int(12) NOT NULL,
  `tds` int(12) NOT NULL,
  `pf` int(12) NOT NULL,
  `finalsalary` int(12) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

I am getting a fatal error from WordPress when I try to install contact-form related plugins like WPforms and Ninja Forms. It has something to do with line 2056 in the wp-db.php file. I am using a theme and have no experience whatsoever with PHP coding, so I don’t even know where to start. I am glad I found the php file at all.

These are my 2 errors:

Upon activating WPforms:
Fatal error: Uncaught mysqli_sql_exception: Table 'postsam_wp1.wp_wpforms_tasks_meta' doesn't exist in /home/postsam/domains/astrosofie.nl/public_html/wp-includes/wp-db.php:2056 Stack trace: #0 /home/postsam/domains/astrosofie.nl/public_html/wp-includes/wp-db.php(2056): mysqli_query() #1 /home/postsam/domains/astrosofie.nl/public_html/wp-includes/wp-db.php(1945): wpdb->_do_query() #2 /home/postsam/domains/astrosofie.nl/public_html/wp-includes/wp-db.php(2695): wpdb->query() #3 /home/postsam/domains/astrosofie.nl/public_html/wp-admin/includes/upgrade.php(2749): wpdb->get_results() #4 /home/postsam/domains/astrosofie.nl/public_html/wp-content/plugins/wpforms-lite/src/Tasks/Meta.php(117): dbDelta() #5 /home/postsam/domains/astrosofie.nl/public_html/wp-content/plugins/wpforms-lite/includes/class-install.php(133): WPForms\Tasks\Meta->create_table() #6 /home/postsam/domains/astrosofie.nl/public_html/wp-content/plugins/wpforms-lite/includes/class-install.php(59): WPForms_Install->run() #7 /home/postsam/domains/astrosofie.nl/public_html/wp-includes/class-wp-hook.php(303): WPForms_Install->install() #8 /home/postsam/domains/astrosofie.nl/public_html/wp-includes/class-wp-hook.php(327): WP_Hook->apply_filters() #9 /home/postsam/domains/astrosofie.nl/public_html/wp-includes/plugin.php(470): WP_Hook->do_action() #10 /home/postsam/domains/astrosofie.nl/public_html/wp-admin/plugins.php(193): do_action() #11 {main} thrown in /home/postsam/domains/astrosofie.nl/public_html/wp-includes/wp-db.php on line 2056

Upon activating Ninja forms:
Fatal error: Uncaught mysqli_sql_exception: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'IF' at line 1 in /home/postsam/domains/astrosofie.nl/public_html/wp-includes/wp-db.php:2056 Stack trace: #0 /home/postsam/domains/astrosofie.nl/public_html/wp-includes/wp-db.php(2056): mysqli_query() #1 /home/postsam/domains/astrosofie.nl/public_html/wp-includes/wp-db.php(1945): wpdb->_do_query() #2 /home/postsam/domains/astrosofie.nl/public_html/wp-includes/wp-db.php(2695): wpdb->query() #3 /home/postsam/domains/astrosofie.nl/public_html/wp-admin/includes/upgrade.php(2749): wpdb->get_results() #4 /home/postsam/domains/astrosofie.nl/public_html/wp-content/plugins/ninja-forms/includes/Database/Migrations/Forms.php(47): dbDelta() #5 /home/postsam/domains/astrosofie.nl/public_html/wp-content/plugins/ninja-forms/includes/Abstracts/Migration.php(134): NF_Database_Migrations_Forms->run() #6 /home/postsam/domains/astrosofie.nl/public_html/wp-content/plugins/ninja-forms/includes/Database/Migrations.php(40): NF_Abstracts_Migration->_run() #7 /home/postsam/domains/astrosofie.nl/public_html/wp-content/plugins/ninja-forms/ninja-forms.php(1039): NF_Database_Migrations->migrate() #8 /home/postsam/domains/astrosofie.nl/public_html/wp-includes/class-wp-hook.php(303): Ninja_Forms->activation() #9 /home/postsam/domains/astrosofie.nl/public_html/wp-includes/class-wp-hook.php(327): WP_Hook->apply_filters() #10 /home/postsam/domains/astrosofie.nl/public_html/wp-includes/plugin.php(470): WP_Hook->do_action() #11 /home/postsam/domains/astrosofie.nl/public_html/wp-admin/plugins.php(193): do_action() #12 {main} thrown in /home/postsam/domains/astrosofie.nl/public_html/wp-includes/wp-db.php on line 2056

Now here is the part of the php file that holds line 2056. Obviously I don’t know what to think of it, since I don’t know PHP. Hopefully someone can point me in the right direction?


	/**
	 * Internal function to perform the mysql_query() call.
	 *
	 * @since 3.9.0
	 *
	 * @see wpdb::query()
	 *
	 * @param string $query The query to run.
	 */
	private function _do_query( $query ) {
		if ( defined( 'SAVEQUERIES' ) && SAVEQUERIES ) {
			$this->timer_start();
		}

		if ( ! empty( $this->dbh ) && $this->use_mysqli ) {
LINE 2056			$this->result = mysqli_query( $this->dbh, $query );
		} elseif ( ! empty( $this->dbh ) ) {
			$this->result = mysql_query( $query, $this->dbh );
		}
		$this->num_queries++;

		if ( defined( 'SAVEQUERIES' ) && SAVEQUERIES ) {
			$this->log_query(
				$query,
				$this->timer_stop(),
				$this->get_caller(),
				$this->time_start,
				array()
			);
		}
	}

programming mysql Uncaught mysqli_sql_exception wordpress Mysqli_query Php mysqli exception

Hướng dẫn what is uncaught mysqli_sql_exception?

Bài Viết Liên Quan

Quảng Cáo

Có thể bạn quan tâm

Toplist được quan tâm

Quảng cáo

Xem Nhiều

Quảng cáo

Chúng tôi

Điều khoản

Trợ giúp

Mạng xã hội