[Typo3] chc_forum no first post

Stefanos Demetriou mougias at gamers-cy.com
Sun Feb 27 21:40:29 CET 2005


many thanks

----- Original Message ----- 
From: "Zach Davis" <zach at castironcoding.com>
Newsgroups: typo3.english
To: <typo3-english at lists.netfielders.de>
Sent: Sunday, February 27, 2005 5:51 AM
Subject: Re: [Typo3] chc_forum no first post


> 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
>>>
>>
> _______________________________________________
> Typo3-english mailing list
> Typo3-english at lists.netfielders.de
> http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-english
> 




More information about the TYPO3-english mailing list