mysql

WordPress Comments – Cleaned Out WP_Comments Table But Still Showing On Admin

Question

I have used MySQL queries to remove 1000s of ramdom comments on my Wordpress Blogs. But when I go into the backend of Wordpress and look at my list of Posts, it is still showing (comments column) the same number of comments as were there before I deleted any. If I go to a post which

comments, mysql, posts, wp-admin cbjroms 1 year 0 Answers 64 views

Updated Php version from 5.4 to 7.2 and getting “PHP installation missing the MySQL extension needed by WordPress”

Question

I am new to wordpress and I wanted to add a custom plugin which required php version 5.6 or higher. In my cPnael -> MultiPHP Manager, there were options to upgrade version to 7.0, 7.1, 7.3, 7.4. I upgraded it to 7.2 but now my wordpress site gives error like Y

mysql, php Hasnain Ghias 1 year 0 Answers 67 views

Add value to usermeta without removing previous values?

Question

How do I add a value to the key dismissed_wp_pointers without removing the existing values (if there are any). Doing this will put the value there, but it will remove everything existing first. function reset_after_customize() { $user_id = get_current_user

customization, dashboard, mysql, php joq3 1 year 0 Answers 64 views

Insert into query with 3 tables

Question

I need to insert into posts table, Its work good and insert 114 posts from another table, but the problem is in the insert to another table, another table needs the post id to insert to other tables, I can get the last id only, but I need all posts id. How can do that global

mysql, plugin-development khalid almallahi 1 year 0 Answers 49 views

How to make WordPress search more flexible?

Question

My customer has a WooCommerce product catalog that uses a number of different naming conventions. A part commonly referred to as D100 could actually be named D100, D100-BLACK, D100BLACK, D100 BLACK, D100 black, d100-black, D100BLACK+, D-100BLACK,.... When a user enters D100 (or any of the aforeme

mysql, search, woocommerce Robert Bethge 1 year 0 Answers 58 views

How to list all categories and their IDs using SQL query?

Question

I am looking for a SQL Query that can give the list of all categories created in WordPress Site along with it's category IDs. Please advise a query to get it as category/term relationship is quite complex in WordPress. I got this but didn't work - SELECT ID,post_title FROM w

categories, database, mysql amitdutt24 1 year 0 Answers 47 views

Creating a view vs running query- speed, security?

Question

I am programming in wordpress and using a lot of MYSQL queries for custom dashboards and other information. I think I know the answer but is it better to create a number of Views in MYSQl and store them there or query everything from WP custom shortcodes? Obviously no matter what I have to call t

mysql, php, query Ted 1 year 0 Answers 48 views

TRIGGER command denied to user for table

Question

so I have a problem. I cant import sql dump to database and im getting this error. I've done database imports couple times but this is the first time im getting error like this. Any help would be appriciated. Thanks

database, mysql kr7 1 year 0 Answers 52 views

How to set MYSQLI_OPT_INT_AND_FLOAT_NATIVE option

Question

I'm having troubles with the mysqli driver used by wordpress, where it is converting each and every integer value to a string within $wpdb->get_results("SELECT..."). I know that it is possible so use the the option MYSQLI_OPT_INT_AND_FLOAT_NATIVE with the mysqli drive

mysql, wpdb Raffaele Candeliere 1 year 0 Answers 55 views

Delete Custom Post Types via SQL

Question

I have a website that operates similarly to many freelancing websites where people can make bids. Its become painfully slow in recent weeks and I used query monitor to find out the issue is likely over 140,000 posts that were build up over the last 5 years. Below is a query that takes 36 seconds

database, mysql Miguel Dey 1 year 0 Answers 44 views

1 2 … 28

Register Now

Login

Lost Password

Add question

Login

Register Now