[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 mail at NOSPsandervangelderen.nl
Sat Mar 3 20:37:34 CET 2007


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


More information about the TYPO3-english mailing list