[TYPO3] Can´t validate in Back End (with PHP 5.2.4 and MySql 5)

[Xatu Cans]

Hi everybody, the problem was MySql 5, I found the solution in Typo3 USA 
forum 
(http://www.typo3-usa.com/forum.0.html?&view=single_thread&cat_uid=4&conf_uid=3&thread_uid=72) 
here it is:

"open the mysql .ini file (possibly in the "C:Program FilesMySQLMySQL Server 
5.0" folder). It must be called my.ini if you didnt change it. AND... look 
for this line:

sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
comment it out (put a # in front)
and replace it with this: sql-mode=MYSQL4 "


"Xatu Cans" <xatucans at gmail.com> escribió en el mensaje 
news:mailman.1.1194611446.19277.typo3-english at lists.netfielders.de...
> yes, both are allowed
> "Christopher" <Chrissitopher at gmx.de> escribió en el mensaje 
> news:mailman.1.1194459803.31188.typo3-english at lists.netfielders.de...
>> Hi Xatu,
>>
>> have you allowed cokkies for the new server?
>> And javascript?
>>
>> Christopher
>>
>>
>> "Xatu Cans" <xatucans at gmail.com> schrieb im Newsbeitrag 
>> news:mailman.1.1194453211.23880.typo3-english at lists.netfielders.de...
>>> Hi, I had a Typo3 4.0.4 project running perfectly on my old server and 
>>> I've
>>> tried to change it to a new server (with  PHP 5.2.4 and MySql 5), but it
>>> dosen't work, it has several problems
>>> 1- Front End : it can´t resolve it
>>> 2- Back-End: it opens the BE validation page, but when I try to validate 
>>> in,
>>> it tells me my user name or password are incorrect (I know they are 
>>> correct)
>>> 3- The Install Tool looks to work ok
>>>
>>> I've changed the referer in the Install Toll [SYS][doNotCheckReferer] = 
>>> 0
>>> but it continue in the same way. Does anybody know where the problem is?
>>>
>>>
>>
>>
>>
>
>