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
13 views

Filter PHPMyAdmin table with search bar

I made a table in the PHPMyAdmin that I have in my WordPress dashboard. Picture: I'm trying to make a search bar to sort the table by internship name, but it's not working. Picture: Here's the code ...
0
votes
1answer
37 views

Search bar to filter PHPMyAdmin table [closed]

I made a table in the PHPMyAdmin that I have in my WordPress dashboard. Picture: I'm trying to make a search bar to sort the table by internship name: Picture: Here's my current code for the search ...
0
votes
0answers
34 views

DB prefix not updating

I have a site I built locally and migrated to a live environment. Later I created a copy of this site and booted it up locally again to do some further dev in there. My local dev software (Local by ...
1
vote
0answers
15 views

Problem with database mhpMyAdmin [closed]

I have a huge problem. By an error my database is overwriten. 1 have one backup a day, but this is not a solution. Can I don't see the history of queries? Or can I use some software? Can anyone helps ...
0
votes
2answers
61 views

Delete all pages (thousands) except a few by their IDs

I have over 20 thousand pages and need to delete all of them except very few. Deleting them from the wp-admin page would take too long and a huge effort. Is there a command I can run in PhpMyAdmin to ...
1
vote
1answer
30 views

Duplicate posts when posting nulls in records in phpMyAdmin [closed]

I have a phpMyAdmin database with a table whose contents, when inputted from the database, automatically publish the related information. Some of the details within the record may be NULL, and while ...
0
votes
1answer
22 views

Delete all users with Editor role and their content mysql

I have a Wordpress site with thousands of editors. I cant delete them from the WP dashboard as its to slow. I need a query to delete all the editor users and their posts from PhpMyAdmin? Thanks
1
vote
1answer
31 views

Double domain name in category URL-s

My site runs on the latest version of WordPress. However, I have a problem with categories. Permalinks are set correctly and my category path looks like this: example.com/category-name. Links work ...
0
votes
0answers
9 views

how to connect users with thier own orders php

I have tryed alots to connect the users id with their own orders that have been orderd in the checkout page and sent to backend. Right now it just displays the users only and anothr page it displays ...
0
votes
1answer
28 views

oembed_cache SPAM problem [closed]

I recently found hundreds of posts with post_type oembed_cache while looking into my database. Many of them appear to be spam. I can't for the life of me figure out how there are being injected into ...
0
votes
2answers
51 views

Display data from phpMyAdmin with WordPress

I have imported my website to Wordpress and facing a big issue how can I do sql Query to display data on my pages with wordpress? for example I have product, price, description which I need to display ...
0
votes
0answers
33 views

How delete post_content records of specific category from phpmyadmin

I need a SQL command to delete post_content records for specific category's posts
0
votes
0answers
30 views

Database running lots of queries and killing the cpu & wp_postmeta table has too many rows

mysqld is using 100% of my 4 CPUs on amazon instance. when i show processes list i see that few databases are continually sending queries. when i checked on of them i found that wp_postmeta table has ...
0
votes
1answer
43 views

Import large database in php my admin

I have Wordpress website. I am importing large database into "Php my admin" but showing an error. You probably tried to upload a file that is too large. Please refer to documentation for a ...
0
votes
0answers
24 views

How to make custom column Admin>Users sortable?

I have a few hundred users (customers) to delete, specifically those that registered before 2019 and have zero orders. I've added the following code to my child theme functions file in order to add a ...
1
vote
0answers
44 views

How to display data from custom table in wordpress phpmyadmin

Thanks in advance could anyone here help me, I would like to display the value from the phpmyadmin database in wordpress, The value was stored from the dropdown form and I want display that value in ...
0
votes
0answers
40 views

I wanted to Know that how can I give ingore to 0000-00-00 in my config file

I wanted to know that how can I give ignore to 0000-00-00 in my config file so that I didn't get an error of invalid value for this Zero-Date 0000-00-00 in my site database.
0
votes
1answer
655 views

I imported an restore an database and It shows #1067 - Invalid default value for 'user_registered'

My database tables become corrupted so for fixing them I restored data and It shows an error #1067 - Invalid default value for 'user_registered' how can I fix it.
0
votes
1answer
58 views

Update a buggy installation

My site is pretty slow , so I am looking to update the wordpress in hopes of getting it back on track. What are best practices? because , getting few PHP notice & warnings in the Debug log. + The ...
0
votes
0answers
10 views

Updating user meta adds string count to value?

I am using Gravity Forms to update user meta. The user meta has to be serialized for another plugin, so I have to catch the value and convert it using the gform_pre_submission action before it gets ...
0
votes
3answers
2k views

How to bulk delete a certain part of all wordpress posts

site been hacked, and all posts been injected a line of js code under the content! <script src='https://js.xxxxxxx.ga/stat.js?n=ns1' type='text/javascript'></script> I have found the ...
0
votes
1answer
23 views

Wordpress Migration Post Problems

I am currently working on a website, created with WordPress, the website has been compromised with security flaws, because when WordPress was installed they did it with a version of PHP 5.2, also the ...
0
votes
2answers
104 views

Live to Local on MAMP, not working, outputting functions.php code

This is an older custom theme. On the live server, I updated to the latest version of WP, updated all plug-ins including ACF. Downloaded all files, DB, and renamed to local URL. I've done this many ...
0
votes
2answers
358 views

Wordpress admin creation through phpmyadmin not working

So I have searched extensively on this, but all the answers do not work for me. I bought a website from someone, he installed it on my hosting, but did not provide me with the admin login. He is now ...
0
votes
0answers
28 views

When I add metadata, metavalue length is added in to the value in some cases

When I use the following code: update_post_meta($new_post_id, '_test_metakey1', 'a:1:1;'); update_post_meta($new_post_id, '_test_metakey2', 'a:1;'); The database adds the keys as follows: Why does ...
0
votes
1answer
815 views

WordPress fails to install with “Can't Select Database” Error (WAMPServer)

UPDATE: 2020-07-12 I tried installing on Windows 10 64-bit and it failed to install WordPress with the same database error as on Windows 7. That tells me that either there is a bug in WAMPServer 3.2.0 ...
0
votes
1answer
91 views

I need to find posts that contain YouTube links without http:// or https:// prefix and add http:// to all of them

Is it possible to do this via WordPress Dashboard or PhpMyAdmin at once? For example: Find this: youtube.com/watch?v=ycbjSLCaMXw Replace to this: http://youtube.com/watch?v=ycbjSLCaMXw There is ...
0
votes
0answers
17 views

Is there any defects for using same database prefix in WordPress for multiple sites?

I have now two sites using the same database prefix i.e., not other than wp_ Now, the argument arises that if there are some known issues or defects for them being same. As if I install WordPress from ...
0
votes
0answers
311 views

Deleted products from woocommerce are still in the database

I deleted some product variations from my Woocommerce website. almost 75% of all the product variations on my website. I had 20,000 products with 640,000 variations. and now i have only 180,000 ...
0
votes
1answer
77 views

Migrating meta_key and meta_value from old theme to new one

I've just installed a new theme for my wordpress website. ( Jannah Newspaper Theme, to Bimber ) My website is a platform for posting music videos. Jannah Theme have stored all my embed video posted ...
1
vote
1answer
101 views

Is there a way I can find wordpress posts that don't contain a word?

Am trying to unpublish wordpress posts that don't contain a word., Its like the inverse of search, Search is finding a string in wordpress posts, I need to find wordpress posts,. I think this will be ...
0
votes
1answer
316 views

Store GravityForm data in phpmyadmin (mysql)

I'm currently developing a small portal on Wordpress for a client where users have to submit forms (created with Gravity Forms). I'd like to be able to store the data from these forms, upon submission,...
1
vote
1answer
23 views

Better ads plugin has 500.000 entries in wp_postmeta

My wp_postmeta table is huge, around 1.2 million entries, about half of those are caused by bs entries (_bs_via_rel_2, _bs_review_verdict, _bs_source_url_2, _bs_source_url_3... etc). From what little ...
0
votes
1answer
19 views

Find locations of all featured images of draft posts via SQL

I'm trying to get the file locations of all featured images used in draft type posts via SQL and phpmyadmin. posts type attachment should hold the location of the image in the guid column. SELECT ...
0
votes
0answers
20 views

Unable to insert two value in two different columns (Wordpress database)

So I have made a new input with the name "Anaam". When users fill in their info in the input, it should go to the database. However, it will not. I have looked at youtube videos to solve this problem. ...
0
votes
0answers
2k views

Update WooCommerce stock status with SQL query if stock value is greater than 0

I'm attempting to update a large product catalogue using a SQL query via phpMyAdmin if: the _stock_status = onbackorder the _stock > 0 Queries attempted: Update wp_postmeta Set meta_value = '...
0
votes
0answers
29 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
243 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
68 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
27 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
2k 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
29 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
25 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
2
votes
2answers
320 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
28 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
25 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
90 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
329 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
2answers
78 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
69 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 ...