[TYPO3-dam] brand new typo3 installation & DAM: only error messages

grac grac at gmx.ch
Tue Feb 3 20:34:34 CET 2009


@dan

maybe this helps to understand or decide whether your suspicion might be 
correct:


Compare with $TCA:
------------------------------------------------------------------------
Comparison between database and $TCA:
Actual and suggested field definitions
This table shows you the suggested field definitions which are 
calculated based on the configuration in $TCA. If the suggested value 
differs from the actual current database value, you should not panic, 
but simply check if the datatype of that field is sufficient compared to 
the data, you want TYPO3 to put there.



tx_dam_cat
Field name: 	Suggested value from $TCA: 	Actual value from database:
hidden 	tinyint(3) NOT NULL default '0' 	tinyint(4) unsigned NOT NULL 
default '0'
fe_group 	blob NOT NULL 	varchar(200) NOT NULL default '0'
title 	tinytext NOT NULL 	text
nav_title 	tinytext NOT NULL 	text
subtitle 	tinytext NOT NULL 	text
keywords 	text NOT NULL 	text
description 	tinytext NOT NULL 	text
parent_id 	blob NOT NULL 	int(11) NOT NULL default '0'
sys_language_uid 	int(11) NOT NULL default '0' 	int(11) NOT NULL default '0'
l18n_parent 	int(11) NOT NULL default '0' 	int(11) NOT NULL default '0'


tx_dam_metypes_avail
Field name: 	Suggested value from $TCA: 	Actual value from database:
type 	int(11) NOT NULL default '0' 	tinyint(4) unsigned NOT NULL default '0'
title 	tinytext NOT NULL 	varchar(60) NOT NULL default ''
parent_id 	int(11) NOT NULL default '0' 	int(11) unsigned NOT NULL 
default '0'


tx_dam_selection
Field name: 	Suggested value from $TCA: 	Actual value from database:
hidden 	tinyint(3) NOT NULL default '0' 	tinyint(4) NOT NULL default '0'
starttime 	int(11) NOT NULL default '0' 	int(11) NOT NULL default '0'
endtime 	int(11) NOT NULL default '0' 	int(11) NOT NULL default '0'
fe_group 	int(11) NOT NULL default '0' 	int(11) NOT NULL default '0'
type 	int(11) NOT NULL default '0' 	int(11) NOT NULL default '0'
title 	tinytext NOT NULL 	text
definition 	text NOT NULL 	text


OS detected: UNIX
UNIX/CGI detected: NO
---------------------------------------------------------------------

stephan


Dan Osipov wrote:
>  > i have checked the ext_tables.sql.
>  > all fields in be_grous, be_users and tt_content are initialised.
>  > also the tables
>  > - tx_dam_cat
>  > - tx_dam_mm_cat
>  > - tx_dam_metypes_avail
>  > - tx_dam_mm_ref
>  > - tx_dam_log_index
>  > - tx_dam_file_tracking
>  > - tx_dam_selection
>  >
>  > but just not tx_dam itself.
> 
> That tells me there might be an issue with MySQL having a problem with a 
> definition of that table. In that case there might be an error it throws 
> when it tries to create that table. Without the detailed error message, 
> its tough to debug (I would have to mimick your install to reproduce the 
> error).
> 
> I know that MySQL 5.1 is a fresh release, and hasn't been battle tested. 
> It's odd for your hosting to upgrade to it...
> 
> Dan Osipov
> Calkins Media
> http://danosipov.com/blog/
> 
> grac wrote:
>> hi martin
>>
>> Martin Holtz wrote:
>>> sometimes it can happen, that you include extensions in the wrong order
>>
>> what do you mean by wrong order?
>> there is nowhere any hint of a necessary installation order of the EXT.
>>
>> i remember from my former catastrophe that someone suggested to 
>> install dam before templavoila.
>> was of no use at all.
>>
>>> and the tx_dam would probably created not from tx_dam. If you install
>>> after that tx_dam, it can lead to such errors.
>>
>> and what would you suggest? remember: it's a brand news installation.
>>
>>
>>> if tx_dam doesnt exists, try to create it by hand.
>>
>> i am an ordinary admin, not a developer.
>> and therefore hesitate to fiddle around with the database itself.
>> on the other hand i would expect an EXT to work well with others.
>> not true?
>>
>>
>>> in the extension folder there should be an *.sql file with create
>>> statements.
>>
>> i have checked the ext_tables.sql.
>> all fields in be_grous, be_users and tt_content are initialised.
>> also the tables
>> - tx_dam_cat
>> - tx_dam_mm_cat
>> - tx_dam_metypes_avail
>> - tx_dam_mm_ref
>> - tx_dam_log_index
>> - tx_dam_file_tracking
>> - tx_dam_selection
>>
>> but just not tx_dam itself.
>>
>>
>>
>>>
>>> perhaps that helps,
>>>
>>> martin
>>>
>>>
>>>
>>



More information about the TYPO3-project-dam mailing list