I found myself in a really weird situation in PDO. A query doesn't want to execute when called from PhP but it does when called from HeidiSQL. The error is in title. SQL query from statement debugDumpParams : SELECT s_id…
Quick note, I know this question has been asked here, but the 'answer' gives an alternative which doesn't involve recursion. I want to get recursion working. Here's some code I wrote to demonstrate the problem: CREATE OR REPLACE PROCEDURE `test`…
So I have an Xampp server with phpmyadmin and I usered this command, which always worked: WITH temptable AS (SELECT *, ROW_NUMBER() OVER (ORDER BY character_ID DESC) AS t FROM characters) SELECT * FROM temptable WHERE t BETWEEN 0 AND…
I want to order the posts by 2 custom fields in the same call. How is this possible? This next code order successfully, but only by only 1 NUMBER custom field (not STRING): add_action('pre_get_posts', function ($q) { if ( !is_admin()…
Well, I'm trying to locate the log file to check errors in phpmyadmin interface and I saw in posts and forums that phpmyadmin have a binary log tab to check it, but I don't have enabled that tab and the…
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…
I try to count how many products were sold each week from Friday to Friday. I try to use meta_key total_sales, but it shows the total amount of products sold. I want to create a report that shows what products…
hi i need to disable strict mode in mariadb even adding via my.cnf but its not working i did the following SET sql_mode = ''; SET GLOBAL sql_mode = ''; output and then i restared mariadb +---------------+-------+ | Variable_name |…
I´m working on a Wordpress plugin and for a strange reason, I save correctly strings in the database with the char € but to display it, even if I don´t use the wordpress way with $wpdb but like this (…
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…