CMS Made Simple Forums

Problem: "Admin Log" never shows any info!

PHP LOG:
    PHP Fatal error:  Call to a member function on a non-object in /usr/local/www/www.example.com/admin/adminlog.php on line 94

POSTGRES LOG:
    ERROR:  LIMIT #,# syntax is not supported
    HINT:  Use separate LIMIT and OFFSET clauses.

Looking in adminlog.php backwards from line 94, I'm guessing the SQL code that caused this was:

    $query = "SELECT * from ".cms_db_prefix()."adminlog ORDER BY timestamp DESC limit $from, $limit";
    $result = $db->Execute($query);

I'm out of my depth here! Is it possible to adjust adminlog.php to avoid using "limit" in this way?

Thanks!

- Martin

Yeah, there should be an adodb abstraction to handle this instead of directly in the sql.  I'll put it on my list.

Thanks!

This is fixed in svn....  I think.  It's using the abstraction from ADODB, so I'm assuming that it'll work properly in postgres.  I don't have it installed currently to double check, though.

Great. I'll install Subversion tonight and test it.  Can I just take adminlog.php in isolation?  I don't really want to run the whole dev release now that my site is populated

Sure.  http://svn.cmsmadesimple.org/cms/trunk/ ... minlog.php will be the latest version.

Ah, so I don't even need to install a Subversion client - great.

I've just tested that.  It works perfectly!  Very good level of admin logging there.

Now CMSMS is working perfectly with Postgres AFAICT


Many thanks! 

Excellent!  Thanks for the heads up on that bug.  There is still some non-adodb sql coe floating around that I'll never find without people testing it.

Thanks again!