Too many SQL queries, why?

For questions and problems with the CMS core. This board is NOT for any 3rd party modules, addons, PHP scripts or anything NOT distributed with the CMS made simple package itself.
JeremyBASS

Too many SQL queries, why?

Post by JeremyBASS »

I was tring to lower this by following all the sugguestion that i've been finding in here, yet i have not gotten it that much better from where is was...  I was wondering if someone could lend a hand on this... I can't cut out the style sheets they need to be editable in the CMS as it is... um... after that I don't know how else to cut back...  an ideas would be great... thanks

Stats:
CMS v 1.2.3
php4
mysql5

Where it is at
first load

refresh



the template

Code: Select all

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<__html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
{* Change lang="en" to the language of your site *}
{metadata}
{* Don't remove this! Metadata is entered in Site Admin/Global settings. *}
{style_switcher action="css_head" template="business_design"}
{stylesheet}
{* This is how all the stylesheets attached to this template are linked to *}
{cms_selflink dir="start" rellink=1}
{cms_selflink dir="prev" rellink=1}
{cms_selflink dir="next" rellink=1}


<head>
<title>{sitename} - {title}</title>
{* The sitename is changed in Site Admin/Global settings. {title} is the name of each page *}
{* Relational links for interconnections between pages, good for accessibility and Search Engine Optmization *}
<!--[if IE]>
<__script__ type="text/javascript" src="modules/MenuManager/CSSMenu.js"></__script>
<![endif]-->

</head>
</__body>
<table id="maintable" cellspacing="0" cellpadding="0">
  <tr>
    <td id="leftGRD"></td>
    <td id="pagewrapper">
<div id="pagewrapper2">
    {* start accessibility skip links *}
    <ul class="accessibility">
      <li>{anchor anchor='menu_vert' title='Skip to navigation' accesskey='n' text='Skip to navigation'}</li>
      <li>{anchor anchor='main' title='Skip to content' accesskey='s' text='Skip to content'}</li>
    </ul>
    {* end accessibility skip links *}

    <hr class="accessibility" />
    {* Horizontal ruler that is hidden for visual browsers by CSS *}

   {* Start Header, with logo image that links to the default start page. Logo image is changed in the stylesheet  "For template: Left menu + 1 column" *}
   <div id="header">
           <h1>{cms_selflink dir="start" text="$sitename"}</h1>
   <hr class="accessibility" />
   </div>
   {* End Header *}

<div id="midHeader" style="z-index: -1000">
  <div id="hideMe4" style="
	z-index: -1000;
	display: '';
"><__script__ type="text/javascript">
AC_FL_RunContent( 'codebase', 'https://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=8,0,0,0','width','775','height','197','title','Header','src','/Core_images/elements/Test resize','quality','high','pluginspage', 'https://www.macromedia.com/go/getflashplayer','movie','/Core_images/elements/Test resize' );
 //end AC code
</__script><noscript><object type="application/x-shockwave-flash"
data="c.swf?path=/Core_images/elements/Test resize.swf" 
width="775" height="197">
<param name="movie" 
value="c.swf?path=/Core_images/elements/Test resize.swf" />
</object></noscript></div> 
</div>
   {* Start Search *}
   <div id="search">
          {search}
   </div>
   {* End Search *}

   {* Start Breadcrumbs *}
   <div class="breadcrumbs">
        {breadcrumbs starttext='You are here' root='Home' delimiter='»'}
   <hr class="accessibility" />
   </div>
   {* End Breadcrumbs *}

   {* Start Content (Navigation and Content columns) *}
   <div id="content">
      {* Start Sidebar *}
      <div id="sidebar">
      {* Start Navigation *}
      <div id="menu_vert">
{cms_module module='menumanager' template='tempCSS'}
         <h2 class="accessibility">Navigation</h2>
      </div>
      {* End Navigation *}
      {* Start News *}
      <div id="news">
         <h2>News</h2>
          {news number='1' detailpage='news'}
      </div>


<div style="text-align:left;" >

<a href="../pacs.html" onclick="return popup(this,'bigwindow')" ><img border="0" width="204" src="../pacs.png" height="38" alt="PACS Link"/></a>
</div>
<div style="text-align:right;" >
<br/><br/>
<a target="_self" href="/St_Joe_Core/services/CHERC/"><img border="0" width="180" src="/St_Joe_Core/images/cherc_DB_flat.gif" alt="Community Health Education Resource Center" height="63" /></a>
<br/>
<br/>
<a target="_self" href="/St_Joe_Core/foundation/" onmousedown="javascript:toggleDiv('hideMe3')"><img border="0" width="180" src="/St_Joe_Core/images/logo_foundation.gif" alt="St. Joseph Regional Medical Center Foundation" height="50" /></a>
<br/>
<a target="_blank" href="http://www.ascensionhealth.org/"><img border="0" width="160" src="../images/logo_ascension_health.gif" alt="Ascension Health" height="73" /></a>
<br/><br/>
</div>



      {* End News *}
      </div>
      {* End Sidebar *}
      {* Start Content Area *}
      <div id="main">
         <div style="float: right;">
{print showbutton=true script=true}</div>
         <h2>{title}</h2> 
         {content} <br />
         {* Start relational links *}
	 <div class="hr"><table width="100%" border="0" cellspacing="0" cellpadding="0" summary="Qiuck Contact List">
  <tr>
    <td align="right"><span style="color:#00194d;font-weight: bold;"><a href="about-st-joseph/contact-st-joseph/" target="_self" onMouseDown="javascript:toggleDiv('hideMe3')">Contact Us</a> • <a href="find-a-doctor/" target="_self" onMouseDown="javascript:toggleDiv('hideMe3')">Find A Doctor</a> • <a href="services/CHERC/" target="_self" onMouseDown="javascript:toggleDiv('hideMe3')">Join A Class</a></span></td>
  </tr>
</table></div>

         <div>
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td width="9px"><img src="images/Aceess_Link_left.gif" width="9" height="51" alt=" "></td>
    <td class="AccessLink"><span class="AccessLinktitle" >Accessibility  links</span><br/><span class="AccessLinks" >{cms_selflink dir="previous" label="Previous page: "}<br/> 
{cms_selflink dir="next"}</span>
</td>
    <td width="41px"><img src="images/Aceess_Link_right.gif" width="41" height="51" alt=" "></td>
  </tr>
</table>

         </div>
         {* The label parameter doesn't need to be there if you're using English, but is here to show how it's used if you don't want the English text "Previous page" *}
	 {* End relational links *}

      <hr class="accessibility" />
      </div>
	  {* End Content Area *}

   </div>
   {* End Content *}

   {* Start Footer. Edit the footer in the Global Content Block called "footer" *}
   <div id="footer">

<br/>This site was Created by <a href="http://digitalbarn.tv/"><font color="#ffffff"><font color="#ff0000">d</font>igital <font color="#ff0000">b</font>arn productions</font></a><br/>
Managed by {emailPROTECT mailbox="dbjeremy" domain="cableone.net" name="Jeremy Bass" subject="From St joe" color="color:#ffffff"}<br/><br/>



   </div> 

   {* End Footer  *}

</div>
{* end pagewrapper *}</td>
    <td id="rightGRD">
{if $ccuser->loggedin() && $ccuser->memberof('Staff')}
<br /><br /><br /><__script__ type="text/javascript">    AC_FL_RunContent('codebase', 'https://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=8,0,0,0','width','188','height','350','id','video_player','align','middle','src','/Core_images/elements/Flash/video_player','quality','best','wmode','transparent','bgcolor','#ffffff','name','video_player','allowscriptaccess','sameDomain','pluginspage', 'https://www.macromedia.com/go/getflashplayer','movie','/Core_images/elements/Flash/video_player' );
 //end AC code</script><noscript></noscript>
{else}

{/if}

</td>
  </tr>
</table>
<div id="hideMe3" style="
display: none;
position: fixed;
bottom: 0;
left: 0;
z-index: 100;
">

<__script__ type="text/javascript"> 
AC_FL_RunContent( 'codebase', 'https://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=8,0,0,0','width','362','height','35','title','Header','src','/Core_images/elements/Flash/pageLoading','wmode', 'transparent','quality','high','pluginspage', 'https://www.macromedia.com/go/getflashplayer','movie','/Core_images/elements/Flash/pageLoading' ); 
//end AC code
</__script><noscript><object type="application/x-shockwave-flash"
data="c.swf?path=/Core_images/elements/Flash/pageLoading.swf" 
width="362" height="35">
<param name="wmode" value="transparent" />
<param name="movie" 
value="c.swf?path=/Core_images/elements/Flash/pageLoading.swf" />
</object></noscript></div> 
<__body>
</__html>
Last edited by JeremyBASS on Tue May 06, 2008 7:36 pm, edited 1 time in total.
JeremyBASS

Re: Too many SQL queries, why?

Post by JeremyBASS »

Here is that output... in the text file

Here is the link
https://www.sjrmc.org/St_Joe_Core/test_area/
Attachments

[The extension txt has been deactivated and can no longer be displayed.]

JeremyBASS

Re: Too many SQL queries, why?

Post by JeremyBASS »

Ok then so i took out the stylesheets and hard coded them in to test... and the queries only went down 2... why is there so many, there has to be a way to cut that down... or cut down the prase time ... um something... heck i don't understand why i'm geting the album css when i'm not even viewing that... I'm thinking at that are many un-needed call to the DB...  please any ideas would be great.. thanks....
Last edited by JeremyBASS on Tue May 06, 2008 7:39 pm, edited 1 time in total.
Wiedmann
Forum Members
Forum Members
Posts: 233
Joined: Wed Mar 26, 2008 1:49 am

Re: Too many SQL queries, why?

Post by Wiedmann »

I'm thinking at that are many un-needed call to the DB
IMHO you are right...

Maybe this can help you too:
http://dev.cmsmadesimple.org/tracker/in ... 6&atid=103
JeremyBASS

Re: Too many SQL queries, why?

Post by JeremyBASS »

:)What do i do what that?
User avatar
Dr.CSS
Moderator
Moderator
Posts: 12711
Joined: Thu Mar 09, 2006 5:32 am

