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

learn more… | top users | synonyms

0
votes
0answers
3 views

multiple wordpress installation with shared usertable on an different database

I have multiple wordpress installation, and I would like them to share the same usertable. The wordpress installations are already up and running, and they all have their own database. Is it ...
1
vote
0answers
10 views

When open add new post or page Wordpress add post with ID=0 continuously

When open add new post or page Wordpress add post with ID=0 continuously. and instead of publish there is submit for review
0
votes
0answers
9 views

Create new table vs post_meta table database dilemma

I'm working on custom function that will store post data but I dont know which method to use. I have meta box in edit post area that will store diferent videos (embed code) for each post will have ...
0
votes
1answer
27 views

Problem in using wpdb

I used "wpdb" in my code But it was not working and the following error: Fatal error: Call to a member function insert() on a non-object Notice: Trying to get property of non-object" in ...
0
votes
0answers
11 views

Hook upon database insertion?

I have downloaded a plugin that inserts a new row into a table in my database. I want to perform a calculation on this row as soon as it is inserted into the database, in my own plugin. I've seen a ...
0
votes
1answer
25 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
1answer
27 views

Build a website with a database connection in Wordpress?

I have built multiple websites using Node.js, PHP, Java and have knowledge on basic web development tools. Except for wordpress. I'm required to build a webpage that does some file manipulation, ...
1
vote
1answer
14 views

When and why should I use $wpdb different return types?

