[TYPO3-ttnews] error: Invalid database result resource detected

Thu Jan 21 20:51:27 CET 2010

Hi Philipp,

I came across the same error. I believe I track down the bug to this:

in /pi/class.tx_ttnews.php somewhere around line 2444 there is a line

$subcats = implode(',', array_unique(explode(',', 
tx_ttnews_div::getSubCategories($row[0]['uid'], $addWhere))));

changing it to

$subcats = implode(',', array_unique(explode(',', 
tx_ttnews_div::getSubCategories($rows[0]['uid'], $addWhere))));

solved the problem for me. Hope this helps you.

Regards, Lukas Stancik

Dne 17.12.2009 23:01, Philipp Gampe napsal(a):
> 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