Re: Too many SQL queries, why?

Post by Dr.CSS »

How many modules do you have installed that you don't use, sometimes it queries all the modules whether they are used or not...

Deleting unused modules may help...
calguy1000
Support Guru
Support Guru
Posts: 8169
Joined: Tue Oct 19, 2004 6:44 pm

Re: Too many SQL queries, why?

Post by calguy1000 »

I've fixed a problem with the cms_selflink tag that resulted in an abnormally large number of queries
Follow me on twitter
Please post system information from "Extensions >> System Information" (there is a bbcode option) on all posts asking for assistance.
--------------------
If you can't bother explaining your problem well, you shouldn't expect much in the way of assistance.
User avatar
Dr.CSS
Moderator
Moderator
Posts: 12711
Joined: Thu Mar 09, 2006 5:32 am

Re: Too many SQL queries, why?

Post by Dr.CSS »

Is it available in the forge?...
JeremyBASS

Re: Too many SQL queries, why?

Post by JeremyBASS »

@calguy1000 ... So what it the fix for that?  Is it something I have to do or download?

@mark ... well I have a lot installed but the only queries that I see that are being done when the mod is not in use is the album... any ideas on how to get that one to stop?

Thank you two for the help... hope your weekend was swell... and have a great day.

jeremyBass
calguy1000
Support Guru
Support Guru
Posts: 8169
Joined: Tue Oct 19, 2004 6:44 pm

