Project

General

Profile

Actions
Copy link

Bug #18221

closed

SQL Error when Explain Queries with multiple tables

Added by Ingo Schmitt almost 17 years ago. Updated over 14 years ago.

Status:
Closed
Priority:
Should have
Assignee:
Michael Stucki
Category:
Database API (Doctrine DBAL)
Target version:
-
Start date:
2008-02-15
Due date:
% Done:

0%

Estimated time:
TYPO3 Version:
4.2
PHP Version:
5.2
Tags:
Complexity:
Is Regression:
Sprint Focus:

Description

When using the feature "explain select queries" with exec select queries with more than one table, an error is show. This is caused when in the from clause "table1, table2" is used, since the from clause is used on "show index from $fromClause"

Error Message:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'tx_commerce_products_categories_mm,tx_commerce_articles, tx_commerce_article_pri' at line 1
SHOW INDEX FROM tx_commerce_products ,tx_commerce_products_categories_mm,tx_commerce_articles, tx_commerce_article_prices

see attached patch
(issue imported from #M7545)

Files

Download all files
patch_explainselect_multitables.patch (1011 Bytes) patch_explainselect_multitables.patch Administrator Admin, 2008-02-15 19:42
class.t3lib_db.7545.patch (2.13 KB) class.t3lib_db.7545.patch Administrator Admin, 2008-02-20 23:47
Actions
Copy link

Also available in: Atom PDF