[TYPO3] SOLVED: 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:
>> 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.

Vlatko,

Thanks very much for your advice.

I set
[SYS][sqlDebug] = 1
in installer, and the error reported table static_taxes missing, my static_info_tables needed updating from 1.8 -> 2.0.2, problem solved.

cheers,

Sander