[TYPO3] Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /Library/WebServer/Documents/typo3/typo3_src-4.0/t3lib/class.t3lib_db.php on line 814

[Sander van Gelderen]

Vlatko Surlan schreef:
> Sander van Gelderen wrote:
>> Sander van Gelderen schreef:
>>> Hi All,
>>>
>>> I attempted to create an utf-8 installation of Typo3. Now, in the 
>>> list module, I get the following warning at the top of the page:
>>>
>>> Warning: mysql_fetch_row(): supplied argument is not a valid MySQL 
>>> result resource in 
>>> /Library/WebServer/Documents/typo3/typo3_src-4.0/t3lib/class.t3lib_db.php 
>>> on line 814
>>>
>>>
>>> Here are the steps I took:
>>>
>>> 1) create an empty MySQL database. After creation, execute following 
>>> SQL:
>>>     ALTER DATABASE databasename DEFAULT CHARACTER SET utf8 DEFAULT 
>>> COLLATE utf8_general_ci;
>>>
>>> 2) In install tool:
>>>     [SYS][setDBinit] = SET CHARACTER SET utf8; SET NAMES utf8;SET 
>>> SESSION character_set_server=utf8;
>>>     [BE][forceCharset] = utf-8
>>>     [SYS][t3lib_cs_convMethod] = iconv
>>>     [SYS][t3lib_cs_utils] = iconv
>>>
>>>
>>> 3) Now I enter DB credentials in install tool and allow Typo3 to 
>>> create tables, so they are all created as utf-8 tables.
>>>
>>> 4) Main Template setup:
>>>     config.renderCharset = utf-8
>>>
>>>
>>>
>>> What can I do to solve this?
>>>
>>> TIA,
>>>
>>> Sander
>>
>> Sorry, forgot to mention:
>>
>> Typo3: 4.0
>> MySQL: 5.0.19
>> PHP: 5.1.2
> 
> Any extensions on it? I've had a similar error when I installed 
> direct-mail but forgot to install one of it's dependencies.

Hi Vlatko,

I just uninstalled any un-used extensions, this leaves awstats, realurl, templavoila and tt_news, but this makes no difference.

Sander