Re: Too many SQL queries, why?

Post by calguy1000 »

the cms_sefllink plugin is committed to SVN and will be out with 1.3

if you're in a hurry you can download the file from svn.
Follow me on twitter
Please post system information from "Extensions >> System Information" (there is a bbcode option) on all posts asking for assistance.
--------------------
If you can't bother explaining your problem well, you shouldn't expect much in the way of assistance.
JeremyBASS

Re: Too many SQL queries, why?

Post by JeremyBASS »

if you're in a hurry you can download the file from svn.
Well is it not always the client that is in the hurry lol... is there in risk of problem if I down load it from the svn?  I have not looking at it and don't know of the top of my head... thanks again calguy :)
Wiedmann
Forum Members
Forum Members
Posts: 233
Joined: Wed Mar 26, 2008 1:49 am

Re: Too many SQL queries, why?

Post by Wiedmann »

JeremyBASS wrote::)What do i do what that?
I have provided a patch in standard diff format for this issue. Just apply the patch.
JeremyBASS wrote:is there in risk of problem if I down load it from the svn?
But if you are not familar with diff/patch, it could be easier, to just download the file from svn (which have the same change applied):
--> http://svn.cmsmadesimple.org/svn/cmsmad ... lflink.php
JeremyBASS

Re: Too many SQL queries, why?

