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

learn more… | top users | synonyms

-1
votes
4answers
273 views

Insert into db with foreach problem

I have no idea why this foreach it`s not running. When i post the article, only inserts once. Should make it at much as needed. Do you see any problem? $array_produse = array(); for($i=1; $i<=8; ...
3
votes
3answers
963 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.
2
votes
3answers
247 views

How do I save data from submitted form from widget

I'm looking over internet for some simple solution of email subscription widget but no luck. Or they are too complicated and paid, or they are relaying on some external email functions. I'm not a ...
0
votes
3answers
85 views

Fetch a single row from a custom table for to a given ID

When I want to get a single row from a custom table of my WordPress database by providing a username through function call, it does not work. When I mention the username in where clause of the query, ...
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 ...
2
votes
2answers
415 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
2answers
34 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
2answers
44 views

Do WordPress Permalinks Refer to a Lookup Table in the Database?

I'm trying to figure out how to rewrite URLs while dropping the original parameter (whether it's a number or text); basically exactly what WP does with it's clean permalinks Does a database lookup ...
0
votes
2answers
428 views

MySQL Syntax Error upon restoring database from backup

Performed a bad import to my Wordpress install and decided to restore from the mqSQL backup (full export) I had made minutes earlier. Dropped all tables in the database and then did an import from my ...
0
votes
2answers
491 views

WordPress database error Got error 28 from storage engine for query

I had been using WordPress for the past three years. I haven't got any errors in the error_log. I think the problem would be cause of the new server my hosting is in. For the last two months i am ...
-3
votes
2answers
420 views

Preventing duplicate entries in mySQL database with PHP

I have a contact form (Contact Form 7) that submits all fields into a mySQL database (via the Contact Form 7 to Database Plugin), everything is working fine with that. I want it to however, throw 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
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
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 ...
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 ...
0
votes
1answer
37 views

How do I find posts?

I am a new website administrator and I am having issues with posts not showing on dashboard. Posts All(21) Published (13) Pending (8). This is a listing site and the posts used to show up. Any ...
0
votes
1answer
87 views

WordPress database error Unknown column

I get this error in my database log: [05-May-2013 21:13:31 UTC] WordPress database error Unknown column 'region' in 'order clause' for query SELECT * FROM tmp1db_wpuf_customfields ORDER BY ...
0
votes
1answer
57 views

Print output of Table Creation

I am creating a few tables and I getting the following message: The plugin generated 440 characters of unexpected output during activation. If you notice “headers already sent” messages, ...
0
votes
1answer
110 views

Trying to post information from a remote database to wordpress page

I'm fairly new to Wordpress and looking for some help. Goal: I would like to stream data from my personal computer's Mysql database and display it on a webpage in my offsite Wordpress hosted site. ...
0
votes
1answer
32 views

Check in function on custom page

I have a website about places and attractions in my country. Each place/attraction is a different custom post. On this page, i would like to add a button with the value "Check In" and if clicked by a ...
0
votes
1answer
70 views

Clipper theme needs database?

I have used clipper theme for my coupon site designing. is it necessary to create a database for this or shall i upload my wordpress files to the webserver? Happy Coding Dinesh
0
votes
1answer
143 views

Query specific posts per user selections from dropdown menus

This may be a little different than most people do. I'm trying to show certain posts that are determined by 4 different "categories." I have a large database table full of "products" (I'm using the WP ...
0
votes
1answer
165 views

Import custom database into wp and keep the post id

Hello guys I have a project where I need to import an old database to wp but I need a solution to keep the old id's as posts id so i can make the links look the same as the old website in this way we ...
0
votes
1answer
38 views

Recommended Post Structure for DB Storage

I'm trying to write a plugin that would help my local little league manage their league, and though I've read the New Table vs Post Meta question, it's still a bit unclear and I'm hoping someone here ...
0
votes
1answer
28 views

What is best for saving lot of extra detail of user?

In my site i need to store 200 extra data for each user. Now i know about the user meta option. But is it a good way to save 200extra field for each user? Or should i create an extra table in the ...
0
votes
1answer
67 views

Get the url of attachments from the post?

I used the following code to get the images attached to a post $current_id = get_the_ID(); $rows = $wpdb->get_results("select guid from $wpdb->posts where post_parent = $current_id"); ...
0
votes
1answer
350 views

Where would I find Custom menu attributes in the database?

In what table would I find the title of a custom menu in MySQL for Wordpress 3.5.x?
0
votes
1answer
61 views

WordPress Multisite platform for different city for single db

I have One WordPress Multisite installation. myplatform.com (Main platform) have custom post list for different city say city1, city2 & city3. Now What I want is on city1.myplatform.com (city1 ...
0
votes
1answer
38 views

Problem with menu categories doubling up when updating database?

I imported a database from a website to my localhost and the menu categories started doubling up. The wordpress dashboard is also missing my custom post types. How can I solve this?
0
votes
1answer
34 views

I would like to create a premium area with “extra information”

I would like to use a contact form (contact form 7/secure contact form/etc) and use the data that people send to create a "premium area" where only specific users will have access. Let's say that I ...
0
votes
1answer
254 views

Get value form wordpress database

I'm sorry if this ambiguous but I'll try my best I have the following php code from a WordPress Plugin $url = 'http://mydomain.com/'.$ListingID.'/'; I need to define a value for $ListingID The ...
0
votes
1answer
221 views

Contact form with database integration issue

This is more a question about the idea I am going to share and ask for advice for. I would like to have a contact form on my site, where people complete their data and it gets stored inside a ...
0
votes
1answer
92 views

Saving zero as meta value

I have a meta_key called "_ordre" and each time I create a new custom post, a new meta_value is set for that meta_key. The thing is, when I set the value of '_ordre' to 0, the meta_value is not saved ...
0
votes
1answer
115 views

Change taxonomy slug in database

I am using Events Calendar Pro and due to a bug multiple Venue taxonomies were created. For example, I have museum, museum-2, etc. I would like to delete the duplicates but assign the event associated ...
0
votes
1answer
101 views

Using custom tables for old posts

I have a site with about 24,000 posts and 200 posts daily and the database will get huge soon. So I plan to transfer the old posts to custom tables to reduce the database load. There's no need to show ...
0
votes
1answer
64 views

How do I find users by password?

I need to add a passkey to each user, so I decided to just giving the user password that value and use WP functionality to store it/retrieve it. So now I need to find what user that password belongs ...
0
votes
1answer
67 views

Is there a full explanation on how to share a database with two Wordpress sites on same server?

I have read that you can have two wordpress database tables (using different table prefixes) to share the same database. I understand the concept but does any know of or can anyone provide an outline ...
0
votes
1answer
138 views

Export / import Wordpress database

Is there a proper way of exporting and importing a big WordPress MySQL database to a new database? When I tried to do that in the standard way I run into 2 issues: All widgets disappeared and I had ...
0
votes
1answer
104 views

Fast worpress backup/clone

i have a problem with 2 websites. I have for example site1.com site2.com How can i make a perfect clone of site1.com for site2.com? i mean i want a method that i can do this in minutes, not ...
0
votes
1answer
177 views

Merge two databases: OLD SITE -> NEW SITE

I am working to a restyle of a website. I made DB dump from remote server and made local installation, then started to work on my local machine. While i've been working other post have been added to ...
0
votes
1answer
115 views

Trying to edit a WP site locally using MAMP

I'm new to WordPress. A friend asked me to redesign his WP blog and I've installed it on my Mac using MAMP. I went through the database setup and imported the site's existing DB and added the tables. ...
0
votes
1answer
92 views

Adding a filter to wp_edit_posts_query() to prevent hierarchical display of pages

So I have a Wordpress 3.3.2 installation with around 8k pages in it now. I seemed to have gotten past a threshold that causes edit.php and the page listing in the admin to take about 20 minutes to ...
-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
124 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
votes
1answer
239 views

Theme Options - localhost to new url

Im having this issue that happens to me each time i work on a website. On every project i start working locally and once im done i export my Database and search replace all localhost url's to the ...
-1
votes
1answer
36 views

Shortcode returning specific content of a post

I'm currently building a plugin to display specific part of post after accepting verification code. Can a shortcode return a part of a post? I mean: Bla bla bla [shortcode postID="100"] Special bla ...
-1
votes
1answer
97 views

Custom wordpress SQL statement for a website

I'm trying to link specific columns from a few standard tables in a wordpress database. I specifically want to see a view/table that includes: post title post content guid meta value = image url ...
-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 ...