The Options API is a simple and standardized way of storing data in the database. The API makes it easy to create, access, update, and delete options.

learn more… | top users | synonyms

15
votes
2answers
3k views

Are all options loaded to memory on each request?

Are all options variables fetched from the database and loaded to cache on each request?
10
votes
2answers
2k views

How come `wp_options` table does not have an index on `autoload`?

In the beginning of each page served by WordPress, there is a MySQL call to fetch options: SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes'; Because there's no index on ...
10
votes
1answer
938 views

Using jQuery to delete data stored in wp_options

I wonder if anyone could advise me further on my problem. Part of my plugin stores log files for debugging purposes. I have successfully displayed them in a (div#log) in my admin page using jquery ...
9
votes
4answers
212 views

This CSS Stuffing Works, But Is This A Good Practice?

I am trying to include a dynamic css in my plugin, I have been searching anywhere but doesn't find any case that is similar to what I do. And what I use to do it is by adding a css file directly into ...
5
votes
1answer
2k views

Best practices for a Style/CSS based theme options page?

I would like to create a theme options page based only on changing the site wide CSS styling. For instance body/container background colors, font-sizes, font colors, etc. I have accomplished this by ...
4
votes
2answers
8k views

Slow Query for the wp_options table

I have been tracking the slow queries log of the WP based site (with the default value of the a long_query_time set to 10), and I have noticed that the following query is often getting logged - # ...
4
votes
5answers
14k 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 ...
4
votes
2answers
527 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 ...
3
votes
2answers
3k views

Transient RSS feeds in wp_options not removed automatically?

I just noticed 55.000 entries(!) in my wp_options table. I had not been there for a while. So I ran: delete from `wp_options` where `option_name` like '_transient_timeout_rss%' delete from ...
3
votes
2answers
4k views

How to change option recently_edited?

WP recently_edited option can be very useful - it tracks last 5 files that you've made changes to. Only problem is - well, that's all, 5 files. What if I've been made numerous changes to Wordpress ...
3
votes
1answer
287 views

wp_options table value

I am trying to understand a wordpress behaviour. When I add a tag in the admin panel mysql does a sequence of queries. Essentially: update wp_terms update wp_term_taxonomy and udate wp_options with ...
3
votes
1answer
869 views

How do you permanently remove default rewrite rules from the wp_options table?

We have tons of rewrite rules saved in our wp_options table and I'd like to permanently remove any entries that we're not using on our site (such as comment feeds, page attachments, etc.). What's the ...
2
votes
1answer
713 views

Site Title and Tagline in Theme Options Page

I'm using the Options Framework Theme to put together an options page. The user(s) I'm building this for would like to be able to edit a few settings directly from this page, including of which - the ...
2
votes
1answer
1k views

How to properly sanitize strings for update_option()

I've tried to import an option value via update_options($name, $value) where $value has special characters (like apostrophe's for example) and I've noticed that the apostrophe gets stripped out of the ...
2
votes
1answer
1k views

Delete option value from array using update_option()

I have a user profile field which subscribes the user to forum posts by email. This adds the user's email address to an array in wp-options. Naturally I want the user to be able to unsubscribe, in ...
2
votes
1answer
69 views

Environment Specific Options Token

Is it possible to add a token to any wp-option that could be replaced on get where the token being defined in a plugin’s option or the configure file? E.g. ...
2
votes
1answer
186 views

Site Title and Tagline in Pagelines DMS Options Panel

I'm using the Pagelines DMS Theme and I'm wanting to extend the functionality of the front end admin panel. The user(s) I'm building this for would like to be able to edit a few settings directly from ...
1
vote
4answers
728 views

How To View Site from Non-Logged-In User's Perspective

I am working on anew blog. I am logged in as administrator, and above every post there is a option to 'edit this entry'. Can I have WordPress set up so that even is I am logged in as administrator, I ...
1
vote
1answer
2k views

Working with an Array inside Your Theme Options Array - Multiple Values

I apologize if this is covered extensively elsewhere, I'm not sure how to phrase my searches on the topic. Basically, instead of the following standard code to store data in WP-options... $options = ...
1
vote
4answers
102 views

Cleaning “cron” from options table, will affect anything?

I have some scheduled events in my WordPress site. For that I use a cron job, so it has created an option in the wp_options table. After some days, my site is getting slow. When I check my database, ...
1
vote
1answer
32 views

Is it possible to sort metabox teaxtarea values?

Textarea is on an options page, is it possible to sort the values within that textarea by alpha? I looked in the Codex but do not see any mention of sorting these values.
1
vote
1answer
62 views

Storing HTML in wp_options

I'm giving my users the option to store HTML in an option with a wp_editor(), using the wp settings api to handle the form. I currently do not apply any data sanatization to it, but realize I probably ...
1
vote
1answer
869 views

What is _transient_random_seed for?

This is a very short question. _transient_random_seed is in wp_options. What is it for?
1
vote
1answer
1k views

Save wp_editor() content as option

I'm having some troubles with a extra feature i'm writing for my theme. The admin should be able to make some special posts, those posts are stored as an option. The options are atored as an array ...
1
vote
2answers
3k views

Some Plugin Settings Are Kept After Removal and Reinstall of the Plugin

