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

learn more… | top users | synonyms

0
votes
0answers
146 views

Wordpress multisite and one database

i need to use one database (i mean the same tables) with all sites under my network. I know about switching blog, but it's not good with wp-admin side (for example for custom post type i can't see the ...
0
votes
1answer
31 views

Update plugin settings option_name for big plugin update

I am working on a plugin update and have changed the settings option_name and key. I would like that the old options are transferred to the new option_name. The old option name is: plugin_options ...
0
votes
1answer
304 views

custom post type: own database table structure and custom “new-post” interface

I was tried to search answer to my question, but I didn't find. What I need: Make own post type. It's simple with Custom Post Type UI plugin. Solved. To have own table in DB for post of new type. ...
0
votes
2answers
795 views

Getting value from database table depending on field value

I am using a plugin called formidable which is similar to Gravity Forms in terms of purpose. I have two fields of interest. The first field loads up all the values in the Town column of my ...
0
votes
0answers
183 views

Displaying database data as pages (or similar)

I have a friend that has a big database of cars (lets say 4000 entries). Now he wants to add this info to his website. Initially I played with the idea of creating a page for each car, but this ends ...
-1
votes
2answers
37 views

Homepage redirects to other site of mine? [closed]

I have a website in which the home page redirects to a different site, which is also from me. I tried getting on it yesterday and then, it was fine. But now, this evening, when I never touched a ...
0
votes
1answer
104 views

User accounts for saving form data?

I have a handful of forms on my WordPress site that people fill out, sometimes repeatedly. They can be fairly long, time-consuming forms, so I'm hoping to find a solution where a user's form data can ...
-1
votes
1answer
156 views

2 WP websites same content different themes

I am using WordPress 3.5.2. I need to have two websites with the same content (plugins/users/posts/pages etc) but different theme. Already tried several ways to achieve that but with no results. I ...
-1
votes
1answer
125 views

Importing Concrete5 content to WordPress

Are there any tools out there to convert content from a Concrete5 database to something WordPress can use? I have a client that may switch over, and would like to avoid manually copying content over ...
0
votes
1answer
135 views

How to fix unchanged URLs in Database after running serialized search and replace script?

I just did my first migration from a dev site to a prod site, using the InterconnectIt serialized search and replace script. The migration worked, but here is where I’m struggling: The site was ...
0
votes
0answers
57 views

'Error establishing a database connection' only after adding redirects

I'm adding some redirects from old URLs. I add them to .htacces and they work fine. Then after a couple of minutes I will get Error establishing a database connection after adding redirects The ...
0
votes
1answer
47 views

Update references to pictures on website after moving to new URL

I moved my wordpress website to a new URL on the same server and managed to update most DB entries with the Velvet Blues Update URLs plugin. But the paths to my pictures, which are being used by the ...
0
votes
0answers
88 views

how to pull and display field data into a users back office in a members environment using affiliate plugin

I am using two plugins which work well together. In fact one is s2memeber so I can have a members area, the other is called affiliate pro so I can use referrals to fill up the members area. However, I ...
1
vote
0answers
49 views

Importing 10 Years of Media into the WP Database

I've been running the same website for 10 years now, and whenever I would create a news story, I would manually upload and store all my news images in a "news" folder via FTP and then manually write ...
0
votes
1answer
95 views

Storing Form data in a different database

I have two wordpress websites and I want to store the data submitted by the forms in a centralized database in order to better manage the information. Is there a way I can store form data in a ...
0
votes
1answer
224 views

wpdb prepare insert table doesn't work

