[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