Questions tagged [phpmyadmin]
phpMyAdmin is a free software tool written in PHP, intended to handle the administration of MySQL over the Web.
207 questions
0 votes
1 answer
180 views
How to return count number from a wordpress database
I have a database 'wp_db7_forms', with fields, 'form_id', 'form_post_id' and 'form_date'. I am trying to get a COUNT of the number of entries for a specific 'form_post_id'. With this sql query in ...
0 votes
1 answer
319 views
Database table prefix different between wp-config.php and in database
I'm completely updating this quesion because I've discovered new facts about the problem. My wp-config.php has the line $table_prefix = 'wp75_';. The plugin WP-Optimize also shows the tables with ...
- 177
0 votes
0 answers
120 views
is it possible to get a list of URLs from post_content directly in a mysql query via phpadmin?
We have many forms that are hosted externally from our Wordpress environment that we are moving to a different system, so we'd like to generate a list of the pages that contain these links along with ...
- 1
1 vote
0 answers
93 views
Wordpress Admin login problems- PLEASE HELP [closed]
I have just taken over a clients website to carry out future maintenance and updates. I am not sure if the previous developer left on a bad note but the thought has crossed my mind. I simply cannot ...
- 11
1 vote
1 answer
504 views
Deleting WordPress posts and media files based on author via MYSQL database
I would like to delete some of the posts in WordPress between a period based on the author via MYSQL database. I have difficulty identifying the WordPress tables and their relationships to perform the ...
- 11
0 votes
1 answer
54 views
After Import: Insert "Use" Statement in Database
In transferring a site from one host to another while retaining the same domain name, copying WP files is straight-forward, not so with sql databases. In a shared hosting environment, importing a ...
- 111
0 votes
1 answer
825 views
#1067 - Invalid default value for 'post_date' when trying to create a new column
I am trying to create a new column inside the wp_posts table but I am getting the error #1067 - Invalid default value for 'post_date' when I try and save it. What I am trying to do is, I am getting ...
- 101
0 votes
0 answers
40 views
problem solving in website loading
/*! elementor – v3.16.0 – 20-09-2023 */ .elementor-widget-image{text-align:center}.elementor-widget-image a{display:inline-block}.elemenhow tor-widget-image a img[src$=”.svg”]{width:48px}.elementor-...
0 votes
2 answers
754 views
How to set autoload from "yes" to "no" _transient_wp_core_block_css_files
In WordPress version 6.3, create a transient named "_transient_wp_core_block_css_files" (~0.4MB) in the wp_options table to store the list of CSS files to load when using WordPress' blocks. ...
- 1
0 votes
1 answer
186 views
SQL phpmyadmin remove posts from cat id exclude condition
I have a sql code for wordpress database that use for deleting posts from specific cat id for specific time duration and I always use this code and it is working fine. DELETE a, -- DELETE from ...
- 11
0 votes
1 answer
298 views
404 Error after URL update
I changed our company domain name and now all i get is a 404 error. I have updated the option table in phpmyadmin as well as updated apache2 conf. Where else do I need to change the info for this to ...
0 votes
1 answer
1k views
How to use phpspreadsheet reader with $wpdb
I am trying to import an excel file on a webpage with a submit button. As far as I can tell, the only way to do so is to use PhpSpreadsheet. How can one incorporate PhpSpreadsheet with $wpdb and ...
- 31
0 votes
0 answers
32 views
Importing data from excel sheet on webpage rather than from within phpMyAdmin
Has anyone ever been able to upload an excel sheet to phpmyadmin without doing it manually? On a webpage, I have a upload file with a submit button. Is it possible for the submit button to upload all ...
- 31
0 votes
2 answers
1k views
Cannot login to WordPress admin after update
Hello I need help please for my website. I can not enter the wordpress admin after updating the version. the hosting does not respond to me either. This is the image that informs me, a php version ...
1 vote
1 answer
2k views
PHP FATAL ERROR [closed]
My website has a PHP Fatal error: Array and string offset access syntax with curly braces is no longer supported in /var/www/vhosts/katalytes.com/httpdocs/wp-includes/script-loader.php on line 706 ...
- 11