WordPress stores user generated content, along with other configurable information, in a a database (typically MySQL).
3
votes
1answer
143 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 ...
1
vote
1answer
82 views
Importing Data from a Non-WordPress database, into WP
I'm migrating data from a totally different database style into WP. The main issue I'm trying to wrap my head around is how to import any meta data, given that WP uses a key value pair style for meta ...
1
vote
1answer
100 views
How to use custom taxonomies to reference complex relationships?
I'm working on a site that will in part house information on products that many people have worked on in different roles. I'd like for people, the projects they've worked on, and their roles in the ...
1
vote
1answer
43 views
cross-site custom menu
i have a multisite whice i want to separate because its unneccery as two of my sites are on the same DATABASE and all i need is actually the dynamic custom menus which i have built in the main site(to ...
1
vote
1answer
42 views
how to migrate wpmu from one host to the other?
this issus is different fromm How to migrate wordpress users from one blog to another
since i am using WPMU, i have backup the database, and then import it to the other host, also i have changed the ...
1
vote
1answer
84 views
page not updating with database
I have code which updates the database fine, but the page doesn't update correctly! I have to refresh the page a second time for it to update correctly.
Here is the code below ...
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
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 ...
2
votes
0answers
73 views
Plugin development with unit tests
One of the things that my plugin does is creates a number of SQL tables as part of a versioning function (that is run under the admin_init hook as I couldn't find a better wordpress way of doing ...
2
votes
0answers
225 views
comment_post_ID 0 (cannot remove from dashboard)
Ran across something a bit odd that I haven't seen before. A client has a pretty active blog and uses Akismet (paid) to protect against spam. At least once a day, they're reporting a spam comment that ...
2
votes
0answers
698 views
Insert query inserts 2 entries, should insert 1
I've written a small posts by views plugin, well at least started one.
My tables are set up but when they are updated the code adds 2 entries into my table when a post is loaded and views are ...
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 ...
1
vote
0answers
46 views
Multisite 404 on pages - rewrite error breaks database
After updating my reading settings on my multisites, I get 404 errors on all my pages.
The only way to fix the issue is by reverting the database to previous version, that is the only way it can be ...
1
vote
0answers
31 views
Backup another database with BackUpWordPress plugin
Is there any possibilities to add another database which is connected to other wordpress plugin?
My site is using two database: main wordpress db and additional db for plugin data. The Backup includes ...
1
vote
0answers
43 views
Copy post to separate database with “add_action(…)”
I'm basically trying to have a copy of a post be sent to another database's table when it's published. I've gotten it to add a new row in the new table, with my own static arguments, but I'm not sure ...
1
vote
0answers
129 views
Should i use wp transient with w3-total-cache apc caching
Should i use in my queries wp transient like this -
<?php
if ( ! $my_paged = absint( get_query_var( 'paged' ) ) )
$my_paged = 1;
if ( ! $my_query = get_transient( "567recent_$my_paged" ) ...
1
vote
0answers
147 views
Easiest Way to Authenticate WP Users Using an External DB?
I have been looking for the best/easiest way to share users on a WP blog (in a subfolder) with the MAIN site's user database so that people do not have to register/log in on the WP blog when already ...
0
votes
0answers
31 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
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 ...
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
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 ...
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
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 ...
0
votes
0answers
15 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 ...
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
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
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
0answers
50 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
60 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 ...
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. ...
0
votes
0answers
20 views
Create a generic post type and define its metadata via another one used for categorization
Ok, I would like to share with you an idea I had and ask you what do you think about it and possible drawbacks I'm not able to forsee.
I'm building a database for an association with many kind of ...
0
votes
0answers
25 views
Create hundreds of users with just ID in phpMyAdmin
I'm trying to do the same as this post. But I have a problem with the
insert records into your wp_users table containing all the ID's of the
members you want to import
Right now, I have 3 ...
0
votes
0answers
80 views
Custom query on Wordpress custom table
I am working with a custom table where some values will be inserted or updated if they already exists, I have checked and rechecked the syntax and it seems to be working fine, if I run the same query ...
0
votes
0answers
44 views
how to display the contact form details after user selects date?
Iam using contact form 7 in my wordpress.
I want to display the form details after selecting the dates i.,e when i select 2 dates i have to get the stored details of form between those dates...
I am ...
0
votes
0answers
44 views
Wordpress and BigDump
I am having a bit of a nightmare situation. I was given a testarea on a subdirectory of a friend's client server as a temporary favor in order to test my wordpress site. The path is as follows:
...
0
votes
0answers
24 views
MySQL Engine vs. Charset
I am attempting to have my plugin create a new table. I am fairly new to SQL. I have found two different method for creating tables:
Method I
$table_name = $wpdb->prefix . 'cool_table';
$sql = ...
0
votes
0answers
35 views
How to add drop down sub menu from database fields in the particular menu slug
I am creating a menu(not in admin panel) in wordpress, and I want to add drop down menu from my database table fields in a particular menu slug?
How can I achieve that, using code?
I found the ...
0
votes
0answers
42 views
Wordpress DB collation for hebrew site
My current db collation is utf8_bin with utf8 charset.
When I add image title via admin (attachment plugin) in hebrew language I got something like "u05e9u05dcu05d5u05dd".
What I have to do to fix ...
0
votes
0answers
64 views
Widgets not restored from backup
I've done a little searching here to try to find what I need but most people seem to have these issues when they're moving a site or changing the sql. I'm doing neither so I can't figure out why ...
0
votes
0answers
68 views
Adding Custom field in a signup form not working
I have used the following code in functions.php to add some custom field to my registration form and add it to the db in the wp_usermeta table. But dont know why it is not working. I am using a custom ...
0
votes
0answers
159 views
Add data from front end into custom made table in database
I have a registration form which contains firstname, lastname, organisation, username, email etc. Here Username and email only will be saved in the db in the wp_users table.
I have created a new table ...
0
votes
0answers
39 views
Two Sub-Directories, One Database
I have an existing site install at mysite.com/wordpress (but it is set to be accessible at simply mysite.com). I have also installed a separate WP installation on a sub-domain (publish.mysite.com). I ...
0
votes
0answers
41 views
I am trying to send ajax collected data to the current users database
I am using WooCommerce and added an additional field "location_gps" to collect the location (lat,long) added the ajax call to collect the data. Now I'm stuck getting the data into the current users ...
0
votes
0answers
43 views
WP_Query returns 100 results on homepage
Bit of a strange one this...
I've recently migrated a site from wordpress.com to my own server. In the new location, however, wp_query always returns 100 posts on the homepage, regardless of which ...
0
votes
0answers
180 views
Share DB tables between two blogs on the same WP Multisite installation
Is it possible for two separate blogs running on the same multisite installation to share tables in the database?
By default, Wordpress adds the blog ID to the table prefix for all of the associated ...
-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
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 / ...
-1
votes
0answers
79 views
Plugin updating wp_options table and causing mysql issues
A client of mine has a wordpress site with the database and the wp installation in in a different servers. Yesterday I migrated the wp install to a new web server, keeping the database the same.
In ...
