Questions tagged [phpmyadmin]

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

59 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
2
votes
2answers
126 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 ...
2
votes
0answers
167 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 ...
2
votes
2answers
2k views

Gaining Login Access via the Database

I have been given a job to amend a Wordpress site. I have only been given access to Cpanel. My questions are can i log in to the back end of Wordpress via Cpanel? If you can't login via Cpanel can i ...
1
vote
1answer
72 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 ...
1
vote
0answers
121 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 ...
1
vote
1answer
796 views

Adding user data to an existing user_id

I'm using phpMyAdmin to add some new user records to the existing users within a WordPress database. The database is for a WordPress Multisite network. I had to migrate my old WP site to the new site,...
1
vote
0answers
14 views

import posts with dutch/special letters

I am importing posts from a csv file using the plugin Really Simple CSV Importer. I am uploading some posts in dutch language. The plugin uploads all the posts nicely but fails for the post which has ...
1
vote
1answer
29 views

Will changing the folder name two directories above a fresh wordpress installation break the site?

I have a client who would like two Wordpress installs on his LAMP stack. The thing is he forgot to give me the directory names that he wants them on. So as per standard LAMP stack each site will be /...
1
vote
1answer
28 views

Backing up and restoring multiple sites efficiently

We are offering complete website backup and restore services once per month to our clients. 90% of the sites are WordPress but hosted in a variety of hosting facilities with varying access (some ...
1
vote
0answers
94 views

MySql query to get posts with all meta and terms

I'm trying to figureout a way to get all fields from wp_post with all of their custom fields and categories in one mysql query. So in one row of the result I should have post fields with their custom ...
1
vote
0answers
56 views

Restose content from revisions - sql query

How i can restore all posts to the closest revision to a particular date via sql query?
1
vote
1answer
308 views

$wpdb to insert html form information

I'm trying to insert posted variables from a form. When I shorten the amount of variables I'm inserting it will sometime pass the information in my mysql database. Once I continue to add on ...
1
vote
0answers
849 views

Set Display Name to first and last name (phpmyadmin SQL Query)

I'm trying to change all the users Display Names to be their first and last name. I have looked into a number of plugins and wrote my own PHP to try and accomplish this however the site has over 50,...
1
vote
2answers
80 views

Better way to migrate to server?

Migrating between local and server with Wordpress (SQL) is a bit time consuming, and I'm wondering if there is a better way to do it. With Drupal, there is a module called BackUp&Migrate, which ...
0
votes
0answers
15 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
55 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
30 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
16 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
0answers
29 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
29 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
20 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
25 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.
0
votes
0answers
21 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
19 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
54 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. ...
0
votes
0answers
27 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
0answers
61 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
26 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
1answer
19 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
16 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
80 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
2answers
180 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 ...
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
229 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 ...
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
280 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 ...
0
votes
0answers
392 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
139 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
0answers
202 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 ...
0
votes
1answer
215 views

403 Forbidden Localhost Wamp Apache Php

I’m completely new to wordpress/website design and I’m following a tutorial on youtube about creating custom themes. I’ve set up a website in localhost and I’m using permalinks to navigate to pages in ...
0
votes
1answer
373 views

How to retrieve user data based on role using SQL?

I need to retrieve user data from SQL database and I have managed to do it with the SQL code given below: SELECT wpu6_users.display_name AS n_user_display_name, t1.meta_value AS ...
0
votes
1answer
302 views

I can not access my local PhpMyAdmin control panel

I have created a local WordPress (WP) website on my computer using the limited edition of DesktopServer. I then used FileZilla to download the WP files along with the associated database. Now I cannot ...
0
votes
1answer
552 views

Changing Wordpress author name in database

I originally begun my wordpress site using a psudonym. Over the past few years I have been attributing my own name to all articles and have had the author name options switched off. Now I'm changing ...
0
votes
1answer
209 views

Wordpress character set issue

I'm currently migrating a wordpress site to a live server. When trying to import my database via phpMyAdmin I run across the following error below: Error CREATE TABLE `wp_commentmeta` ( `...
0
votes
1answer
89 views

Error while submitting form using AJAX and php

Hii i am trying to save data of form to user meta data table by using javascript, AJAX and php. Here is my code HTML Form: <form id="savem" method="post"> <input type="text" name="...
0
votes
1answer
607 views

Missing latest posts and options after DB migration via phpMyAdmin

The latest posts and options are not appearing after importing the database. I'm missing all the latest posts and the latest Advanced Custom Fields. The export is from the remote server and import to ...
0
votes
1answer
108 views

wp_login.php redirects to old domain

i changed my domain name associated with my hosting account yesterday when i click on http://mynewdomain.com/wp_login.php it redirects to http://myolddomain.com i already changed the siteurl in ...