A message from our CEO about the future of Stack Overflow and Stack Exchange. Read now.

Questions tagged [phpmyadmin]

phpMyAdmin is a free software tool written in PHP, intended to handle the administration of MySQL over the Web.

Filter by
Sorted by
Tagged with
0
votes
0answers
17 views

Bulk delete hundreds of WooCommerce attribute taxonomies

I'm trying to remove all the attribute taxonomies, I used this to remove the products from those attributes, but the taxonomies still exist under Attributes. I have 1,243 I'd like to delete. DELETE ...
0
votes
0answers
15 views

why not selecting multiple rows of same standard_id using SQL query from database?

i have invested much more time in simple query ,i was trying to select different rows of same standard_id and in my database is two such rows which have same standard_id but from them i only getting ...
0
votes
1answer
18 views

SQL query to change custom field in Wordpress database

I'm newbie in SQL questions, and today i have a big problem. I need change many fields in my SQL, about 4,5k. But have some rules to the query change, to don't change wrong fields where don't need ...
0
votes
0answers
28 views

update_post_meta not working in template_redirect action

I have a problem I'm trying to listen to a webhook, and I can do it, I check with the help wp_mail function and I get all the data But I want to make a add data in the database, and for some reason ...
0
votes
0answers
28 views

$wpdb->get_results returns different results compared to phpmyadmin

this is my sql statement, which works in phpmyadmin: SELECT wp_ccs_cashflowaccounttype.cashflowaccounttypeid, wp_ccs_cashflowbookingtexttype.cashflowbookingtexttypeid, w.invoiceid, ...
0
votes
0answers
17 views

How to combine Opencart 3 affiliate with customer account

I am using the Journal 3 theme. How can I make it so once I sign into a customer account, if not an affiliate show option to join on my account page; if already an affiliate then auto sign in? And ...
0
votes
0answers
24 views

What is recommended data type and encryption type for password in a database

I want to know what data type and encryption type best to use in a database for user passwords. Thank you in advance.
1
vote
2answers
91 views

How to delete users with no order history through phpmyadmin sql?

I have a wordpress ecommerce website which I have begun to update after not touching it for over a year. The first thing I did was implement reCaptcha into all inquiry and contact forms to reduce the ...
0
votes
0answers
14 views

Search and replace text with line break in database

How can I search and replace two sentence with line break? For example, I want to replace this in my database- Imagination is more important than knowledge. Imagination encircles the world. If it's ...
0
votes
0answers
15 views

Can I disable auto increment of WordPress Posts Database to utilize previously deleted records?

When I delete a record field of WordPress posts database such as Post, Image, Page, etc. and add new item then it will add in a fresh record field due to auto increment function. But I would like to ...
0
votes
1answer
18 views

WordPress PHP version

My server has last PHP versión but WordPress still But my site keeps asking for the latest version, how do I update this? Thank you
0
votes
0answers
33 views

Menus Problem - “widget setting ID: nav_menu_item[]” error - 84540 rows of “0”

I have a problem with a WP Multisite where only sub-site is misbehaving. All other subsites work OK On this problem subsite, I can’t open Customise – it throws an error … Uncaught Exception: Illegal ...
0
votes
0answers
17 views

mamp upgrade database backtrace error

I use MampPro to setup my sites on the local server... all well and good. So, every time I fire it up I get the upgrade nag... so, I figure its time, and hit the upgrade... and it does its thing. ...
2
votes
2answers
120 views

$wpdb->query() vs. $wpdb->get_results() vs. phpMyAdmin

I have this code: $query = "SELECT * FROM $wpdb->posts INNER JOIN $wpdb->postmeta ON $wpdb->posts.ID = $wpdb->postmeta.post_id ...
0
votes
0answers
25 views

Login issue in Wordpress

I'm facing currently an issue with my wordpress site, i don't know exactly what happened but when i try to login from /wp-admin i enter my password and i connect, but naturaly after the session dies i ...
0
votes
1answer
18 views

syntax error for changing user role from database

I want to change user role from the database, UPDATE wp_usermeta SET meta_value = 'a:1:{s:10:"subscriber";b:1;}' WHERE meta_key = 'wp_capabilities' AND meta_value = 'a:1:{s:9:"wpas_user";b:1;}'; ...
0
votes
1answer
31 views