Post by JeremyBASS »

Ok... this was odd... so I downloaded the file... then uploaded... and well this is what I got




That is an increase of 4 queries... um... I thought it was going to go down... any ideas?
Wiedmann
Forum Members
Forum Members
Posts: 233
Joined: Wed Mar 26, 2008 1:49 am

Re: Too many SQL queries, why?

Post by Wiedmann »

That is an increase of 4 queries... um... I thought it was going to go down... any ideas?
Well, for me this is a increase of ~50 queries (in my current project).

For a test you can enable debug mode in config.php and look which queries are executed in detail. (e.g. the statistics module needs a lot queries).
JeremyBASS

Re: Too many SQL queries, why?

Post by JeremyBASS »

Here is the debug output... i have to work out the login Emergency in the last post... but thought i'd throw this up...
any idea why this would be so  many?... looks like some are copy of them self...
Generated in 2.953547 seconds by CMS Made Simple using 78 SQL queries and n/a bytes of memory

Debug: (0.036076) loading smarty

Debug: (0.041283) loading adodb

Debug: (0.046824) loading page functions

Debug: (0.049906) loading content functions

Debug: (0.053357) loading pageinfo functions

Debug: (0.056397) loading translation functions

Debug: (0.058848) loading events functions

Debug: (0.06276) done loading files

Debug: (0.088755)
(mysql): SELECT sitepref_name, sitepref_value from StJoe_CMS_siteprefs
Error (0):

Debug: (0.105716)
(mysql): SELECT * FROM StJoe_CMS_userplugins
Error (0):

Debug: (0.131509)
(mysql): SELECT * FROM StJoe_CMS_modules WHERE admin_only = 0 ORDER BY module_name
Error (0):

Debug display of 'End of include':(1.180898)

Debug display of 'Load Content Operations':(1.181226)

Debug display of 'End Load Content Operations':(1.188596)

Debug: (1.189046)
(mysql): SELECT content_id FROM StJoe_CMS_content WHERE default_content = 1
Error (0):




Debug: (1.190408)
(mysql): SELECT c.content_id, c.content_name, c.content_alias, c.menu_text, c.titleattribute, c.hierarchy, c.metadata, c.id_hierarchy, c.prop_names, c.create_date AS c_create_date, c.modified_date AS c_date, c.cachable, c.last_modified_by, t.template_id, t.encoding, t.modified_date AS t_date FROM StJoe_CMS_templates t INNER JOIN StJoe_CMS_content c ON c.template_id = t.template_id WHERE (c.content_alias = '52' OR c.content_id = '52') AND c.active = 1
Error (0):




