The tag has no wiki summary.

learn more… | top users | synonyms

12
votes
2answers
2k 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
857 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
576 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
191 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
1k 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
1answer
389 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
3k 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 - # ...
3
votes
2answers
2k 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
65 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
551 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
520 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
715 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
569 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
66 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
129 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
304 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
5answers
7k 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
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
1answer
26 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 ...
1
vote
1answer
510 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
922 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
3k 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
2answers
26 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
1k 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
218 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
160 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
38 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
29 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
439 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
50 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
193 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
432 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
1answer
891 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
107 views

What is _transient_random_seed for?

This is a very short question. _transient_random_seed is in wp_options. What is it for?
0
votes
1answer
162 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
70 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 ...
0
votes
1answer
220 views

Multiple options in the options_value field of the wp_options table

I have come across a theme that has a way of having multiple options in the option_value field.For instance,in the theme,one can perform the Create,Read,Uodate and Delete functionalities on such ...
0
votes
3answers
610 views

Default plugin config to override wp_options?

I have a few plugins that I always set the configuration for exactly the same way. Every time I create a new site, the same plugins go in, and the same amount of time is needed to set them up. Would ...
0
votes
1answer
1k views

How do I retrieve multiple values from a multidimensional array in wp_options?

I'm just starting to store data in multi-dimensional arrays in wp_options and I need some help to retrieve some data... My data is below and is stored as option_name "my_category_fields" I need to ...
0
votes
1answer
44 views

shopping cart plugin development

I'm developing a new shopping cart plugin for WordPress. At a point, how to save orders, I am stuck, sort of confused. Actually I am not sure whether I should save order through options api or create ...
0
votes
1answer
42 views

Image link issues after importing a database backup to my local web server

I am pretty new in WP (I came from Joomla) and I have the following problem trying to import an old WP blog (made using WP 3.5) on my local web server. I have put the old blog foder into my www ...
0
votes
1answer
73 views

Wordpress setup one database with two different website?

Hello Friends I want to setup two website first.com and second.in that are different domain and server. I want to a same data base in both site with the same content. means we enter new posts in ...
0
votes
1answer
28 views

Subscription list function

I have created a function which automatically adds users with the role of contributor to a list in which they will receive forum (modified mingleforum plugin) updates by email. My problem is that the ...
0
votes
2answers
177 views

Accidentally deleted active_plugins portion of the wp_options DB table

Ok, so I'm pretty sure I'm screwed here, because I do not have a database backup, but I figured I'd ask just in case. Within PhpMyAdmin, I meant to just go to the wp_options table and empty out ...
0
votes
1answer
77 views

What could cause a WP Option to get truncated?

I have a WP plugin, where all admin setting field values were suddenly changed to the letter 'a'. All settings are stored in one 'big' option in the table. Seemed like the serialization gone wrong. I ...
0
votes
3answers
234 views

Display random image url from list of input values

I have created an options page in my WordPress theme that allows the user to input a url/upload an image to an input field. The field has the name headerimage_options[image] and when it is populated ...
0
votes
1answer
194 views

accessing wordpress serialized data outside wp

I've never worked with serialized data... I need a little help with how to load "text" widgets title and content in php script outside wordpress... my script just connects to database (including ...
0
votes
1answer
672 views

Wordpress Options Page not working

So, I need to add a custom options page, and based on as many tutorials I could find, I came up with the following code to create an officers & chairs options page for my group, mainly, so I can ...