WordPress stores user generated content, along with other configurable information, in a a database (typically MySQL).

learn more… | top users | synonyms

0
votes
0answers
13 views

Can't get URL rewrite to work for participants database plugin

I am fairly new to WordPress, but here we go. For the past 18 hours or so, I have tried every method I have found on the internet in an attempt to force the url example.com/file/?pdb=3 to become ...
1
vote
1answer
38 views

Custom fields not getting saved in the databse when added to the add new user profile page

I want to save the custom field values in the wp-users table. Do I have to create the fields(client and user_groups) in the table or it gets created automatically when the data gets saved into the ...
1
vote
0answers
18 views

Logins from WP users table use on another page

I'm creating new website and I want use logins from WP table wp_users. I have problem with password encryption. I tried something with PasswordHash(8, True) but it generated string, which doesn't ...
6
votes
6answers
574 views

Backup the Database and Restore from the Backup?

I am using WordPress 3 and would like to backup the database to my computer (a Mac). My webhost is using PHP safe mode, so that sometimes limits what plugins I can use. What is a good way to do a ...
1
vote
1answer
57 views

Delete all post meta except featured image

My aim is to clear up my database entries. I did a migration from blogger which added many useless post_meta. I found a plugin (db reset) that has the option to reset/delete all post meta. However if ...
-3
votes
1answer
65 views

Does anyone know what the wp_snp_stats table is? Maybe I was hacked?

Nothing is pulling up in Google. I've got a good handle on all my plugins that create custom tables. If you're familiar with this table, please let me know. Or else I have a long road ahead. Thx
3
votes
8answers
4k views

Multisite database upgrade SSL error

I have upgraded my Multisite setup WordPress to 3.6.1. And after that, when I do Network Upgrade > Database Upgrade it's showing: Warning! Problem updating http://www.example.com/site1. Your ...
0
votes
1answer
27 views

Associating special meaning with user id 0

I'm writing a plugin that creates a custom table holding data which is linked to a user account with a user_id field. Now if that users account would be deleted for any reason I would like to set that ...
0
votes
1answer
1k 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
201 views

Upload wordpress from localhost to 000webhost

I want to know how to upload wordpress localhost to server with plugin and filezila i tried many times but failed. When I'm upload wordpress through filezila database cannot connect to the site. Tell ...
1
vote
0answers
78 views

inserting a post from an extern php file but post content doesn't show on wp site

I'm doing a php file that insert post's on my wordpress site. I'm filling all the fields in wp_posts, but the content doesn't shows on my wordpress site. I wonder if it's because the categories are ...
0
votes
0answers
13 views

Post links behaving weirdly after migrating DB to Amazon

I have partially successfully migrated a local DB for a WordPress site I was working on. I imported the new DB using phpmyadmin and move the template and seems to be working fine. The only thing that ...
1
vote
0answers
51 views

Least expensive way to get table prefix in multisite installation

I am writing an api that will have to handle extremely high volumes of calls so, in short, I can not afford to load the WordPress core every call. I have no problem building the API to use the ...
0
votes
1answer
192 views

Error: SELECT SQL_CALC_FOUND_ROWS

My php error_log keep showing this message, WordPress database error Unknown column 'wp_postmeta.meta_value' in 'order clause' for query SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts WHERE ...
0
votes
0answers
14 views

update_post() on all databases of a multisite wordpress

