FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » General » FUDforum in eGroupWare » SQL syntax error when trying to enter forums
Show: Today's Messages :: Polls :: Message Navigator
Return to the default flat view Create a new topic Submit Reply
Re: SQL syntax error when trying to enter forums [message #29421 is a reply to message #29416] Mon, 19 December 2005 23:18 Go to previous messageGo to previous message
sommer is currently offline  sommer   Denmark
Messages: 21
Registered: December 2005
Location: Denmark
Karma:
Junior Member
I have not been able to locate the thread_common.inc.t file you mentioned above and although there is a file named thread_view_common.inc.t I don't think this is the one you have in mind as it does not contain the query mentioned above.

However, I did make the FUDforum work by altering ../theme/default/thread.php and ../theme/default/msg.php, although I know this is not recommended.

msg.php and thread.php have been changed like this:
- $c = q('SELECT f.id, f.name, c.name, c.id, CASE WHEN '.$GLOBALS['usr']->last_read.' < m.post_stamp AND (fr.last_view IS NULL OR m.post_stamp > fr.last_view) THEN 1 ELSE 0 END AS reads

+ $c = q('SELECT f.id, f.name, c.name, c.id, CASE WHEN '.$GLOBALS['usr']->last_read.' < m.post_stamp AND (fr.last_view IS NULL OR m.post_stamp > fr.last_view) THEN 1 ELSE 0 END AS laesninger

These changes make the FUDforum work (at least I haven't found any errors yet), which made me think that the queries I needed to alter could be found in thread.php.t and msg.php.t recpectively, but that was not the case. Where can I find the right queries?

/Henrik


[Message index]
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Error 404 in eGroupware
Next Topic: Migrating issues
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Nov 08 14:20:47 GMT 2024

Total time taken to generate the page: 0.06101 seconds