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

learn more… | top users | synonyms

0
votes
1answer
38 views

How to connect remote database in wordpress?

I have already wordpress website. i want split my existing database into two parts and store into remote database. So how can i set up remote database connection for existing wordpress ? If its not ...
1
vote
2answers
2k views

“Error establishing a database connection” - Intermittent error on GoDaddy

After transferring a working WordPress site to GoDaddy hosting, we've begun getting "Error establishing a database connection" errors on all pages- first intermittently, and now consistently. It's ...
0
votes
1answer
76 views

Sharing users across multiple sites, each on their own database

I have read many solutions out there for sharing users and checked out the other posts on here, but can't find specifically what I'm after, as they all talk about users on the same database. ...
0
votes
0answers
20 views

get_results is not working properly

I tried to find an answer in many forums for this problem, but it has been impossible. My problem is that when I do $wpdb->get_results in an empty table, mi webpage immediately stops working. ...
0
votes
1answer
36 views

Wordpress site URL changed; how to fix it without database access?

we would like your assist on an error that occurred during some changes on the admin panel. We have this site called Caid.gr , it's for a non-profit company. We changed the Wordpress site URL by ...
1
vote
1answer
3k views

what is the use of /wp-includes/SimplePie?

I have this location on my server. /home/localhost/public_html/wp-includes/SimplePie. I have not installed samplepie plugin. What is it used for since it is not associated with samplepie plugin. The ...
0
votes
1answer
17 views

Split posts between databases

My client requested quite a specific solution for his WP based wordpress (single site, not multisite). Basically what he wants is, let's say after 1000 posts new database should be created (with 5 ...
5
votes
1answer
125 views

WordPress and multithreading

I'm working on a plugin. I've created an API that reads and writes to a custom table in the DB. This API can be called potentially from N clients simultaneously (and it really happens). I noticed that ...
0
votes
1answer
67 views

2 website 1 database… Local to online

I've two wordpress websites : - One online in FTP folder "www", for this website everything's ok ! - The second website is on localhost for the moment. I would like to put the second website on the ...
0
votes
1answer
212 views

Save and user submitted data from a form and display them in the wp backend

My question is very simple but the answer I'm not sure if will be that simple. I'm developing a website for a non-profit organization where people can fill out a form containing questions usually ...
0
votes
1answer
17 views

What Wordpress file is saving new users to database

I need to know, what Wordpress php file is saving new users to database. I can't find it, but I need to modify new users usernames before it's added to DB. Thank you!
0
votes
1answer
180 views

Why is converting my database to UTF-8 truncating entries?

I'm running WordPress 4.1.1. My site is hosted at NearlyFreeSpeech. I've been using my WordPress blog since the days when it encoded information in the latin1 charset. This week, I realized that ...
0
votes
1answer
26 views

Converting Posts to Pages

So my site backend had issues and my hosting company had fixed it up for me. In doing that, they inadvertently made all my pages, posts. I'm looking at the database that hosts this and there is a ...
0
votes
0answers
20 views

Pages edit as posts

I'm currently dealing with the fallout of the following question (How to change post to page). I got all my pages back though all the pages' URLs were changed so there is no hierarchy and when I try ...
1
vote
0answers
76 views

Set Display Name to first and last name (phpmyadmin SQL Query)

I'm trying to change all the users Display Names to be their first and last name. I have looked into a number of plugins and wrote my own PHP to try and accomplish this however the site has over ...
0
votes
0answers
143 views

Save data on custom table Wordpress

Here is my current code, <div class="wrap"> <div id="icon-tools" class="icon32"></div> <h2>Quote Manager</h2> <div class="aio-content"> <form method="post" ...
0
votes
2answers
87 views

Shared Custom post type between WP network sites

I'm developing four websites which are separate, besides the Events (custom post type). Three of the websites are WP, and I've got them in a Network. I would like Events to show up in all three Admin ...
-1
votes
1answer
21 views

Website that sells statistics

I'm building a website that will have statistics based on user activity on the website (online votes and views etc). People will have to pay to view those stats. I am utilising wodpress features ...
0
votes
1answer
22 views

Add several fields from different tables to post, fields per post are in same row of table

I like to add 4 or 5 extra fillout boxes to the adminpage of my post... For example, under the actual page box, I would like to add the following fields: Name position publications freetext Here ...
0
votes
1answer
113 views

Creating a search form and displaying results

Im trying to create a plugin for a site where the user can see a table of orders from customers in the Wordpress dashboard, It's a custom db but I'm using the wp-list-table, I've wrecked my brain for ...
0
votes
0answers
264 views

Fatal Error in \wp-admin\includes\misc.php after failed WP update

I was recently approached by a client whose wordpress site had been hacked. The hack caused traffic from search engines to be hijacked to cuteonbags.com. I narrowed down the malware in question and ...
0
votes
1answer
109 views

Image thumbnails not available post migration, but still accessible via direct URL - DB issue

