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

learn more… | top users | synonyms

0
votes
0answers
18 views

Override $table_prefix only for the options table

The only documentation i found was too obsolete. (https://wordpress.org/support/topic/two-sites-two-themes-one-database-same-content) and this one (Change options table prefix only) doesn't help me. ...
0
votes
0answers
16 views

Call to a member function insert()

I did a POST form and try to sign in to the Wordpress database is showing this error. Fatal error: Call to a member function insert() on a non-object in C:\wamp\www\teste\wp-content\themes\...
0
votes
0answers
37 views

How to generate notifications when MySQL data base changes

I am developing a WordPress multisite and I am wondering how I can generate notifications when MySQL database changes? For example the user in site #1 can sell his society. When he selected it, it ...
0
votes
0answers
27 views

How to display the results of inner join to user?

I have three tables of contents. And I put them together and display the result to the user, how can I do this? MY CODE THAT INSERT DATA IN TABLES: function cadastra_experiencia($nome, $email, $...
0
votes
0answers
26 views

Sharing tables between 2 different websites based on the same database

I have 2 different websites installed on the same database. The 2 websites are sharing the users tables, but I want them to share the posts tables too. I tried to do it by editing wp-db.php. After ...
0
votes
0answers
22 views

Wordpress Authentication without Wordpress functionality

The requirement is to authenticate against the WordPress users tables to get past the paywall but not offer any WordPress functionality. The problem to resolve is that since the user is ...
0
votes
0answers
21 views

Trim data before insert?

Recently I use this syntax to input data like below: $STRING_DATA = StrToLower(Trim($input_data)); $wpdb->query ( $wpdb->prepare ( 'SQL SYNTAX WITH PARAMETER STRING', $STRING_DATA ) ); Do I ...
0
votes
0answers
39 views

INNODB Supports transactions, row-level locking, and foreign keys

When I try to create a table for a plugin (that was dropped in the past) I get the error: #1005 - Can't create table 'database_db.wordpress_popularpostssummary' (errno: -1) (Details…) And the ...
0
votes
0answers
58 views

Search result by taxonomy name

Currently my search filters by title and I'm trying to filtered by taxonomy tags. How do you I do that. Here is my code: $query = " SELECT * FROM $wpdb->posts WHERE $wpdb->posts.post_status = '...
0
votes
0answers
14 views

Exporting a multisite DB for a single site production site

So I have a wordpress multisite that houses all of my client test sites(14). This means that its all one database obviously. This client is now ready to go live on a single wordpress instance so I'm ...
0
votes
0answers
32 views

Storing Unique Data on the Database

I have created a custom table on my database using the code below: function dbcreator_activate() { global $wpdb; $table_name = $wpdb->prefix . "ftbstatistics"; if( $wpdb->get_var('...
0
votes
0answers
22 views

Options of accessing wordpress data from mobile app

There is an existing wordpress website and I would like to make native app(probably will do crossplatform native with React Native as I have experience with it) for it. So my question is: is there an ...
0
votes
0answers
34 views

Custom database query with accents returning no results

I have an issue where using accents in my custom database query (wpdb) returns no results. $wpdb->get_results( "SELECT * FROM table WHERE city = 'Montréal'" ); Returns nothing, while $wpdb-&...
0
votes
0answers
17 views

same users different websites other then wordpress

I am creating a network of sites. I have some wordpress installations as well as some other scripts installations. I know that i can use single wordpress users table for different wordpress ...
0
votes
0answers
12 views

compare database values before an update

in my wordpress, I want to store my form data to database by using: update_user_meta(); I successfully store the data to database and write it to the page, but the problem in whenever I updated the ...
0
votes
0answers
27 views

Custom post types from custom database

For a plugin I want to use custom post types based on data stored in an external database. This database isn't related to WordPress (the structure of the tables is independent). The datastructure is ...
0
votes
0answers
31 views

Database collation and char set issue

I attempted to import my WordPress website from local host to live server online and i get an error #1115: that i have wrong db collation of utf8mb4. So i googled and changed the cllation to ...
0
votes
0answers
20 views

Add a Filed to WordPress User Table

I am going to give points for users for their activities. I thought to add a field for user table. Is it a bad idea? I use my own function to update that field.
0
votes
0answers
17 views

Why Do I Still Getting Duplicate Rows in SQL?

I'm creating a Custom Freight System which stores the order and the products requested by the user into the WordPress Database. The Problem When I insert the product into the wp_my_custom_products ...
0
votes
0answers
33 views

Join Wordpress databases from 2 different installs

I'm just now getting into SQL and the core of Wordpress (PHP). So I'm not an experienced WP developer but not intimidated by the tools. But, if the answers could be dummied down a bit would be very ...
0
votes
0answers
50 views

How to delete a stuck post using phpMyAdmin

I was attempting to change some leftover http:// references in the DB using Update/Set SQL statements. I was getting confident and started doing them in bulk and stopped noting exactly what I was ...
0
votes
0answers
9 views

Save Hist in Author Pages by Date (Year and Month)

I'm trying to save the hits that a page receives in the database so I can display them in the front-end if required. I need the hits that an author pages receives and save them by month. I'm a bit ...
0
votes
0answers
23 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
0answers
57 views

How can I push local database changes to production, without impacting recent posts/pages that were published on production server?

I am currently pushing static file changes like this: git > remote repo > deployHQ > production Seems to work great for static files. Finding a similar solution for the database hasn't been as ...
0
votes
0answers
23 views

Associate multiple Database ID's

I am using a form plugin in a multi-seller woocommerce environment where each user (seller) utilizes this form which the values are stored in form's DB tables. My problem/question is: when a seller......
0
votes
0answers
53 views

How to configure MySQL-SSL-Access to a MySQL Server 5.5 when a list of CIPHERS seems mandatory?

I have a MySQL 5.5 Server with SSL setup. I can connect with my MySQL user via command line from the webserver to the database server over TCP and verified the connection is encrypted. I figured out ...
0
votes
0answers
18 views

Query a custom post type from a different WordPress install?

I have a client who would like to only create his items on one domain, but have a specific taxonomy of that custom post type display on a different domain (this is not multi-site...they are separate ...
0
votes
0answers
23 views

Database table not created without error

I have this code to run on activation to create the table $table_name = $wpdb->prefix . "codes" function code_install() { $sql = "CREATE TABLE IF NOT EXISTS " . $table_name . " ( id ...
0
votes
0answers
23 views

user_id increment?

I wanted an Admin account with user_id 999 in our database, so I changed some settings in the database according to http://www.wpwhitesecurity.com/wordpress-security/change-wordpress-administrator-id/....
0
votes
0answers
82 views

Unusable menus and “Illegal widget setting ID: nav_menu_item[]” error

This is a bug in my WP install that has crept up unknowingly; I can't say for sure when it began. To describe it: there were menus created in the Appearance -> Menus page early in the site's history, ...
0
votes
0answers
16 views

Excerpt data from one page into another

I'm a comparative noob at working inside WordPress. I'm trying to do my homework before asking, but haven't been able to uncover answers to the following. I could use your expertise. I'm working ...
0
votes
0answers
17 views

change data in mysql but don't change in admin

I have a problem, I have changed the content of my page in MySQL, but when I reopen the same page in the WordPress Admin panel, the content hasn't changed why is this? I'm using the interconnect ...
0
votes
0answers
26 views

WordPress Database - wp_comments?

I am working on extracting data from a WordPress database to my own. I have managed to transfer all the comments from the wp_comments table. Every comment should have an image or attachment ...
0
votes
0answers
28 views

Wordpress changes not showing

I'm wondering how to fix the website when the changes are not showing instantly? I tried the following fix: Installed W3 Total Cache and Super cache and cleared all the cache on the website Cleared ...
0
votes
0answers
23 views

log in form using a separate database

in the html code i have made this form: <form action="http://www.mySite.co/login.php" method="post"> <fieldset> <p><input type="text" name="uname" placeholder="Name" required>&...
0
votes
0answers
20 views

Processing a lot of $wpdb isn't insert all the data

In my plugin the user provides some CSV files that are processed and either inserted or updated based on a sku (which acts as a foreign key to my DB and a primary key for where the CSV comes from). I ...
0
votes
0answers
20 views

See site's database's schema

How can I have access to my wordpress site's database schema without SSH an access ? I need to see the tables and fields but couldn't find a way without SSH (my host doesn't provide SSH access).
0
votes
0answers
23 views

Access a WordPress Table from Outside Project

I have a PHP project on example.com and I have a WordPress installation on example.com/blog. I need to get data for my PHP project from one of My WordPress table. Is it possible? If it is possible ...
0
votes
0answers
12 views

Do I need to worry about filling meta_value column in wp_postmeta table during migration?

I am migrating article/post data from a Joolma site running 'seblod', which has scattered the data across multiple database tables, so I can't use an off the shelf migration plugin. I am transfering ...
0
votes
0answers
133 views

How do I establish a connection between Firebase user database and WordPress?

I'm making a Website and an android app. The android app stores its user details i.e., username and password on Firebase database; I'm also making a website and I want a login in the website which ...
0
votes
0answers
24 views

One WP Database outside localhost and two connections

I would like to ask for help with this problem. I have two places where I have the same WP. 1) Test site - own domain, hosting and DB - here is stored database, so siteurl is here, example: test.com ...
0
votes
0answers
20 views

Import SQL backup

So I accidentally deleted MySQL database of my wordpress, but my site is still running, I can access all the file in the filezilla but I just can't access the admin area of wordpress to make any ...
0
votes
0answers
51 views

#1062 - Duplicate entry '1' for key 'PRIMARY'

I am trying to move my database from my usbwebserver to my online server. But I get this error, can anyone help me with this? #1062 - Duplicate entry '1' for key 'PRIMARY'
0
votes
0answers
18 views

Importing inventory from a csv file in the ftp to the database

I'm looking to upload the content contained in a csv file from FTP directly into a WordPress database every 24 hours. This csv file (containing inventory items) gets generated from one site, and I ...
0
votes
0answers
38 views

MS Access to wordpress sql

I have a client who runs a store and has around 125000 products and he manages his stock from MS Access server. His current site is just for product catalog but he wants to have a new site to sell ...
0
votes
0answers
22 views

“User Role” Not Working

While following recommendations in IThemes Security Plugin, I renamed the database file prefixes which broke our site (multisite installation). I restored the database and everything seemed to work ...
0
votes
0answers
37 views

In WordPress do I create tables for my plugin or do I create custom post types for a Student and Classes Registration system?

I want to use WP 4.x as a framework to build a small Student system. I do not wish to use an existing plugin. My needs are unique, and these do not do what I need. In my design, I have Students ...
0
votes
0answers
22 views

Bulk find replace to convert hundreds of old URL calls

We have a new wordpress site generated from an old html site with thousands of pages. An import process was used, but unfortunately as a result the site has hundreds of references within content to ...
0
votes
0answers
95 views

Wordpress installation: Error establishing a database connection

I've successfully installed Wordpress on my local system and used it to create a demo site. Now I'm struggling to get an empty wordpress installation to work on my webspace. Running the install.php in ...
0
votes
0answers
66 views

How Can I lock function to prevent running multiple instances in one time?

I have written a plugin. There's a function int it that works with a DB table and (works on a data tree) ,I want if function starts running ,other instances lock until it finishes(then other instance ...