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

learn more… | top users | synonyms

3
votes
1answer
145 views

Using Vagrant for customizable Wordpress Multi-sites

Background: My partner and I have a goal to create a customizable vagrant project that uses Wordpress multi site, as a local development environment. Ideal Use Case: Various developers on our team ...
1
vote
1answer
26 views

Why does dbDelta() not catch MysqlErrors?

From what I can see, dbDelta() is designed to suppress database errors that occur during its operation. Generally speaking, this seems to be the case, but New Relic is still reporting MysqlErrors ...
1
vote
1answer
10 views

Detecting errors generated by $wpdb->get_results()

How do I detect errors when using $wpdb->get_results()? For example: $result = $wpdb->get_results("SELECT * FROM this is not a valid query"); The preceding code doesn't generate any exceptions ...
1
vote
1answer
14 views

How to display posts by vote count and if no value continue with latest posts with no votes?

Maybe someone can help me with this. I want to display posts by votes. Users can only vote up. So what I want is - the most voted posts by vote count on top and then latest posts with no votes. The ...
1
vote
1answer
20 views

Does auto_load to 'no' in wp_options improve performance

I am trying to improve the performance of a wordpress based blog. I am looking at wp_options table and am thinking to set the column auto_load to 'no'. Does it have any side-effect on the site ...
1
vote
1answer
38 views

Query Wordpress database by registered date and role

I would like to get the display name and email address for all users who have registered to my multisite today with the role of subscriber. It needs to be an SQL query as it's used outside of the WP ...
1
vote
1answer
103 views

How to recover Wordpress on GoDaddy hosting after reseting database password?

I did reset my database password, so I could enter the phpMyAdmin, but now my Wordpress installation can't connect to the database. I tried to access the "wp-config.php" (should be at ...
1
vote
1answer
92 views

How to use default WP form elements to interact with custom DB table?

I know about the use of Custom Post Types, 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'd like to ...
1
vote
1answer
132 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
255 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 ...
1
vote
1answer
50 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
56 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
98 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
18 views

When I click edit on a post, all the content disappear. Does anyone know how to fix this?

I am working on a site: greatlakesecho.org When I try to edit a post, the content just disappears from the visual editor. I am running the latest version of Word Press but this happened on the ...
0
votes
1answer
11 views

How to set search query for joining two tables in sql?

What's the wrong with this query? SELECT l.company_name,DISTINCT c.sub_cat_name FROM tbl_listing l,tbl_sub_category c WHERE l.company_name LIKE '%cy%' and l.city_id='2' and l.area_id=23 ORDER BY ...
0
votes
1answer
24 views

How Do I Merge Categories With phpMyAdmin

I tried the following phpMyAdmin query to merge my category 112747 into my category 112748: UPDATE wp_term_relationships SET term_taxonomy_id = 112747 WHERE term_taxonomy_id = 112748; It did not ...
0
votes
1answer
51 views

single.php not pulling in any data from database

My single.php doesnt seem to be fulling any information through from the database for the current post. here is my single.php code: <?php get_header(); ?> <div class="main-container"> ...
0
votes
1answer
19 views

Changing starting number of User ID

I've got a client who would like their online user registration to match their current database. Thus they'd like their wordpress sign ups to start with 00100, I can't seem to find a plugin that ...
0
votes
1answer
20 views

WP Posts Not Adding Up

My WP is hosted at Yahoo I am running WP 3.5.2 and the Posts Page does not add up All (4,356) | Published (629) | Sticky (1) | Drafts (265) | Private (88) WP seems to have an extra 3373 posts. I ...
0
votes
1answer
28 views

Retrieving Login Data from Woocommerce and Putting it into a Form

So my goal is to try and retrieve the data from the account a user logs in with. e.g name,age, address and place this within a contact 7 form. So there name, age and address will appear already ...
0
votes
1answer
43 views

Using custom post types WordPress network

Working on a project I am setting up a WordPress network containing sites/blogs for small shops. I would like to use 2 custom post types in the following way: A location post type; The blog admin can ...
0
votes
1answer
33 views

