phpGroupWare - Bugs: bug #20284, Upgrade to MySQL 5.x causes MySQL...
You are not allowed to post comments on this tracker with your current authentication level.
bug #20284: Upgrade to MySQL 5.x causes MySQL 1064 error when opening individual Forums.
Submitter: | Robert <burnttoast> | ||
Submitted: | Wed 27 Jun 2007 09:36:13 PM UTC | ||
Item Group: | 0.9.16.011 | Category: | phpgw-FUDForum |
Severity: | 3 - Normal | Priority: | 9 - Immediate |
Status: | None | Privacy: | Public |
Assigned to: | None | Open/Closed: | Open |
Component Version: | SVN | Operating System: | GNU/Linux - Debian |
Reproducibility: | Every Time | Planned Release: | None |
Fixed Release: |
No files currently attached
Depends on the following items: None found
Items that depend on this one: None found
Carbon-Copy List
There are 0 votes so far. Votes easily highlight which items people would like to see resolved in priority, independently of the priority of the item set by tracker managers.
No changes have been made to this item
I upgraded to MySQL 5.0.32 from the 4.x series. After the upgrade (and a cvs update) I could not enter any of the forums.
My installation was working great before the upgrade, but I have already solved the issue I ran across.
After upgrading to MySQL 5.0.32 I got an error which read:
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
Apparently the term "reads" in this query is supposed to be used to assemble the list in some fashion, but as of sometime in the MySQL 5.x series the word "reads" became a reserved word or function which MySQL attempts to process directly. Changing the word "reads" to "pulled" (or any other non-reserved/special word) in these queries takes care of this problem immediately.
I found the term reads in these files:
../fudforum/setup/base/src/forumsel.inc.t: Line 38:
../fudforum/theme/default/msg.php: Line 98:
../fudforum/theme/default/thread.php: Line 26:
../fudforum/theme/default/threadt.php: Line 26:
../fudforum/theme/default/tree.php: Line 110:
and changed it to "pulled" and now the installation works as intended.