× If you expect answers you should describe your problem and give as much information's as possible. (SQL-Structure, Template Code, Joomla Version ...) Please read this before posting: joodb.feenders.de/support.html

SQL Commands/Queries in URL

More
11 years 4 months ago #2682 by stombaugh
SQL Commands/Queries in URL was created by stombaugh
Is there anyway to have the Component ignore any commands given in the URL?

For instance: {url}?format=html&orderby=convert%28varch%20ar,0x7b5d%29&Itemid=161&task=&search=search...&limit=0&ordering=&view=cata%20log&reset=false&option=com_joodb%29

or {url}?orderby=whatever

Both of those and more will show the Table name within the error. Is it possible to maybe just have the error say there was an error and not show the table name?

?format Give this warning:

Warning
Error : Unknown column 'a.convertvarchar0x7b5d' in 'order clause' SQL=SELECT a.* FROM `{tablename}` AS a GROUP BY a.`id` ORDER BY a.`convertvarchar0x7b5d` ASC LIMIT 0, 9742

Orderby gives this Warning:

Warning
Error : Unknown column 'a.whatever' in 'order clause' SQL=SELECT a.* FROM `{tablename}` AS a GROUP BY a.`id` ORDER BY a.`whatever` ASC LIMIT 0, 50

Please Log in to join the conversation.

Moderators: Dirkjoest
Powered by Kunena Forum