WordPress stores user generated content, along with other configurable information, in a a database (typically MySQL).
0
votes
2answers
75 views
WordPress Site - Connection to MySQL Database: The Basics [closed]
What is/are the best source/s to check to find the nuts and bolts of connecting a MySQL database to my WordPress website? Thanks.
1
vote
0answers
45 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 ...
0
votes
1answer
28 views
I would like to create a premium area with “extra information”
I would like to use a contact form (contact form 7/secure contact form/etc) and use the data that people send to create a "premium area" where only specific users will have access.
Let's say that I ...
0
votes
0answers
22 views
blank page after downgrade [closed]
i tried to solve my latest problem with downgrading my wordpress to version 3.4
and now when i click on http://ntm.at/r0sa/wp-admin/ everything is empty. whats the problem? i deleted wp-admin and ...
0
votes
1answer
35 views
DB access blocked when initializing WP externally
I have an odd problem I'm hoping the group can help with. The problem is this:
I have a few situations where I load the Wordpress environment without the overhead of the GUI (details)
I am able to ...
4
votes
7answers
454 views
How to move existing Wordpress wp-content folder along with database to new server and new domain name?
Running WP 3.5.1 on a LEMP stack (over at Linode) ...
I have a wp-content folder for a WP site along with a full backup of the database. The URL of the site was something like:
...
0
votes
1answer
78 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 ...
2
votes
1answer
51 views
What is the easiest way to implement cascading database upgrade for my plugin?
Lets assume following situation:
I develop a plugin. The plugin requires custom database table to store some kind of information.
From month to month I release new versions of my plugin. Different ...
0
votes
0answers
79 views
Wp super cache causes database problem [closed]
I have a serious problem :
I have a dedicaded server. I did a reboot 4h before and now i have database errors :
The home is okay : http://worldissmall.fr/
wp admin : ...
0
votes
1answer
63 views
How to back-up a database on IIS
I've been having trouble finding a good tutorial on how to back-up a WordPress database using IIS as the web server. I installed WordPress using IIS's web platform installer and now I can't even find ...
1
vote
2answers
70 views
The plugin generated x characters of unexpected output, $wpdb not defined
I've written a simple Wordpress plugin to create a new database table.
The new table ought to be created when the plugin is activated.
When I try to activate the plugin, I get the following error:
...
0
votes
1answer
90 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 ...
2
votes
2answers
115 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 ...
0
votes
1answer
51 views
Saving zero as meta value
I have a meta_key called "_ordre" and each time I create a new custom post, a new meta_value is set for that meta_key.
The thing is, when I set the value of '_ordre' to 0, the meta_value is not saved ...
0
votes
2answers
106 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.
1
vote
1answer
102 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.
...
0
votes
1answer
65 views
Accessing + retrieving custom database in WordPress
I am looking for something really simple(?). I am using WordPress as a CMS. I created a new page in which I added a form (questionnaire). Inside WordPress' database (the same database in which all ...
0
votes
1answer
65 views
Change taxonomy slug in database
I am using Events Calendar Pro and due to a bug multiple Venue taxonomies were created. For example, I have museum, museum-2, etc. I would like to delete the duplicates but assign the event associated ...
2
votes
0answers
99 views
Plugin Not Working, But Only On GoDaddy Hosted site
I'm creating a plugin for a friend to log search terms on his site. It's very basic. It creates a new table to store terms entered in the search box. It converts the search term to lower case, ...
3
votes
1answer
246 views
Wordpress admin never finishes saving page on site with large page count
I have a Wordpress install with a very large amount of pages (a few hundred thousand), and over time it has gotten to the point where editing a page takes an extremely long amount of time. It would ...
2
votes
3answers
1k 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 ...
1
vote
1answer
118 views
Migrating from PDO using SQLite to clean new install using MySQL
I've been using PDO plugin for wordpress and SQLite database. It does not work as expected so I want to use MySQL database, but without PDO for Wordpress since I cannot trust that plugin anymore, It ...
0
votes
1answer
79 views
Inserting into WP DB
I had initially asked a question based on my code (which has since been removed), I need some help/guidance in creating a plugin.
Scenario: I have created a custom post type (CPT), now I need to ...
0
votes
0answers
45 views
downloading BLOB from database [closed]
I have a small problem with the php content-disposition, I kind of understand where the problem lies but I have no idea how to solve it (new to using databases). Calling this php page will result in ...
0
votes
1answer
144 views
$wpdb error (Call to a member function insert() on a non-object)
I have very few knowledge on oo php and databases, and I am simply trying to insert data in my wp_pagesvisites table but I am having some trouble with this error message.
This is my script:
...
-1
votes
4answers
105 views
Insert into db with foreach problem
I have no idea why this foreach it`s not running. When i post the article, only inserts once. Should make it at much as needed. Do you see any problem?
$array_produse = array();
for($i=1; $i<=8; ...
0
votes
1answer
141 views
How to update BuddyPress xprofile fields programmatically?
I update user info using wp_update_user function. I also need to update the table wp_bp_xprofile_data. Is there any function, where I can update data on wp_bp_xprofile_data table?
2
votes
1answer
117 views
BuddyPress: What's the use of wp_bp_xprofile_data table and how does it get updated?
I have a questions related to BuddyPress:
What's the use of wp_bp_xprofile_data table? How does the data in the table get updated?
And when any user updates his information - does the data in this ...
1
vote
2answers
101 views
Relationship between performance and database size
What's the relationship between performance and database size in WordPress? Does a bigger DB mean that my site will be slower? My DB size is currently 360mb.
I also noticed that I have some tables ...
5
votes
1answer
92 views
Performance Gains of Relational DB Setup
Our team is working on the 3rd of large WP sites for a client, and contrary to most "typical" WordPress setups, our projects are generally experience lots of requests, data pulls, and general content ...
2
votes
1answer
41 views
Text snippets shared across posts
I'd like to add a "fast facts" section to a wordpress site - an area in the sidebar where snippets of text are rotated.
Where is the best place to store things like this? Widgets don't really allow ...
0
votes
1answer
89 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
45 views
Is this plugin safe to run?
This is an extract of code from a wordpress plugin. Is it safe to run despite the variables not being filtered? Also does the wpdb class filter to prevent any injection?
list($email_id, $user_id, ...
0
votes
1answer
86 views
Handling large N data in WordPress
I realize that this also pertains to PHP and MySQL in general, but the context and operation is within WordPress.
Introduction
I am currently developing a plugin that creates and saves data about ...
0
votes
1answer
58 views
Why is one one of these DB query methods (using a where filter) faster than the other (a direct get_var() query)? [closed]
In this thread I presented what I thought was a good answer, and @toscho presented one afterwards which to me seemed inferior.
But after running some timed tests, my code turns out to be ...
1
vote
2answers
61 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 ...
2
votes
1answer
52 views
Wordpress database growing dramatically in size despite adding no new content
I have an old Wordpress site that I no longer maintain but keep online anyway. I have a cron job setup on the server that backs up the Wordpress database once a month. I am noticing a continuing ...
0
votes
1answer
31 views
My wordpress site must be being affected by outside sources [duplicate]
Possible Duplicate:
Error 310 too many redirects after switching domains
Some of my pages are resulting in 310 errors. We recently switched domains from kgstiles.com to ...
1
vote
1answer
279 views
Wordpress default menu in database
There are 3 menus in my wordpress(3.5) now.
Main menu (default from wp)
Footer menu (default from wp)
Test menu
Now I have kept test menu as default.
Where does Wordpress store this thing?
I ...
1
vote
1answer
272 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:
...
6
votes
2answers
128 views
How to check if image is already stored in a site's post database? (network)
I currently have configured Wordpress so that a post can be copied to other sites within a Wordpress network. However, a post may be broadcast more than once, and I want to check if the image is ...
2
votes
2answers
198 views
Custom database or Custom Post Types?
I have been searching throughout the web for the best way to implement what I need but just cannot find a best solution as there always seems to be some drawback. I'd prefer to do it right the first ...
0
votes
1answer
53 views
WPMU on MySQL limited to 1GB of space?
My MySQL databases are limited to 1024MB per 1 database but WPMU websites need to exceed that... Is there any way to make WPMU go and use database_2 when database_1 is already close to 1024MB?
I can ...
1
vote
0answers
221 views
Upgrade to WP 3.5 hangs in “database upgrade” step [closed]
Just tried to upgrade my wordpress blog using the automatic upgrade function. It asks me to upgrade my database, and after I click the button all I get is a page with the wordpress logo, nothing else.
...
0
votes
3answers
1k views
Custom form that store input in database
I have never used WordPress before, but have done a lot of programming. But what is the normal way of making customs forms?
I need to create a form where a user fill some input fields and on submit ...
1
vote
2answers
104 views
Does dbDelta delete columns as well?
I created a table using the dbDelta function and then removed a few columns and added a few. The new columns did get created but the old columns did not get deleted from the table.
Is there a ...
0
votes
1answer
85 views
Using custom tables for old posts
I have a site with about 24,000 posts and 200 posts daily and the database will get huge soon. So I plan to transfer the old posts to custom tables to reduce the database load. There's no need to show ...
4
votes
1answer
130 views
What is the advantage of the wp_options design pattern?
As we all know, a design pattern that is used frequently in Wordpress' DB code is the idea of persisting data for a particular object (blog/post/comment), indexed with a particular name or key.
We ...
0
votes
1answer
54 views
Make Database query only when option is updated
Below is a DB query I am using to retrieve values and place them in a WP_List_Table. Values are currently being added by add_option, then those values are converted into a custom database table ...
0
votes
1answer
43 views
How do I find users by password?
I need to add a passkey to each user, so I decided to just giving the user password that value and use WP functionality to store it/retrieve it.
So now I need to find what user that password belongs ...