I want to change a certain option from every single site of a multisite networks. I wrote the following that I hope will update all databases $allSites = wp_get_sites(); foreach (allSites as ...
0
votes
1answer
18 views

WP_Query with page_ids in arguments without a result

I want to get some pages with WP_Query: $resume_args = array(); $resume_args['post_type'] = 'resume'; $resume_args['posts_per_page'] = -1; //$resume_args['page_id'] = array(9046, 9346); //No ...
1
vote
2answers
134 views

Why do wordpress store pages/posts within the database instead of files? [closed]

I don't understand why wordpress stores that kind of data: posts' content and pages' content, directly within the database instead of storing it in the filesystem and referencing them in the database ...
0
votes
1answer
79 views

How do I make this Metabox show current DB value?

<p> <?php $options = get_option( 'city' ); $names = explode( PHP_EOL, $options ); ?> <label for="City" class="timeshare-row-title"><?php _e( ...
0
votes
1answer
40 views

WordPress security [closed]

I created a website for my customer via wordpress and I uploaded it in their server ..we assume the user have the access in the whole server ..is it possible to protect this website from being used in ...
0
votes
2answers
1k views

/wp-admin/install.php redirecting to 123-reg

This is my first time installing wordpress via FTP, and the first time to an existing host and domain (I normally use EvoHosting, since it's automatic) I've gotten to the stage where I'm heading to ...
0
votes
0answers
234 views

Delete all posts of a custom post type—efficiently

I'm looking for a safe and fast way to delete all of one custom post type's posts. Using get_posts() and wp_delete_post() for each returned post does not work; it's not fast enough due to the sheer ...
1
vote
1answer
23 views

I need to get an array from the wordpress database

I need to convert this code //This creates an array from the database and allows us to use it later in the jquery //CREATE SQL STATEMENT $sql_locations = "SELECT * FROM tbllocations"; //EXECUTE SQL ...
1
vote
1answer
38 views

How to write Hebrew characters?

Our database is set to: define(‘DB_CHARSET’, ‘utf8’); define(‘DB_COLLATE’, ”); As a result, entered Hebrew characters in a post are turned into question marks (?) on saving of the post. What is the ...
0
votes
2answers
28 views

Issue “Error establishing a database connection” problem.

Here's the situation. I needed to create a copy of the website online so that I could redesign it and collaborate with others to redo the content. Consequently: I copied a website (example.org) to ...
0
votes
1answer
41 views

Need help for creating custom table on wordpress

I'm trying to learn how to create and use custom tables on wpdb for a plugin that I'm going to build. So far I've seen a bunch of tutorials and know how to create a table but I'm facing problems ...
0
votes
0answers
35 views

Export User Info into CSV - Additional Column (post_title)

I'm using the 'Export Users to CSV' a plugin for wordpress. By default, The plugin only extracts wp_users and wp_usermeta I have been wanting to add post_title column from wp_posts. I was able to ...
0
votes
0answers
21 views

get backup file from wordpress database in x days

I have a wordpress website with so many posts and custom fields located in meta table. What I have to do is to make backup from each 30 days (for posts and postsmeta table) and append it to my last ...
0
votes
1answer
312 views

Inserting Post Meta From SQL

I'm trying to get post meta to be updated/replaced with $wpdb and running into issues. I have working SQL, but cannot get it work when coding it up for my WP plugin. Extra note: The post meta being ...
1
vote
3answers
788 views

Why does $wpdb return strings for mysql integer values?

I find it very inconvenient and hard to understand that the default behavior of the Wordpress db-interface is to convert all integer (and float?) types to strings. e.g $wp_posts = ...
0
votes
1answer
82 views

Accessing external database: ERR_INCOMPLETE_CHUNKED_ENCODING

I installed the "Insert PHP" plugin in my Wordpress page, activated it, and put this code in my page: <p> Connection test </p> [insert_php] $mydb = new ...
0
votes
0answers
18 views

Store id from database query in cookie

I need to store an ID value which is generated upon doing a database insert. After the insert, javascript redirects the user to an external page, which will then redirect back to a wordpress page ...
0
votes
2answers
61 views

How do you build a database-centric site in WP?

The best way to explain this might be to relate my site to a comparison shopping site, as I have around seven tables with 500k+ records each. The content on my site is a comparison of items, and ...
0
votes
0answers
22 views

Allow network sites but also allow single sites

Ok, I think I really need some help here. I am feeling like this is more complicated then it should be. Here is my aim. If plugin is used on single wordpress site than allow and use the class ...
0
votes
1answer
85 views

Automatically generate pages from SQL

I'm building a biodiversity database and am looking for the easiest way to display all the information online. I know I can do this without a CMS, but I have too tight a deadline to waste time ...
0
votes
2answers
109 views

Split database on large site?

What will be best way to split large database on single site, not multi-site wp installation? HyperDB is maybe for this (just, less than 10 webmasters managed to figure out how to install it, ...
0
votes
1answer
38 views

Can form entries from a WordPress form go to a database

I am using Wordpress 4.3.1. I have built a stand alone form (form 1) using PHP where one can enter volunteering tasks doable in a city, has fields like volunteering activity, city, state. The values ...
0
votes
0answers
16 views

MyISAM vs InnoDB [duplicate]

We have a Wordpress website with almost 100k posts (and many more drafts and images). Number of simultaneous visitors reach 6k at peak times. Which database is more suitable for us?
1
vote
2answers
36 views

What happens if I overwrite the current wp_options table with a backup from a week ago?

I have a rather silly situation. I tried this query UPDATE wp_options SET option_value = 'a:0:{}' WHERE option_name = 'active_plugins'; which disabled all my plugins. I was testing some issues on ...
0
votes
1answer
543 views

How to create a searchable database with a single-field search box at the front end?

I have seen many websites having developed a (hidden) database of their certified clients (actually details of the clients and the given certificates) and they have devoted a web page where clients ...
1
vote
3answers
2k 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 ...
0
votes
0answers
9 views

WordPress Integration with Drupal

I could use some assistance. Can I build a site using WordPress as a CMS for one function, and use Drupal for another site (more of a CRM suite app) elsewhere, and grant permissions to records within ...
0
votes
1answer
66 views

CPT or Custom Table for Repository of Serial Numbers

My app allows users to purchase products from a WooCommerce store. But I need to attach a serial number (cannot be generated on the fly) to each product, depending on type, size and design. The ...
0
votes
0answers
46 views

Website goes slow down after importing long database

I am working on a site which have 2 lakhs post and 15 categories. I have home page with 3 post of each category on home page. And after that its goes down while run home page and shows page not found. ...
0
votes
0answers
18 views

How can I move a Wordpress multi-site's domain seamlessly?

I have a multisite install and I've been setting up local and staging sites fine using a plugin (All-in-one-migration) tool to import / export DBs which handles updating the domain link embedded in ...
0
votes
1answer
31 views

AJAX Not Working With Wordpress Database properly

I have created a simple like system where user can click on like button and the like count will increase by one . And if he has already liked the button and he like the button again then it will ...
0
votes
1answer
28 views

Directly editing WP database issues

I've been struggling with this for a long time and would appreciate some help. I would like to change a value inside WP database using phpmyadmin. Sadly, this change seems to corrupt the database ...
0
votes
1answer
77 views

Store the wordpress “featured image” under »wp_posts« Database table

How to store the WordPress featured image under the wp_posts table. Can any one help me? The reason why I am asking same table details (wp_posts), is because I am using a JSON response to add in my ...
0
votes
1answer
50 views

How do you render posts from outside wordpress?

I'm trying to display posts outside of the wordpress system (another system is pulling from the mysql database). However, the posts stored in the database seem to be void of <p> tags and ...
0
votes
1answer
2k views

Database tables for sports betting integrated in Wordpress

I am currently building a sports betting website, and have problems creating database tables for tipsters who writes sports picks. All the picks should be stored in a database table, with information ...
0
votes
2answers
202 views

Website keeps going down, is it a plugin, database, memory problem, or something else?

So I've been having a problem with one of the websites I manage. Essentially, we keep seeing the cloudflare 'site is offline' message for at least half the day, constantly and consistently. Whenever ...