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

learn more… | top users | synonyms

0
votes
1answer
29 views

Using class id from array for query

I'm using Event Calendar 3. Since there seems to be no easy way of querying all upcoming events as posts, I tried it this way, getting the IDs from the DB and querying the posts from that: <?php ...
0
votes
1answer
22 views

Copying blog from root to /folder (Not moving)

Here is the scenario - I want to COPY (not move) the blog from www.domain_name.com/ to www.domain_name.com/folder... I want to keep the copy in root folder intact but run the same blog on subdomain ...
0
votes
0answers
21 views

Wordpress database tables crashing frequntly

For my site www.placementmantra.in, I am experiencing twice-daily table crashes, mainly wp_posts. I tried disabling all plugins, but the problem persists. Any suggestions?
2
votes
1answer
300 views

how to show database content in wordpress post

I'm a beginner for WordPress. I have a database app written in PHP and MySQL and I need to convert it to WordPress and also I what to post the database rows info by shortcode were id="x" like: ...
0
votes
2answers
1k views

Inserting into data into external DB using WPDB

I'm trying to work with an external db in Wordpress for the first time and can't seem to get it to insert the data into the DB. Here's what I have: <?php global $wpdb; $url = ...
0
votes
0answers
49 views

Getting deleted users in database

I am using the database that is being used by a WordPress site. I am trying to get all the users from wp_users table with SQL query. But there is also previously deleted users in wp_users table. I ...
0
votes
0answers
265 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
37 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
546 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
2k 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
280 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
41 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
182 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
204 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
251 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 ...
1
vote
1answer
192 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
1answer
61 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 ...
1
vote
0answers
52 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
130 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
345 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
52 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
294 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
559 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
85 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 ...
0
votes
1answer
2k 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
35 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
61 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
139 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
283 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
176 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
47 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
906 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
214 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
179 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
322 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
167 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 ...
1
vote
1answer
764 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
34 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
152 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
36 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
265 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
84 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
23 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
105 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
122 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
66 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
124 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
425 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
277 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
114 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 ...