Questions tagged [database]

WordPress stores user generated content, along with other configurable information, in a database (typically MySQL).

0
votes
0answers
14 views

Remove special characters from filenames

I have a website that i transfered recently from one host to another. Unfortunately when i did that, i noticed that all the images that had special characters in it lik (é, è, à, ...) weren't showing ...
-1
votes
1answer
13 views

Any1 knows how to make crons job for following action

how to make crons job for optimizing wordpress database how to make crons job for emptying wordpress logs in database I dont need plugin
0
votes
0answers
13 views

Lead capture offering download via WordPress + Amazon SES

Is it possible to integrate WordPress with Amazon SES this way? I want to collect lead e-mails by providing items to download (e-books, podcasts and other stuff). The flow is: user leaves his mail,...
0
votes
0answers
10 views

Voting system database connection

I am trying to implement a polls plugin in WordPress. I have to import previous questions and answers from previous polls existing in a database and implement new questionnaires and voting systems. I ...
0
votes
0answers
16 views

Code to insert TAG taxonomy Wordpress

I made a grave error. I delete many TAGs from the database of my blog. Many TAGs were orphaned. And yet, unfortunately, many posts have anchor words that link to deleted tags. That is, several links ...
0
votes
0answers
26 views

Translating WP query into to SQL query

I have very complex wp query and I want to use sql query instead of this. Is there any way to translate wp query to sql query. I am thinking that I will have a better control over sql query as the wp ...
0
votes
0answers
21 views

Accessing an external database

I manage a web site for a charity. We are in the process of moving from WebPlus (no longer supported by Serif) to WordPress. Once the move is complete I would like to introduce a database of members,...
0
votes
1answer
22 views

How can I UN-orphan media files?

Something wrecked a non-profit WordPress site I'm responsible for (I'm not a WP expert, just the most technical of all our volunteers). I was able to restore most of it from a backup, but the ...
0
votes
0answers
9 views

WPSiteSync & Advanced Custom Fields

I'm using the plugin WPSiteSync which can copy posts from one wordpress install to another. It works well however I’m using Advanced Custom Fields with a Relationship field. When it copies over posts ...
0
votes
0answers
17 views

Accessing data from Google Cloud Datastore in Wordpress site

I want to access data stored in Google Cloud Datastore (or possibly other Google database option) in my Wordpress site. I have tried to find information about this without much luck. The alternatives ...
0
votes
1answer
12 views

Can I use a wpdb object to connect to a non-Wordpress Oracle database

I simply have a quick question. I've found information related to this, but I'm not completely sure if this is possible. I know that I can create a second database connection using the wpdb object as ...
3
votes
2answers
57 views

How to deploy a new theme/theme options from staging to production site

Let's say you are building a new theme on a staging site. While you were building, the production database has changed due to new user registrations/orders. So now the question becomes how do you ...
0
votes
1answer
23 views

Error establishing a database connection - wordpress-issues [closed]

I thought that during the installation process the file wp-config-sample.php gets to wp-config.php – but this is not happening. Error establishing a database connection This either means that ...
0
votes
1answer
13 views

How retreive saved data from gravity forms in my template?

I want to display the completed gravity form values in frontpage using entry id and form id. I know about this but unable to retrieve values GFFormsModel::get_leads($form_id) returns a list of ...
0
votes
1answer
12 views

syntax error for changing user role from database

I want to change user role from the database, UPDATE wp_usermeta SET meta_value = 'a:1:{s:10:"subscriber";b:1;}' WHERE meta_key = 'wp_capabilities' AND meta_value = 'a:1:{s:9:"wpas_user";b:1;}'; ...
0
votes
0answers
24 views

Database Query not accepting my WHERE LIKE wildcard in my PHP code?

I have a query that works fine when I run it in PHPMyAdmin, but does not return anything when ran via the website form post. I copy and paste the exact SELECT below, replace both$searchByText and $...
0
votes
0answers
9 views

Creating a custom search form for custom data NOT for custom fields, categories, taxonomies