Changing root password in PHPMyAdmin for Wordpress Database when going live

Is it a good idea to create a password and make your password secure for your Wordpress database when uploading the database to a third-party web host (going live instead of hosting on localhost) ...
0
votes
0answers
33 views

Reset post IDs with all post meta

I imported posts from an old website. Posts from the new website have IDs under 100. Posts from the old website have IDs above 9934. I tried to change manually the post IDs in phpmyadmin in order to ...
0
votes
0answers
22 views

Export Custom post + WPML

Hi everybody I have a Main wordpress with 500 custom post type, some of them are in Spanish, some of them in other language through WPML. I need to export them into a new wordpress, but I only ...
0
votes
2answers
34 views

Setting up Wordpress Locally on WAMP for a new site (with one already)

Here are the steps I took in downloading and setting up WordPress on a WAMP (Windows, Apache2, MySQL, PHP): 1.) Download WAMP Server, here: WAMP Server Installation 2.) Download WordPress on ...
0
votes
1answer
16 views

Help locating old custom_css in PHP MyAdmin

I started developing a website, and midway through I changed the URL. I was and still am an amateur so unfortunately I've had some issues with the database now that I'm trying to go back and clean ...
0
votes
0answers
14 views

avoid duplicate content after migration

I've done a full migration of two wordpress site (transferring bunch of blogs). I see that there are few blogs that have been repeated twice. Like, after moving old blogs from old to new sites along ...
0
votes
1answer
34 views

Getting Error Trying to Create Table

