[TYPO3-ttnews] error: Invalid database result resource detected
Philipp Gampe
phil at philippgampe.info
Thu Dec 17 23:01:51 CET 2009
Ok, here you go....
TYPO3 4.3.0
PHP 5.2.99 on {1}
PHP 5.3.0 on {2}
for {2} please the attached debug output from install tool (phpinfo)
tt_news 3.0.1 (latest from TER)
errors are equal
error rows in equal the total of all assigned categories to all news
displayed (or listed in list view)
so if news A with cat a,b,c and news B with cat b,c,d is shown, I get 6
errors
error row: (devlog)
tt_news || EMPTY $catlist (tx_ttnews_div::getSubCategories) ||
class.tx_ttnews_div.php, Zeile 110
this is what I get per mail (two mail per row in devlog):
Invalid database result resource detected: function
t3lib_DB->sql_fetch_assoc called from file
po3conf/ext/tt_news/lib/class.tx_ttnews_div.php in line 121. Use a devLog
extension to get more details.
Invalid database result resource detected: function
t3lib_DB->sql_free_result called from file
po3conf/ext/tt_news/lib/class.tx_ttnews_div.php in line 131. Use a devLog
extension to get more details.
{1} is a bigger site with pretty massed up configuration, but error is
equal on {2}
setup and template on {2}
the category tree is flat, meaning there are no subcategories
pagetree
--root (shortcut to blog)
----blog (news latest)
------single (hidden, single view)
------archive (archive menu, list view)
----cal (with a some subpages)
----records
------news (holds categories as well as news)
------cal and some other like feusers
root template:
constants:
styles.content.imgtext.maxWInText = 0
styles.content.imgtext.linkWrap.width = 800
styles.content.uploads.filesizeBytesLabels = " B| KB| MB| GB"
styles.content.loginform.pid = 0
-----------------------------------------------------
setup:
config {
baseURL = http://typo3.philippgampe.info
tx_realurl_enable = 1
sendCacheHeaders = 1
sendCacheHeaders_onlyWhenLoginDeniedInBranch = 1
doctype = <!DOCTYPE html>
xhtmlDoctype = xhtml_strict
xmlprologue = xml_10
xhtml_cleaning = all
htmlTag_langKey = de_DE
htmlTag_dir = ltr
locale_all = de_DE
language = de
removeDefaultJS = external
inlineStyle2TempFile = 1
meaningfulTempFilePrefix = 1
spamProtectEmailAddresses = ascii
noScaleUp = 1
pageTitleFirst = 1
moveJsFromHeaderToFooter = 1
admPanel = 0
} #config
# Default PAGE object:
page = PAGE
# main Menu
page.10 = HMENU
page.10 {
#entryLevel = 0
special = directory
special.value = 4
wrap = <nav id="menu">|</nav>
1 = TMENU
1 {
wrap = <ul>|</ul>
expAll = 1
noBlur = 1
showAccessRestrictedPages = 12
NO = 1
NO {
wrapItemAndSub = <li>|</li>
ATagTitle.field = title // abstract // description
} #page.10.1.NO
} #page.10.1
2 < .1
3 < .1
} #page.10
# main content
page.20 < styles.content.get
-----------------------------------------------------
constants for page where news plugin is inserted
plugin.tt_news.pid_list = 8
plugin.tt_news.singlePid = 11
plugin.tt_news.backPid = 7
plugin.tt_news.latestLimit = 5
plugin.tt_news.displaySubCategories = 1
plugin.tt_news.displayXML.xmlLink = http://typo3.philippgampe.info
plugin.tt_news.displayXML.xmlDesc = Letzte Posts von Philipp Gampe
plugin.tt_news.displayXML.xmlLang = de
plugin.tt_news.displayXML.xmlTitle = Philipp Gampe
plugin.tt_news.archiveTypoLink.parameter = 13
plugin.tt_news.limit = 10
plugin.tt_news.showCatRootline = 1
plugin.tt_news.showRelatedNewsByCategory = 1
plugin.tt_news.useMultiPageSingleView = 1
plugin.tt_news.datetimeDaysToArchive = 60
plugin.tt_news.displayCatMenu.showNewsCountForCategories = 1
------------------------------------------------------------------
apart from that, there is no special configuration on {2}
### DEBUG SYSTEM INFORMATION - START ###
HTTP_HOST : typo3.philippgampe.info
TYPO3_HOST_ONLY : typo3.philippgampe.info
TYPO3_PORT :
PATH_INFO :
QUERY_STRING : TYPO3_INSTALL[type]=phpinfo
REQUEST_URI : /typo3/install/index.php?TYPO3_INSTALL[type]=phpinfo
HTTP_REFERER :
http://typo3.philippgampe.info/typo3/install/index.php?TYPO3_INSTALL[type]=about
TYPO3_REQUEST_HOST : http://typo3.philippgampe.info
TYPO3_REQUEST_URL :
http://typo3.philippgampe.info/typo3/install/index.php?TYPO3_INSTALL[type]=phpinfo
TYPO3_REQUEST_SCRIPT:
http://typo3.philippgampe.info/typo3/install/index.php
TYPO3_REQUEST_DIR : http://typo3.philippgampe.info/typo3/install/
TYPO3_SITE_URL : http://typo3.philippgampe.info/
TYPO3_SITE_SCRIPT : typo3/install/index.php?TYPO3_INSTALL[type]=phpinfo
TYPO3_SSL :
TYPO3_REV_PROXY :
SCRIPT_NAME : /typo3/install/index.php
TYPO3_DOCUMENT_ROOT : /kunden/xxxxxxxxxxxx/webseiten/philippgampe/typo3
SCRIPT_FILENAME :
/kunden/xxxxxxxxxxxx/webseiten/philippgampe/typo3/typo3/install/index.php
REMOTE_ADDR : 89.0.146.194
REMOTE_HOST :
HTTP_USER_AGENT : Mozilla/5.0 (X11; U; Linux x86_64; de; rv:1.9.1.5)
Gecko/20091109 Ubuntu/9.10 (karmic) Firefox/3.5.5
HTTP_ACCEPT_LANGUAGE: de-de,de;q=0.8,en-us;q=0.5,en;q=0.3
CONST: PHP_OS : Linux
CONST: TYPO3_OS :
CONST: PATH_thisScri:
/kunden/268799_53125/webseiten/philippgampe/typo3/typo3/install/index.php
CONST: php_sapi_name: cgi-fcgi
OTHER: TYPO3_VERSION: 4.3.0
OTHER: PHP_VERSION : 5.3.0
imagecreatefromgif(): 1
imagecreatefrompng(): 1
imagecreatefromjpeg(: 1
imagegif() : 1
imagepng() : 1
imagejpeg() : 1
imagettftext() : 1
OTHER: IMAGE_TYPES : 15
OTHER: memory_limit : 256m
SERVER: SERVER_PORT : 80
SERVER: SERVER_SOFTW: Apache/1.3 (Unix) mod_ssl/2.8.28 OpenSSL/0.9.8f
AuthPG/1.3 FrontPage/5.0.2.2635
SERVER: GATEWAY_INTE: CGI/1.1
SERVER: SCRIPT_NAME : /typo3/install/index.php
SERVER: PATH_TRANSLA:
T3CV_GFX: image_proc: 1
T3CV_GFX: gdlib : 1
T3CV_GFX: gdlib_png : 1
T3CV_GFX: gdlib_2 : 2
T3CV_GFX: im : 1
T3CV_GFX: im_path : /usr/bin/
T3CV_GFX: im_path_lz:
T3CV_GFX: im_version: gm
T3CV_GFX: im_negate_: 0
T3CV_GFX: im_imvMask: 0
T3CV_GFX: im_combine:
### DEBUG SYSTEM INFORMATION - END ###
hope it helps a bit
btw. can also have BE and FTP access if you want, just drop me an email at
mailto:t3_news at philippgampe.info
Best regards
Phil
More information about the TYPO3-project-tt-news
mailing list