Debug: (1.190934)
(mysql): SELECT MAX(modified_date) AS thedate FROM StJoe_CMS_content c
Error (0):




Debug: (1.229454)
(mysql): SELECT template_id, template_name, template_content, stylesheet, encoding, active, default_template, modified_date FROM StJoe_CMS_templates WHERE template_id = '17'
Error (0):




Debug: (1.244892)
(mysql): SELECT * FROM StJoe_CMS_module_feusers_loggedin WHERE lastused<1210611123
Error (0):




Debug: (1.245343)
(mysql): DELETE FROM StJoe_CMS_module_feusers_loggedin WHERE lastused<1210611123
Error (0):




Debug: (1.246152)
(mysql): SELECT * FROM StJoe_CMS_module_feusers_loggedin WHERE sessionid='a7221d1e3767d308a7212de8dbe5c77b'
Error (0):




Debug: (1.246653)
(mysql): SELECT * FROM StJoe_CMS_module_feusers_loggedin WHERE lastused<1210611123
Error (0):




Debug: (1.247041)
(mysql): DELETE FROM StJoe_CMS_module_feusers_loggedin WHERE lastused<1210611123
Error (0):




Debug: (1.251478)
(mysql): SELECT * FROM StJoe_CMS_module_feusers_loggedin WHERE sessionid='a7221d1e3767d308a7212de8dbe5c77b'
Error (0):




Debug: (1.254281)
(mysql): SELECT * FROM StJoe_CMS_module_feusers_loggedin WHERE lastused<1210611123
Error (0):




Debug: (1.254923)
(mysql): DELETE FROM StJoe_CMS_module_feusers_loggedin WHERE lastused<1210611123
Error (0):




Debug: (1.257168)
(mysql): SELECT * FROM StJoe_CMS_module_feusers_loggedin WHERE sessionid='a7221d1e3767d308a7212de8dbe5c77b'
Error (0):




Debug: (1.258127)
(mysql): SELECT * FROM StJoe_CMS_module_feusers_belongs WHERE userid=0
Error (0):




Debug: (1.259153)
(mysql): SELECT * FROM StJoe_CMS_module_feusers_loggedin WHERE lastused<1210611123
Error (0):




Debug: (1.25953)
(mysql): DELETE FROM StJoe_CMS_module_feusers_loggedin WHERE lastused<1210611123
Error (0):




Debug: (1.264853)
(mysql): SELECT * FROM StJoe_CMS_module_feusers_loggedin WHERE sessionid='a7221d1e3767d308a7212de8dbe5c77b'
Error (0):




Debug: (1.266585)
(mysql): SELECT eh.tag_name, eh.module_name, e.originator, e.event_name, eh.handler_order, eh.handler_id, eh.removable FROM StJoe_CMS_event_handlers eh
        INNER JOIN StJoe_CMS_events e ON e.event_id = eh.event_id
        ORDER BY eh.handler_order ASC
Error (0):




Debug: (1.54931)
(mysql): SELECT DISTINCT media_type FROM StJoe_CMS_css c, StJoe_CMS_css_assoc
      WHERE  css_id    = assoc_css_id
      AND    assoc_type  = 'template'
      AND    assoc_to_id = '17'
Error (0):




Debug display of 'Start Loading Hierarchy Manager':(1.549508)

Debug display of 'starting tree':(1.549549)

Debug: (1.552143) file needs loading



Debug: (1.556479)
(mysql): SELECT * FROM StJoe_CMS_content WHERE parent_id = -1 ORDER BY hierarchy
Error (0):




Debug display of 'ending tree':(1.560942)

Debug display of 'End Loading Hierarchy Manager':(1.561018)

Debug: (1.562817)
(mysql): SELECT * FROM StJoe_CMS_content WHERE default_content = 1
Error (0):




Debug: (1.56354)
(mysql): SELECT * FROM StJoe_CMS_content WHERE content_id = '52'
Error (0):




