mysql

wordpress database connection failed, while mysql client succeeds

Question

I am trying to prepare a WordPress site, on my public web server, running apache2. The database host, I am trying to use, for the WordPress installation, is another server. While I can successfully connect the db_host from my web server, through

manmatha.roy 5 days 0 Answers 0 views

mysql – remove wordpress post links

Question

I found such a code to remove all links in the articles, but the code also deletes the link texts. Is there a sql query code that will remove the links without deleting the link texts? UPDATE wp_posts SET post_content = CONCAT( LEFT(po

Suleyman Guloglu 1 month 0 Answers 0 views

mysql – Initialization of table in database using ‘CREATE … IF NOT EXISTS’

Question

Proceeding first plugin installation and activation, I've initialized a table in database for plugin-related data using the statement 'CREATE ... IF NOT EXISTS' : $init_query = 'CREATE TABLE IF NOT EXISTS `' . $this->db_prefix . $table_

brittle_spirit 1 month 0 Answers 0 views

terms – mysql to get related tags of a tag and order by intersection rate?

Question

What I try to do is create a wp plugin to get related tags of a tag and order by intersection rate. For example, in a WordPress site, data structure like below: 40 posts has tags B, 200 posts has tags C

cloudinstone 2 months 0 Answers 0 views

php – wp_mail function not working in user query loop

Question

I'm trying to send an e-mail to every user who is logged in more than a year ago (based on woocommerce meta value from database), but the e-mails do not go out. In my code I'm trying to filter myself for the testing phase, so that only me get the mail, a

Attila Sotus 2 months 0 Answers 0 views

apache – MySQL’s maximum memory usage is dangerously high / php-cgi overloads CPU

Question

When I'm using https://httpstatus.io/ to check the HTTP status of let's stay 30 URLs, the server crashes and only the first 5-6 images return 200, the others return a server er

WordpressHelp 2 months 0 Answers 0 views

How can I delete the options from DB when the plugin is deleted?

Question

Stack Overflow for Teams is moving to its own domain! When the migration is complete, you will access your Teams at stackoverflowteams.com, and they will no longer appear in the left sideba

Rajin Sharwar 2 months 0 Answers 0 views

php – Submit form with foreign key

Question

I am using wordpress, and am trying to figure out how to add and insert a foreign key upon submission. I have a regular submit form, but am unsure how to use the foreign key. My fields: <form> <label for="First_Name">F

John Lyons 2 months 0 Answers 0 views

mysql – SQL get last entry of a specific gravity form

Question

I have a ROI calculator that needs to show the results as a graph. I am using the Visualizer Plugin, which allows for

jloz312 3 months 0 Answers 0 views

php – How to set variable to specific field when querying

Question

I am trying to validate an input box against a field in a database. My question is, how does one check a single input equal to any field in a column? I am able to connect to my query, but am unable to perform the validation. Am I missing something?

John Lyons 4 months 0 Answers 0 views