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

learn more… | top users | synonyms

0
votes
0answers
10 views

Importing inventory from a csv file in the ftp to the database

I'm looking to upload the content contained in a csv file from FTP directly into a WordPress database every 24 hours. This csv file (containing inventory items) gets generated from one site, and I ...
0
votes
0answers
11 views

MS Access to wordpress sql

I have a client who runs a store and has around 125000 products and he manages his stock from MS Access server. His current site is just for product catalog but he wants to have a new site to sell ...
0
votes
0answers
12 views

WordPress database error (wp_terms)

I'm having the following issue. Whenever WordPress try to get any term from database (product_tag, portfolio_tag, etc) I see messages like: WordPress database error: [Error writing file ...
0
votes
0answers
5 views

“User Role” Not Working

While following recommendations in IThemes Security Plugin, I renamed the database file prefixes which broke our site (multisite installation). I restored the database and everything seemed to work ...
0
votes
0answers
27 views

In WordPress do I create tables for my plugin or do I create custom post types for a Student and Classes Registration system?

I want to use WP 4.x as a framework to build a small Student system. I do not wish to use an existing plugin. My needs are unique, and these do not do what I need. In my design, I have Students ...
0
votes
0answers
17 views

Bulk find replace to convert hundreds of old URL calls

We have a new wordpress site generated from an old html site with thousands of pages. An import process was used, but unfortunately as a result the site has hundreds of references within content to ...
0
votes
0answers
33 views

Wordpress installation: Error establishing a database connection

I've successfully installed Wordpress on my local system and used it to create a demo site. Now I'm struggling to get an empty wordpress installation to work on my webspace. Running the install.php in ...
0
votes
0answers
43 views

How Can I lock function to prevent running multiple instances in one time?

I have written a plugin. There's a function int it that works with a DB table and (works on a data tree) ,I want if function starts running ,other instances lock until it finishes(then other instance ...
0
votes
0answers
27 views

Can't Install WordPress (local) Failed to open file wp-includes/wp-db.php

Title kinda says it all. Trying to install WP locally and I get the following error when trying to use the wp-config.php generator UI: Warning: mysqli_real_connect(): (HY000/2002): No such file or ...
0
votes
0answers
10 views

Can't get URL rewrite to work for participants database plugin

I am fairly new to WordPress, but here we go. For the past 18 hours or so, I have tried every method I have found on the internet in an attempt to force the url example.com/file/?pdb=3 to become ...
0
votes
0answers
12 views

Post links behaving weirdly after migrating DB to Amazon

I have partially successfully migrated a local DB for a WordPress site I was working on. I imported the new DB using phpmyadmin and move the template and seems to be working fine. The only thing that ...
0
votes
0answers
13 views

update_post() on all databases of a multisite wordpress

I want to change a certain option from every single site of a multisite networks. I wrote the following that I hope will update all databases $allSites = wp_get_sites(); foreach (allSites as ...
0
votes
0answers
81 views

Delete all posts of a custom post type—efficiently

I'm looking for a safe and fast way to delete all of one custom post type's posts. Using get_posts() and wp_delete_post() for each returned post does not work; it's not fast enough due to the sheer ...
0
votes
0answers
33 views

Export User Info into CSV - Additional Column (post_title)

I'm using the 'Export Users to CSV' a plugin for wordpress. By default, The plugin only extracts wp_users and wp_usermeta I have been wanting to add post_title column from wp_posts. I was able to ...
0
votes
0answers
21 views

get backup file from wordpress database in x days

I have a wordpress website with so many posts and custom fields located in meta table. What I have to do is to make backup from each 30 days (for posts and postsmeta table) and append it to my last ...
0
votes
0answers
14 views

Database migrations because of docker

Assuming I dockerize my wordpress environment to easily transport it to other developers. This is no other than putting the hole installation on a VPS or Vagrantbox. My point is. The DEVs have a copy ...
0
votes
0answers
14 views

Store id from database query in cookie

I need to store an ID value which is generated upon doing a database insert. After the insert, javascript redirects the user to an external page, which will then redirect back to a wordpress page ...
0
votes
0answers
20 views

Allow network sites but also allow single sites

Ok, I think I really need some help here. I am feeling like this is more complicated then it should be. Here is my aim. If plugin is used on single wordpress site than allow and use the class ...
0
votes
0answers
8 views

WordPress Integration with Drupal

I could use some assistance. Can I build a site using WordPress as a CMS for one function, and use Drupal for another site (more of a CRM suite app) elsewhere, and grant permissions to records within ...
0
votes
0answers
30 views

Website goes slow down after importing long database

I am working on a site which have 2 lakhs post and 15 categories. I have home page with 3 post of each category on home page. And after that its goes down while run home page and shows page not found. ...
0
votes
0answers
18 views

How can I move a Wordpress multi-site's domain seamlessly?

I have a multisite install and I've been setting up local and staging sites fine using a plugin (All-in-one-migration) tool to import / export DBs which handles updating the domain link embedded in ...
0
votes
0answers
18 views

Syncronize post from different databases

I have an "engine" site that import rss post from all over the world, all day, like an aggregator. That importing activity is really slowin down things. So in a different neat and clean wordpress ...
0
votes
0answers
231 views

Need to save data to database from AJAX phone submit form

I have an input that accepts a country code (a select/dropdown form) and a phone number (number input) and submits them via AJAX to a pin verification service. The verification works great, but I need ...
0
votes
0answers
27 views

What would Repair and Optimize Wordpress Database do?

Recently I am getting an error establishing a database connection in a clients Wordpress site. I googled for a solution and an article suggested to enable Wordpress Repairs by adding this to the ...
0
votes
0answers
30 views

$wpdb global causing issues with plugin class

I am currently building a plugin. I have a main init.php file which loads all the necessary plugin classes. Within one of the classes, I have several methods that call the $wpdb global. One of the ...
0
votes
0answers
34 views

how to sync user database with excel sheet

guys! I'm currently building a website for a ONG and I've been asked to create a private page where the user's could see the points they have gathered with our organization and that can latter be ...
0
votes
0answers
52 views

siteurl value getting populated with junk in wp_options table

My website was getting this error on every page : Catchable fatal error: Object of class WP_Error could not be converted to string in /home/juhisheth/public_html/wp-includes/default-constants.php on ...
0
votes
0answers
56 views

How to get data from Wordpress form into php or C#

I have a wordpress website and I created a form where the users can put in some information. I want to get that submitted information using preferably C# or any other popular programming language like ...
0
votes
0answers
45 views

why require a refresh page for see the changes from database $wpdb

I used a functions for create a new user, new site, switch to new blog and give new theme. wpmu_create_blog add_user_to_blog switch_to_blog switch_theme(); restore_current_blog(); when form ...
0
votes
0answers
35 views

mySLQ database into wordpress

Ok. I'm not even sure how to ask this but I'm trying to make a leaderboard on my site, where users enter points daily for five different options - on the honor system. I want the users to enter the ...
0
votes
0answers
27 views

Querying same column twice with wpdb (for postmeta values, specifically latitude and longitude)

I've seen similar questions around, but I just can't apply them to my case, I'm quite new at this, apologies. I'm trying to create a google map of my posts, using a latitude and longitude that are ...
0
votes
0answers
56 views

WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for

In my wordpress showing this error: WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' ...
0
votes
0answers
14 views

Where are user records awaiting to be confirmed stored in the database? Where's the Lock ?

Per the title : I have a user that claims to have not received their "confirmation" email - I (the db) has no record of their email address, because I manually deleted it via the 'dashboard' due to ...
0
votes
0answers
119 views

create a form and save data into new table

I want to create new form to add my customer details including name, email, contact num, address Once created, this form should store all these values into newly created table and also generate 4 ...
0
votes
0answers
23 views

Wordpress autosuggestion box

I have been searching all day for a solution, but I think I'm to noob to distill an answer to my problem from the various sources in the community. I'm trying to create an autosuggestion/autocomplete ...
0
votes
0answers
19 views

Array or Database

I have a question concerning the storage of variables. For my website I would like to add fields for education to the profile of users. To promote uniformity I would like that every user picks from ...
0
votes
0answers
107 views

Use a Firebase DB as main DB

I was wondering if it was possible to use a Firebase database as a main database? Or do you have another solution to use a unique DB across multiple dev station? Thanks :)
0
votes
0answers
60 views

