Matrix site suddenly not loading, help!

Squiz Matrix Support
1

when viewing the server --> https://webtest.uarts.edu:8081/


this is all that shows up --> 


    Fatal error: Call to undefined function: quotesmart() in /applications/matrix/core/include/asset_manager.inc on line 7058



here is the error code I've been emailed all night as things went bump...

    *MySource Error*
    File : [SYSTEM_ROOT]/core/include/assertions.inc
    Line : 516
    Version : 3.8.4
    DB Type : pgsql

[ASSERT EXCEPTION] DB Error: unknown error
SELECT l.url, l.assetid
                                FROM sq_ast_lookup l
                                 WHERE l.url  = 'webtest.uarts.edu:8081/Campus_Resources' AND l.https = 1
                                ORDER BY LENGTH(l.url) DESC LIMIT 1, 0 [nativecode=ERROR:  LIMIT #,# syntax is not supported
HINT:  Use separate LIMIT and OFFSET clauses.
] (LINE 5894 IN [SYSTEM_ROOT]/core/include/asset_manager.inc) [SYS0270]
------------------------------------------------------------------
*Root Urls*
webtest.uarts.edu:8081
------------------------------------------------------------------
*Current URL*
https://webtest.uarts.edu:8081//Campus_Resources
------------------------------------------------------------------
*Back Trace*
0 => array (
        "function" => "sq_error_handler",
        "args" => array (
                0 => 256,
 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1 => "[ASSERT EXCEPTION] DB Error: unknown error<br/>SELECT l.url, l.assetid\n\t\t\t\tFROM sq_ast_lookup l\n\t\t\t\t WHERE l.url &nbsp;= \'webtest.uarts.edu:8081/Campus_Resources\' AND l.https = 1\n\t\t\t\tORDER BY LENGTH(l.url) DESC LIMIT 1, 0 [nativecode=ERROR: &nbsp;LIMIT #,# syntax is not supported\nHINT: &nbsp;Use separate LIMIT and OFFSET clauses.\n] (LINE 5894 IN [SYSTEM_ROOT]/core/include/asset_manager.inc) [SYS0270]",
 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2 => "[SYSTEM_ROOT]/core/include/locale_manager.inc",
 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3 => 512,
 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;4 => array (
 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;[Max Depth Reached]
 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;)
 &nbsp; &nbsp; &nbsp; &nbsp;)
),
1 => array (
 &nbsp; &nbsp; &nbsp; &nbsp;"file" => "[SYSTEM_ROOT]/core/include/locale_manager.inc",
 &nbsp; &nbsp; &nbsp; &nbsp;"line" => 512,
 &nbsp; &nbsp; &nbsp; &nbsp;"function" => "trigger_error",
 &nbsp; &nbsp; &nbsp; &nbsp;"args" => array (
 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0 => "[ASSERT EXCEPTION] DB Error: unknown error<br/>SELECT l.url, l.assetid\n\t\t\t\tFROM sq_ast_lookup l\n\t\t\t\t WHERE l.url &nbsp;= \'webtest.uarts.edu:8081/Campus_Resources\' AND l.https = 1\n\t\t\t\tORDER BY LENGTH(l.url) DESC LIMIT 1, 0 [nativecode=ERROR: &nbsp;LIMIT #,# syntax is not supported\nHINT: &nbsp;Use separate LIMIT and OFFSET clauses.\n] (LINE 5894 IN [SYSTEM_ROOT]/core/include/asset_manager.inc) [SYS0270]",
 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1 => 256
 &nbsp; &nbsp; &nbsp; &nbsp;)
),
2 => array (
 &nbsp; &nbsp; &nbsp; &nbsp;"file" => "[SYSTEM_ROOT]/core/include/general.inc",
 &nbsp; &nbsp; &nbsp; &nbsp;"line" => 958,
 &nbsp; &nbsp; &nbsp; &nbsp;"function" => "raiseerror",
 &nbsp; &nbsp; &nbsp; &nbsp;"class" => "locale_manager",
 &nbsp; &nbsp; &nbsp; &nbsp;"type" => "->",
 &nbsp; &nbsp; &nbsp; &nbsp;"args" => array (
 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0 => "SYS0270",
 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1 => 256,
 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2 => array (
 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;[Max Depth Reached]
 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;)
 &nbsp; &nbsp; &nbsp; &nbsp;)
),
3 => array (
 &nbsp; &nbsp; &nbsp; &nbsp;"file" => "[SYSTEM_ROOT]/core/include/assertions.inc",
 &nbsp; &nbsp; &nbsp; &nbsp;"line" => 516,
 &nbsp; &nbsp; &nbsp; &nbsp;"function" => "trigger_localised_error",
 &nbsp; &nbsp; &nbsp; &nbsp;"args" => array (
 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0 => "SYS0270",
 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1 => 256,
 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2 => "DB Error: unknown error<br/>SELECT l.url, l.assetid\n\t\t\t\tFROM sq_ast_lookup l\n\t\t\t\t WHERE l.url &nbsp;= \'webtest.uarts.edu:8081/Campus_Resources\' AND l.https = 1\n\t\t\t\tORDER BY LENGTH(l.url) DESC LIMIT 1, 0 [nativecode=ERROR: &nbsp;LIMIT #,# syntax is not supported\nHINT: &nbsp;Use separate LIMIT and OFFSET clauses.\n]",
 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3 => 5894,
 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;4 => "[SYSTEM_ROOT]/core/include/asset_manager.inc"
 &nbsp; &nbsp; &nbsp; &nbsp;)
),
4 => array (
 &nbsp; &nbsp; &nbsp; &nbsp;"file" => "[SYSTEM_ROOT]/core/include/assertions.inc",
 &nbsp; &nbsp; &nbsp; &nbsp;"line" => 429,
 &nbsp; &nbsp; &nbsp; &nbsp;"function" => "trigger_exception",
 &nbsp; &nbsp; &nbsp; &nbsp;"args" => array (
 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0 => "DB Error: unknown error<br/>SELECT l.url, l.assetid\n\t\t\t\tFROM sq_ast_lookup l\n\t\t\t\t WHERE l.url &nbsp;= \'webtest.uarts.edu:8081/Campus_Resources\' AND l.https = 1\n\t\t\t\tORDER BY LENGTH(l.url) DESC LIMIT 1, 0 [nativecode=ERROR: &nbsp;LIMIT #,# syntax is not supported\nHINT: &nbsp;Use separate LIMIT and OFFSET clauses.\n]",
 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1 => ,
 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2 => 1
 &nbsp; &nbsp; &nbsp; &nbsp;)
),
5 => array (
 &nbsp; &nbsp; &nbsp; &nbsp;"file" => "[SYSTEM_ROOT]/core/include/asset_manager.inc",
 &nbsp; &nbsp; &nbsp; &nbsp;"line" => 5894,
 &nbsp; &nbsp; &nbsp; &nbsp;"function" => "assert_valid_db_result",
 &nbsp; &nbsp; &nbsp; &nbsp;"args" => array (
 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0 => new db_error Object (
 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;[Max Depth Reached]
 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;)
 &nbsp; &nbsp; &nbsp; &nbsp;)
),
6 => array (
 &nbsp; &nbsp; &nbsp; &nbsp;"file" => "[SYSTEM_ROOT]/core/include/mysource.inc",
 &nbsp; &nbsp; &nbsp; &nbsp;"line" => 358,
 &nbsp; &nbsp; &nbsp; &nbsp;"function" => "getassetfromurl",
 &nbsp; &nbsp; &nbsp; &nbsp;"class" => "asset_manager",
 &nbsp; &nbsp; &nbsp; &nbsp;"type" => "->",
 &nbsp; &nbsp; &nbsp; &nbsp;"args" => array (
 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0 => "https",
 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1 => ,
 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2 => 1,
 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3 => 1
 &nbsp; &nbsp; &nbsp; &nbsp;)
),
7 => array (
 &nbsp; &nbsp; &nbsp; &nbsp;"file" => "[SYSTEM_ROOT]/core/web/index.php",
 &nbsp; &nbsp; &nbsp; &nbsp;"line" => 38,
 &nbsp; &nbsp; &nbsp; &nbsp;"function" => "start",
 &nbsp; &nbsp; &nbsp; &nbsp;"class" => "mysource",
 &nbsp; &nbsp; &nbsp; &nbsp;"type" => "->",
 &nbsp; &nbsp; &nbsp; &nbsp;"args" => array (
 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;[Empty]
 &nbsp; &nbsp; &nbsp; &nbsp;)
)</pre><br />




