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

learn more… | top users | synonyms

0
votes
1answer
6 views

Write mysql credentials in plugin

I've to create a custom plugin to print data from a database different from the wordpress one. I'm using wpdb. Is it fine, from a security point, to write database credantials in the plugin files in ...
0
votes
0answers
2 views

Why are no posts showing despite my apparently correct DB restoration?

I restored a backup to MySQL using the phpMyAdmin Import feature. When I browse the DB in phpMyAdmin, I see that my posts are there. But in Wordpress, I only see the default out-of-the-box welcome ...
1
vote
1answer
44 views

$wpdb->get_results leaking memory

I have developed a wordpress plugin that reads large custom xml files and imports the information as custom post types and a lot of post meta information. So I am calling a lot of database ...
0
votes
1answer
20 views

Opinion on Best Database Move Option

I am moving a lot of my sites from one server to another. They are on a shared host, and was wondering how many votes these two options would get, and which one you all think is the best option. ...
0
votes
3answers
344 views

Problems with moving my Wordpress site to another domain/server

I'm having problems moving a wordpress site from one domain to another. I've searched the site but couldn find a useful answer for my situation. Here's what i did: I made a backup of the website. ...
0
votes
1answer
18 views

Doubt using $wpbd->get_col for a single column

$table = $wpdb->prefix . 'posts'; foreach ( $wpdb->get_col( "DESC " . $table, 0 ) as $column ){//get all columns from wp_posts echo "<div><p>". ...
-3
votes
0answers
28 views

Too many users? [on hold]

I'm setting up a website and importing users from a csv with a plugin. This import process and everything works fine until I reach 13.000 users or so, then the wp-admin section stops working at all. ...
0
votes
1answer
13 views

Import live site to local setup without access to live site

I am working with a client to update a current wordpress site. I do not have access to the actual Wordpress install because they are behind a VPN that I'm not able to get behind for various reasons. ...
3
votes
4answers
2k views

How to run Two Wordpress blogs with different themes and with single database and same content

How do you run two Wordpress blogs with different themes using one database where the content remains the same in both sites? The issue that I am getting is at the Domain mapping in both blogs.
0
votes
0answers
23 views

Insert Custom Registration fields in Database

I am newbie to WP and working on login and registration forms. Recently I have integrated custom registration form following this tutorial. I managed to add validations and user can register but some ...
0
votes
1answer
25 views

fastest replacement DB

What's the best database setup for WordPress for speed and lots of posts (hundred thousands of rows in posts and post_meta tables)? While I can cache as much as I can and optimize my queries/PHP as ...
0
votes
0answers
12 views

import xml to database [on hold]

I want to import an external .xml file to the database. So I created a new table in my database with some fields I need. I solved all my error messages and the system sais "Success". The rows are ...
0
votes
2answers
18 views

Looking for suggestions on creating simple database (Help!!)

I'm working on creating a basic database for a theatre and really need some suggestions as the best way to approach this. Each production from this theatre will have its own page. The page should ...
0
votes
2answers
46 views

Woocommerce - Check product stock availability from external database

I have an external database (not a Wordpress one) where my client's stock is managed and I need to check the product availability considering this database, not the wordpress' one. My inicial idea is ...
0
votes
2answers
37 views

Execute a function every hour in the background

I'm in kind of a weird situation (for me) My client has a website that runs on a custom CMS He wants an online site that loads some data from the existing database. This is an external MSSQL database ...
0
votes
1answer
15 views

using same mysql user with many databases

As we know that in order to connect WP with database we should to define mysql username and password in wp-config.php, so at that point i have a question regarding security or ( some sort of ...
0
votes
2answers
54 views

Is it possible to have more than 1 sql databases in my wordpress blog?

I m watching video on installing wordpress manually. on first launch wordpress prompts you to input your sql database name, sql password etc. then i can start working from dashboard. is it ...
0
votes
1answer
20 views

Backing up Wordpress database and files

I've tried a few third party plugins for backing up my site, with some working well and others not so much, so I'm trying out backing up the site manually. Is there anything I'm missing here or is ...
-2
votes
0answers
20 views

Database connection question

I am new to WordPress and I wondered if it would be possible for me to develop my website using WordPress. I need to be able to implement a feature where users log in and a table is displayed ...
0
votes
1answer
40 views

Retrieve and display data from custom db table in admin area?

So, i'm having a bit of an issue with a plugin i'm developing, I wonder if anyone can shed any light on the situation, as many, MANY searches have come back with zero help. :-/ Basically, my plugin ...
1
vote
1answer
66 views

Retrieve featured image (thumbnail) url from multiple posts with one query

I have a list of post ids and need to get all the standard data plus the thumbnail of the posts. As there will be several hundred posts i need an efficient way to retrieve the data, just looping over ...
0
votes
1answer
99 views

Proper approach to moving complete site from one domain to another AND preserve widgets

I consider myself fairly versed in this matter, however I've recently had a rash of issues when moving sites. I am able to successfully move the site, edit wp-config.php, move the database, etc. ...
0
votes
1answer
199 views

After moving my site from a dev subdomain, to root, all my custom meta data is gone

I just movde my site from a dev subdomain, to the root. I have extensive amounts of data saved in custom meta fields which I created with the WpAlchemy class. All of this data is not appearing in ...
5
votes
4answers
5k views

Can posts have parents?

Are posts supposed to have parents? If so, what would that mean for a post to have a parent? Also, if there are some constraints to posts having parents, then where is that enforced? Not in the DB as ...
4
votes
2answers
371 views

Using Vagrant for customizable Wordpress Multi-sites

Background: My partner and I have a goal to create a customizable vagrant project that uses Wordpress multi site, as a local development environment. Ideal Use Case: Various developers on our team ...
1
vote
1answer
24 views

Add action on delete comments?

I add some input fields to the comment form, and than this new data is stored on commentmeta table. When a comment is deleted, the data on commentmeta is still there. How can I delete these data ...
4
votes
3answers
748 views

How might I retrieve a featured post image from an external WP site and display it as a link back?

I have two WP sites. I want to reach from one of them, into the other, and retrieve specific featured images for posts, and display them with a link to that post. I am using this line (with the ...
0
votes
0answers
20 views

MySQL 1005 ErrNo 1 - “can't create table” when importing DB backup into phpmyadmin?

I have been developing a WordPress site locally using the following mysql version: LOCAL DATABASE SERVER: Server: Localhost via UNIX socket Server type: MySQL Server version: 5.5.40-0ubuntu0.14.04.1 ...
2
votes
1answer
2k views

Insert query inserts 2 entries, should insert 1

I've written a small posts by views plugin, well at least started one. My tables are set up but when they are updated the code adds 2 entries into my table when a post is loaded and views are ...
1
vote
1answer
381 views

Wordpress database import: Row size too large

I've done a dump of my Wordpress database using Windows's command prompt: mysqldump -u username -p databasename > filename.sql Then, on a different server, imported it using: mysql -u username ...
2
votes
1answer
34 views

Should I be able to run two different “close” code versions of wordpress with the same DB

A concrete example - I am upgrading to 4.1 from 4.0, the upgrade was successful but I discovered that a plugin broke. Can I just revert the code. The real live issue I am facing is having two ...
0
votes
1answer
273 views

Displaying BLOB PDF File

I have some pdf files that are stored in the wordpress database as a blob and I need to display these files. The files are not linked to any posts directly. The code I have currently is: <div ...
0
votes
0answers
51 views

two wordpress sites, two themes, one database, same content

I am doing research about wordpress and there are many interesting stuff to learn, i browse the wordpress forum and i found a post about duplicating site.. or multisite.. I am not sure exactly how it ...
1
vote
1answer
20 views

WordPress Local And Live Site

I have a local WordPress install that I am using to test a new theme out. When I initial set up the local site I was able to import my database and media content. However that was a few months ago. ...
1
vote
0answers
21 views

delete duplicate comments

I found a solution for this a long time ago. Here is the code: <?php require_once('wp-config.php'); global $wpdb, $comment_content, $comments,$comment_ID; # First select all comments $query = ...
0
votes
1answer
30 views

MySql Database In WordPress Multisite

I have a multi-site installation. It's a fresh installation, and currently all the sites use the same database. What would you recommend among these and why? Pros and Cons of using the same? Option 1 ...
0
votes
0answers
14 views

Serialized Data Being Cut Off?

I have two separate installations of WP on two servers. They're both the exact same website. In my CPT's meta, I have a field that's a very long piece of serialized data. On one server the full data ...
0
votes
1answer
367 views

How to fetch records from database WordPress

index.php: <?php $new=$wpdb->query("select * from wp_posts where post_title='Auto Draft'"); $new1=mysql_fetch_row($new); echo $new1[0]; ?> How to fetch record from database? How ...
1
vote
0answers
7 views

localize elements in database

I want to localize my website with .mo files. Now, while it's pretty easy to scan existing php files and add the relative translation, it's not clear to me how to localize the elements in the db. I ...
0
votes
2answers
844 views

Saving Custom Post types and fields to a custom table

I have a project in which I am trying to import a large amount of data into a WordPress installation and from that data, create pages on my site (as a custom post type). Since these pages will be ...
1
vote
1answer
351 views

Wordpress choose wrong database

I have 2 databases. When I include the database connection (with a include('filename.php');) wordpress acts really strange. I can't login, the wordpress username and password is right but it tries to ...
0
votes
1answer
20 views

How do i get value from wp_postmeta?

I am trying to get a specific value from wp_postmeta, I'm aware about meta_key and meta_value. Problem is Meta value stores lots of values and i want specific value. Here's the value in the ...
0
votes
0answers
37 views

Handling Massive Amounts of Data in a Wordpress Plugin

I've been working on my own version of a Youtube Post Importer plugin for Wordpress and I've run into a bit of a wall. I'm using the 3rd version of the Youtube Data API seen here ...
0
votes
0answers
19 views

wp_update_post set value to null

Is it possible to set a field to NULL using wp_update_post? I'm trying the following: wp_update_post( array( 'ID' => $future_orphan_id, 'post_parent' ...
1
vote
1answer
96 views

Maintenance holding page while migrating website

I was hoping someone might be able to help me with the right procedure for establishing a holding page while migrating a local WP site to an already live server. I know there are lots of maintenance ...
1
vote
1answer
2k views

How to create database table, add data, update and delete using wpdb via plugins?

I am just starting out to create plugins with database. I know to create a custom database when activating the plugin. I just want to know whether we can create tables at the front end like adding the ...
0
votes
1answer
3k views

Error establishing a database connection when installing multiple sites locally

Initially I was using MAMP and had only 1 wordpress site running locally on my Mac. I've set: document root to: documents/mywebsites/mysite1 In phpMyAdmin I created a DB called: mysite1 wp-config ...
2
votes
3answers
644 views

How to export/import theme customizer settings?

I am wondering if it is possible to export theme customizer settings(theme_mods) to be imported into another install of the same theme. I know that the settings are saved into the database so I am ...
0
votes
0answers
9 views

Will be the posts over writen according to the posts' ID when I import from an old site using XML file?

I have a site now and it has 350 posts. (Let's call is New site) I have another site which has 500 posts (Let's call is Old site) Now I am in a need of importing the all posts (500) from my old site ...
0
votes
0answers
15 views

Editable form with database

I want to create a profile page in which user will give title and description for it.this title should be visible in list on same page by clicking on it associated description should get open for ...