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

learn more… | top users | synonyms

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
23 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
36 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
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
0answers
23 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
22 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 ...
0
votes
0answers
38 views

How to create a coupon in the database?

I added over 1000 coupons (schedule ones) in the database. I had one line in wp_posts and several wp_postmeta tables per coupon. To add, I've saw how a coupon was represented there and I've made ...
0
votes
0answers
19 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
14 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
19 views

How can visitors create appointment request to be accessed by all subscribers?

I need some guidance regarding an 'appointment request' implementation. I'm developing an online community as free university platform for patients to find free dental care in university clinics. ...
0
votes
0answers
13 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
15 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 ...
0
votes
0answers
40 views

WordPress database error Deadlock found

My website become slow due to this issue. WordPress database error Deadlock found when trying to get lock; try restarting transaction for query DELETE FROM wp_options WHERE option_name LIKE ...
0
votes
0answers
38 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
16 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
22 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
23 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
22 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" ...
0
votes
0answers
19 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
18 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
22 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
8 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
48 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
20 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
30 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
13 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
18 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
18 views

WordPress database error (wp_terms)

I'm having the following issue. Whenever WordPress try to get any term from database (product_tag, portfolio_tag, etc) I see messages like: WordPress database error: [Error writing file ...
0
votes
0answers
10 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
35 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
19 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
78 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
56 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 ...
0
votes
0answers
44 views

Can't Install WordPress (local) Failed to open file wp-includes/wp-db.php

Title kinda says it all. Trying to install WP locally and I get the following error when trying to use the wp-config.php generator UI: Warning: mysqli_real_connect(): (HY000/2002): No such file or ...
0
votes
0answers
41 views

get_the_terms is not working

After I updated WordPress, a function using get_the_terms() is not working. When I run get_the_terms() I'm not getting terms, but when I add before that call wp_cache_flush(); I'm getting terms so ...
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 ...
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 ...
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
0answers
225 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 ...
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
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
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
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
0answers
45 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
0answers
20 views

Syncronize post from different databases

I have an "engine" site that import rss post from all over the world, all day, like an aggregator. That importing activity is really slowin down things. So in a different neat and clean wordpress ...