How to create a searchable database with a single-field search box in the front end? I have a client who is announcing a recall of one of its products. They are looking to have a single-field search ...
0
votes
0answers
28 views

Optimize WP site for millions of posts

I have a news portal Using WP cms, It has around 90K posts. DB size 2GB. Used Apache, ngnix, WP Memory Limit 4096M, Time 300 Sec, Using CDN :) I am using 2 Dedicated servers E5 2650 V4, 96GB Ram. ...
0
votes
1answer
28 views

Changing root password in PHPMyAdmin for Wordpress Database when going live

Is it a good idea to create a password and make your password secure for your Wordpress database when uploading the database to a third-party web host (going live instead of hosting on localhost) ...
0
votes
1answer
70 views

Advice on how to structure a custom plugin

I am attempting to create a custom plugin and would like some advice/ideas on how best to store the data. Expected Posts ~ 1,000 Expected Users ~ 10,000 Each user will need to have at least one ...
0
votes
1answer
41 views

How can I find the cause of a 500 server error?

I'm not sure if this question fits this site, since the title specifically mentions development of WordPress. Anyway, i am running a Linode Debian Stretch server that I just built. Previously, I was ...
0
votes
0answers
61 views

changeset_post_save_failure

when I attempt to save customized changes(customize.php), I get an error: changeset_post_save_failure and when I watch ajax requests I see this error: {“success”:false,”data”:{“message”:””,”code”:”...
0
votes
0answers
12 views

Meta data in wp_posts table

I was checking my wp_posts table and I saw some appearances from themes and child themes I used in the past under post_title column (e.g. the title being mh-healthmag which is the name of the child ...
0
votes
2answers
40 views

How to copy data from a custom field to the post_content?

i used ACF to store post data in custom fields. i'd like to copy the data from a wysiwyg field to post_content into wp_posts table. How can i do this? Roughly: data is on wp_postmeta table, where ...
0
votes
1answer
19 views

Get url of product's images (woocommerce)

What happen when a post (product) didnt have a guid,because it has the same image with another product ? For example: Query1: select guid from wp_posts where post_type='attachment' and ...
0
votes
0answers
22 views

Is it safe to add INDEX to a column in Wordpress database?

I made this custom code that makes Comment into Review with star-rating. The star is saved as comment_karma. In the Product Archive page, I want to show text like this: "25 people 5-starred this" in ...
0
votes
0answers
19 views

Reusing old post IDs

When I exported my posts I noticed that some of the ID numbers were missing e.g. it started from 8 and went to say 21 and then from 24 to 30 etc. Is it possible to reuse IDs 1-7 (or any others that ...
1
vote
0answers
20 views

Is it safe to convert tables from MyISAM to InnoDB?

I have inherited a WP site (with WP5.1 and WooCommerce 2.6.14, LearnDash 2.5.4 and few other smaller plugins). From screenshot you can see that it is a mix and match of MyISAM and InnoDB tables. ...
0
votes
1answer
37 views

WordPress hook which triggers on post import

I am adding few meta fields for product post type using wp_insert_postaction and it is working perfectly. But I have to trigger my function upon product imports as well as this action is not firing ...
0
votes
0answers
19 views

how to migrate Parse database hosted on Sashido.io to wordpress mysql?

I had a mobile app developed using Ionic framework and hosted at Sashido.io. I want to migrate its database from there to wordpress mysql (As website is developed using Wordpress). Please, can anyone ...
0
votes
1answer
44 views

$wpdb->update prefixes database name to table when executing query

I run into a problem I can't seem to fix. I went back and forth and even used $wpdb->prepare() and $wpdb->query() functions, nothing helps. $table_prefix."users" returns wp_2qttgdv7ac_2_users (...
0
votes
2answers
30 views

Error establishing a database connection with XAMPP

I'm just getting started with Wordpress, and currently using an XAMPP server to try and get a local installation working. The localhost environment is working fine, and I've successfully followed the ...
0
votes
0answers
37 views

How restrict some data for some users?

I need a professional advise. I need a simple function that will block&replace some WP-WooC database widely used data (as Site Name, User Name, Taxonomies, Products Attributes, etc) from ...
0
votes
0answers
7 views

wp_option table breaks layout when merging CSS

When merging css files the whole layout breaks as if no css file were being called, no matter what plugin I am using for merging. After starting a fresh install and migrate data step by step I found ...
0
votes
0answers
10 views

Dokan Muti Vendor Plugin - Change commission of vendor after order has been synced

I did not set the admin commission (read: it was 0%) when the website went live so right now no vendor has any commission. I have around 120 orders and I need to set commissions each vendor received ...
0
votes
0answers
18 views

Can't connect to uploaded database

I have buy a domain hsoting in godaddy and trying to upload my wordpress website backup into this hosting. So, I went to manage domain, it asked for setup website, I just choose next - next & ...
0
votes
1answer
35 views

PHP Warning: Error while sending QUERY packet

I have woocommerce website which give database error from 4-5 days. I checked the error log, the error is: PHP Warning: Error while sending QUERY packet. PID=31071 in /home/goldenwiggles/...
1
vote
1answer
16 views

Multiples Empty Posts were created and cannot delete them

Over 2000 empty posts were created and I cannot delete them from the admin. Couldn't find them on SQL either using SELECT * FROM wp_posts a LEFT JOIN wp_term_relationships b ON ( a.ID = b.object_id )...
0
votes
0answers
15 views

Trigger on DB make problem on wordpress?

If i insert a trigger for wp_posts table, wordpress make me impossible to publish posts,forums,articles. And get error: "You don't have permission for publish". How it should bee(it's without ...
0
votes
0answers
28 views

Using Filters to modify contect - DB query results alwats appear fist

thanks to help provided by this forum, I have managed to develop a plugin that uses a database of UK towns & postcodes - using the URL parameters to build up a query & display the results. I'm ...
2
votes
2answers
133 views

Meta query interfering with orderby relevance

I'm trying to re-order the search results using the pre_get_posts hook and set the orderby parameter to relevance. I also want to put priority posts, which is based on post meta _prioritize_s to be ...
0
votes
1answer
8 views

is it possible to install new Wordpress in an old Wordpress folder?

I have deleted my old wordpress database after backup it with a plugin "UpdraftPlus" but I keep the wp-content folder in the same old location which include all my attached files (PDF, Video, Audio, ...
0
votes
1answer
110 views

Editing the term_order field

Can I add the term_order field to the terms edit page? I need a text field, not a sorting plugin. Thank.
0
votes
1answer
31 views

I can't update my data through $wpdb

I am trying to update my sql data through $wpdb, but can't... If anyone can help what's the real issue? $updated_version = $wpdb->update('wp_visitors', array('views' => $updated), array( '%d' ))...
0
votes
1answer
18 views

Trouble running $wpdb->query() with last_insert_id

I am trying to get a primary key from a coupon table to put it in my target table as a foreign key. In between I would like to run a query to get the last insert id. I can't get the syntax right ...
1
vote
2answers
93 views

wp search-replace (not executing)

I'm running multisite. Looking to replace old URLs with new URLs for pulling a copy of the site form one environment to another environment. Here is my command: wp search-replace --url=domain.com ...
0
votes
0answers
17 views

Create a custom table with column as an index

I want to create a table in my wordpress database with a column that is an index. But I can't seem to make it work with this code: $table_name_t2mtokens = $wpdb->prefix . "t2mtokens"; $...
0
votes
0answers
26 views

stop execution and Display Errors when inserting data to custom table

I created a stats table. on a daily basis I retrieve data from Post meta, aggregate it and insert it into the stats table (code bellow). function updatePostDay($postID, $month) { global $...
0
votes
0answers
24 views

WordPress number pagination from a custom table

Is it possible to create a numbered pagination of a table which is coming from custom created WordPress table? I want to show only 10 entries on a page then 10 on page number two and so on... Below ...
0
votes
1answer
24 views

Issue running db create table query from static method

I suspect the way I call the table creation function below is the culprit for no table creation (nothing shows in the debug log or query array). Can anyone see my mistake? // main plugin file, ...