<?xml version="1.0" encoding="utf-8"?>
<rss version="2.0">
	<channel>
		<title><![CDATA[TNF : Tatter Network Foundation forum - 다중사용자 관련(Unknown column 'a.owner' in 'field list')]]></title>
		<link>http://forum.tattersite.com/ko/viewtopic.php?id=7219</link>
		<description><![CDATA[다중사용자 관련(Unknown column 'a.owner' in 'field list') 의 최근 RSS 글들.]]></description>
		<lastBuildDate>Wed, 26 Nov 2008 08:53:40 +0000</lastBuildDate>
		<generator>PunBB</generator>
		<item>
			<title><![CDATA[다중사용자 관련(Unknown column 'a.owner' in 'field list')]]></title>
			<link>http://forum.tattersite.com/ko/viewtopic.php?pid=32260#p32260</link>
			<description><![CDATA[<p>태터 1.0.6 -&gt; 1.1.3 -&gt; 1.7.6으로 업그레이드 진행했습니다.</p><p>메인이 되는 블로그는 어떻게든 돌아가고 있는 것 같습니다.<br />이전에 사용하던 다중 블로깅 기능이 안되네요.</p><p>메인 : <a href="http://dain2.net">http://dain2.net</a> (O)<br />다중 : <a href="http://dain2.net/riss">http://dain2.net/riss</a> (X)</p><p>에러메시지는 아래와 같고<br />디버깅 모드 on 한 내용도 덧붙입니다.</p><p>도움 말씀 부탁드립니다.</p><p>(1) dain2.net/riss로 접속시 에러 메시지 : Unknown column &#039;a.owner&#039; in &#039;field list&#039;<br />(2) 디버깅 on :<br />Undefined variable: lightboxuser(8)<br />File: /home/hosting_users/miniz/www/plugins/lightbox/lightboxtt_setting.php:13</p><p>--------------------------------------------------------------------------------<br />Undefined offset: 6(8)<br />File: /home/hosting_users/miniz/www/plugins/CHAKANI_BRAINTAG/index.php:27</p><p>--------------------------------------------------------------------------------<br />Unknown column &#039;a.owner&#039; in &#039;field list&#039;count query string elapsed (ms) elapsed sum (ms)&nbsp; rows error stack <br />1 [DEBUG : Basic functions loaded.]&nbsp; 6.7&nbsp; &nbsp; &nbsp;/home/hosting_users/miniz/www/interface/index.php:46 include_once<br />/home/hosting_users/miniz/www/rewrite.php:90</p> <br /><p>2 [DEBUG : Default library loaded.]&nbsp; 18.0&nbsp; &nbsp; &nbsp;/home/hosting_users/miniz/www/interface/index.php:46 include_once<br />/home/hosting_users/miniz/www/rewrite.php:90</p> <br /><p>3 [DEBUG : Models loaded.]&nbsp; 106.7&nbsp; &nbsp; &nbsp;/home/hosting_users/miniz/www/interface/index.php:46 include_once<br />/home/hosting_users/miniz/www/rewrite.php:90</p> <br /><p>4 [DEBUG : Views loaded.]&nbsp; 121.3&nbsp; &nbsp; &nbsp;/home/hosting_users/miniz/www/interface/index.php:46 include_once<br />/home/hosting_users/miniz/www/rewrite.php:90</p> <br /><p>5 SET CHARACTER SET utf8 0.2 127.3&nbsp; &nbsp;0 Error no. 1115 : Unknown character set: &#039;utf8&#039; /home/hosting_users/miniz/www/library/initialize.php:13 require<br />/home/hosting_users/miniz/www/library/include.php:87 require<br />/home/hosting_users/miniz/www/library/includeForBlog.php:58 require<br />/home/hosting_users/miniz/www/interface/index.php:46 include_once<br />/home/hosting_users/miniz/www/rewrite.php:90</p> <br /><p>6 SET SESSION collation_connection = &#039;utf8_general_ci&#039; 0.2 127.7&nbsp; &nbsp;0 Error no. 1064 : You have an error in your SQL syntax near &#039;collation_connection = &#039;utf8_general_ci&#039;&#039; at line 1 /home/hosting_users/miniz/www/library/initialize.php:13 require<br />/home/hosting_users/miniz/www/library/include.php:87 require<br />/home/hosting_users/miniz/www/library/includeForBlog.php:58 require<br />/home/hosting_users/miniz/www/interface/index.php:46 include_once<br />/home/hosting_users/miniz/www/rewrite.php:90</p> <br /><p>7 SELECT name, value FROM tt_ServiceSettings 0.5 129.8&nbsp; &nbsp;6&nbsp; /home/hosting_users/miniz/www/library/components/Needlworks.DBMS.MySQL.php:187 pod::queryallwithcache<br />/home/hosting_users/miniz/www/library/model/common.setting.php:30 getservicesetting<br />/home/hosting_users/miniz/www/library/suri.php:8 require<br />/home/hosting_users/miniz/www/library/initialize.php:24 require<br />/home/hosting_users/miniz/www/library/include.php:87 require<br />/home/hosting_users/miniz/www/library/includeForBlog.php:58 require<br />/home/hosting_users/miniz/www/interface/index.php:46 include_once<br />/home/hosting_users/miniz/www/rewrite.php:90</p> <br /><p>8 SELECT blogid FROM tt_BlogSettings WHERE name=&#039;name&#039; AND value=&#039;riss&#039; LIMIT 1 0.4 130.7&nbsp; &nbsp;1&nbsp; /home/hosting_users/miniz/www/library/components/Needlworks.DBMS.MySQL.php:187 dbquery::queryallwithcache<br />/home/hosting_users/miniz/www/library/components/Needlworks.DBMS.MySQL.php:107 pod::querycell<br />/home/hosting_users/miniz/www/library/components/Needlworks.Database.php:100 tablequery-&gt;getcell<br />/home/hosting_users/miniz/www/library/model/blog.service.php:14 getblogidbyname<br />/home/hosting_users/miniz/www/library/suri.php:41 require<br />/home/hosting_users/miniz/www/library/initialize.php:24 require<br />/home/hosting_users/miniz/www/library/include.php:87 require<br />/home/hosting_users/miniz/www/library/includeForBlog.php:58 require<br />/home/hosting_users/miniz/www/interface/index.php:46 include_once<br />/home/hosting_users/miniz/www/rewrite.php:90</p> <br /><p>9 SELECT value FROM tt_PageCacheLog WHERE blogid = 2 AND name = &#039;globalCacheStorage&#039; 0.4 133.7&nbsp; &nbsp;0&nbsp; /home/hosting_users/miniz/www/library/components/Needlworks.DBMS.MySQL.php:187 dbquery::queryallwithcache<br />/home/hosting_users/miniz/www/library/components/Needlworks.DBMS.MySQL.php:107 pod::querycell<br />/home/hosting_users/miniz/www/library/components/Needlworks.Cache.PageCache.php:270 globalcachestorage-&gt;load<br />/home/hosting_users/miniz/www/library/components/Needlworks.Cache.PageCache.php:280 globalcachestorage-&gt;getcontent<br />/home/hosting_users/miniz/www/library/components/Textcube.Function.Setting.php:59 setting::getblogsettingsglobal<br />/home/hosting_users/miniz/www/library/model/blog.service.php:25 getblogsettings<br />/home/hosting_users/miniz/www/library/suri.php:58 require<br />/home/hosting_users/miniz/www/library/initialize.php:24 require<br />/home/hosting_users/miniz/www/library/include.php:87 require<br />/home/hosting_users/miniz/www/library/includeForBlog.php:58 require<br />/home/hosting_users/miniz/www/interface/index.php:46 include_once<br />/home/hosting_users/miniz/www/rewrite.php:90</p> <br /><p>10 SELECT * FROM tt_BlogSettings WHERE blogid=2 0.7 134.7&nbsp; &nbsp;36&nbsp; /home/hosting_users/miniz/www/library/components/Needlworks.DBMS.MySQL.php:187 dbquery::queryallwithcache<br />/home/hosting_users/miniz/www/library/components/Needlworks.DBMS.MySQL.php:161 pod::queryall<br />/home/hosting_users/miniz/www/library/components/Needlworks.Database.php:112 tablequery-&gt;getall<br />/home/hosting_users/miniz/www/library/components/Textcube.Function.Setting.php:68 setting::getblogsettingsglobal<br />/home/hosting_users/miniz/www/library/model/blog.service.php:25 getblogsettings<br />/home/hosting_users/miniz/www/library/suri.php:58 require<br />/home/hosting_users/miniz/www/library/initialize.php:24 require<br />/home/hosting_users/miniz/www/library/include.php:87 require<br />/home/hosting_users/miniz/www/library/includeForBlog.php:58 require<br />/home/hosting_users/miniz/www/interface/index.php:46 include_once<br />/home/hosting_users/miniz/www/rewrite.php:90</p> <br /><p>11 SELECT * FROM tt_SkinSettings WHERE blogid = 2 0.5 136.1&nbsp; &nbsp;1&nbsp; /home/hosting_users/miniz/www/library/components/Needlworks.DBMS.MySQL.php:187 dbquery::queryallwithcache<br />/home/hosting_users/miniz/www/library/components/Needlworks.DBMS.MySQL.php:120 pod::queryrow<br />/home/hosting_users/miniz/www/library/model/blog.service.php:47 getskinsetting<br />/home/hosting_users/miniz/www/library/suri.php:59 require<br />/home/hosting_users/miniz/www/library/initialize.php:24 require<br />/home/hosting_users/miniz/www/library/include.php:87 require<br />/home/hosting_users/miniz/www/library/includeForBlog.php:58 require<br />/home/hosting_users/miniz/www/interface/index.php:46 include_once<br />/home/hosting_users/miniz/www/rewrite.php:90</p> <br /><p>12 SELECT id FROM tt_Sessions WHERE id = &#039;5639e8a955130847680ea8df4d186aa7&#039; AND address = &#039;211.180.195.57&#039; AND (userid IS NOT NULL OR preexistence IS NOT NULL) 0.4 139.0&nbsp; &nbsp;1&nbsp; /home/hosting_users/miniz/www/library/components/Needlworks.DBMS.MySQL.php:187 dbquery::queryallwithcache<br />/home/hosting_users/miniz/www/library/components/Needlworks.DBMS.MySQL.php:107 pod::querycell<br />/home/hosting_users/miniz/www/library/session.php:233 _sessionquery<br />/home/hosting_users/miniz/www/library/session.php:215 sessionquery<br />/home/hosting_users/miniz/www/library/session.php:144 issessionauthorized<br />/home/hosting_users/miniz/www/library/session.php:170 setsession<br />/home/hosting_users/miniz/www/library/session.php:244 require<br />/home/hosting_users/miniz/www/library/initialize.php:27 require<br />/home/hosting_users/miniz/www/library/include.php:87 require<br />/home/hosting_users/miniz/www/library/includeForBlog.php:58 require<br />/home/hosting_users/miniz/www/interface/index.php:46 include_once<br />/home/hosting_users/miniz/www/rewrite.php:90</p> <br /><p>13 SELECT data FROM tt_Sessions WHERE id = &#039;5639e8a955130847680ea8df4d186aa7&#039; AND address = &#039;211.180.195.57&#039; AND updated &gt;= (UNIX_TIMESTAMP() - 3600) 0.4 139.7&nbsp; &nbsp;1&nbsp; /home/hosting_users/miniz/www/library/components/Needlworks.DBMS.MySQL.php:187 dbquery::queryallwithcache<br />/home/hosting_users/miniz/www/library/components/Needlworks.DBMS.MySQL.php:107 pod::querycell<br />/home/hosting_users/miniz/www/library/session.php:233 _sessionquery<br />/home/hosting_users/miniz/www/library/session.php:215 sessionquery<br />/home/hosting_users/miniz/www/library/session.php:39 readsession<br />/home/hosting_users/miniz/www/library/session.php:248 require<br />/home/hosting_users/miniz/www/library/initialize.php:27 require<br />/home/hosting_users/miniz/www/library/include.php:87 require<br />/home/hosting_users/miniz/www/library/includeForBlog.php:58 require<br />/home/hosting_users/miniz/www/interface/index.php:46 include_once<br />/home/hosting_users/miniz/www/rewrite.php:90</p> <br /><p>14 SELECT name FROM tt_Users WHERE userid = 1 0.3 140.3&nbsp; &nbsp;1&nbsp; /home/hosting_users/miniz/www/library/components/Needlworks.DBMS.MySQL.php:187 dbquery::queryallwithcache<br />/home/hosting_users/miniz/www/library/components/Needlworks.DBMS.MySQL.php:107 pod::querycell<br />/home/hosting_users/miniz/www/library/components/Textcube.Core.php:24 user::getname<br />/home/hosting_users/miniz/www/library/initialize.php:33 require<br />/home/hosting_users/miniz/www/library/include.php:87 require<br />/home/hosting_users/miniz/www/library/includeForBlog.php:58 require<br />/home/hosting_users/miniz/www/interface/index.php:46 include_once<br />/home/hosting_users/miniz/www/rewrite.php:90</p> <br /><p>15 SELECT name, value FROM tt_UserSettings WHERE userid = 1 0.3 140.8&nbsp; &nbsp;0&nbsp; /home/hosting_users/miniz/www/library/components/Needlworks.DBMS.MySQL.php:187 dbquery::queryallwithcache<br />/home/hosting_users/miniz/www/library/components/Needlworks.DBMS.MySQL.php:161 pod::queryall<br />/home/hosting_users/miniz/www/library/components/Textcube.Function.Setting.php:231 setting::getusersettingglobal<br />/home/hosting_users/miniz/www/library/components/Textcube.Core.php:126 user::gethomepage<br />/home/hosting_users/miniz/www/library/initialize.php:34 require<br />/home/hosting_users/miniz/www/library/include.php:87 require<br />/home/hosting_users/miniz/www/library/includeForBlog.php:58 require<br />/home/hosting_users/miniz/www/interface/index.php:46 include_once<br />/home/hosting_users/miniz/www/rewrite.php:90</p> <br /><p>16 SET time_zone = &#039;0+9:00&#039; 0.2 141.3&nbsp; &nbsp;0 Error no. 1064 : You have an error in your SQL syntax near &#039;time_zone = &#039;0+9:00&#039;&#039; at line 1 /home/hosting_users/miniz/www/library/include.php:87 require<br />/home/hosting_users/miniz/www/library/includeForBlog.php:58 require<br />/home/hosting_users/miniz/www/interface/index.php:46 include_once<br />/home/hosting_users/miniz/www/rewrite.php:90</p> <br /><p>17 [DEBUG : Initialization finished.]&nbsp; 143.2&nbsp; &nbsp; &nbsp;/home/hosting_users/miniz/www/interface/index.php:46 include_once<br />/home/hosting_users/miniz/www/rewrite.php:90</p> <br /><p>18 SELECT name FROM tt_Plugins WHERE blogid = 2 0.6 147.2&nbsp; &nbsp;11&nbsp; /home/hosting_users/miniz/www/library/plugins.php:29 require<br />/home/hosting_users/miniz/www/library/include.php:87 require<br />/home/hosting_users/miniz/www/library/includeForBlog.php:58 require<br />/home/hosting_users/miniz/www/interface/index.php:46 include_once<br />/home/hosting_users/miniz/www/rewrite.php:90</p> <br /><p>19 [DEBUG : Plugin module loaded.]&nbsp; 175.7&nbsp; &nbsp; &nbsp;/home/hosting_users/miniz/www/interface/index.php:46 include_once<br />/home/hosting_users/miniz/www/rewrite.php:90</p> <br /><p>20 SELECT CN.*, CNQ.id AS queueId, CNQ.commentId AS commentId, CNQ.sendStatus AS sendStatus, CNQ.checkDate AS checkDate, CNQ.written AS queueWritten FROM tt_CommentsNotifiedQueue AS CNQ LEFT JOIN tt_Comments AS CN ON CNQ.commentId = CN.id WHERE CNQ.sendStatus = &#039;0&#039; and CN.parent is not null ORDER BY CNQ.id ASC LIMIT 0, 1 0.5 176.5&nbsp; &nbsp;0&nbsp; /home/hosting_users/miniz/www/library/components/Needlworks.DBMS.MySQL.php:187 dbquery::queryallwithcache<br />/home/hosting_users/miniz/www/library/components/Needlworks.DBMS.MySQL.php:120 pod::queryrow<br />/home/hosting_users/miniz/www/library/model/blog.comment.php:857 notifycomment<br />/home/hosting_users/miniz/www/interface/index.php:64 include_once<br />/home/hosting_users/miniz/www/rewrite.php:90</p> <br /><p>21 SELECT value FROM tt_PageCacheLog WHERE blogid = 2 AND name = &#039;skinCache&#039; 0.4 177.5&nbsp; &nbsp;1&nbsp; /home/hosting_users/miniz/www/library/components/Needlworks.DBMS.MySQL.php:187 dbquery::queryallwithcache<br />/home/hosting_users/miniz/www/library/components/Needlworks.DBMS.MySQL.php:107 pod::querycell<br />/home/hosting_users/miniz/www/library/components/Needlworks.Cache.PageCache.php:144 pagecache-&gt;getpagecachelog<br />/home/hosting_users/miniz/www/library/components/Needlworks.Cache.PageCache.php:137 pagecache-&gt;getdbcontents<br />/home/hosting_users/miniz/www/library/components/Needlworks.Cache.PageCache.php:73 pagecache-&gt;load<br />/home/hosting_users/miniz/www/library/blog.skin.php:361 skin-&gt;loadcache<br />/home/hosting_users/miniz/www/library/blog.skin.php:93 skin-&gt;skin<br />/home/hosting_users/miniz/www/interface/index.php:71 include_once<br />/home/hosting_users/miniz/www/rewrite.php:90</p> <br /><p>22 SELECT COUNT(*) FROM tt_Entries e LEFT JOIN tt_Categories c ON e.blogid = c.blogid AND e.category = c.id WHERE e.blogid = 2 AND e.draft = 0 AND e.visibility &gt; 0 AND (c.visibility &gt; 1 OR e.category = 0) AND e.category &gt;= 0 1.0 181.5&nbsp; &nbsp;1&nbsp; /home/hosting_users/miniz/www/library/components/Needlworks.DBMS.MySQL.php:187 dbquery::queryallwithcache<br />/home/hosting_users/miniz/www/library/components/Needlworks.DBMS.MySQL.php:107 pod::querycell<br />/home/hosting_users/miniz/www/library/components/Textcube.Model.Paging.php:117 paging::fetchwithpaging<br />/home/hosting_users/miniz/www/library/model/common.legacysupport.php:76 fetchwithpaging<br />/home/hosting_users/miniz/www/library/model/blog.entry.php:208 getentrieswithpaging<br />/home/hosting_users/miniz/www/interface/index.php:79 include_once<br />/home/hosting_users/miniz/www/rewrite.php:90</p> <br /><p>23 SELECT e.*, c.label categoryLabel FROM tt_Entries e LEFT JOIN tt_Categories c ON e.blogid = c.blogid AND e.category = c.id WHERE e.blogid = 2 AND e.draft = 0 AND e.visibility &gt; 0 AND (c.visibility &gt; 1 OR e.category = 0) AND e.category &gt;= 0 ORDER BY e.published DESC LIMIT 0, 1 0.9 182.6&nbsp; &nbsp;1&nbsp; /home/hosting_users/miniz/www/library/components/Needlworks.DBMS.MySQL.php:187 dbquery::queryallwithcache<br />/home/hosting_users/miniz/www/library/components/Needlworks.DBMS.MySQL.php:161 pod::queryall<br />/home/hosting_users/miniz/www/library/components/Textcube.Model.Paging.php:136 paging::fetchwithpaging<br />/home/hosting_users/miniz/www/library/model/common.legacysupport.php:76 fetchwithpaging<br />/home/hosting_users/miniz/www/library/model/blog.entry.php:208 getentrieswithpaging<br />/home/hosting_users/miniz/www/interface/index.php:79 include_once<br />/home/hosting_users/miniz/www/rewrite.php:90</p> <br /><p>24 SELECT blogid FROM tt_SessionVisits WHERE id = &#039;5639e8a955130847680ea8df4d186aa7&#039; AND address = &#039;211.180.195.57&#039; AND blogid = 2 0.4 185.3&nbsp; &nbsp;1&nbsp; /home/hosting_users/miniz/www/library/components/Textcube.Model.Statistics.php:83 statistics::updatevisitorstatistics<br />/home/hosting_users/miniz/www/library/piece/blog/begin.php:8 require<br />/home/hosting_users/miniz/www/interface/index.php:80 include_once<br />/home/hosting_users/miniz/www/rewrite.php:90</p> <br /><p>25 SELECT visits FROM tt_BlogStatistics WHERE blogid = 2 0.3 185.8&nbsp; &nbsp;1&nbsp; /home/hosting_users/miniz/www/library/components/Needlworks.DBMS.MySQL.php:187 dbquery::queryallwithcache<br />/home/hosting_users/miniz/www/library/components/Needlworks.DBMS.MySQL.php:107 pod::querycell<br />/home/hosting_users/miniz/www/library/components/Textcube.Model.Statistics.php:12 statistics::getstatistics<br />/home/hosting_users/miniz/www/library/piece/blog/begin.php:9 require<br />/home/hosting_users/miniz/www/interface/index.php:80 include_once<br />/home/hosting_users/miniz/www/rewrite.php:90</p> <br /><p>26 SELECT date, visits FROM tt_DailyStatistics WHERE blogid = 2 AND `date` in (&#039;20081126&#039;,&#039;20081125&#039;) 0.4 186.3&nbsp; &nbsp;2&nbsp; /home/hosting_users/miniz/www/library/components/Needlworks.DBMS.MySQL.php:187 dbquery::queryallwithcache<br />/home/hosting_users/miniz/www/library/components/Needlworks.DBMS.MySQL.php:161 pod::queryall<br />/home/hosting_users/miniz/www/library/components/Textcube.Model.Statistics.php:15 statistics::getstatistics<br />/home/hosting_users/miniz/www/library/piece/blog/begin.php:9 require<br />/home/hosting_users/miniz/www/interface/index.php:80 include_once<br />/home/hosting_users/miniz/www/rewrite.php:90</p> <br /><p>27 SELECT * FROM tt_Trackbacks WHERE blogid = 2 AND entry = 33 AND isFiltered = 0 ORDER BY written 0.6 191.0&nbsp; &nbsp;0&nbsp; /home/hosting_users/miniz/www/library/view/view.php:172 gettrackbacksview<br />/home/hosting_users/miniz/www/library/piece/blog/entries.php:73 require<br />/home/hosting_users/miniz/www/interface/index.php:81 include_once<br />/home/hosting_users/miniz/www/rewrite.php:90</p> <br /><p>28 SELECT * FROM tt_Comments WHERE blogid = 2 AND entry = 33 AND parent IS NULL AND isFiltered = 0 ORDER BY id ASC 0.7 192.4&nbsp; &nbsp;0&nbsp; /home/hosting_users/miniz/www/library/components/Needlworks.DBMS.MySQL.php:187 dbquery::queryallwithcache<br />/home/hosting_users/miniz/www/library/components/Needlworks.DBMS.MySQL.php:161 pod::queryall<br />/home/hosting_users/miniz/www/library/model/blog.comment.php:254 getcomments<br />/home/hosting_users/miniz/www/library/view/view.php:256 getcommentview<br />/home/hosting_users/miniz/www/library/piece/blog/entries.php:79 require<br />/home/hosting_users/miniz/www/interface/index.php:81 include_once<br />/home/hosting_users/miniz/www/rewrite.php:90</p> <br /><p>29 SELECT `acceptComment` FROM `tt_Entries` WHERE `blogid` = 2 AND `id` = 33 0.4 193.2&nbsp; &nbsp;1&nbsp; /home/hosting_users/miniz/www/library/components/Needlworks.DBMS.MySQL.php:187 dbquery::queryallwithcache<br />/home/hosting_users/miniz/www/library/components/Needlworks.DBMS.MySQL.php:107 pod::querycell<br />/home/hosting_users/miniz/www/library/view/view.php:362 getcommentview<br />/home/hosting_users/miniz/www/library/piece/blog/entries.php:79 require<br />/home/hosting_users/miniz/www/interface/index.php:81 include_once<br />/home/hosting_users/miniz/www/rewrite.php:90</p> <br /><p>30 SELECT t.* FROM `tt_Tags` t INNER JOIN `tt_TagRelations` r ON r.blogid = 2 AND r.entry = 33 AND r.tag = t.id INNER JOIN `tt_Entries` e ON e.id = r.entry AND e.visibility &gt; 0 GROUP BY r.tag ORDER BY t.name 0.7 194.5&nbsp; &nbsp;0&nbsp; /home/hosting_users/miniz/www/library/piece/blog/entries.php:81 require<br />/home/hosting_users/miniz/www/interface/index.php:81 include_once<br />/home/hosting_users/miniz/www/rewrite.php:90</p> <br /><p>31 SELECT name FROM tt_Users WHERE userid = 2 0.3 195.1&nbsp; &nbsp;1&nbsp; /home/hosting_users/miniz/www/library/components/Needlworks.DBMS.MySQL.php:187 dbquery::queryallwithcache<br />/home/hosting_users/miniz/www/library/components/Needlworks.DBMS.MySQL.php:107 pod::querycell<br />/home/hosting_users/miniz/www/library/components/Textcube.Core.php:24 user::getname<br />/home/hosting_users/miniz/www/library/piece/blog/entries.php:113 require<br />/home/hosting_users/miniz/www/interface/index.php:81 include_once<br />/home/hosting_users/miniz/www/rewrite.php:90</p> <br /><p>32 SELECT * FROM tt_Categories WHERE blogid = 2 AND id &gt;= 0 ORDER BY parent, priority 0.5 196.0&nbsp; &nbsp;4&nbsp; /home/hosting_users/miniz/www/library/components/Needlworks.DBMS.MySQL.php:187 pod::queryallwithcache<br />/home/hosting_users/miniz/www/library/model/blog.category.php:118 getcategories<br />/home/hosting_users/miniz/www/library/model/blog.category.php:59 getcategorybodyidbyid<br />/home/hosting_users/miniz/www/library/piece/blog/entries.php:123 require<br />/home/hosting_users/miniz/www/interface/index.php:81 include_once<br />/home/hosting_users/miniz/www/rewrite.php:90</p> <br /><p>33 SELECT title FROM tt_Entries WHERE blogid = 2 AND draft = 0 AND visibility &gt; 0 AND category = -1 ORDER BY char_length(title) DESC 0.5 197.0&nbsp; &nbsp;0&nbsp; /home/hosting_users/miniz/www/library/model/blog.keyword.php:16 getkeywordnames<br />/home/hosting_users/miniz/www/library/piece/blog/entries.php:126 require<br />/home/hosting_users/miniz/www/interface/index.php:81 include_once<br />/home/hosting_users/miniz/www/rewrite.php:90</p> <br /><p>34 SELECT * FROM tt_Attachments WHERE blogid = 2 AND parent = 33 0.7 204.7&nbsp; &nbsp;0&nbsp; /home/hosting_users/miniz/www/library/components/Needlworks.DBMS.MySQL.php:187 dbquery::queryallwithcache<br />/home/hosting_users/miniz/www/library/components/Needlworks.DBMS.MySQL.php:161 pod::queryall<br />/home/hosting_users/miniz/www/library/model/blog.attachment.php:19 getattachments<br />/home/hosting_users/miniz/www/plugins/FM_TTML/ttml.php:118 fm_ttml_bindattachments<br />/home/hosting_users/miniz/www/plugins/FM_TTML/index.php:11 fm_ttml_format<br />/home/hosting_users/miniz/www/library/model/common.module.php:71 formatcontent<br />/home/hosting_users/miniz/www/library/view/view.php:1127 getentrycontentview<br />/home/hosting_users/miniz/www/library/piece/blog/entries.php:126 require<br />/home/hosting_users/miniz/www/interface/index.php:81 include_once<br />/home/hosting_users/miniz/www/rewrite.php:90</p> <br /><p>35 SELECT COUNT(*) FROM tt_Entries e WHERE e.blogid = 2 AND e.draft = 0 AND e.visibility &gt; 0 AND e.category &gt;= 0 0.8 213.0&nbsp; &nbsp;1&nbsp; /home/hosting_users/miniz/www/library/components/Needlworks.DBMS.MySQL.php:187 dbquery::queryallwithcache<br />/home/hosting_users/miniz/www/library/components/Needlworks.DBMS.MySQL.php:107 pod::querycell<br />/home/hosting_users/miniz/www/library/model/blog.entry.php:12 getentriestotalcount<br />/home/hosting_users/miniz/www/library/piece/blog/end.php:35 require<br />/home/hosting_users/miniz/www/interface/index.php:84 include_once<br />/home/hosting_users/miniz/www/rewrite.php:90</p> <br /><p>36 SELECT * FROM tt_Categories WHERE blogid = 2 AND id &gt;= 0 ORDER BY parent, priority 0.0 213.3&nbsp; &nbsp;0 (cached) /home/hosting_users/miniz/www/library/piece/blog/end.php:36 require<br />/home/hosting_users/miniz/www/interface/index.php:84 include_once<br />/home/hosting_users/miniz/www/rewrite.php:90</p> <br /><p>37 SELECT value FROM tt_PageCacheLog WHERE blogid = 2 AND name = &#039;entry_queryCache_1482161100&#039; 0.4 216.2&nbsp; &nbsp;1&nbsp; /home/hosting_users/miniz/www/library/components/Needlworks.DBMS.MySQL.php:187 dbquery::queryallwithcache<br />/home/hosting_users/miniz/www/library/components/Needlworks.DBMS.MySQL.php:107 pod::querycell<br />/home/hosting_users/miniz/www/library/components/Needlworks.Cache.PageCache.php:226 querycache-&gt;getpagecachelog<br />/home/hosting_users/miniz/www/library/components/Needlworks.Cache.PageCache.php:204 querycache-&gt;load<br />/home/hosting_users/miniz/www/library/components/POD.Core.Legacy.php:64 pod::queryallwithdbcache<br />/home/hosting_users/miniz/www/library/model/blog.archive.php:17 getarchives<br />/home/hosting_users/miniz/www/library/piece/blog/end.php:46 require<br />/home/hosting_users/miniz/www/interface/index.php:84 include_once<br />/home/hosting_users/miniz/www/rewrite.php:90</p> <br /><p>38 SELECT value FROM tt_PageCacheLog WHERE blogid = 2 AND name = &#039;entry_queryCache_2054490487&#039; 0.4 217.6&nbsp; &nbsp;1&nbsp; /home/hosting_users/miniz/www/library/components/Needlworks.DBMS.MySQL.php:187 dbquery::queryallwithcache<br />/home/hosting_users/miniz/www/library/components/Needlworks.DBMS.MySQL.php:107 pod::querycell<br />/home/hosting_users/miniz/www/library/components/Needlworks.Cache.PageCache.php:226 querycache-&gt;getpagecachelog<br />/home/hosting_users/miniz/www/library/components/Needlworks.Cache.PageCache.php:204 querycache-&gt;load<br />/home/hosting_users/miniz/www/library/components/POD.Core.Legacy.php:64 pod::queryallwithdbcache<br />/home/hosting_users/miniz/www/library/model/blog.archive.php:36 getcalendar<br />/home/hosting_users/miniz/www/library/piece/blog/end.php:48 require<br />/home/hosting_users/miniz/www/interface/index.php:84 include_once<br />/home/hosting_users/miniz/www/rewrite.php:90</p> <br /><p>39 SELECT name, count(*) cnt, t.id FROM `tt_Tags` t, `tt_TagRelations` r, `tt_Entries` e WHERE r.entry = e.id AND e.visibility &gt; 0 AND t.id = r.tag AND r.blogid = 2 AND e.blogid = 2 GROUP BY r.tag ORDER BY RAND() limit 30 1.3 220.1&nbsp; &nbsp;15&nbsp; /home/hosting_users/miniz/www/library/components/Needlworks.DBMS.MySQL.php:187 dbquery::queryallwithcache<br />/home/hosting_users/miniz/www/library/components/Needlworks.DBMS.MySQL.php:161 pod::queryall<br />/home/hosting_users/miniz/www/library/model/blog.tag.php:81 getrandomtags<br />/home/hosting_users/miniz/www/library/piece/blog/end.php:50 require<br />/home/hosting_users/miniz/www/interface/index.php:84 include_once<br />/home/hosting_users/miniz/www/rewrite.php:90</p> <br /><p>40 SELECT count(r.entry) `cnt` FROM `tt_TagRelations` r INNER JOIN `tt_Entries` e ON r.blogid = e.blogid AND e.visibility &gt; 0 AND r.entry = e.id WHERE r.blogid = 2 GROUP BY r.tag ORDER BY `cnt` DESC LIMIT 1 1.0 221.6&nbsp; &nbsp;1&nbsp; /home/hosting_users/miniz/www/library/components/Needlworks.DBMS.MySQL.php:187 dbquery::queryallwithcache<br />/home/hosting_users/miniz/www/library/components/Needlworks.DBMS.MySQL.php:107 pod::querycell<br />/home/hosting_users/miniz/www/library/model/blog.tag.php:124 gettagfrequencyrange<br />/home/hosting_users/miniz/www/library/view/view.php:1105 getrandomtagsview<br />/home/hosting_users/miniz/www/library/piece/blog/end.php:50 require<br />/home/hosting_users/miniz/www/interface/index.php:84 include_once<br />/home/hosting_users/miniz/www/rewrite.php:90</p> <br /><p>41 SELECT id, title, slogan, published FROM tt_Entries WHERE blogid = 2 AND draft = 0 AND visibility &gt; 1 AND category = -2 ORDER BY published DESC 0.6 224.2&nbsp; &nbsp;1&nbsp; /home/hosting_users/miniz/www/library/components/Needlworks.DBMS.MySQL.php:187 dbquery::queryallwithcache<br />/home/hosting_users/miniz/www/library/components/Needlworks.DBMS.MySQL.php:161 pod::queryall<br />/home/hosting_users/miniz/www/library/model/blog.notice.php:27 getnotices<br />/home/hosting_users/miniz/www/library/piece/blog/end.php:53 require<br />/home/hosting_users/miniz/www/interface/index.php:84 include_once<br />/home/hosting_users/miniz/www/rewrite.php:90</p> <br /><p>42 SELECT e.id, e.userid, e.title, e.slogan, e.comments FROM tt_Entries e WHERE e.blogid = 2 AND e.draft = 0 AND e.visibility &gt; 0 AND e.category &gt;= 0 ORDER BY published DESC LIMIT 10 0.9 225.8&nbsp; &nbsp;10&nbsp; /home/hosting_users/miniz/www/library/piece/blog/end.php:63 require<br />/home/hosting_users/miniz/www/interface/index.php:84 include_once<br />/home/hosting_users/miniz/www/rewrite.php:90</p> <br /><p>43 SELECT value FROM tt_PageCacheLog WHERE blogid = 2 AND name = &#039;comment_queryCache_1362052157&#039; 0.4 228.5&nbsp; &nbsp;1&nbsp; /home/hosting_users/miniz/www/library/components/Needlworks.DBMS.MySQL.php:187 dbquery::queryallwithcache<br />/home/hosting_users/miniz/www/library/components/Needlworks.DBMS.MySQL.php:107 pod::querycell<br />/home/hosting_users/miniz/www/library/components/Needlworks.Cache.PageCache.php:226 querycache-&gt;getpagecachelog<br />/home/hosting_users/miniz/www/library/components/Needlworks.Cache.PageCache.php:204 querycache-&gt;load<br />/home/hosting_users/miniz/www/library/components/POD.Core.Legacy.php:64 pod::queryallwithdbcache<br />/home/hosting_users/miniz/www/library/model/blog.comment.php:709 getrecentcomments<br />/home/hosting_users/miniz/www/library/piece/blog/end.php:65 require<br />/home/hosting_users/miniz/www/interface/index.php:84 include_once<br />/home/hosting_users/miniz/www/rewrite.php:90</p> <br /><p>44 SELECT value FROM tt_PageCacheLog WHERE blogid = 2 AND name = &#039;trackback_queryCache_1866093342&#039; 0.4 231.2&nbsp; &nbsp;1&nbsp; /home/hosting_users/miniz/www/library/components/Needlworks.DBMS.MySQL.php:187 dbquery::queryallwithcache<br />/home/hosting_users/miniz/www/library/components/Needlworks.DBMS.MySQL.php:107 pod::querycell<br />/home/hosting_users/miniz/www/library/components/Needlworks.Cache.PageCache.php:226 querycache-&gt;getpagecachelog<br />/home/hosting_users/miniz/www/library/components/Needlworks.Cache.PageCache.php:204 querycache-&gt;load<br />/home/hosting_users/miniz/www/library/components/POD.Core.Legacy.php:64 pod::queryallwithdbcache<br />/home/hosting_users/miniz/www/library/model/blog.trackback.php:128 getrecenttrackbacks<br />/home/hosting_users/miniz/www/library/piece/blog/end.php:67 require<br />/home/hosting_users/miniz/www/interface/index.php:84 include_once<br />/home/hosting_users/miniz/www/rewrite.php:90</p> <br /><p>45 SELECT l.*, lc.name AS categoryName FROM tt_Links l LEFT JOIN tt_LinkCategories lc ON lc.blogid = l.blogid AND lc.id = l.category WHERE l.blogid = 2 ORDER BY lc.name, l.name 0.6 232.2&nbsp; &nbsp;4&nbsp; /home/hosting_users/miniz/www/library/components/Needlworks.DBMS.MySQL.php:187 dbquery::queryallwithcache<br />/home/hosting_users/miniz/www/library/components/Needlworks.DBMS.MySQL.php:161 pod::queryall<br />/home/hosting_users/miniz/www/library/model/blog.link.php:16 getlinks<br />/home/hosting_users/miniz/www/library/piece/blog/end.php:69 require<br />/home/hosting_users/miniz/www/interface/index.php:84 include_once<br />/home/hosting_users/miniz/www/rewrite.php:90</p> <br /><p> Shutdown&nbsp; 242.9&nbsp; &nbsp; &nbsp;</p><p>46 (45+1 cache) Queries <br />20.2 ms elapsed in db query, overall 242.9 ms elapsed&nbsp; </p><p> path parser result : <br />Array<br />(<br />&nbsp; &nbsp; [host] =&gt; dain2.net<br />&nbsp; &nbsp; [fullpath] =&gt; /riss/<br />&nbsp; &nbsp; [position] =&gt; /rewrite.php<br />&nbsp; &nbsp; [root] =&gt; /<br />&nbsp; &nbsp; [input] =&gt; riss/<br />&nbsp; &nbsp; [URLfragment] =&gt; Array<br />&nbsp; &nbsp; &nbsp; &nbsp; (<br />&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; [0] =&gt; <br />&nbsp; &nbsp; &nbsp; &nbsp; )</p><p>)<br />Array<br />(<br />&nbsp; &nbsp; [url]=&gt; /riss/<br />&nbsp; &nbsp; [value] =&gt; <br />&nbsp; &nbsp; [directive] =&gt; /<br />&nbsp; &nbsp; [page] =&gt; 1<br />)</p>]]></description>
			<author><![CDATA[null@example.com (김민기)]]></author>
			<pubDate>Wed, 26 Nov 2008 08:53:40 +0000</pubDate>
			<guid>http://forum.tattersite.com/ko/viewtopic.php?pid=32260#p32260</guid>
		</item>
	</channel>
</rss>