This one returns an object $mylink = $wpdb->get_row("SELECT * FROM $wpdb->links WHERE link_id = 10"); An associative array $mylink = $wpdb->get_row("SELECT * FROM $wpdb->links WHERE ...
0
votes
1answer
11 views

Structure of postmeta meta_value for woocommerce product download

So I'm working on a monster script to port all of our existing stuff from Joomla/Virtuemart to Wordpress/WooCommerce. So far I've got just about everything done with moving over our product ...
0
votes
1answer
29 views

Get the post permalink within the loop but without additional DB query

I am looking to create a custom 'directory' page which will link to several thousands of posts. Because of the large number I am trying to limit the number of DB queries. I notice that to link to each ...
4
votes
0answers
44 views

Relaunch 4.2 utf8mb4 databse upgrade

I updated WP to 4.2 while it was on an old server, that doesn't match the utf8mb4 upgrade requirements. I moved to another server that fit these requirements, but WP won't launch this database ...
0
votes
0answers
10 views

Text with sub bullets not saved correctly

I'm having problems with sub list items. In my backoffice it looks like this (text is blurred): Visual: Text: In the text editor it looks good but when I save the post I get this in my database ...
0
votes
2answers
34 views

Disable Database Update Required ? break my website

Im having an issue if i want to login to the dashboard, it needs a "Database Update Required" I'd like to disable it, because once it update the Database, if I go to any post of single-pages, it ...
0
votes
0answers
18 views

WordPress and user security

When we talk about Information Security, many things come into mind and people tend to use CMS to be clear on security as CMS people do the job for you, in terms on hashing passwords, encryption etc. ...
0
votes
0answers
16 views

Two same URL domain

I have a problem with my wordpress . I just migrate to a new install only the post and categories . But now entering a link or search the CSS BASE URL for example doubles A href attribute URL : ...
0
votes
1answer
6 views

Changed meta_key value in structures, now dashboard shows zero users

I was trying to edit the email form field so that it accepts int values like of a phone number. I knew very less about how database values work and this is what i did: 1. Figured out that email field ...
0
votes
1answer
13 views

How to enable the user to add value through the admin panel?

please help me! I have custom posts type 'gallery'. In my custom post type i have custom fields. I added them through the file functions.php. How to enable the user to add value through the admin ...
0
votes
1answer
34 views

SQL Error wp_commentmeta - incorrect table definition

I'm trying to import a database and wonder how I can stop getting the following error? "#1075 - Incorrect table definition; there can be only one auto column and it must be defined as a key " ...
-1
votes
1answer
20 views

What is table `wp_woocommerce_termmeta` for? [closed]

I'm using Woocommerce plugin for my Wordpress website. After added, I notice that there is a table called wp_woocommerce_termmeta. What is this table storing? p.s. Is there any relationship ...
0
votes
1answer
24 views

Why user_pass column in wp_users table is varchar(64)

while working on a project, I found that "user_pass" column in "wp_users" table is varchar(64). WordPress always stores user password in md5 which is a 32 char ASCII string. So why not store it in ...
0
votes
0answers
6 views

Database level import of featured images and link to posts - How?

I have been attempting to import about 50,000 images into 50,000 posts in WP 4.2.2. The _posts table data is all correctly imported already. I know I need to import to _postmeta table and add new ...
0
votes
1answer
22 views

update_user_meta(): invisible data storage

I try to customize users profile using this code (from this tutorial) : <?php function extra_user_profile_fields( $user ) { ?> <h3>Autres</h3> <table class="form-table"> ...
0
votes
1answer
17 views

Wordpress Failed to Login (DB Error)

is there anyone experience how to fix DB Error on WordPress (switch back to default theme and reset all plugins from FTP) but still cannot login). This is the erro I got: WordPress database error: ...
0
votes
0answers
24 views

Problem in adding new site on WP multisite

It's for two or three months that this problem exists in WordPress multisite and I'm still waiting for a solution or an update. When adding new site, I get this error: Warning: preg_match() ...
-1
votes
0answers
15 views

Customization in Wordpress Plugin - Search result page

I am using a WordPress plugin for travel search by Travel Grove. This is the url : http://www.designgridstudios.com/demo3/ . After filling the search form it points to Merchant site and compare the ...
2
votes
1answer
14 views

WordPress and automated MySQL backups to a different host

I'm having the following setup. A development computer in my local network and a production server with a real internet domain. Developing the PHP/CSS files on my dev computer for my theme is handled ...
0
votes
2answers
29 views

Should non-WordPress data get its own DB?

I couldn't find anything on Google or on here about best practice for data that is not really Wordpress related. Say we have a database of clients that we'll be accessing through PHP/SQL. Should I ...
0
votes
0answers
33 views

Loading posts from another wordpress database on the same server

I've searched quite a while and found several solution but apparently I'm doing a lot of stuff wrong. I'm having 4 different Wordpress sites and need to load the latest 2 posts of each site. For ...
-1
votes
0answers
12 views

Why only one of my sites is so slow to backup?

I have made many websites with Wordpress, but only one is really slow to backup, slow like many many many hours. My site : 1630 articles + 36 pages My backup plugin : Wordpress Database Backup (by ...
0
votes
0answers
9 views

MYSQL ignore categories on Wordpress widget

I have this WP widget that pulls random products from the DB. What I really want is to be able to include just a few products categories (or exclude). Can anyone help me? I appreciate. <?php ...
0
votes
1answer
38 views

Post Views / Hit Counter Problem?

I have decide to use WordPress as a CMS to my 5 moths old website. I have already added all previous posts to my new site ( WordPress ). But now I need to change view counts to previous views counts. ...
0
votes
0answers
32 views

wp_editor content in plugin options page

Hi I'm writing a plugin it involves the site builder / user adding content via wp_editor this content is then saved and submitted via a submit_button. I've wrapped the editor in form action = ...
0
votes
0answers
17 views

wp_include_post in custom post with coustom field

I'm new in wordpress and my english are not good. I'm using Custom Post Type UI plugin to create a post type "Product" and Advanced Custom Fields plugin to create some custom fields like address. Now ...
1
vote
0answers
40 views

Issue with wp_insert_post and post_content field error Could not update post in the database

I'm having issues creating an import / caching script to be used within a WordPress site. This feed comes from a single text file that is then parsed and returned as an array. When running through ...
0
votes
1answer
35 views

Is it possible to recover Deleted users?

I've accidentally deleted all of my WordPress site users and now I want to recover those deleted users? IS it possible? I've not created database backup so is it still possible?
0
votes
2answers
42 views

Running a song lyrics site on WordPress

I converted an old site, which used to run on a CMS called Smarty, to WordPress and am trying to make the look and feel of the site look like a proper music lyrics site. There don't seem to be themes ...
0
votes
1answer
25 views

what is the best way to store user created data?

The plan is for users to be able to store locations and have notes and other variables for each location. These locations would later be shown on a map, so I would need to be able to quickly access ...
0
votes
1answer
15 views

Expired Post with More Recent Time Stamp?

Im having issues with custom posts not showing in worpdress. I see in my posts table theres two enters for each custom post X - Has a date Jan14th- 2:06pm - post_status: expired Y - Has a date ...
0
votes
1answer
21 views

Weird Behaviour: Not all Wordpress Posts appearing

My wordpress posts have vanished on my dashboard but remain in the database? Meaning I have many 404 errors. All (52) | Published (4) | Drafts (7) | Trash (2) TOTAL =11 items (Note how theres only ...
0
votes
0answers
20 views

Database migration tool for GoDaddy Managed WordPress

I’m about to revoke my Managed WordPress subscription because tools that I have paid for (such as WP Migrate DB Pro) that are an integral part of my development process that sync or migrate my local ...
0
votes
0answers
6 views

Users getting registration errors when signing up but still being registered on the backend?

Having a very strange issue on a Wordpress install - we cannot replicate the error ourselves, but multiple customers have complained about it: They fill out the registration form and get an error ...
0
votes
1answer
38 views

option select form always deleting the sql query

I have this form: <tr class="user-statusz-wrap"> <th><label for="statusz"><?php _e('Státusz') ?></label></th> <td> <select type="text" ...
0
votes
2answers
29 views

How to transfer from localHost to live but use the already existing database on the server?

I have been developing a WordPress website for a client, working from my own machine utilizing WAMP to create a local environment on which to work. Now, the problem is that the website needs to go ...
0
votes
0answers
28 views

Google-App-Engine[PHP]: Error trying to establish database connection

Hi to whom this may interest, I am finding a problem with the cloudsql as database connection is not being established. I have followed the following site step-by-step ...
0
votes
0answers
34 views

Insert XML data into the existing posts

I have nba videos news website and I want to insert xml data into the existing posts. For ex I have this post Pacers vs Timberwolves Match report and I want to import data from this xml: ...
2
votes
1answer
90 views

error establishing a database connection

I know this question is asked like a million times, but I can't find an answer for my problem. This problem is happening in a user of my server (my father's blog actually), and as he told me: "Just ...
0
votes
2answers
58 views

Ideas to connect external database table to wordpress posts as custom field source

I have a custom database table within wordpress database.. I filled this database with data and wordpress posts table with matching ids an example would be... wp-posts table has id - title ...
0
votes
0answers
44 views

How to configure the file wp-db.php at /home/…/public_html/wp-includes/wp-db.php on line 1444

I need your support guys ! When I try to connect to my website I got this error: WordPress database error: [Lost connection to MySQL server during query] SELECT cm_posts.* FROM cm_posts INNER JOIN ...
0
votes
1answer
33 views

Fetch data from another site, but the same database

We have two WordPress sites (Site 1 and Site 2) in the same database, with different prefixes ("site_1_" and "site_2_"). Let's say we've got a custom post type named "stuff", which is in Site 1. We'd ...
7
votes
2answers
194 views

Is it mandatory to use $wpdb->prefix in custom tables

Sorry if this question is trivial. I'm just beginning to develop plugins in WordPress. In all the tutorials I found this: while creating the custom tables, $wpdb->prefix is used. Example: ...