WordPress stores user generated content, along with other configurable information, in a a database (typically MySQL).
0
votes
1answer
149 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
6 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
1answer
22 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
2answers
26 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
34 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 ...
0
votes
1answer
165 views
How to update BuddyPress xprofile fields programmatically?
I update user info using wp_update_user function. I also need to update the table wp_bp_xprofile_data. Is there any function, where I can update data on wp_bp_xprofile_data table?
0
votes
1answer
137 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
119 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 ...
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 ...
3
votes
2answers
299 views
WordPress use innodb by default?
I just created a new WordPress site in my server. Normally, WordPress uses MyISAM as the database type. But this time, it created all InnoDB tables! Is this normal? Has WordPress switched to InnoDB in ...
0
votes
1answer
10 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 ...
2
votes
2answers
133 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
0answers
77 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
111 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
30 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
32 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
1answer
20 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
...
9
votes
4answers
759 views
Is it bad practice to create own table for a plugin?
If I want to save settings for my plugin then it is pretty easy and straight forward.
Now I would like to save to the database a bit more.
A file name, and 3 other values that only apply to that ...
0
votes
0answers
29 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 ...
4
votes
1answer
94 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
0answers
24 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
25 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
votes
0answers
25 views
Execute mySQL query on publishing of post
I would like to post some data to a db when certain categories are selected in a WP post. I would like this to action when the post is made.
This is the query I want to run:
mysqli_query( $con, ...
0
votes
0answers
28 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
2answers
53 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
42 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 ...
4
votes
3answers
584 views
Performance tips for a large user base [closed]
I’m preparing a site with many users (100.000+). Since the output depends on the current user’s relation to some custom post types and taxonomies a static cache won’t help much.
Besides using a ...
1
vote
2answers
442 views
Wordpress doesn't show all posts in database
I have around 140 post in database but wordpress admin page shows just 50 post. How could I let wordpress shows all the posts in database?
Thanks
0
votes
1answer
15 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?
2
votes
2answers
226 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
1answer
28 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
18 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
21 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 ...
-1
votes
0answers
20 views
Trouble loading custom table database data
I have the following table: wp_customercounts with the following fields: customercountid (unique and auto generated), customerid (post_id) and logged_date.
I want to return the number of counts / ...
-2
votes
0answers
27 views
Wordpress and web portal based on DB [closed]
I have a MySQL database with some tables and I want to create a web interface on it.
In this web portal I want to manage:
user (access, policy, log)
security
action log
page based on DB (single ...
0
votes
0answers
30 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 ...
3
votes
1answer
133 views
Plugin Not Working, But Only On GoDaddy Hosted site
I'm creating a plugin for a friend to log search terms on his site. It's very basic. It creates a new table to store terms entered in the search box. It converts the search term to lower case, ...
3
votes
1answer
144 views
How to use custom database tables for custom post types?
I need to use an existing database table as a Custom Post Type (CPT) to integrate it with wordpress.
I've considered @boone-gorges thoughts here (should I?) and have decided, Yes, I need to use a ...
0
votes
0answers
17 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
2answers
132 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.
0
votes
1answer
27 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
28 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
133 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 ...
10
votes
3answers
522 views
Performance of my permalink structure?
I have read the discussion on the performance of different permalinks on the wp hackers mailinglist, THIS forum and around Google.
I could however not really deduce if the permalink structure I have ...
1
vote
0answers
32 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 ...
2
votes
2answers
217 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 ...
0
votes
0answers
19 views
How to use default WP form elements to ineract with custom db table?
I know about the use of custom_post_type, 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 like to use ...
2
votes
1answer
82 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
24 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
30 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 ...
