[TYPO3] install tool doesn't update database

Joerg Wagner jwagner at digilog.de
Wed Apr 25 19:31:16 CEST 2007


does the install tool show you something like
    ALTER TABLE be_groups CHANGE title title varchar(50) NOT NULL default 
    Current value: varchar(50) binary default ''
(Note the "binary" in the Current value line)

If so you have probably set the collation of your Typo3 MySQL db to 
The install tool is not prepared for that. Try to change the collation of 
the DB and of all tables and columns to something like latin1_german1_ci .
Best way to do this:
Dump the db,
erase all occurrences of  "COLLATE latin1_bin",
change all occurrences of  "COLLATE=latin1_bin" to 
delete all tables from the db and reimport.

Hope that helps.
Jörg Wagner.

"Christoph Koehler" <christoph.koehler at gmail.com> schrieb im Newsbeitrag 
news:mailman.1.1173231574.5216.typo3-english at lists.netfielders.de...
> Hello there,
> This is a problem I have had for a while: I cannot update the db from the 
> install tool compare. Using TYPO3 4.1 now, MySQL 5.0.22, PHP 5.1.2, Apache 
> 2.0.55.
> It reloads the page, but the modifications are still there to be executed. 
> Checking the db with phpmyadmin confirms no changes.
> Thanks!
> Christoph 

More information about the TYPO3-english mailing list