WordPress stores user generated content, along with other configurable information, in a a database (typically MySQL).
-1
votes
4answers
105 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; ...
0
votes
3answers
30 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
115 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 ...
2
votes
2answers
198 views
Custom database or Custom Post Types?
I have been searching throughout the web for the best way to implement what I need but just cannot find a best solution as there always seems to be some drawback. I'd prefer to do it right the first ...
2
votes
2answers
130 views
What is an efficient way to query based on post_meta?
The problem I am having is when I allow users to filter posts it overpowers the database and things run extremely slow. I am unsure what the best way to query posts using meta values is. My site has a ...
2
votes
2answers
212 views
Using Disqus, how to stop storing comments in wp database?
I'm using disqus comments system, but it keeps storing the comments in the wordpress database as well. Is there way to disable option to store comments in wordpress database because I don't see any ...
0
votes
2answers
69 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
55 views
Import External XML
I don't know where to start with this one.
I would like to create custom post type which will list properties on clients website. I would like those properties being feed from another ...
0
votes
2answers
105 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.
-3
votes
2answers
169 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
25 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
22 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
29 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
179 views
Wordpress error since update 3.2.1 to 3.5.1
Since I have updated wordpress 3.2.1 to 3.5.1 I have this error.
One month looking for this error and so far, I can not find a solution even know what file causing this error.
[16-Mar-2013 11:36:35 ...
0
votes
1answer
51 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
31 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
23 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
115 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 ...
0
votes
1answer
28 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
78 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
90 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
51 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
65 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
89 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 ...
0
votes
1answer
85 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
43 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
47 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
85 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
131 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
78 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
91 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
143 views
database not responding on localhost
I'm trying to work on an existing WordPress site on my Mac using MAMP. I've setup a new database using phpMyAdmin and imported the tables from the backup of the online version. I pasted this into ...
0
votes
1answer
84 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
45 views
What is the correct/safe way to delete all comments?
We've inherited a WordPress (3.3.2) site that has 13k pending comments, all of which are spam.
To delete all these comments is it sufficient and safe enough to do:
DELETE FROM wp_comments;
DELETE ...
0
votes
1answer
64 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
109 views
Simple subscribe widget form
Im 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.
Im no ...
-1
votes
1answer
31 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
80 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
...
