[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

[Vlatko Surlan]

Sander van Gelderen wrote:
> 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


There is a flag somewhere in the installer that will output any failing 
queries. Turn that on and post the query. You'll probably figure out 
whats wrong as soon as you see the query.