Need count with group by – Phpmyadmin
I have attached order table, Please find below. I need a count value 4, can you help me make a SQL query Note : status = 1 and order_id should count only one time if order_id available with more than…
Laravel 7X admin/login loops back to admin/login despite correct credentials – Phpmyadmin
I am working on a Laravel admin panel that loops back to admin panel when i input the crenditials. The goal is to navigate to th edashboard. Laravel vrsion is 7x. I am working on it from the localhost/xampp. I…
MySQL – just adding ORDER BY an indexed field adds 5 minutes for just 52 records. Where to start? – Phpmyadmin
EDIT 2: now that we have optimized the db and narrowed down in MySQL - Why is phpMyAdmin extremely slow with this query that is super fast in php/mysqli? EDIT 1: there are two solutions that helped us. One on…
PHPMyAdmin Configuration not working because of MySQL user password? – Debian
Hello stackoverflow-community! When I try to install and afterwards configure my phpmyadmin on my debian server I always get this error-message. ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL…
phpmyadmin on raspbian busetr cannot log in
Latest Raspbian Buster fresh install on Pi 3B Apache2 installed and working PHP 7.3 installed and Working MariaDB 10.3.22 installed and working PHPMyAdmin installed and appears to work database mysql table user shows 2 users for localhost, root with no…
Remote MySQL Query using Node.js mysql Module – CPanel
I am trying to query a database on my website's hosting service (HostWinds). However, when I run the following code nothing happens. No error, no console logs, nothing. I have MySQL installed, and I'm using the same username and password…
selecting records based on datetime column changes the data in the datetime column ..very strange – Phpmyadmin
So i have a table that has multiple date time columns and i am trying to select certain records based on a certain date using SELECT * FROM `posdata` WHERE `CommissionDate` >= '2019-01-01 00:00:00' the table structure CREATE TABLE `posdata`…
Query WordPress Posts Using Wp-Posts and Wp-Terms – Phpmyadmin
I'm trying to query all posts from my Wordpress site that have wp_terms.slug = 'portfolio-photos'. I've connected the tables using wp_terms, wp_term_taxonomy, wp_term_relationships and wp_posts. I'm not sure what's wrong with the SQL code I have. Can someone advise what's…
phpmyadmin : Depends: php-twig (>= 2.9) but 2.6.2-2 is to be installed. WHAT? – Debian
I need help figuring out what's wrong. I want to install phpmyadmin on a server to import a wordpress DB but when I install it I have a problem with php-twig I install phpmyadmin : debian@XXX:~$ sudo apt-get install phpmyadmin…
SQL LEFT JOIN is not filling a column with values from table 2 – Phpmyadmin
SELECT zmogaus_id, hobio_id, hobio_pav2 FROM zmogaus_hobiai LEFT JOIN hobiai ON zmogaus_hobiai.hobio_pav2=hobiai.hobio_pav WHERE zmogaus_id=3 Using this I want to get zomgaus_id =3 . hobio_id =1 . hobio_pav2 =name1 (from hobio_pav) zomgaus_id =3 . hobio_id =2 . hobio_pav2 =name2 (from hobio_pav) But…