If you provided full code, issue is probably in this line: $wpdb->prepare(“INSERT INTO ‘myprefix_posts_views’ (postid, ip, device) VALUES (%d, %s, %s) ON DUPLICATE KEY UPDATE create_at=VALUES(create_at)”, $postID, $_SERVER[‘REMOTE_ADDR’], $_SERVER[‘HTTP_USER_AGENT’]); Because into column postid you are trying to put variable $postID, when you didn’t declare it anywhere. This column is NOT NULL, so probably you have … Read more
We need to made few changes in the code so that it works properly. Here is the updated code. <?php if ( ! defined( ‘ABSPATH’ ) ) { exit; } if ( ! class_exists( ‘WP_List_Table’ ) ) { require_once ABSPATH . ‘wp-admin/includes/class-wp-list-table.php’; } class Transactions_List_Table extends WP_List_Table { public function __construct() { parent::__construct( array( ‘singular’ … Read more
WordPress can only use the tables with the same prefix as listed in the wp-config.php file. Many times when a database has been used for sometime it will hold several version of the site in the same database by adding different table prefixes to the site versions. This is likely what you are seeing. It … Read more
show the entire contents of posts in an archive page as a table
To many WooCommmerce related transients in WordPress options table
There are probably a great number of ways to create such table. It is rather difficult to give an exact answer without knowing all the requirements and specifications. Here are some general level ideas that should get you started. First of all you’ll probably want to create a custom plugin to host all the relevant … Read more
As I’m working on a displayed on a page (still in Draft) on WordPress, something weird happened : Nothing about this is weird or unexpected, but it would be if you were unaware of the DOM. While I’ve written this very simple code on my editor : This is raw HTML text sent from your … Read more
How to set an exact search box in tablepress plug-in
Have WordPress Use a Different Database for users
Welcome to WPSE. Asking for plugin recommendations is considered off-topic here, so here’s an action approach to the problem. wp_insert_user() takes care of adding new users to the database. The last action the function fires is user_register, which “Fires immediately after a new user is registered”. You could hook your function to this action and … Read more