[Typo3] chc_forum no first post

[Zach Davis]

Stefanos,

I looked at your installation this morning. I found (and fixed) the 
problem, although I'm not exactly sure why it's happening. I guess this 
could be called a bug in the forum, or maybe more accurately, it's the 
lack of a feature...

anyhow, the problem was cause by a few lines in the form class, which 
contained "mysql_insert_id" (used to get the UID of the thread that was 
created so it can be added to the post). For some reason, this function 
doesn't actually return the insert ID on your server. I'm not sure why 
this is the case, but it is.

Anyhow, since the forum strives for DB compatibility, I try to always 
use the typo3 DB API for any database transactions. I wrote the forum 
before the DB API was finished, so there are still a few places where I 
failed to update the mysql functions to use the typo3 interface -- this 
was one of them. By changing mysql_insert_id to use the DB wrapper:

$GLOBALS['TYPO3_DB']->sql_insert_id()

The problem seems to have been solved, since the function does work with 
the DB wrapper. I'm writing this here in case someone else is having 
this problem; I'll fix it for the next release.

best,
Zach

-- for some reason, mysql_insert_id and mysql_affected_rows

Stefanos Demetriou wrote:
> I went browsing through the database and saw that when posting a new 
> thread it does not link the post record in tx_chcforum_post to the 
> thread record in in tx_chcforum_thread via the thread_id column.  This 
> works ok however when posting a reply to the thread.
> 
> ----- Original Message ----- From: "Zach Davis" <zach at castironcoding.com>
> Newsgroups: typo3.english
> To: <typo3-english at lists.netfielders.de>
> Sent: Saturday, February 26, 2005 7:31 AM
> Subject: Re: [Typo3] chc_forum no first post
> 
> 
>> Stefanos Demetriou wrote:
>>
>>> Hi
>>>
>>> I am having trouble with chc_forum as it doesn't show me the first 
>>> post of any given thread.  I can only see from the first reply and 
>>> afterwards.
>>>
>>> Has anyone witnessed this before?
>>
>>
>> Do the records for the first posts exist, or were they deleted?
>>
>> Zach
>> _______________________________________________
>> Typo3-english mailing list
>> Typo3-english at lists.netfielders.de
>> http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-english
>>
>