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

learn more… | top users | synonyms

0
votes
2answers
1k views

How to use “TRUNCATE TABLE” MySQL statement?

I have tried dbDelta and $wpdb->query, they does not work. Does anyone has any ideas?
0
votes
2answers
159 views

migrate comments from old database to new database

i recently created a new wp site with some of the same content from my old wp site. is there a way to migrate comments from my old database to me new database? i tried importing old the wp_comments ...
0
votes
1answer
262 views

Default Plugin Settings Not Writing to Database

I have my plugin setup as such: Main plugin file mouldings.php <?php /* Plugin Name: Moulding Profiles Plugin URI: Description: Creates a 'Moulding Profiles' and 'Idea Gallery' custom post ...
0
votes
4answers
570 views

can't upgrade wordpress or install plugins, it seems to “think” it's still on a local installation

I'm pretty new to Wordpress, so sorry if this is an obvious mistake :) I've just moved a site from local installation on my computer to a live server. When I'm trying to install plugins or upgrade ...
0
votes
1answer
422 views

Re-creating a Wordpress database

In a moment of sheer stupidity, I deleted the wordpress database for a site of mine. Fortunately, it was a young site with only a few pages. Now, I understand that everything that was stored in that ...
0
votes
1answer
1k views

Database tables for sports betting integrated in Wordpress

I am currently building a sports betting website, and have problems creating database tables for tipsters who writes sports picks. All the picks should be stored in a database table, with information ...
0
votes
1answer
54 views

How can I query the db to access current post information?

Alright y'all. I want to dynamically display the information of the 2 most current posts to the screen. So far I have only been able to get results by hard coding the ID into the query. Is there a way ...
1
vote
1answer
274 views

How do I write this SQL statement for Posts written in last 24 hours?

Someone gave me this SQL code to count the number of posts (of post_type 'mixtapes') in the last 7 days. I tried to convert it to 'in the last 24 hours' as well, but it's giving the wrong number. ...
1
vote
1answer
676 views

Where are wordpress custom types stored?

Where are custom types stored? Because when a custom type is created, in wp_posts, the post type is set to the <new_custom_post_type>. But where are the details of the new custom post type ...
1
vote
1answer
1k views

Accessing WordPress MySQL Database via Data Connection in Visual Studio 2010 using C#

So I've Googled and followed countless tutorials, read documentation on MySQL, Visual Studio, WordPress, and Plesk. I try to leave posting on this site as the final option and it seems it has come to ...
2
votes
2answers
2k views

Edit Custom Database Tables in Wordpress

I have a site that uses custom database tables to manage info that is inserted by a process completely independent from Wordpress. The data from the table is used in the Wordpress site but it is not ...
1
vote
1answer
555 views

Merge two WordPress installations into one, and keep posts separated?

I have two Wordpress installations that I would like to make into one installation, but still keep the posts (and their meta-data) separated. Both installations currently share the same database. I ...
0
votes
1answer
200 views

Media Library won't recognize SOME old files after move

First off, I'm on a Windows 2008 box running IIS7 with a web.config file not htaccess. That being said, I've migrated my old Apache(XAMPP) installed WPMS site over to a new IIS7 server successfully ...
1
vote
1answer
331 views

Migrating WPMS from apache to IIS7 causes Database Error

// Be sure to read the updates at the bottom I have a large multisite installation hosted on XAMPP on an XP 2003 server and am trying to move it from XAMPP/Apache to a new Windows 2008 server with ...
12
votes
1answer
3k views

Should I use custom post types or a custom database tables for plugin development?

I'm fairly new to writing wordpress plugins, but I've jumped in the deep end already and I want to make sure I'm doing it "right" on my upcoming big project. I'm going to be heavily extending ...
1
vote
1answer
918 views

Use Custom Database with Custom Post Type

I decided to ask this question as searching online left me really overwhelmed and not knowing which direction to take. I am about to tackle a project that has its own custom database (finished e-r ...
0
votes
1answer
43 views

How to migrate a database from a server to another

I try the export method of phpmyadmin, but the user is exported with the data... so there is no way to re import it into another database without error message. The old user is name : ...
0
votes
1answer
732 views

add an image field to wordpress category

i am trying to add an image field to the wp_term table in the database, I'll call it icon. I want that filed to contain a URL to an image that will be the thumb for the category. I have already added ...
4
votes
2answers
288 views

Is it possible to define two databases for one installation?

Is it possible to define 2 database for one wp installation, I have searched but there are options for one database and 2 installations. I want this because, one of my clients site is hosted on ...
1
vote
3answers
964 views

Use one Wordpress database with multiple instances of one site

Is there a way to use the same database, tables and all, with two different domains? For example, two employees each have thier own subdomain to develop / test with, so there may be two instances of a ...
0
votes
1answer
92 views

Proper approach to moving complete site from one domain to another AND preserve widgets

I consider myself fairly versed in this matter, however I've recently had a rash of issues when moving sites. I am able to successfully move the site, edit wp-config.php, move the database, etc. ...
2
votes
1answer
46 views

Leader board for game on homepage

I've built a simple game which is housed on my homepage. I'd like to create a leader board (a small results table) which displays the top three 3 scores. How would i insert/retrieve the score data ...
1
vote
2answers
60 views

plugin code is pulling information from database in one instance and not in other. What is wrong?

In my plugin code, I am pulling the table id from two tables. The id is being pulled from one table but not from the other and I get errors in both instances. The queries work on mysql when I use ...
0
votes
2answers
560 views

When to use custom DB tables or add_option?

I've got a pretty straight forward question. When does it become too much data to use add_option, update_option, etc, and instead use a custom DB table? For example, if a plugin stores thousands and ...
1
vote
1answer
529 views

Using GROUP CONCAT in my-sql query with wp_usermeta table

I have a query that is meant to return user details from Wordpress tables. It would be fine if I was just SELECTing column names that I want, but within Wordpress there is a usermeta table which has 2 ...
1
vote
1answer
237 views

How can I store an image in the database with Transients API?

I'm trying to store an image generated with imagecreatefrompng() using the Transients API, but it just stores an empty string (string(0) ""). Also, I notice if I set the transient before imagedestroy( ...
1
vote
1answer
949 views

How to make sense of the active_plugins option_value to enable and disable certain plugins from the database?

Can anyone explain how to interpret and make sense of the active_plugins option_value string in WordPress. And then use this string/ array to disable and activate specific plugins? Here is an ...
0
votes
1answer
447 views

Best practice to import user base (subscribers) from one website to another?

I want to import users from a Wordpress installation to another. Same domain, but complete different websites. Website A (old, 700 users): running WP3.0 plain installation + BBPress 1.x Website B ...
0
votes
2answers
1k views

Convert user passwords to MD5?

I am in the process of migrating my site out of Wordpress and I need to filter the registration and/or login process so there is a separate database field that holds the user password in a hash that ...
0
votes
1answer
246 views

How not to display ALL items of a database

When I select a category from the head navigation bar in a database http://www.taracomplementos.com/tara/, the default display is all the items of the DB, and you must select one of the categories ...
0
votes
1answer
510 views

database columns: post_title vs post_name

I changed post_title, post_contents, and post_name to allow for utf by changing collating sequence to: utf8_general_ci Then using add new post, I type for the title three Hebrew ALEFs. The post_title ...
1
vote
4answers
406 views

Migration: Copying database content to a different server

I'm migrating our WordPress site from one server to another. I need some hint on how to deploy a database dump (which I have) from the original server to the new one. There is no phpmyadmin (at least ...
0
votes
2answers
753 views

can we add extra table or column in wordpress for adding our data

Just a simple question is it possible if yes what are the requirements of this mean i want to make a table for adding songs information in table like link | name | date | size | moviename is it ...
1
vote
2answers
770 views

Query from a different database than the default

I'm making a layout for a wordpress page. The layout needs to connect to a second database (both databases are in the same domain). But the problem is, when i execute just the file it works. But ...
0
votes
1answer
229 views

Can you refresh ONLY the wordpress adminbar and not the whole page?

Here is my challenge: I have included an electronic wallet in the admin bar of my wordpress site and what I need to do is to refresh ONLY the admin bar so that, upon a purchase, the electronic wallet ...
0
votes
2answers
281 views

Importer fails to import every post

I'm trying to move the content of a wordpress.com blog to a self-hosted one. Right now I'm just trying to set things up on my local environment. I exported the content using the built-in WordPress ...
0
votes
1answer
166 views

Creating Job Tickets

I work in a small print shop and I want to digitize our workflow. I have found many plugins that are for support tickets, but I want to be able to create job tickets for printing jobs. I have found ...
0
votes
2answers
589 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
1answer
390 views

contact form-7 drop downs not populating database

I am using contact form 7 with Contact Form to DB Extension. I have this following code for my form. However when I to a test submit only the name and the address populate the database, there isn't ...
0
votes
1answer
388 views

dbdelta failing with error: "WordPress database error Table 'wp_2_myPlugin' already exists

I'm upgrading a plugin and having issues with dbdelta. Here's the original db creation function: global $jal_db_version; $jal_db_version = "0.1"; function jal_install() { global ...
1
vote
1answer
726 views

wp_get_current_user always returns 0 continued

I have been busting my head trying to get the user ID with every piece of code possible but it always comes back "0". Not sure what I'm doing wrong. I started out using this: <?php $user_info = ...
1
vote
2answers
1k views

Moving online website to MAMP or dumb idea?

I was thinking of doing some major design (incl child theme and plugin stuff) on an existing site which is rather large. I'm thinking it would be good to do my trial and errors offline and having a ...
0
votes
1answer
68 views

Database interaction (private-public) [closed]

I like to have a nice website for my client. I will do it with WordPress. But that client will manage a database, much like Excel or Lotus or Access or FileMaker. I like to offer the same style of ...
0
votes
3answers
915 views

Ajax save data to database on document ready, no data being saved

I have written a plugin which collects stats on document ready. Keep in mind that my database table is already created. I've added the following code to do the ajax code add_action( 'wp_head', ...
0
votes
1answer
134 views

Moving to another server database connection error [closed]

I have some issues when I try to move it on other server. This are the steps: I go into my actual database through phpmyadmin, export the database. I copy the entire folder of my wordpress website ...
0
votes
1answer
483 views

Cloning blog to localhost via WAMP

How do restore a Wordpress blog (actually, cloning would be the right word) from my server to localhost with WAMP? I backed up my blog with BackUpWordPress and got a .zip file ...
-2
votes
1answer
113 views

Wordpress can't fetch the posts from the database after moving to new server [closed]

After moving wordpress to a new server , I used the same domain in the old server , it's display "Nothing Found" in the index page , and even can't get the posts in "The most comments" widget , and ...
0
votes
1answer
256 views

Managing database tables in WordPress multisite

I'm working on plugin that creates and stores some data in database table (using global $wpdb->base_prefix). In WordPress multisite I want sub-website owners to have access only to data that they've ...
1
vote
1answer
634 views

Within the database, where is the flag which says that a user has Super Admin rights?

I have an user in a Wordpress Multisite installation and have access to the Mysql database, I would like to give myself super-admin rights to access the wp-admin/network page. Where can I do it on ...
1
vote
1answer
70 views

Export all content from wordpress

Evening all. I've decided instead of upgrading the install of wordpress that I have, to just take the content (my writeups, comments, pages) and move them to the new site install. Is there an easy ...