Debug: (1.56578)
(mysql): SELECT * FROM StJoe_CMS_content WHERE default_content = 1
Error (0):




Debug: (1.568712)
(mysql): SELECT * FROM StJoe_CMS_content WHERE default_content = 1
Error (0):




Debug: (1.569468)
(mysql): SELECT * FROM StJoe_CMS_content WHERE content_id = '53'
Error (0):




Debug: (1.57202)
(mysql): SELECT * FROM StJoe_CMS_content WHERE default_content = 1
Error (0):




Debug: (1.57378) start global_content_get_template



Debug: (1.579495)
(mysql): SELECT htmlblob_id, htmlblob_name, html, owner, modified_date FROM StJoe_CMS_htmlblobs WHERE htmlblob_name = 'HeaderFLASH'
Error (0):




Debug: (1.581007) end global_content_get_template



Debug: (1.581077) start global_content_get_timestamp



Debug: (1.581134) end global_content_get_timestamp



Debug: (1.674847)
(mysql): SELECT content from StJoe_CMS_module_templates WHERE module_name = 'Search' and template_name = 'displaysearch'
Error (0):




Debug: (1.675595)
(mysql): SELECT modified_date from StJoe_CMS_module_templates WHERE module_name = 'Search' and template_name = 'displaysearch'
Error (0):




Debug: (1.866484)
(mysql): SELECT * FROM StJoe_CMS_module_feusers_loggedin WHERE lastused<1210611124
Error (0):




Debug: (1.868502)
(mysql): DELETE FROM StJoe_CMS_module_feusers_loggedin WHERE lastused<1210611124
Error (0):




Debug: (1.870235)
(mysql): SELECT * FROM StJoe_CMS_module_feusers_loggedin WHERE sessionid='a7221d1e3767d308a7212de8dbe5c77b'
Error (0):




Debug: (1.871143)
(mysql): SELECT * FROM StJoe_CMS_content WHERE content_alias = '\'\'login\'\''
Error (0):




Debug: (1.871392) start findNodeByTag



Debug: (1.871452) end findNodeByTag



Debug: (1.872083)
(mysql): SELECT * FROM StJoe_CMS_content WHERE content_alias = 'Home'
Error (0):




Debug display of 'Start of Menu Manager Display':(1.874599)

Debug: (1.876274)
(mysql): SELECT * FROM StJoe_CMS_content WHERE parent_id = '53' ORDER BY hierarchy
Error (0):




Debug: (1.88142)
(mysql): SELECT * FROM StJoe_CMS_content WHERE parent_id = '87' ORDER BY hierarchy
Error (0):




Debug: (1.884402) load properties called



Debug: (1.885012)
(mysql): SELECT * FROM StJoe_CMS_content_props WHERE content_id = '143'
Error (0):




Debug: (1.886205)
(mysql): SELECT * FROM StJoe_CMS_content WHERE content_id = '66'
Error (0):

Debug: (1.88818)
(mysql): SELECT * FROM StJoe_CMS_content WHERE parent_id = '66' ORDER BY hierarchy
Error (0):

Debug: (1.889885)
(mysql): SELECT * FROM StJoe_CMS_content WHERE parent_id = '69' ORDER BY hierarchy
Error (0):

Debug: (1.892692)
(mysql): SELECT * FROM StJoe_CMS_content WHERE content_id = '67'
Error (0):

Debug: (1.893828)
(mysql): SELECT * FROM StJoe_CMS_content WHERE parent_id = '67' ORDER BY hierarchy
Error (0):

Debug: (1.895037)
(mysql): SELECT * FROM StJoe_CMS_content WHERE content_id = '56'
Error (0):

Debug: (1.899987)
(mysql): SELECT * FROM StJoe_CMS_content WHERE parent_id = '56' ORDER BY hierarchy
Error (0):

