WordPress stores user generated content, along with other configurable information, in a a database (typically MySQL).
1
vote
3answers
2k views
Will it break my site if I delete all transient records in wp_options table?
My site currently has an outrageous 500k+ transient records in the wp_options table.
This causes the table to be crashed frequently and so be my site.
I thought transient records will all expired ...
1
vote
1answer
1k views
How to build a movie database with wordpress?
I'm looking for a plugin to build a movie database like Popcritics
The plugin would permits me to add custom info (like CustomPress can do) about a movie.
Ultimately, the plugin could permit users ...
1
vote
2answers
365 views
What's the most efficient database method to add and query usermeta?
What's the most efficient way - concerning the database - to add and query extra usermeta fields to a profile?
I need to add four additional fields of numeric and text data to a user profile and then ...
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 ...
1
vote
2answers
79 views
Where to store custom tagging data associated with a custom post type
My application allows users to add tags to an image (similar to facebook). Each tag can consist of up to 8 attributes and there is currently no limit on the amount of tags a user can add.
At the ...
1
vote
1answer
64 views
Extend the wp_users table
I'd like to to extend the wp_users table in my WordPress' database.
Why? I want people to add more information about themselves when they sing up at my website.
I know how to extend it, but I'm ...
1
vote
1answer
154 views
Large database causes slow load
I have a 2GB WordPress database (using InnoDB Storage Engine) and I noticed my site loads slow when I press the publish button right after I selected a featured image in the media library.
I had a ...
1
vote
1answer
29 views
How to store an extra (surrogate) ID when creating a post with wp_insert_post?
I am generating posts based on rows from a table on an existing database.
If a row in the database gets updated I will have to update the respective post.
The proble is that I have to find the post ...
1
vote
1answer
349 views
Custom search page and search by title, content and tag
Can someone review my code , I need to know better solutions or any bug.
Okey ! , I made a PHP file to get search results by parameters and search by title , content and tag
PHP's head look like:
...
1
vote
1answer
53 views
Why does WordPress rely on an fully qualified site_url with a 15-step plan for moving a site?
From the Moving WordPress codex page (emphasis mine):
When your domain name or URLs change there are additional concerns. The files
and database can be moved, however references to the old ...
1
vote
2answers
225 views
How to create and work with custom data / tables (i.e., for arbitrary data)?
Getting started on Wordpress just today. I noticed that Wordpress created tables in a mySql database (with name *.wrdp1) when I first set it up. These tables cover comments, posts, users, and some ...
1
vote
2answers
274 views
How do I copy a wordpress database?
I'm trying to migrate my wordpress site from an old host to a new host. The Wordpress Codex says "you can move by just copying your files and database." Copying the files is easy enough, but how do I ...
1
vote
1answer
145 views
One post carries 30 postmeta values, is this too much?
I have some data saved as post meta, occasionally some plugins may save an extra piece. Now I installed bbpress, it saves at least 10 pieces of post meta. Adding them together, there are nearly 35 ...
1
vote
1answer
257 views
WPML tables not deleted when removing multisite subsite, need help clearing up my sql-file!
I´m building a WP Multisite for a client that wants a multilingual site. Before choosing WP Multisite, I bought and tried out WPML. However that plugin didn't fit for the job so I deleted it and got a ...
1
vote
3answers
129 views
Single database for multiple instances
I would like to create two instances of WP on a single domain. For example, I would like wp1.domain.com and wp2.domain.com to use a single database (same comments/posts). One for production and one ...
1
vote
1answer
173 views
How is the data stored in the database?
I have years of experience with PHP and MySQL, but just starting to develop plugins for WordPress and need some help.
Currently, I am working on a plugin that will add extra functionality to another ...
1
vote
3answers
523 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 ...
1
vote
2answers
313 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 ...
1
vote
1answer
312 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
68 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 ...
1
vote
2answers
255 views
Bootstrapping Wordpress MultiSite Outsite of Wordpress - No $wpdb
I'm working on a plugin for a system to use Wordpress as the authentication backend, so that I can use my existing Wordpress users in another application. The plugin works great when running in single ...
1
vote
2answers
475 views
Import 10,000 Users into Wordpress WITH a specific ID for each user
I have a website which has about 10,000 users. I am converting this site over to Wordpress. The new site is ready to roll, but I have to bring over all the users.
There are a number of plugins ...
1
vote
3answers
167 views
Retrieving a Value from a wp-database
why my sql statement is not returning any value.. is this wrong?
<?php
global $wpdb;
$result = $wpdb->get_results($wpdb->prepare("SELECT * FROM ...
1
vote
2answers
442 views
Wordpress doesn't show all posts in database
I have around 140 post in database but wordpress admin page shows just 50 post. How could I let wordpress shows all the posts in database?
Thanks
1
vote
4answers
2k views
After server migration only the homepage works
I have recently changed hosting of my WordPress site to VPS.net. I have moved all of my files and imported the database. Everything appeared to be fine until I clicked a link and noticed that all of ...
1
vote
1answer
409 views
Is it possible to split database tables using HyperDB?
I'm looking for an answer from someone who's implemented HyperDB or has knowledge of it.
I have a database which has just passed the 100mb mark a week or so ago, the problem is my host only allows ...
1
vote
1answer
947 views
Safe way to find last inserted id in a table?
Is it safe to use $wpdb->insert_id; to find the id of a last updated row id just after an update? ex:
$sql = $wpdb->insert($table_name, $arrayWithDataToInsert, array('%s','%s'));
...
1
vote
1answer
189 views
WP database error for comments_popup_link()
I'm using the comments_popup_link() function to show the number of comments for each post in a loop.
<?php if (have_posts()) : while (have_posts()) : the_post(); ?>
<?php if ( ...
1
vote
1answer
553 views
Adding new row to wp_post table
I want to add 2 more rows (for voting up or down) to my default wordpress posts table. Would those rows be deleted when I update my WP version, or cause any other problem? An alternative would be to ...
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.
1
vote
1answer
109 views
How can I create a Bible search engine via WordPress? [closed]
I have some translations of Bible in Turkish language. But, they are as of books. (Matthew, Mark, Luke, John... ) I uploaded them into a website which is being managed by a wordpress software.
...
1
vote
2answers
65 views
Wordpress DB: options-table –> 32 gzipcompression?
I just wondered what this row in the Wordpress Database refers to?
32 gzipcompression 0
I stumbled upon it in the WP options table. What if I set the value to 1.
I do already have ...
1
vote
2answers
301 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. ...
1
vote
5answers
309 views
Moving WP from local server to live, error establishing a db connection
Not sure what's going on here 'cos I've done it already a couple of times and it always worked. Basically I'm moving a testing site from my local machine (MAMP) to a live server by:
zipping the ...
1
vote
1answer
1k views
How can I check email exists via a jquery keyup()?
I have setup a jQuery keyup delay function to check the email typed into an input field.
It works fine after testing with an alert('Key pressed!');
But I want it to say, for example, 'Yes this ...
1
vote
1answer
221 views
WP_Query Performance Issues with meta_query
I'm working on a custom template for a new theme that uses a WP_Query instance to select posts from 2 post types with 2 custom fields that are NOT empty. Depending on the section of the site, a ...
1
vote
1answer
32 views
Building an email signup form. Where should the information be saved in the DB?
I would like to try build a simple plugin that collects and stores the name and email address of the person who filled in the form. I realize there are probably dozens of plugins out there that do ...
1
vote
1answer
94 views
Should a child theme share the same theme options row as the parent, or should it have it's own options row?
I'm developing a theme which uses the NHP Theme Options Framework to add some theme options. Naturally, the theme options framework creates a single row in the database to store the theme's options ...
1
vote
2answers
171 views
when I fetch data from remote mysql database in wordpress built in wordpress function is not working?
In one of my page I have to fetch data from remote mysql database. We have connection to remote mysql database by creating new instance of $wpdb class.
$mydb = new wpdb(DB_USER2, DB_PASSWORD2, ...
1
vote
2answers
221 views
how to transfer wordpress sql/database from local to live
So for backing up any/all my wordpress sites i use a tool called "BACKUP BUDDY" and its
a great tool and all but lately its been really buggy and today finally it went kaboom!
Usually my workflow is ...
1
vote
1answer
248 views
Clean database from unused tables
I used to have many plugins installed on one of my sites, and after deleting most of them, I still have a database full of extra tables, I am sure most of them are unused. How do I clean them off?
1
vote
2answers
473 views
How to initialize $wpdb?
I have a .php page in the theme root to check the data of one CUSTOM form.
After receiving this data I need to do a query in a custom mysql table, so I need $wpdb, but I can't use it directly (or ...
1
vote
1answer
409 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 ...
1
vote
1answer
130 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
2answers
977 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 ...
1
vote
1answer
1k views
Add Admin User via SQL
I gave my client the admin account to his wordpress install and I forgot to add an administrator user for myself. Now, I can no longer access the admin panel because they have changed their password. ...
1
vote
1answer
121 views
Adding Custom Forms
I'm looking to create a page for a wedding site that will have a form. The idea is that it is an RSVP page where a visitor will input a unique string that was on the invitation that they received and ...
1
vote
1answer
150 views
Is there a naming convention for database tables created by a plugin?
I have setup my plugin's table to use $wpdb->prefix but aside from that are there any conventions that you should name them;
Maybe $wpdb->prefix.'plugin_'.$tablename or something.
I can't find ...
1
vote
1answer
143 views
Display SQL that wordpress is running
I am wanting to see the actual SQL that worpress is running to build certain pages, is there a debug method or some other way to outpout this or view it?
1
vote
3answers
80 views
How can I transition a site from using the Beta Tester plugin to a “normal” install?
I'm currently using the WordPress Beta Tester plugin on a site. Is there a "best" way to transition the site to a "normal" WordPress install? The plugin includes this notice:
Please note: Once you ...
