[TYPO3-project-seminars] sql error, speakers not editable in list view in backend

[Ben Kerner]

Hi Niels,

great tip. It works now, thanks.

But, i don?t understand the error. It works now with this code in the 
ext_tables.php:

$TCA['tx_seminars_speakers'] = array(
 'ctrl' => array(
  'title' => 'LLL:EXT:seminars/locallang_db.xml:tx_seminars_speakers',
  'label' => 'title',
  'tstamp' => 'tstamp',
  'crdate' => 'crdate',
  'cruser_id' => 'cruser_id',
  'default_sortby' => 'title',
  'delete' => 'deleted',
  'dynamicConfigFile' => $extPath.'tca.php',
  'iconfile' => $extIconRelPath.'icon_tx_seminars_speakers.gif'


With a
'default_sortby' => 'ORDER BY title'
like it was before, it doesn?t work.

The other arrays are with 'default_sortby' => 'ORDER BY title'

Greetings
Ben

"Niels Pardon" <mail at niels-pardon.de> schrieb im Newsbeitrag 
news:mailman.1.1237467626.19739.typo3-project-seminars at lists.netfielders.de...
> Hi Ben!
>
> You can activate sqlDebug in the Installtool to get more information
> about failing SQL queries.
>
> Greets,
>
> Niels
>
>
> Ben Kerner schrieb:
>> hi group,
>>
>> if i select the speakers-sysfolder in the typo3 backend with the list 
>> view,
>> a sql error appears:
>>
>> Warning: mysql_num_rows(): supplied argument is not a valid MySQL result
>> resource in /opt/lampp/htdocs/website/t3lib/class.t3lib_db.php on line 
>> 796
>>
>> The speakers aren´t visible in the list. if i try to create a new
>> speaker-entry and enter a name and save: another error appears:  2: SQL
>> error: '' ()
>>
>> In the Seminars-view i can see the speakers, but if i try to delete one, 
>> a
>> sql error appears:
>>
>> 100: You have an error in your SQL syntax; check the manual that 
>> corresponds
>> to your MySQL server version for the right syntax to use near 'ORDER BY
>> title='1000000000' WHERE uid=7' at line 5
>>
>> how can i debug the sql-queries to find out whats wrong?
>>
>> greetings
>> ben
>>
>>
>>