Size article thumbnails and retrieve them directly from database

I've integrated the Wordpress database directly with my .NET application. What I want is to set the featured image of a post. This featured image must be maximum 800pixels wide, and automatically ...
0
votes
1answer
46 views

How to change images size after theme modification?

The images in the previous theme were using a height and width listed in the source html. The new theme will resize the images using percentages, so I need to remove all the height and width in the ...
0
votes
1answer
47 views

Getting data from a table using a query

I’m starting with WordPress and I have a lot of problems and doubts. I’m trying to display on a page data stored in a table of my database. I have a table named Customers (id, name, surname, phone). ...
0
votes
1answer
18 views

custom post type for custom talbe

Where would I start if I want to have a custom post created each time data was submitted from a form on the front page for non-logged in users? I have the script set up to send the data to a custom ...
0
votes
1answer
86 views

How to fetch records from database WordPress

index.php: <?php $new=$wpdb->query("select * from wp_posts where post_title='Auto Draft'"); $new1=mysql_fetch_row($new); echo $new1[0]; ?> How to fetch record from database? How ...
0
votes
1answer
88 views

Get content from other database table based on an ID and rewrite URL

I am currently using WordPress with SEO friendly permalinks. One page of my website is a special one though, let's call it http://example.org/locales. It is using a custom page template that loads ...
0
votes
1answer
57 views

Sub-domain or 2nd, temporary different domain?

I'm developing a Wordpress site for a website that already exists (that's not currently using Wordpress). The current website cannot be taken down until the new Wordpress site is ready to replace it. ...
0
votes
1answer
70 views

import (migration) user database to wp-users

I am having hard time for importing to user-meta and post-meta from my non-wp-tables. I am trying to do db migration from user table and post table to WordPress tables. So it might be user table ...
0
votes
1answer
67 views

Comments broken. All comments gone & no new comments can be made. Possible jetpack issue?

So, my client has two self hosted wordpress blogs- one long-existing and one new one that she just launched. She clicked on a jetpack activation link- meant to connect her new blog to it's ...
0
votes
1answer
56 views

Database location in Wordpress

I have created my website in WordPress and want to transfert it in my domain created with ipage. I am not able to locate the WordPress database. Can you help me? How is the format or extention of DB ...
0
votes
1answer
122 views

delete duplicate meta_value with same post_id

I've trying to cut down on the time to query a custom post type. After looking at the database and the wp_postmeta table, for some reason, there is some duplicate meta values for the same post_id and ...
0
votes
1answer
45 views

Copy site on same server?

I have a wordpress installation running in my root folder, and I want a copy in /en (including theme, posts and pages). I want a bilingual site and found the plugins too complicated for me - so I ...
0
votes
1answer
24 views

How to find an option in the database?

As far as I can tell, the plugin that I'm using is saving options to the wp_options file: ### New global settings container, will eventually be the only one! $cformsSettings = ...
0
votes
1answer
98 views

Displaying BLOB PDF File

I have some pdf files that are stored in the wordpress database as a blob and I need to display these files. The files are not linked to any posts directly. The code I have currently is: <div ...
0
votes
1answer
33 views

Working local with one database

We are working with GIT while development but keep sending each other database exports. I would like to use one database on a development server (as suggested to be the easiest solution on Keeping WP ...
0
votes
0answers
82 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
10 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
467 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
246 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
38 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
42 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
123 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
105 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
109 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
44 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
154 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
67 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 ...
-1
votes
0answers
24 views

Remove comments from database

I have a number of comments generated by a WooCommerce payment gateway module. For some reason the comments can not be deleted in the backend (no checkboxes). Would it be safe to delete them from the ...
-3
votes
0answers
18 views

How to store form submissions and edit their statuses in admin area?

The main idea is to create form (product purchase) and store submissions in DB. In admin area I need to assign statuses for each submission and assign completion to user role 'manager'. Create user ...