Multiple domain with one database

I have multiple domain (Multiple domain + subdomain as well) for the different countries and for the different states of it. Now i want to run all the domain from one signle database, all the domain ...
0
votes
0answers
22 views

WordPress Database Update Required

This is my first time experiencing the "DataBase update required" and then will not login in to the site. I am currently running version 4.2.2. I have read many blogs and see many people have had ...
0
votes
0answers
20 views

Hook upon database insertion?

I have downloaded a plugin that inserts a new row into a table in my database. I want to perform a calculation on this row as soon as it is inserted into the database, in my own plugin. I've seen a ...
0
votes
0answers
16 views

Text with sub bullets not saved correctly

I'm having problems with sub list items. In my backoffice it looks like this (text is blurred): Visual: Text: In the text editor it looks good but when I save the post I get this in my database ...
0
votes
0answers
22 views

WordPress and user security

When we talk about Information Security, many things come into mind and people tend to use CMS to be clear on security as CMS people do the job for you, in terms on hashing passwords, encryption etc. ...
0
votes
0answers
40 views

Two same URL domain

I have a problem with my wordpress . I just migrate to a new install only the post and categories . But now entering a link or search the CSS BASE URL for example doubles A href attribute URL : ...
0
votes
0answers
22 views

Database level import of featured images and link to posts - How?

I have been attempting to import about 50,000 images into 50,000 posts in WP 4.2.2. The _posts table data is all correctly imported already. I know I need to import to _postmeta table and add new ...
0
votes
0answers
56 views

Loading posts from another wordpress database on the same server

I've searched quite a while and found several solution but apparently I'm doing a lot of stuff wrong. I'm having 4 different Wordpress sites and need to load the latest 2 posts of each site. For ...
0
votes
0answers
11 views

MYSQL ignore categories on Wordpress widget

I have this WP widget that pulls random products from the DB. What I really want is to be able to include just a few products categories (or exclude). Can anyone help me? I appreciate. <?php ...
0
votes
0answers
116 views

wp_editor content in plugin options page

Hi I'm writing a plugin it involves the site builder / user adding content via wp_editor this content is then saved and submitted via a submit_button. I've wrapped the editor in form action = ...
0
votes
0answers
18 views

wp_include_post in custom post with coustom field

I'm new in wordpress and my english are not good. I'm using Custom Post Type UI plugin to create a post type "Product" and Advanced Custom Fields plugin to create some custom fields like address. Now ...
0
votes
0answers
88 views

Database migration tool for GoDaddy Managed WordPress

I’m about to revoke my Managed WordPress subscription because tools that I have paid for (such as WP Migrate DB Pro) that are an integral part of my development process that sync or migrate my local ...
0
votes
0answers
7 views

Users getting registration errors when signing up but still being registered on the backend?

Having a very strange issue on a Wordpress install - we cannot replicate the error ourselves, but multiple customers have complained about it: They fill out the registration form and get an error ...