Re: SQL syntax error when trying to enter forums [message #29421 is a reply to message #29416] |
Mon, 19 December 2005 23:18 |
sommer
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
|
|
|