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

learn more… | top users | synonyms

0
votes
1answer
31 views

Has anyone tried putting PHP ActiveRecord on Wordpress?

I have worked with Ruby on Rails and I was looking for some code that did something close to the wonderfull RoR's ActiveRecord. I stepped by this site. Its PHP-ActiveRecord! I found it amazing, and ...
0
votes
2answers
274 views

WSOD 3.9.1 – Tried Everything so far

Hoping someone can help me troubleshoot my White Screen of Death. Site Info: WP 3.9.1 (just upgraded) PHP Version: 5.4 (just upgraded) Single Version Many other installs of WP on this server (with ...
0
votes
2answers
727 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 ...
3
votes
2answers
528 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 ...
1
vote
1answer
96 views
+50

Save custom post type in different table

I need to store custom post type post data into a custom table, not in wp_posts and wp_postmeta. Is it possible? anyone help please. Actually, I have created two custom post type named "truck" and ...
0
votes
0answers
9 views

How to migrate the posts from an old custom legacy blog to a new WordPress website?

I have to migrate the posts of a very old custom legacy blog made in ASP (the posts are stored in a MySql table) into a new WordPress blog. So I need your help to find the smartest solution to do it, ...
1
vote
1answer
288 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
2answers
611 views

Saving Custom Post types and fields to a custom table

I have a project in which I am trying to import a large amount of data into a WordPress installation and from that data, create pages on my site (as a custom post type). Since these pages will be ...
0
votes
0answers
14 views

Multiple Installs using the same database AND tables

I've been looking for a solution to this problem for actually a few months. Before I get started I would like to inform that I have NO INTEREST in using wordpresses multisite. Here is the issue for ...
2
votes
1answer
2k 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
1answer
15 views

Linking Custom Fields to Database Records

Hey there im fairly new to wordpress and php, but have a strong programming/database background. I recently learned about custom fields and am wondering if it is at all possible to do the following ...
0
votes
0answers
11 views

Store several information in another database [closed]

I like ticketing system to be part of wordpress but because of many tickets/replies, database becomes a lot bigger every day and I don't want to take any risks because products, billing info etc are ...
2
votes
3answers
291 views

How do I save data from submitted form from widget

I'm 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. I'm not a ...
1
vote
1answer
5k views

Insert data in database using form

I am writing a simple plugin that create a table with name "newsletter" in database and provide a shortcode to put a registration form in pages. the form contain "name" and "email". i have problem ...
0
votes
1answer
11 views

Issue with data array format

I am trying to fetch a record of date from table booking_history with bellow code but the result array not displaying any record from start_date column. when i echo the query query displaying value ...
3
votes
1answer
234 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 ...
0
votes
0answers
20 views

Add new user and custom post at once [closed]

I'm creating av car selling website an I have a form that need to connect with the wp-db and add a new member upon registration. But it also need to add a car ad for the new user. How do I do that? ...
1
vote
1answer
247 views

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

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 ...
0
votes
1answer
451 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?
2
votes
1answer
16 views

Subscribers to posts

Consider each post to be topic of conversation, and comments a conversation. For now it is fine. I created a post type called conversation. Now I want to list all the conversations a user is in. How ...
0
votes
1answer
39 views

Hook into $wpdb

Is there a way to hook into the WPDB instance ($wpdb)? What i basically want, is to execute a own function BEFORE the desired query get's executed. Is this possible? Additional question for comment ...
1
vote
0answers
41 views

WP_Query orderby and tax_query

My goal is to have custom posts type's posts (CPT for simplicity) from a custom taxonomy (CT for simplicity) let say CT Hometown with slug Nebraska to be listed grouped by another CT, let say ...
1
vote
0answers
24 views

Insert menus in the database

I want to create a large menu structure, and the admin pages time out, so I cannot insert them via the admin screens. How can I insert the menu entries directly in the database? Thank you
0
votes
0answers
19 views

Issues with page load after CSV export of database

I'm having an odd issue. I am using GEO my WP plugin (http://geomywp.com/) to create some custom post types and search forms on the front end. I am trying to import a database with about 600 posts ...
-2
votes
0answers
33 views

Recreate WordPress blog from www files [duplicate]

I managed to totally destroy my database. I still have the content of my site though; so I was wondering, what is the easiest way to re-create from scratch a Wordpress blog, using old material from ...
0
votes
0answers
21 views

Restore database from .frm and .ibd [migrated]

I had a WordPress website running a long while ago. I used WAMP server. Then, I uninstalled WAMP. Today I would like to work again on my website; all that remains of my database is this (I cannot find ...
0
votes
1answer
28 views

Copying database tables to new database

am trying to migrate my old site to a new site, by only copying database tables. the reason doing this way is the old site is out of date with plugins etc and i have WooCommerce installed which i dont ...
1
vote
1answer
900 views

Split WP install between 2 databases?

Is it possible for Wordpress to work from two databases? The reason I ask is that we're approaching our 100mb limit for database size on our host (1and1) but have up to 100 databases, so what I was ...
1
vote
2answers
2k views

How to use multiple database in wordpress?

I want to fetch some post from another wordpress site which is hosted in the same server. How can I fetch those post? Is multiple database connection is possible in wordpress?
1
vote
1answer
239 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
2answers
575 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
289 views

wpdb->insert multiple record at once

So after I have created the table 'settings-table' i want to add a couple of records to it. This is how I want to do it, not the best way, so I need a better way to do this because I will add more ...
0
votes
0answers
23 views

Writing directly to WP_Posts table

We directly add posts to WP_Posts table using filemaker. Once the post has been published, however, wordpress seems to be disregarding the existence of certain fields. For example, we have data in ...
0
votes
0answers
20 views

Get custom value from external database

a non-coder here but fairly competent to put together blocks of code :) I´m trying to build a prototype using Wordpress and one need I have is to connect to one or more different databases to get a ...
0
votes
1answer
29 views

Adding custom tables to Wordpress

I have a database which has thousands of rows of data in each of the tables. I would like to migrate this database into a Wordpress website. I would like the user to be able to log in to Wordpress ...
3
votes
3answers
1k 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
0answers
24 views

Can't seem to replicate permalink structure for localhost development site

I'm helping a friend migrate her WordPress powered shop. I'm to the part where I manually re enter all of her products on WooCommerce. On her current live site the link looks like: ...
6
votes
2answers
2k views

Default table collation on plugin activation?

I'm following this to make my plugin auto-create a table when the plugin is activated, but what happens is that while all the tables (the whole db) are utf8_general_ci, the newly created table is ...
0
votes
1answer
374 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
16 views

Database of names with search engine

Hi I'm interested in creating website with a database of names and a search engine that finds matches for queries and displaying the full record for the relevant field. I would like to know how I ...
1
vote
2answers
2k views

Two WordPress sites sharing the same content

My question is this: Is it possible to have two separate installations of WP with two separate domains sharing the same content? Scenario: User on http://A.mysite.com publishes a post. ...
8
votes
4answers
13k views

How do I show data from gravity forms in my template?

Preface I've installed gravity forms, created a form and users are submitting data to my site. What I want to do is show the data users are submitting to my site on one of my pages. I know there's ...
4
votes
2answers
10k views

How to get the post publish date outside the loop?

I need to pull out the post publish date in order to make the post post auto expire. The thing is I can't get the right publish date. Here is my code: global $wpdb; $post_ids = ...
0
votes
1answer
268 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
18 views

WP get stuck with a query on MySQL when the site is resumed

I'm running my web site from a local dev on a VM. Everything works fine with the exception of the resuming bit. When I resume the machine, systematically WP takes ages to load. And actually the ...
1
vote
2answers
2k views

clean wp_options table unused rows

In my Wordpress Blog site i have installed too much plugin and remove also many plugins. In database table "wp_options" size increases approx 13MB and there are many rows which are unused at this ...
0
votes
1answer
22 views

$wpdb doesn't like to store arrays

I'm attempting to store an array that looks like the one below, into a cell in a database using the code below the sample array. Unfortunately, WordPress doesn't seem to want to save it, and ...
1
vote
2answers
31 views

How can I show related posts from multiple separate installations

Say I have three sites, abc.com, def.com and xyz.com. All the three sites are different wordpress installations and different databases. Now in story page I want that related articles should come from ...
0
votes
1answer
21 views

Pulling values from a sepcific row in table

I'm trying to get the first and last name values for ONE person in a database where the meet certain conditions of being a team leader and having a specific project id. Because of this, it will always ...
0
votes
0answers
30 views

call stored procedure without parameters

I asked this question last week, but then I deleted it because it was stated to be off-topic because I use a function within buddypress. However, I am convinced that whatever I am doing wrong is more ...