I have uninstalled and then reinstalled all my plugins hoping to restore my WordPress installation to its original state because I have problem with the funtion of RevieAzon plugin. For example, ...
1
vote
2answers
5k 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 ...
1
vote
1answer
234 views

get_option() is not working even db contains the corresponding option_name and option_value

First of all, this is not a plugin specific problem. I wonder why this might happen? I am using @bainternet's Tax Meta Class for saving Taxonomy Meta using the options table. I uploaded my contents ...
1
vote
1answer
84 views

Creating a one click demo importer

edit: I've re-written this because it is unclear, apologies it was written rushed on a Friday afternoon. Wordpress has import/export functionality for posts within wordpress, I am a theme developer ...
1
vote
2answers
44 views

Would it be dangerous to send all the wp_options to javascript file?

I've noticed that wordpress allows me to send the wordpress options to javascript via wp_localize_script: wp_localize_script( $this->plugin_slug . '-plugin-script', 'wp_options', ...
1
vote
1answer
2k views

wp_user_roles and Advanced Manipulation

I removed a line from my wp_user_roles to manually remove a role I had created and now the sites administration gives me an "You do not have sufficient permissions to access this page." error. I ...
1
vote
2answers
288 views

Help running a MySQL query to update all wp_#_options tables in a Multisite install

I'd like to run a query through my WordPress database that updates the blog_public values on all individual sites. I'm stuck on how to have the statement look for wp_2_options, wp_3_options, etc. I ...
1
vote
1answer
163 views

Classes and functions involved in serialization and unserialization

I want to know all the classes and functions(individual .php files) in a wordpress installation that handle serialization and unserialization.
1
vote
1answer
37 views

Character Encoding for wp_options

I've been looking for a solution to my problem for a while now. Under my wp_options page I have the following serialized entry saved: ...
1
vote
0answers
11 views

Why is MySQL receiving such a large serialized object?

I have gotten a 20GB error log that has an entry of repetitive serialized objects that look like this: ...
1
vote
0answers
66 views

Cannot update my options using wp_ajax

I have implemented wp_ajax in on my options page but the value of my options are not getting saved or updated. Here is my form: public function email_settings_form(){ // Set class property ...
1
vote
0answers
372 views

Wordpress Deadlock Error

I see more of this error these days in error_log. I see that someone asked this question here a year ago but no solution. Please advise what is causing this issue. Already, tried deactivating some ...
1
vote
1answer
62 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
0answers
12 views

After migration of an old WP blog on my local web server I obtain white screen, why? is it a wp_options DB table problem? [duplicate]

I am pretty new in WP (I came from Joomla) and I am finding some difficulties in the migration of an old WP website (made inWP 3.5) on my local web server. I have performed the following operation: ...
1
vote
1answer
34 views

Editing options pages?

I'm trying to find a way of adding a single checkbox to one of the existing options pages, most likely options-reading.php programmatically. Unfortunately, I haven't found any good references on this. ...
1
vote
4answers
639 views

Updating wp_options with an array on save_post results in duplicated entries

I'm not entirely sure this is Wordpress' fault, but I figure I'd ask anyway and see if anyone else has experienced any problems like this before. I'm trying to save an array to a wp_options table ...
1
vote
0answers
51 views

Set $options reference

I am starting up in theme development and i have searched on codex on the topic of setting theme options.This is is what i am talking about, $options = array ( array( "name" => $themename." ...
1
vote
1answer
212 views

Deploying Updated or New Plugins That Modify the wp_options Table

I have a WordPress site under local version control with Git. I deploy it to the production server using Capistrano. For the initial deployment, I manually import the SQL database to the production ...
0
votes
2answers
469 views

Efficiency of wp_options vs a new table

I'm building a WordPress theme framework, that will likely have many options as development progresses. I found a related question: When is it appropriate to create a new table in the WordPress ...
0
votes
3answers
118 views

Same option_id=0 for 2 options in wp_options?

What does it mean when (according to mySQL Workbench) 2 options have option_id = 0? Just noticed this for unrelated plugin and theme holding very different options. Update Just noticed over 200 ...
0
votes
1answer
1k views

Should I remove transients from the wp_options table?

I have been doing some cleaning up in the database of one of my WordPress installs, and I noticed that the wp_options table was about 2.1mb, and had 1200 rows. I've gotten it down to around 800 rows, ...
0
votes
1answer
24 views

How to set wp_options in functions.php for removeing the Default Front Page

I want to disable the default front page as I want to show always the first listed page in the frontend. Therefor I disable the Static Front Page. But I have also to set in wp_options the variables ...
0
votes
1answer
386 views

How do I add a value to a wp_options option that is an array?

What is the best way to add an option value to a registered option in wp_options that is an array? With phpmyadmin i see the option_value field is ...
0
votes
2answers
1k views

update a value in wordpress wp_options

I am trying to modify a plugin and in which i require to update a value in wp_options which has multiple values . My option_name is ws_mem_options and the option_value has values such as in ...
0
votes
1answer
230 views

Link blogname and blogdescription to the Options Framework

I'm putting together a Theme Options page, where the user(s) I'm building this for would like to be able to edit a few settings directly from this page, including of which - the Site Title and ...
0
votes
1answer
72 views

retain querystring values when savincustom options in admin

Quick question, I have a custom options page which posts to options.php, however I have a few sections to my options page where i change the post url like so: <form ...