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
WordPress User Login not accepted although listed in DB
First of all, you should check the DB Configuration at wp-config.php, is the name and the db user+pw correct? Does the DB User have all the necessary permissions to the DB? Is the DB Server running at all? You find more info how wp config should like over here: https://help.dreamhost.com/hc/en-us/articles/214693268-WordPress-wp-config-php-overview
How to CRUD remotely hosted WP database without root?
There’s only one naming convention to remember, the WP table prefix. If you don’t want to use it you can do whatever you want. WordPress only cares about its own tables, you can create any other tables you want. Keep in mind though that the WordPress table prefix isn’t always wp_, and it changes for … Read more
For this I suggest you to use Search and Replace plugin which has Dry Run option under Tools > Search & Replace > Search & Replace, here we need to check the Dry Run checkbox. In Dry Run we can find in which table we have that searched text so from that you can find … 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
Yes, you can set up a free method to check if your WordPress database is online and get an email if the site shows the “Error Establishing a Database Connection” message. You can achieve this by adding a simple PHP script to your WordPress theme or via a custom plugin. Step-by-Step Solution: Create a Custom … Read more
Using the wpdb::prepare() method is recommended for creating queries properly and avoiding SQL injection. For a basic solution, use the addslashes() function, but this is not sufficient for preventing SQL injection. See Mysql + php with special characters like ‘(Apostrophe) and ” (Quotation mark).
How to make a term belong to multiple taxonomies?