Debug: (1.902269)
(mysql): SELECT * FROM StJoe_CMS_content WHERE content_id = '58'
Error (0):

Debug: (1.903514)
(mysql): SELECT * FROM StJoe_CMS_content WHERE parent_id = '58' ORDER BY hierarchy
Error (0):

Debug: (1.905692)
(mysql): SELECT * FROM StJoe_CMS_content WHERE content_id = '64'
Error (0):

Debug: (1.920967)
(mysql): SELECT * FROM StJoe_CMS_content WHERE content_id = '65'
Error (0):

Debug: (1.922513)
(mysql): SELECT * FROM StJoe_CMS_content WHERE parent_id = '65' ORDER BY hierarchy
Error (0):

Debug: (1.923735)
(mysql): SELECT * FROM StJoe_CMS_content WHERE content_id = '75'
Error (0):

Debug: (1.925297)
(mysql): SELECT * FROM StJoe_CMS_content WHERE content_id = '76'
Error (0):

Debug: (1.926331)
(mysql): SELECT * FROM StJoe_CMS_content WHERE content_id = '88'
Error (0):

Debug: (1.941455)
(mysql): SELECT * FROM StJoe_CMS_content WHERE content_id = '103'
Error (0):

Debug: (1.953902)
(mysql): SELECT * FROM StJoe_CMS_content WHERE content_id = '104'
Error (0):

Debug: (1.955041)
(mysql): SELECT * FROM StJoe_CMS_content WHERE content_id = '107'
Error (0):


Debug: (1.974353)
(mysql): SELECT content from StJoe_CMS_module_templates WHERE module_name = 'MenuManager' and template_name = 'tempCSS'
Error (0):

Debug: (1.97837)
(mysql): SELECT modified_date from StJoe_CMS_module_templates WHERE module_name = 'MenuManager' and template_name = 'tempCSS'
Error (0):


Debug display of 'End of Menu Manager Display':(2.181296)

Debug: (2.188419)
(mysql): SELECT * FROM StJoe_CMS_content WHERE content_alias = 'news'
Error (0):


Debug: (2.188567) start findNodeByTag

Debug: (2.188899) end findNodeByTag

Debug: (2.190438)
(mysql):
            SELECT count(mn.news_id) as count
            FROM StJoe_CMS_module_news mn
            LEFT OUTER JOIN StJoe_CMS_module_news_categories mnc
            ON mnc.news_category_id = mn.news_category_id
            LEFT OUTER JOIN StJoe_CMS_users u
            ON u.user_id = mn.author_id
            WHERE
                status = 'published'
            AND
        ( IFNULL(start_time, '1969-12-31 19:00:01')  < '2008-05-12 13:22:04')  AND (( IFNULL(end_time, '1969-12-31 19:00:01')  = '1969-12-31 19:00:01') OR (end_time > '2008-05-12 13:22:04'))
Error (0):


Debug: (2.221576)
(mysql):
            SELECT
                mn.*,
                mnc.news_category_name,
                mnc.long_name,
                u.username,
                u.first_name,
                u.last_name
            FROM StJoe_CMS_module_news mn
            LEFT OUTER JOIN StJoe_CMS_module_news_categories mnc
            ON mnc.news_category_id = mn.news_category_id
            LEFT OUTER JOIN StJoe_CMS_users u
            ON u.user_id = mn.author_id
            WHERE
                status = 'published'
            AND
        ( IFNULL(start_time, '1969-12-31 19:00:01')  < '2008-05-12 13:22:04')  AND (( IFNULL(end_time, '1969-12-31 19:00:01')  = '1969-12-31 19:00:01') OR (end_time > '2008-05-12 13:22:04')) ORDER BY news_date desc LIMIT 0, 1
Error (0):


Debug: (2.224338)
(mysql): SELECT A.value,B.id,B.name,B.type FROM StJoe_CMS_module_news_fieldvals A, StJoe_CMS_module_news_fielddefs B WHERE A.fielddef_id = B.id AND B.public = 1 AND A.news_id = '2' ORDER BY B.item_order
Error (0):


