bugphpGroupWare - 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
Category:  phpgw-FUDForum Item Group:
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: 

Wed 27 Jun 2007 09:36:13 PM UTC, original submission:  

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.

Robert <burnttoast>


(Note: upload size limit is set to 16384 kB, after insertion of the required escape characters.)

No files currently attached


Depends on the following items: None found

Items that depend on this one: None found


Carbon-Copy List
  • -email is unavailable- added by burnttoast (Submitted the item)

    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

    Back to the top

    Powered by Savane 3.13-4b48.
    Corresponding source code