Package: phpgroupware-fudforum Version: 0.9.16.011-3 After upgrading to Version 0.9.16.011-3 I only get blank pages as normal user. Amins get a SQL-error-message like
---snipp 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'reads FROM phpgw_fud_fc_view v INNER JOIN phpgw_fud_forum f ON f.id=v.f ' at line 1 Query: SELECT f.id, f.name, c.name, c.id, CASE WHEN 0 < m.post_stamp AND (fr.last_view IS NULL OR m.post_stamp > fr.last_view) THEN 1 ELSE 0 END AS reads FROM phpgw_fud_fc_view v INNER JOIN phpgw_fud_forum f ON f.id=v.f INNER JOIN phpgw_fud_cat c ON c.id=v.c LEFT JOIN phpgw_fud_msg m ON m.id=f.last_post_id LEFT JOIN phpgw_fud_forum_read fr ON fr.forum_id=f.id AND fr.user_id=2 ORDER BY v.id ---snapp Therefore I change in /usr/share/phpgroupware/fudforum/setup/base/src/forumsel.inc.t the line THEN 1 ELSE 0 END AS reads to THEN 1 ELSE 0 END AS myreads and it works. 2. But after change password normal users cant create new posts (or answers). The get a message: "unknown URL". When I set in the table phpgw_fud_users the value users_opt from 6454262 to 4357110 (over mysql-admin) then the users can work normaly. I'm using debian etch/testing with kernel 2.6.12.5 mysql-server 5.0.32-7etch1 With regards Andreas Matthus
smime.p7s
Description: S/MIME cryptographic signature
