MySQL parsing error in phpMyAdmin ("This type of clause was previously parsed")

I have the following SQL query:

SELECT SUM(tmp.mval), tmp.timekey FROM
(SELECT teghamas, 
        MAX(arzheq) as mval, 
        ceil(UNIX_TIMESTAMP(zhamanak)/(60 * 60)) AS timekey
   FROM `masnakcutyun`
   LEFT JOIN teghkentron ON `masnakcutyun`.`teghKentronId`=`teghkentron`.`teghKentronId` 
  WHERE teghkentron.hamaynq="London" group by timekey, teghkentron.teghamas)         
AS tmp
GROUP BY tmp.timekey

It works fine in phpMyAdmin. But there's a warning there saying:

"This type of clause was previously parsed (near select)".

Can you guess what is the problem? The query can execute and return the expected results.

It seems to be a phpMyAdmin parser bug, see the issue on github, the query itself is valid.

parse error opening phpMyAdmin, Hello all, When trying to open phpMyAdmin on one of our cPanel servers, we get the I'm still getting the same parse error on line 47. Also ran /scripts/mysql just to see if it would fix anything, and restarted SQL service. When executing this query PhpMyAdmin throws me the following error: MySQL said: Documentation 1064 - Something is wrong in your syntax near 'cte ( SELECT category, ndeporte, gender, team1, score1, team3, score3 FROM sco 'on line 2. It should be noted that this stored procedure when I execute it in MYSQL 8 is executed perfectly.

MySQL allow write subquery in from clause, but this is know issue, you can create view and use it :

CREATE VIEW viewname AS (SELECT teghamas, 
    MAX(arzheq) as mval, 
    ceil(UNIX_TIMESTAMP(zhamanak)/(60 * 60)) AS timekey
    FROM `masnakcutyun`
    LEFT JOIN teghkentron ON `masnakcutyun`.`teghKentronId`=`teghkentron`.`teghKentronId` 
    WHERE teghkentron.hamaynq="London" group by timekey, teghkentron.teghamas) ;

SELECT SUM(mval) as MySum, timekey 
FROM viewname
GROUP BY timekey

4.5.5, issue #11959 Fix javascript error in setup - issue #11964 Undefined index: MySQL error messages - issue #11792 Undefined index: parameters - issue Full path disclosure vulnerability in SQL parser, see PMASA-2016-8  MYSQL and PHPMYADMIN Error Helpful? Please support me on Patreon: https://www.patreon.com/roelvandepaar With thanks & praise to God, and with thanks to the m

I've got the same error message, in my case I just had few UPDATE clause without a semicolon to end.

UPDATE `table` SET `column`='val2' WHERE `id`=1 **;**
UPDATE `table` SET `column`='val2' WHERE `id`=2

FAQ, 2.3 The error message “Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111) …” is displayed. What​  phpMyAdmin error code 200 – Reasons & Solutions Usually, this error may disappear once the customer restart the MySQL service or the whole server. But, this is not permanent. The same error can occur again at any point of time.

Parse error using subquery in from list · Issue #12080 · phpmyadmin , I also am getting erroneous error displays, though the query executes, PHP 7.0.7, PHPMyAdmin 4.6.2, MySQL 5.7.12-log - MySQL Community  nijel closed this in phpmyadmin/sql-parser#90 Oct 3, 2016 nijel added a commit that referenced this issue Oct 3, 2016 Update SQL parser to 3.4.9 …

parse error - accessing php admin, Parse error: syntax error, unexpected T_STRING in /home/fhlinux196/m/mrbartle.​com/user/htdocs/phpmyadmin/config.inc.php on line 8 A validating SQL lexer and parser with a focus on MySQL dialect. - phpmyadmin/sql-parser All commands are able to parse input from stdin (standard in), such as

Mastering PhpMyAdmin 3.3.x for Effective MySQL Management: A , To helpsolveaproblem, we shouldfirstpinpointthe originofthe error message. an error message: MySQL server: These messages are relayed by phpMyAdmin, server: For example, Parser error Web server: The error can be seen fromthe  I was wondering if anyone could assist me in trouble-shooting an issue I am having with MySQL and phpMyAdmin. Until recently, everything had been running flawlessly, but I updated a bunch of software this morning (openSuse 10.2), and now when I try to log into phpMyAdmin on localhost, I am hit with the following:

Comments
  • Thank you! This helped a lot.
  • It returns error: Unrecognized statement type. (near "with" at position 0)