how to determine where the error came from?

126 Posts

johnrobert27 Reply #1, 12 years, 1 month ago

hi guys,

I'm just wondering how do I determine which snippet has an error.

the error looks like this..

[2014-09-17 08:55:54] (ERROR @ /index.php) Error 42000 executing statement: 
Array
(
    [0] => 42000
    [1] => 1064
    [2] => 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 'GROUP BY Tblbook.system_brand_id' at line 1
)

thanks

MODX Staff
10,725 Posts

opengeek Reply #2, 12 years, 1 month ago

Well, are you using a snippet that issues a query to a table known as "Tblbook" ? That'd be the first clue to follow...

Jason Coward
Chief Architect @ MODX
http://www.jasoncoward.com | http://twitter.com/drumshaman | https://github.com/opengeek

126 Posts

johnrobert27 Reply #3, 12 years, 1 month ago

thanks for the reply

yes, I have a couple of snippet that uses the same table, but what if I use for example "Tblbook" in all of my snippet, do I need to scan all of the snippet?and every line?