I followed the introduction to use prepare to insert some data to the table. The code is like this: $wpdb->query( $wpdb->prepare( "INSERT INTO ...
0
votes
1answer
43 views

select a single val though a table in wordpress

The table is like this: category_id category_name category_parent_name I would like to get category_id by using category_name. I searched online, and the code is like below: $ad_cat is the ...
0
votes
1answer
176 views

wpdb get_var is not returning any result (verified mysql query returns only one value)

I'm trying to modify a wordpress plugin to make it more adaptable for our needs. I have a custom user_meta called practice and we separate our users based on practice, so we need to separate quiz ...
0
votes
2answers
336 views

add_post_meta — not working

I am trying to insert data into wp_post and wp_postmeta tables but it seems like i am doing something wrong. Here is my code: $post_data = array( 'post_title' ...
0
votes
1answer
57 views

MySQL database migration to WordPress

I have a MySQL database established for a web application I have been working on in a non WordPress database. This database has many tables with pre-populated rows for foreign keys etc. which took a ...
-1
votes
1answer
1k views

Multiple WP install with same users database

I am creating a e-commerce website. I am using woocommerce with some cool extensions I bought. I need to make 2 websites, but store the users database (purchases, subscription purchases, etc) as well ...
1
vote
1answer
34 views

Use mulitple usernames?

Can I configure wordpress to use two database usernames, one to read (which has read-only permissions in the database) and one to post (who is hidden in a protected wp-admin directory) for security ...
0
votes
1answer
55 views

Should I use Wordpress to skin a database website?

I am going to start programming a website which allows users to post adverts for aircraft for sale. (Think autotrader for planes). It will be free to use. There are a few websites that do this already ...
0
votes
1answer
93 views

How many databases do I need?

I have been asked to build another site for someone else. Eventually, I will turn it over to them. I will develop it locally, then take it live, then turn over full control. In the meantime I need a ...
0
votes
0answers
186 views

Get User Login Data (date, time… )

I did my best looking for information about this subject. Your guidance is appreciated. My goal is to perform some actions based on the number of user logins on my website per month and login days ...
0
votes
0answers
168 views

Save Changes function after table is sorted using jquery

I have a simple table, and the jquery works great for sorting. The fields drags an drops perfectly, and updates then and their. Also of course the data in the fields are saved in a array. The data in ...
0
votes
1answer
40 views

$wpdb->update Issue

Can anyone see what I have wrong here? $wpdb->update( $table, array( 'lat'=>$paper_lat, 'lon'=>$paper_lon ), array( 'id'=> $result=>id ...
1
vote
0answers
383 views

How to fix database error duplicate entry

At first I thought this was just a damaged table, so I tried repairing via MySQL, but it appears there's more fundamental issues. Which of the duplicates should I remove, and any further advice in ...
5
votes
1answer
187 views

Using a database view = evil incarnate?

I'm at a point in doing some WordPress plugin development where from what I can tell I either have to create an entirely new plugin or I can create a database view. The client wants some simple logs ...
0
votes
1answer
123 views

Second ezSQL initialization for MSSQL

We are trying to pull data from a second database into Wordpress. The secondary database is used internally to store data, and Wordpress (also only used internal) is partially used to display some of ...
0
votes
1answer
194 views

Why does wp_links still exist in the db schema?

I understand that links used to be a big thing when Wordpress came out and during the blog rise, but the link feature is so underused nowadays that as of version 3.5 it is hidden by default (thus ...
1
vote
2answers
139 views

How to use a different database to list and manage comments in the backend

I need to make Wordpress use another database (not the one specified in wp-config site-wide) on the "Comments" admin backend. I then must be able to edit, approve, delete etc. comments as usual. The ...
0
votes
0answers
69 views

Can't connect to database when moving One-Click installed WP site to new server

I used my server (Media Temple's) tool to install a Wordpress site as a One-Click application, and developed the theme on my testing server. It's time to move the site to its company domain so I moved ...
1
vote
1answer
481 views

Bad Request (Invalid Hostname) on working server, database problem

I have a local server up using EasyPHP. I know its working because I have a default wordpress install running and up on my brower. I have a full site which I also know I have working because when I ...
0
votes
1answer
28 views

Limit of char count in WP custom fields

does anyone of you know what is the limit of chars count which can be stored in to database via WP custom fields? Let's say that I would want to add to custom field 20 000 chars. Would it be problem?
0
votes
1answer
69 views

Migrating database / content of non-CMS site to Wordpress

I have a non-CMS website which is fully build with PHP with a lot of content in it. I don't want to add my posts manually in Wordpress, because that's a pain in the ass (I am talking about 5000 ...
-2
votes
1answer
34 views

Create a plugin to create a new page in wordpress for each time a record is added into the database

I am new to wordpress and would like to get a way forward for a particular problem. I have a database table A with various columns. For each record in table A a wordpress page needs to be created in ...
1
vote
1answer
104 views

Remove old custom field after import

I have imported a set of posts to a new Wordpress install recently. This OLD set of posts had a set of custom fields attached to it (via post_meta using the ACF plugin). The new installation has ...
0
votes
0answers
65 views

Combine Query and Select Database to create directory loop

I have a query loop on my page that I am using which displays all users on the page with certain custom fields filled out. It's working fine however, I need to also query these users for their level ...
0
votes
0answers
22 views

Moving database from WP 2.6 to 3.5 problem

I recently moved my database from a wp 2.6 blog to a wp 3.5 form using this posts advice. (Alex Miller's answer). Everything looked good on the home page; however, when I click on an individual ...
0
votes
1answer
87 views

How do I display offsite database info on my wordpress site?

I host some online games from my personal computer which the game saves information to my Mysql database. I would like to display live data (if possible) on my hosted Wordpress site. I know the ...
0
votes
1answer
101 views

Where To Find bb_profile_data(); In bbPress?

I posted this same question on WP Forum, but it's completely dead. So, there is a great tutorial in this blog about showing post count in bbPress at this link. According to that article, to show ...
1
vote
0answers
59 views

database query with more than a couple meta hangs and doesn't complete

I have a development website with about 70 checkboxes for custom fields. The idea is the user selects one or more checkboxes, it queries the database for all posts that have a meta_key for the ...
1
vote
1answer
89 views

How to use default WP form elements to interact with custom DB table?

I know about the use of Custom Post Types, but in this case I do need to use a custom database table (FYI: it's a table that is IP-based shared with another non-WP website). In wp-admin, I'd like to ...
2
votes
1answer
313 views

Formatting of curly brackets array from WP database to get more readable output

E.g. when I want to edit something in my WP database, I get a headache, literally. Because I see something like this: ...
1
vote
1answer
178 views

Accessing two databases

I have two databases on my server, and wanted to know is there a way to access both databases from wordpress? My thought is adding the second set of credentials to the wp-config.php.
0
votes
1answer
97 views

Best practice to limit results in get_row()?

This is my query to check if a title exists (it's in a loop, therefore [$i]). $wpdb->get_row("SELECT * FROM wp_posts WHERE post_title = '" . $titles_arr[$i] . "'", 'ARRAY_A'); Anyway, I would ...
0
votes
1answer
108 views

Split WP_POST table based on post types

I was wondering if it's possible to get my posts from 2 databases depending on the post type. I'm using HyperDB but can't seem to get it to specify the database based on post type. I Basically need ...
2
votes
2answers
124 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 ...
1
vote
1answer
85 views

Extracting post categories

I'm in the middle of assisting a colleague in reconfiguring a Wordpress database for use on another platform. The database is essentially details regarding all the posts and accompanying metadata, ...