DAL Errors

Squiz Matrix Support
1

Since our upgrade, we have been getting this strange error in our error logs. It does not seem to be affecting anything, but I really don't know when or why it is happening.

    Raw Entry:	[31-Dec-2008 10:49:02] PHP Fatal error: Uncaught exception 'DALException' with message 'SQLSTATE[42601]: Syntax error: 7 ERROR: syntax error at or near "s" at character 635' in /home/websites/puc_matrix_3-16-2/core/lib/DAL/DAL.inc:774
    Raw Entry:	Stack trace:
    Raw Entry:	#0 /home/websites/puc_matrix_3-16-2/core/lib/DAL/DAL.inc(983): DAL::executePdoGroupedAssoc(Object(PDOStatement))
    Raw Entry:	#1 /home/websites/puc_matrix_3-16-2/core/include/asset_manager.inc(7762): DAL::executeSqlGroupedAssoc('SELECT l.asseti...')
    Raw Entry:	#2 /home/websites/puc_matrix_3-16-2/core/include/asset.inc(4453): Asset_Manager->getAssetURL('46', NULL, false)
    Raw Entry:	#3 /home/websites/puc_matrix_3-16-2/core/assets/site/site.inc(754): Asset->getURL()
    Raw Entry:	#4 /home/websites/puc_matrix_3-16-2/core/include/mysource.inc(2927): Site->paintAsset(Object(Page_Standard))
    Raw Entry:	#5 /home/websites/puc_matrix_3-16-2/core/include/mysource.inc(438): MySource->_paintNotFoundAsset(Object(Page_Standard), Object(Site))
    Raw Entry:	#6 /home/websites/puc_matrix_3-16-2/core/web/index.php(30): MySource->start()
    Raw Entry:	#7 {main}
    Raw Entry:	 thrown in /home/websites/puc_matrix_3-16-2/core/lib/DAL/DAL.inc on line 774


Any ideas on what this might be?
2

It's hard to tell without seeing the query. Can you log query errors in PostgreSQL for a few hours and see if it gives you the query there.

3

Ok, I ran log_min_error_statement (ERROR) in psql, is this what you meant?
4

Yeah, that's what I meant.



You might want to try getting into the command line interface and running a dodgy query to make sure it is logging.

5

Ok, I am back to this…


We got the same error this morning, and when checking the postgres log at that time, we only get:


    2009-02-12 07:24:43 PST puc_matrix_3-16-2 matrix_web :: ERROR:  syntax error at or near "s" at character 635


Which is not very helpful. It seems to be logging errors correctly, as I tried a query that failed and it logged it...any other ideas?
6

[quote]Ok, I am back to this…


We got the same error this morning, and when checking the postgres log at that time, we only get:


    2009-02-12 07:24:43 PST puc_matrix_3-16-2 matrix_web :: ERROR:  syntax error at or near "s" at character 635


Which is not very helpful. It seems to be logging errors correctly, as I tried a query that failed and it logged it...any other ideas?[/quote]
From the original backtrace it looks like the query being run is related to retrieving the URLs for asset #46.
The error seems to be triggered when this asset is painted.
7

[quote]From the original backtrace it looks like the query being run is related to retrieving the URLs for asset #46.
The error seems to be triggered when this asset is painted.[/quote]



Asset #46 is the site asset for Pacific Union College. Could this be coming from asset listing that have dynamic parameters, and the root node set to the site asset #46?

8

That's a good suggestion, however looking again at the backtrace I have noticed that it seems to be starting to paint the "Not Found" page for this Site:

    MySource->_paintNotFoundAsset...

Perhaps entering an invalid URL with a prefix that matches one of site's URLs will cause this query to be triggered.