Debug: (2.254742)
(mysql): SELECT content from StJoe_CMS_module_templates WHERE module_name = 'News' and template_name = 'summarySample'
Error (0):


Debug: (2.255324)
(mysql): SELECT modified_date from StJoe_CMS_module_templates WHERE module_name = 'News' and template_name = 'summarySample'
Error (0):


Debug: (2.326863) start global_content_get_template

Debug: (2.32748)
(mysql): SELECT htmlblob_id, htmlblob_name, html, owner, modified_date FROM StJoe_CMS_htmlblobs WHERE htmlblob_name = 'Side_Bar_Links'
Error (0):


Debug: (2.32766) end global_content_get_template

Debug: (2.327708) start global_content_get_timestamp

Debug: (2.327756) end global_content_get_timestamp

Debug: (2.349542)
(mysql): SELECT * from StJoe_CMS_module_templates WHERE module_name = 'Printing' and template_name = 'linktemplate'
Error (0):


Debug: (2.351593)
(mysql): SELECT content from StJoe_CMS_module_templates WHERE module_name = 'Printing' and template_name = 'linktemplate'
Error (0):


Debug: (2.352131)
(mysql): SELECT modified_date from StJoe_CMS_module_templates WHERE module_name = 'Printing' and template_name = 'linktemplate'
Error (0):


Debug: (2.402253) start findNodeByTag

Debug: (2.402322) end findNodeByTag

Debug: (2.4025) load properties called

Debug: (2.403913)
(mysql): SELECT * FROM StJoe_CMS_content_props WHERE content_id = '52'
Error (0):


Debug: (2.404088) load properties called

Debug: (2.404932)
(mysql): SELECT * FROM StJoe_CMS_content_props WHERE content_id = '52'
Error (0):


Debug: (2.443617) start global_content_get_template

Debug: (2.444172)
(mysql): SELECT htmlblob_id, htmlblob_name, html, owner, modified_date FROM StJoe_CMS_htmlblobs WHERE htmlblob_name = 'Qikcon'
Error (0):


Debug: (2.44436) end global_content_get_template

Debug: (2.44441) start global_content_get_timestamp

Debug: (2.444459) end global_content_get_timestamp

Debug: (2.476832)
(mysql): SELECT * FROM StJoe_CMS_content WHERE default_content = 1
Error (0):


Debug: (2.47863)
(mysql): SELECT * FROM StJoe_CMS_content WHERE default_content = 1
Error (0):


Debug: (2.481276) start global_content_get_template

Debug: (2.481757)
(mysql): SELECT htmlblob_id, htmlblob_name, html, owner, modified_date FROM StJoe_CMS_htmlblobs WHERE htmlblob_name = 'footer'
Error (0):


Debug: (2.481933) end global_content_get_template

Debug: (2.481982) start global_content_get_timestamp

Debug: (2.48203) end global_content_get_timestamp

Debug: (2.651366) start global_content_get_template

Debug: (2.652789)
(mysql): SELECT htmlblob_id, htmlblob_name, html, owner, modified_date FROM StJoe_CMS_htmlblobs WHERE htmlblob_name = 'Loading'
Error (0):


Debug: (2.652971) end global_content_get_template

Debug: (2.65302) start global_content_get_timestamp

Debug: (2.653068) end global_content_get_timestamp

Debug: (2.687986) start global_content_get_template

Debug: (2.688874)
(mysql): SELECT htmlblob_id, htmlblob_name, html, owner, modified_date FROM StJoe_CMS_htmlblobs WHERE htmlblob_name = 'QuickLink'
Error (0):


Debug: (2.68907) end global_content_get_template

Debug: (2.689122) start global_content_get_timestamp

Debug: (2.689173) end global_content_get_timestamp
Locked

Return to “CMSMS Core”