[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:34:45 CET 2007
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
More information about the TYPO3-english
mailing list