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, mysql, posts, wp-admin 4 months 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 ...

mysql, php 4 months 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_id(); ...

customization, dashboard, mysql, php 5 months 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 ...

mysql, plugin-development 5 months 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 ...

mysql, search, woocommerce 5 months 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 ...

categories, database, mysql 5 months 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 ...

mysql, php, query 5 months 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 5 months 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 ...

mysql, wpdb 5 months 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 ...

database, mysql 5 months 0 Answers 44 views

1 2 … 28

Register Now

Login

Lost Password

Login

Register Now