Zikula Community

• kakkerlakgly
  
  

  • Rank: Registered User
  • Registered: Nov 27, 2006
  • Last visit: Jan 13, 2009
  • Posts: 11

  Posted: Jan 11, 2009 - 11:32 PM

  I would like to know how i configure config/config.php in order for zikula to log all SQL statements preferably in the table zikula_sc_log_event.

  • 
  •  
• jaenosjelantru
  
  

  • Rank: Moderator
  • Registered: Mar 15, 2005
  • Last visit: May 30, 2010
  • Posts: 1077

  Posted: Jan 11, 2009 - 11:40 PM

  Better have a lot of disk space. Not sure how to do that but that thing will fill up rather quickly for a site with even decent activity.

  • 
  •  
• Simon
  
  

  • Rank: Legend
  • Registered: Dec 11, 2002
  • Last visit: Oct 21, 2009
  • Posts: 11674

  Posted: Jan 12, 2009 - 03:03 AM

  You should look into the ADOdb logging functions, if you require clever SQL debugging. However, as far as I know there is no interface in DBUtil / Zikula for this.
  
  --
  itbegins.co.uk - Zikula Consulting
  
  birtwistle.me.uk - Personal Blog
  
  
  Please read the Support Guide

  • 
  •  
• kakkerlakgly
  
  

  • Rank: Registered User
  • Registered: Nov 27, 2006
  • Last visit: Jan 13, 2009
  • Posts: 11

  Posted: Jan 13, 2009 - 01:08 AM

  I was hoping some of the settings in config.php would enable me to do just that, more precisely this part but i can't seem to get it to work:
  
  // ----------------------------------------------------------------------
  // Debugging/Tracing settings
  // ----------------------------------------------------------------------
  $PNConfig['Debug']['debug'] = 0; //
  $PNConfig['Debug']['pagerendertime'] = 0; // display page render time, 0 to disable
  $PNConfig['Debug']['sql_adodb'] = 0; // adodb debug flag, generates lots of print output
  $PNConfig['Debug']['sql_count'] = 0; // count SQL statements, 0 to disable
  $PNConfig['Debug']['sql_time'] = 0; // time SQL statements, 0 to disable
  $PNConfig['Debug']['sql_detail'] = 0; // collect executed SQL statements, 0 to disable
  $PNConfig['Debug']['sql_data'] = 0; // collect selected data, 0 to disable
  $PNConfig['Debug']['sql_user'] = 0; // user filter, 0 for all, any other number is a user-id, can also be an array

  • 
  •  
• mumuri
  
  

  • Rank: Developer
  • Registered: May 17, 2004
  • Last visit: Apr 08, 2010
  • Posts: 386

  Posted: Jan 14, 2009 - 12:09 AM

  usually this
  

  Code

  $PNConfig['Debug']['debug'] = 1; //
  $PNConfig['Debug']['sql_adodb'] = 1;

  
  
  should be enought, but i don't know if ALL the queries are displayed
  
  if you wan't a more rustic (and working) way to do it , you can simply look for "adodb-mysql.inc.php" and
  
  before
  
  

  Code

  mysql_query($sql,$this->_connectionID);

  
  
  around line 507
  
  add
  

  Code

  echo $sql."<br/>";// or any code to log the output in a different way

  
  
  
  
  edited by: mumuri, Jan 14, 2009 - 04:12 AM

  • 
  •  
•  
•  

Users on-line

• rgasch

This list is based on users active over the last 60 minutes.