[TYPO3-english] changing databank -old was in latin1 and new is in utf-8

[Rupali]

from fe debug following came out:
caller   t3lib_DB::exec_INSERTquery
ERROR  Data too long for column 'ident' at row 1
lastBuiltQuery  INSERT INTO cache_hash
(
hash,
content,
ident,
tstamp
) VALUES (
'c9d335b01e8834f5899a863dfb217bc0',
'a:10:{s:32:\"802db22dc926beea3a45d18f524e18b1\";s:23:\"[compatVersion =
4.2.0]\";s:32:\"338e394457c2db162483324451f05ded\";s:23:\"[compatVersion =
3.9.0]\";s:32:\"41428859d35690400a615c4ebfa39dc3\";s:15:\"[loginUser =
*]\";s:32:\"872bdb82d5e14e1fca7a0fa4dc1a5f36\";s:19:\"[globalVar=LIT:0<1]\";s:32:\"c790644fc9440e7f54519217aab557d0\";s:85:\"[userFunc
= user_powermailOnCurrentPage()] && [globalVar = LIT:prototype =
prototype]\";s:32:\"15d056efa2cee5af7825b4e9cb7de1a4\";s:82:\"[userFunc =
user_powermailOnCurrentPage] && [globalVar = LIT:mootools =
prototype]\";s:32:\"454c5905c41719b95b9d1c807cc533e7\";s:21:\"[globalVar =
GP:L =1]\";s:32:\"60f399dfa6cf364dde7f7c7d9f4fd658\";s:15:\"[treeLevel =
1]\";s:32:\"5916e85ed947629628fa0f90443f9d8c\";s:22:\"[globalVar = GP:L =
1]\";s:32:\"7359f6e0719130196c27365bfa4f0503\";s:22:\"[globalVar = GP:L =
0]\";}',
'TMPL CONDITIONS - ALL',
'1237981616'
)
debug_backtrace  require#76 // tslib_fe->getConfigArray#386 //
t3lib_TStemplate->start#2005 // t3lib_pageSelect->storeHash#377 //
t3lib_DB->exec_INSERTquery#965 // t3lib_DB->debug#181
Warning: Cannot modify header information - headers already sent by (output
started at /www/domain.com/htdocs/t3lib/class.t3lib_db.php:1140) in /www/
domain.com/htdocs/typo3/sysext/cms/tslib/class.tslib_fe.php on line 3226

 :(

2009/3/25 Rupali <rupali.ffm at googlemail.com>

> Hello list,
>
> After almost completing our Project, we came to know that the Databank
> used was in latin1. as utf-8 was needed, our provider imported all data
> from
> old databank to new one with utf-8.
>
> from install tool-> localconf.php , we changed the the values of
> $typo_db_username
> $typo_db_password
> $typo_db_host
> to new ones. And from  Admin tools-> Db check -> updated the reference
> index.
>
> but now it seems nothing working in project. when editor wants to create
> new
> page, following warnings and error came:
>
> *Warning*: mysql_fetch_assoc(): supplied argument is not a valid MySQL
> result resource in */www/domain.com/htdocs/t3lib/class.t3lib_db.php* on
> line
> *809*
>
> *Warning*: reset()
> [function.reset<http://agentur-pp.com/typo3/function.reset>]:
> Passed variable is not an array or object in */www/
>
> domain.com/htdocs/typo3conf/ext/mc_autokeywords/class.tx_mcautokeywords.php*on
> line
> *228*
>
> *Warning*: Variable passed to each() is not an array or object in */www/
>
> domain.com/htdocs/typo3conf/ext/mc_autokeywords/class.tx_mcautokeywords.php*on
> line
> *229*
>
> *Warning*: mysql_fetch_assoc(): supplied argument is not a valid MySQL
> result resource in */www/domain.com/htdocs/t3lib/class.t3lib_db.php* on
> line
> *809*
> *Errors:* 2: SQL error: 'Field 'tx_templavoila_flex' doesn't have a default
> value' (pages:NEW49ca16e52e920)
>
>  so we cant create new sites and new page contents.
>
> Pls help.
>
>
>
> Regards,
>
> Rupali
> _______________________________________________
> TYPO3-english mailing list
> TYPO3-english at lists.netfielders.de
> http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-english
>