WordPress stores user generated content, along with other configurable information, in a a database (typically MySQL).
0
votes
1answer
32 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
8 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
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
0answers
76 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
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
...
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
91 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, ...
1
vote
2answers
50 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
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
1answer
40 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
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?
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
26 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 ...
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
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 ...
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 ...
0
votes
0answers
18 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
80 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 ...
0
votes
1answer
26 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
0answers
16 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
21 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, ...
0
votes
2answers
27 views
Is database deleted on clicking “reinstall” button in Wordpress updates?
I have a blog made with WordPress. If I click "Re-install" button present in WordPress updates page, will all the database be dropped and created again? Will my posts be deleted?
1
vote
1answer
44 views
Is it possible to create Custom Post plug-in?
I understand that Wordpress allows you to create Custom Post Types with Custom Fields, but is it possible to create a custom Plug-In that creates and maintains its own Custom Post type (outside of ...
0
votes
0answers
24 views
Plugin for organizing and sharing information collected from contactforms
I would really appreciate to get some help with a wordpress page that I'm creating.
I want to create a page where people who are interested to be contacted for a service I'm providing are sending in ...
0
votes
1answer
35 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
18 views
Is the wordpress user-model changed in wpmu?
I'm running wpmu on heroku using a postgres extension. It works great, but I have a plugin that needs to get the userId based on the e-mail-adress. This is how it does it:
$sql = 'SELECT id FROM ' . ...
0
votes
1answer
26 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 ...
1
vote
1answer
58 views
Separate table or usermeta
We are creating custom fields for users like annual income, gender, city, country, etc. There are about 10 odd new fields. We will be importing approx. 30,000 records for each user in a month through ...
0
votes
0answers
21 views
Using Zoho Creator Database inside Wordpress Frame
Our agency network has an existing Wordpress-based website, and we would like to use Zoho Creator sort of like an intranet which is accessed through the Wordpress site. Basically, something along the ...
0
votes
1answer
80 views
Insert data in custom table during new post creation
I want to in insert data in my custom db table when creating a post.
Suppose there are three categories (php, wordpress & jquery). When i create a post in wordpress, i want to insert post id and ...
0
votes
0answers
8 views
update other databases when main databases update
WPMU membership plugin on three WP websites and want to have update the other two sites automatically when someone joins the main website. Do not want to use Multisite.
content on each site is ...
0
votes
2answers
29 views
What is the best way to store a few fields?
I'm researching what it would take to develop a custom Wordpress plugin. The plugin is a pretty small one. We just need to persist 2 fields of integer information. It's a pretty basic progress bar ...
2
votes
1answer
46 views
Filter WordPress posts by between parameter
How to filter WordPress posts by a taxonomy and between parameter? Consider a mobile website with "memory size" taxonomy, I need to show posts that have more than 256 mb memory and less than 768 mb.
...
0
votes
1answer
38 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
0answers
51 views
Host does not allow remote connection, so how do I transfer data to my WordPress site?
I spent the last week trying to get my PHP code on my website to connect to my remote "personal" computer to display some data on a webpage. I just found out today from my web host (ipage)
"our ...
0
votes
0answers
62 views
Install WordPress with SQL database
I am very new to WordPress. I didn't even know it existed until I had to do it for my work. So I started in with a WAMP server with WordPress. That worked fine until we needed multiple sites with ...
1
vote
2answers
97 views
Error establishing database connection - high traffic?
I have a WordPress 3.5.1 site that's getting a little bit of traffic (80 concurrent visitors, ~5 clicks/pageviews per second). The site runs fine until it spikes to ~85 visitors. There are usually 4 ...
0
votes
0answers
48 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. ...
