[TYPO3-dam] brand new typo3 installation & DAM: only error messages PROBLEM SOLVED
grac
grac at gmx.ch
Mon Feb 9 16:51:17 CET 2009
@peter
Peter Kuehn [wmdb] wrote:
> so - if I got that right the problem was using multiplyDBfieldSize > 1
> on a db set to utf-8 without reading
> http://wiki.typo3.org/index.php/UTF-8_support as suggested in the
> install tool ;)
right.
it was definitely the EXT db_ttv which had multiplyDBfieldSize = 2 in
it's full package (localconf.php).
i missed to check this special value because i knew from the developer
himself since a year that setting multiplyDBfieldSize > 1 in combination
with utf-8 would be a waste of space (yaml forum - i never thought that
the same developer would change his mind?!).
what i didn't know before this thread was that dam wouldn't create its
own table, depending on this wrong setting.
> > maybe a hint in the dam-documentation could help?!
> as this is no dam but a general problem imho this would go beyond the
> scope of documenting a particular extension.
>
> @uschi: what do you think?
since all other tables RE the EXT dam were created in the first round,
but only tx_dam itself was not created, maybe it would be worth a hint?!
> > please tell this my webhoster.
> > i'm sure he has an answer for you.
> this goes definately beyond the scope :D
this was just a joke from my side :-)
thanks for answering
stephan
>
> gRTz
> pekue
>
> grac schrieb:
>> hi everybody
>>
>> problem solved - table tx_dam created!
>>
>> it was in the end not complicated.
>> the problem was to find the right hints:
>>
>>
>> 1. a thread in the forum
>>
>> "TYPO3.net - DAM Tabelle tx_dam läßt sich nicht installieren"
>> (title: table tx_dam cannot be created), to find under
>>
>> http://www.typo3.net/forum/list/list_post//84965/?page=1&sword=dam#pid317649
>>
>>
>> from 12.12.2008, which included the same additional compare-statement
>> i had and didn't seem related to dam:
>>
>> Add fields
>> ALTER TABLE sys_refindex ADD KEY lookup_string
>> (ref_table,ref_string(400));
>>
>> Add tables CREATE TABLE tx_dam (
>> uid int(11) NOT NULL auto_increment,
>> pid int(11) NOT NULL default '0',
>> tstamp int(11) unsigned NOT NULL default '0',
>> ....
>>
>>
>> 2. a response in this thread which referred to a link about the
>> problem with sys_refindex:
>>
>> "sys_refindex ref_string(400)-Problem"
>>
>> http://typo3.sfroemken.de/index.php?id=4&tx_ttnews
>> [tt_news]=19&tx_ttnews[year]=2009&tx_ttnews
>> [month]=01&tx_ttnews[day]=29&cHash=ebd94d2b9f
>>
>> this link leaded to ...
>>
>>
>> 3. a blog-entry from stefan frömken, dated 29.01.2009
>>
>> which dealt with the correct utf-8 implementation in a new typo3
>> installation.
>> under others it says that the variable "multiplyDBfieldSize" should
>> have the value of = 1
>>
>>
>> 4. a check in my all-configuration showed that i had
>> "multiplyDBfieldSize = 2" (no idea where it came from - maybe from the
>> EXT db_ttv).
>> this entry leaded the author to sys_refindex/ref_string(400) as
>> described under 1.
>>
>>
>> 4. after deleting the value = 2 the comparison finally allowed to
>> create the table tx_dam and all the necessary fields.
>> (and all the other necessary fields in other tables.)
>>
>>
>> 5. a second round finally allowed to change the
>>
>> ALTER TABLE sys_refindex ADD KEY lookup_string...
>>
>>
>>
>> so finally dam is now to be used.
>> and there are no MySQL error messages or warnings any more.
>>
>>
>>
>> i wrote this in full length for others who have the same problem as i
>> had.
>>
>> so it was not dam nor MySQL, but an incorrect value of a totally
>> different variable!
>> maybe a hint in the dam-documentation could help?!
>>
>>
>> @georg
>>
>>> PS: FULL-ACK to 5.1-RC in production-envs; upgrading to rc-versions
>>> with the excuse of "security" seems pretty stupid to me;
>>
>> please tell this my webhoster.
>> i'm sure he has an answer for you.
>>
>>
>> stephan
More information about the TYPO3-project-dam
mailing list