I'm trying to create a new table in phpmyadmin. I'm using MAMP and this is of course inside wordpress. <?php function testtheme_database() { global $wpdb; global $testtheme_db_version; $...
0
votes
1answer
70 views

SQL query to bulk change short code in all posts

PHP/SQL noob here. Based on this question I attempted to change some entries in phpmyadmin for my wordpress blog: I want to all galleries to link to file instead to file attachment (add link="file" to ...
0
votes
0answers
16 views

Moving attachment postmeta rows to new database

I am moving a lot of content from one existing (and damaged) Wordpress installation to another existing installation. I am trying to bring the media library attachments into the new site, but when I ...
0
votes
2answers
140 views

Importing posts content from csv

I want to export some specific posts from my database (csv or sql) and then replace content to these and import them back without changing the id number of the posts.I s this possible to do it and if ...
1
vote
1answer
59 views

phpMyAdmin displays error when importing database 2

I'm cloning a WordPress into my PC. I have already backed up all files.. The problem is that when I try and import the database using phpMyAdmin, I get this error message: Error Query SQL: -- Dump ...
1
vote
0answers
25 views

How to delete posts that does not have a thumbnail?

I have a problem with my blog. The thing is this, all the posts have a thumbnail in this address: wpbv_postmeta-->meta_key-->thumb And several (A LOT) of posts don't work, because I have made a ...
0
votes
1answer
22 views

Duplicate database to roll back theme & content changes

I am going to update site to a new custom theme and it will take a few days to get all the work done. Can I duplicate a wp database in phpMYadmin, so i have wp-db1 and wp-db2. Then I can change wp-...
0
votes
1answer
186 views

WP website showing blank page after moving from subdomain to main domain

I created my website on the subfolder https://www.lokaction.be/dev/. After it was finished, I moved the website's files to the main adress https://www.lokaction.be/ (ftp). And after that, I edited ...
1
vote
3answers
155 views

Is it possible to create a wordpress database with php code?

Just curious . Is it some how possible to create a database with php code? I am having only having access to public_html folder and i want to make a wordpress installation. Is there any method to make ...
0
votes
1answer
69 views

Clients with empty username are not receiving request new password email

I am looking after a old site from a client and a lot of users dont have username. I had setup in woocommerce "When creating an account, automatically generate a username from the customer's email ...
1
vote
1answer
399 views

Delete all post meta except featured image Using SQL

Please I just migrated my site and I found out that wp_postmeta consumes most of my cpu resources, Is the any Sql code to Delete all post meta except the featured image. I dont want to Use wp ...
0
votes
1answer
40 views

submit form data to wordpress existing database table using my plugin

i have created a plugin for wordpress to sbmit form dtails to wordpress database. I created a table in cpanel phpmyadmin called 'wp_in_booking'. im trying to send the form data, but it can not get ...
0
votes
1answer
139 views

Plugin: register_deactivation_hook works perfectly well, while register_activation_hook suddenly stopped working

So interestingly, I moved my main plugin file into a folder within the plugin directory. Where before the register_activation_hook worked perfectly well, it now does not work; however, the ...
2
votes
0answers
144 views

Emojis getting converted to “?”

Emojis in posts and comments on a 500+ posts blog get converted automatically into single question marks in irregular and untraceable intervals. The respective tables wp_comments and wp_posts are ...
0
votes
0answers
29 views

duplicate wordpress site on same bdd

I have only one bdd with 2 wordpress sites : first with _wp suffix second with _wp2 suffix. For the url : mydomain/site1 mydomain/site2 Now i need to duplicate the site2 as site3 (mydomain/site3) ...
0
votes
1answer
208 views

WooCommerce categories do not show in Backend

I have created categories for Woocommerce via phpmyadmin. Including three tables: term_taxonomy, termmeta, terms. And then go to wp-admin/edit-tags.php?taxonomy=product_cat&post_type=product, it ...
1
vote
2answers
1k views

Where is the “default attribute” values located in the phpMyAdmin in Woocommerce?

I'm looking to mass remove or clear the default attribute for variable products in Woocommerce. Is there an easy way to mass clear this value? If not, would you be able to direct me on where I can ...
0
votes
2answers
37 views

WP CLI can't delete plugin related table

I have installed a plugin following wp plugin install ... CLI command and then activate through CLI command its working properly. But problem is that when I deactivate then delete the plugin the table ...
1
vote
0answers
109 views

Wordpress Database Huge wp_usermeta Table

I have a wordpress site with over than 700,000 users. Each user adds more than 20 rows to the wp_usermeta table ! this is causing very slow queries and the website started to crash, login failure and ...
0
votes
1answer
137 views

Can't update WordFence Options, clear data manually

I ran across this problem today. Found enough bits on Stack Overflow to finally get me there, but figured I'd post a coherent answer to my question. Problem: I can't save changes in WordFence, and ...
1
vote
1answer
425 views

Update slug (URL) of pending posts via phpMyAdmin

I need to remove/delete slug of posts on pending via phpMyAdmin. Most of posts on pending have slug/URL which is different from their post title, deleting post slug/URL will force WP to generate new ...
0
votes
1answer
1k views

Export Yoast Keywords from MySQL/phpMyAdmin

I'd like to export all focus keywords from Yoast, as we're moving platforms to Craft CMS and using a similar tool, Ethercreative's SEO tool. I'd love a good query to pull these from the database, ...
0
votes
1answer
196 views

AWS Bitnami Wordpress - SELECT command denied to user

I'm using Amazon Web Services (AWS) Wordpress which uses Bitnami. I've created a test template, wrote a SELECT statement to test pulling data from the database, uploaded the template, selected the ...
1
vote
3answers
782 views

How to replace values in Wordpress DB using phpMyAdmin

I am trying to save a value in a cg_option row/field using phpmyadmin, however data is not stored correctly and when loaded again after saving, only part of data appears. Do I need to use a conversion ...
0
votes
0answers
350 views

An SQL query to find orphaned image attachments and their meta

This is for people who are good with MySQL queries. I'm using phpMyAdmin locally to try to optimize an old WordPress & Woocommerce site which has gone through a couple of iterations over the years....
0
votes
1answer
126 views

Change Custom Post Type to Post + Category

I have a rather difficult problem, I have a news site and I used a custom template with custom post-types for each "category" and now I want to change the template, but I can not change the posts for ...
0
votes
1answer
4k views

Connection refused on locahost after importing database?

I'm using Wordpress Instant for my development environment. It's a portable dev environment that allows me to run a local wp install off a usb, so it's portable and I can take it from one computer to ...
0
votes
0answers
192 views

Adding wordpress posts using phpmyadmin

I am trying to add wordpress posts exported from phpmyadmin into a site that already has wordpress posts. The process would work fine if the site I am trying to upload the sql file to was a brand ...