This is a production server, and I've never seen anything like this before with Matrix.



I've attempted to simply restart apache, but that didn't do it.

I also restarted postgresql and that didn't help either.



Any and all help is appreciated.
2

I ran the SQL query

    SELECT l.url, l.assetid
    FROM sq_ast_lookup l
    WHERE l.url  = 'webtest.uarts.edu:8081/Campus_Resources' AND l.https = 1
    ORDER BY LENGTH(l.url) DESC LIMIT 1, 0;


that matrix appears to be trying to run, and received the same error.

I'm confused, because obviously this is the same code that matrix has always been running.

Thoughts?
3

if I run the query by hand…

    ELECT l.url, l.assetid
    FROM sq_ast_lookup l
    WHERE l.url  = 'webtest.uarts.edu:8081/Campus_Resources' AND l.https = 1
    ORDER BY LENGTH(l.url) DESC LIMIT 1;


Notice: I removed the ',0' after the "LIMIT 1" from the broken query, it appears to get what is wanted.

url webtest.uarts.edu:8081/Campus_Resources
assetid 41

1 rows fetched (0.23 sec)


The code has decided to start putting a ',0' in to its sql queries?

which is returning a PSQL syntax error?

but why all of a sudden, when no one was using the system, or any changed were being made?
4

sigh
redhat network updated a security patch for php last night, which I guess nuked pear… so I updated all the pear packages… and it looks like it fixed the problem…



I think.

I am now seeing 


     PHP Notice
    Undefined offset: 624
    
    
    PHP Notice
    Undefined offset: 544


I'll make a new ticket for that though.
thank you for reading the posts above at the least :)
5

Yes, the first error occurs when Red Hat (incorrectly) downgrades the PEAR DB package.


The second error usually happens when you have links on one page pointing to assets that no longer exist in the system (i.e. have been purged from the trash). You should run a Links Report to see if this is the case.

6

I had restored an old version of the database to see if that helped before I figured out the PEAR package upgrade path… I restored the current DB, and everything worked.


Thank you!