To start with, I'll just clarify that this appears to be a different issue to the numerous migration ones already covered. In short, I've migrated my site to a new domain (both in root, no directory ...
0
votes
0answers
17 views

Migrate database between 2 different wordpress version

I have been trying to import a sql dump from a production site, which is several wp version behind the development site (4.1), is there any compatibility issue? Every time I try to login after the db ...
7
votes
4answers
25k views

How to integrate custom database table in Wordpress and using Wordpress functions

I'm on Wordpress 3.0.4 and I'm having a hard time deciding which way to go. The following is my problem: I have a mysql database table widgets, with about 10 properties like id, size, color etc. ...
4
votes
5answers
1k views

How many users can WordPress handle?

I want to design a member login site in WP but I have a doubt that is WordPress can handle more than 40000 users on same database? I am not sure about this so I am stooping my work here. So please ...
0
votes
2answers
93 views

$wpdb->query can't insert data

I Write Code to Save data in the Wordpress database table (table name is wp_fafa) But Can't Save data in $qry = $wpdb->query( "INSERT INTO `wp_fafa` ...
0
votes
0answers
18 views

Need sort posts by data in custom DB tabel

There is possibility to vote on project (custom_post_type) in theme I created. It has separate db table, where every vote are written (post id, ip, category id, vote time). What would be best way to ...
0
votes
0answers
15 views

Featured image for a third party application

I'm building a Phonegap application that retrieves posts from an existing WordPress database. In which way featured image (i guess it's in wp_postmeta) is related to the post id and how is it ...
1
vote
1answer
48 views

Super slow queries from author archive pages killing my database

I'm wondering if you can help me figure something out with these queries from author archive pages that are killing my database server. These queries are taking 7-15 seconds to run! Here's an ...
2
votes
1answer
257 views

Ways of managing staging and production wordpress sites?

Ok I've see a lot similar questions.. but they all either outdated or do not fall in in my problem. So the problem is: We have a website and its clone stage website. On that website apart form me ...
1
vote
1answer
195 views

MS Access to manage WordPress Database

Now I don't believe this is practical or possible without a large amount of development. My client's old site used MS Access to manage the user's profiles on his old website. His new site uses ...
1
vote
0answers
115 views

Separate Database Tables For Different Post Types

one big problem with wordpress is that everything on it is a post(a record in wp-posts table)! images, posts, pages, products(for example in woocommerce), portfolios, Post Revisions... Almost ...
0
votes
0answers
92 views

one database, same content, two wordpress sites, different structure? or another solution to have 2 websites with the same content?

I have a WordPress site that shows posts that it gets from rss using a plugin. I want to split the "jobs" in 2 different websites because in this configuration is not working properly (high amount of ...
0
votes
2answers
28 views

Connecting to wordpress database in my application [closed]

I am creating a wordpress site that will give accounts to people that want to be contributors/authors of a cause that people can donate too. We will approve/deny causes of approved authors Our ...
0
votes
0answers
22 views

Display all records in a table

I am new for word press i am displaying the all records in a table.Which file to write the coding in word press files.And also display the users page my like this ...
0
votes
1answer
63 views

Wordpress plugin: efficient way to store large data

I have excel file with 1000+ records. Basically it has zipcode and corresponding email addresses. I need to create a custom wordpress plugin which queries this data and sends the mail. It would be ...
0
votes
0answers
17 views

Creating a meta table for term or term taxonomy

I found this tutorial which works great for what I need. However, I am doubting wether it should be associated with the wp_term's term_id or the wp_term_taxonomy's term_taxonomy_id. They seem to be 1 ...
4
votes
2answers
427 views

Using Vagrant for customizable Wordpress Multi-sites [closed]

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 ...
0
votes
1answer
77 views

not saving post in wp_post wordpress database table

I write following code to save post in wordoress wp_post database table. but don't save in database function writeMsg(){ global $wpdb; $result = $wpdb->get_results ( "SELECT * FROM ...
0
votes
0answers
90 views

save content in to wordpress wp_post table of database

i write code to get content from other site. now I want save content in to wp_post of wordpress database.. date .. content.. titile ,.. wp_insert function wp_publish function thise my php ...
0
votes
1answer
38 views

User Tracking for Custom Post Type “Lesson”. Database Queries and Performance

So I wrote this little code snippet to add a post id along with the current users id to the user meta table. I'll use this to show the "lesson" posts that a user has viewed back to them. My only ...
0
votes
0answers
25 views

Moving Site: Is Re-downloading Files After Changing URLs necessary?

On the Wordpress Codex: Moving Site page under Changing Your Domain Name and URLs, it states that you should re-download your site files (Step 5) after changing your site URLs (Step 4). Is Step 5 ...
0
votes
1answer
30 views

more than 1 database user with in wordpress using wp-config

i want to use more than 1 database user to overcome the 7500 query database limit how i can do that using wp config my server is rxrxus.ipagemysql.com I want the users have the same password thanks ...
0
votes
1answer
28 views

How can I work on a database along side a client?

I was wondering what the best way would be to work on a database locally while a client is placing content into the database externally. My initial thought was to connect remotely to the database but ...
0
votes
1answer
40 views

Database alteration: users who voted

I have a post voting system that stores and displays the vote as an integer. When someone clicks on plus the vote increases by 1, when minus - decreases by 1 (exactly the same way as on this website). ...
0
votes
1answer
215 views

Is there a function to get post info for any publish_status by post ID?

I'm trying to, essentially, check whether a post exists and if it does (in published, draft or auto-draft states) return the post info. I'm finding get_post() doesn't seem to work with drafts, and ...
0
votes
1answer
46 views

Wordpress as a frontend website for iOS app [closed]

I am developing a product for a local gym. The product comes in 2 parts : - a smartphone app used by the client - a website used by the coach The coach uses the website to prepare the workout. So ...
0
votes
0answers
25 views

wordpress database error

I write code to extract peice from website with curl. this should be refresh page to get price. I want store data in the wordpress database with foreach. when I refreshing page but give this ...
0
votes
0answers
15 views

Partial text search custom taxonomy

I am trying to do an autocomplete field that interrogates the database finding a custom taxonomy but can't seems to figure out how to achieve this. Would i need a custom query?
0
votes
1answer
17 views

Website displays old version of page

So I'm working on a website for a company and everytime I edit a page/post I have to manually go in to the database and remove the old versions (which isn't something that I'd like to do since it's ...