[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