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

0
votes
0answers
25 views

Why would wp_options.ibd be over 6GB

We run a WordPress 4.4.2 website using Mariadb per table indexing. The wp_options.ibd file is almost 7GB in size when there are less than 6K records in the table. Below is the my.cnf we are using, ...
0
votes
1answer
24 views

Redirecting to old domain, tried everything, nothing works

I've moved a Wordpress site from one domain to another. I have changed the siteurl and home options in the wp-options table, added this tags into wp-login.php file: update_option('siteurl', ...
0
votes
1answer
35 views

Wordpress modify Settings > Permalinks (options-permalink.php) Add CPT Permalink Options

How do I modify the Settings > Permalinks (options-permalink.php) admin page to add more custom permalink parameters? I'd like to add additional permalink parameters to the "Optional" section for ...
0
votes
0answers
18 views

Website keeps redirecting to Wordpress install page (install.php)

I hope someone here can help me as the problem I have is driving me insane. For the last few months I have been putting together a Wordpress portfolio and had almost finished it. Recently, out of ...
0
votes
1answer
23 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 ...
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: ...
0
votes
1answer
19 views

WP Page Options Array

I'm creating a page options which contain some multiple checkboxes with specific values. Here is a snippet of my checkboxes form code: <label>Global Checkboxes</label> <input ...
0
votes
0answers
31 views

Saved option shows in page dropdown after page refresh

I'm adding a submenu page with a simple dropdown of pages as a settings, the code looks like this: <?php add_action('admin_menu', 'mytheme_admin_menus'); ...
0
votes
1answer
21 views

What should I use instead of get_blog_option?

I am using a plugin that was using get_blog_option and it no longer works. I looked up the call and it doesn't work because it's a wpmu function only. Is there an equivalent method that I can use ...
0
votes
1answer
48 views

Save Image in wp_options-Table

I'd like to save one image in my custom settings page. i.e. this image should be the logo which should get print to the pdf files I generate. Thats why I want to store the image (the image link) in ...
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.
0
votes
1answer
48 views

WP_OPTIONS table, active_plugins entry [closed]

I asked it here and found no response so far. Here is a sample entry from the active_plugins line of WP_OPTIONS table: ...
1
vote
4answers
101 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
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 ...
0
votes
0answers
34 views

Select fields on a settings page

I'm trying to do it in the style of 'Example #2' on this page: https://codex.wordpress.org/Creating_Options_Pages as it seems the tidiest way I have come across to do it. The problem is I want to ...
0
votes
0answers
20 views

Counter variable resets before script is finished

I am working on a script for a client (a bookstore) that will upload their inventory to their WordPress database. They are using WooCommerce, and the upload file contains approximately 17,000 records. ...
0
votes
0answers
71 views

siteurl value getting populated with junk in wp_options table

My website was getting this error on every page : Catchable fatal error: Object of class WP_Error could not be converted to string in /home/juhisheth/public_html/wp-includes/default-constants.php on ...
0
votes
0answers
87 views

What is the cron doing?

So I installed the P3 plugin to analyze the plugin load time at my site. It was OK at the actually analyzing but just a really poor plugin that basically crashed my server which has great specs over ...
0
votes
1answer
60 views

Store plugin page content in wp_options?

I want to write a plugin for wordpress that in some cases will show some content as if it were a post or page as an end result of a form processing. My idea is to add a hook that checks for and ...
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 ...
0
votes
0answers
35 views

update object options on option form

I have an object on an option called 'option_voc'. Now I would like to update only one field of this object through form i created on menu page i created (The plugin's settings page). I do not find ...
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 ...
1
vote
0answers
367 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 ...
0
votes
1answer
177 views

Cannot unserialize Wordpress serialized values in `wp_options` table?

I have nav_menu_options in my Wordpress database as below. 284,'nav_menu_options','a:2:{i:0;b:0;s:8:\"auto_add\";a:0:{}}' I tried to deserialize this value but the result is empty string - I put a ...
0
votes
0answers
36 views

How to create a new database table whenever user changes options

I'am new to wordpress plugin development and I'am stuck in developing menu for my plugin. By going through documentation and many sites i created following menu. But i want to create a new table in ...
0
votes
1answer
37 views

Custom Role accessing the wp-option table

I'm using a plugin that create an additional record in the wp-option. Everything is great with the admin account, the record can be save and update. But I'm stuck with allowing one of the custom role ...
0
votes
0answers
98 views

Store custom taxonomy option data in option table

Iam stuck in middle of thing that how could i store custom field data in option table of custom taxonomy. Actually i have a csv file and i want to save those data in custom taxonomy with the help of ...
1
vote
1answer
232 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 ...
0
votes
1answer
740 views

Save and user submitted data from a form and display them in the wp backend

My question is very simple but the answer I'm not sure if will be that simple. I'm developing a website for a non-profit organization where people can fill out a form containing questions usually ...
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 ...
0
votes
2answers
276 views

WP CLI to set options

I have WP-CLI working fine using WP Multisite (or network). I can create blogs, add users, set permissions etc. But am not certain how to enable plugins for individual blogs via WP CLI. For example, ...
0
votes
1answer
134 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
106 views

Options table - where does my values go?

I just got my hand into wordpress and wp theme development. I know to create basic wordpress themes from scratch but I wondered how to get into custom theme options. My custom theme options (custom ...
0
votes
1answer
384 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
0answers
45 views

Saving plugin options page

As I understood, default mechanism of saving options on plugin admin settings page (submitting form to options.php) allows to update only WordPress options (get_option, etc). But I have 2 values to ...
0
votes
0answers
241 views

WP_Query on “property” in the options table

I'm quite new to WP and I hope this question isn't seen as too specific. It's not entirely bound to my little "pre story". I'd really like an answer to this question for future cases as well. I get ...
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 ...
1
vote
1answer
867 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
2answers
284 views

WP_Options high

I have a site where the options_id field in the wp_options table have grown very, very large. After a month and a half after the installation the auto_increment value is now at over 10 million. ...
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', ...
0
votes
0answers
148 views

Add images functionality not working as wanted

I achieved this structure in wordpress admin panel. I am using wordpress option api to save and retrieve data from option.php . All I want to do is on every click of add more image button one more ...
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 ...
0
votes
1answer
88 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 ...
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
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 ...
0
votes
0answers
151 views

Share content between two different sites in same domain

I am trying to accomplish something weird... I have a client who wants to have two different sites to share the same content (some post types and pages). I warned him about SEO problems, but he still ...
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
638 views

How Do I create multiple Top Level Admin Menu Pages To submit data to the options table?

I am trying to create more than one top level options page in my wordpress theme. But right now I can only save the data for one. How can I save the data for two without having to create tabbed ...
0
votes
1answer
421 views

WP Options Query “Rewrite Rules” Taking 10 Seconds After Testing wp_insert_post( )

Suddenly one of my test sites became absolutely unresponsive after testing with wp_insert_post( $my_post ) I Installed the black box plugin and checked what queries are slowing it down I found one ...