bugphpGroupWare - Bugs: bug #20284, Upgrade to MySQL 5.x causes MySQL...

 
 

You are not allowed to post comments on this tracker with your current authentification level.

bug #20284: Upgrade to MySQL 5.x causes MySQL 1064 error when opening individual Forums.

Submitted by:  Robert <burnttoast>
Submitted on:  Wed 27 Jun 2007 09:36:13 PM UTC  
 
Item Group: 0.9.16.011Category: phpgw-FUDForum
Severity: 3 - NormalPriority: 9 - Immediate
Status: NonePrivacy: Public
Assigned to: NoneOpen/Closed: Open
Component Version: SVNOperating System: GNU/Linux - Debian
Reproducibility: Every TimePlanned 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>

 

No files currently attached

 

Depends on the following items: None found

Items that depend on this one: None found

 

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

    Do you think this task is very important?
    If so, you can click here to add your encouragement to it.
    This task has 0 encouragements so far.

    Only logged-in users can vote.

     

    Please enter the title of George Orwell's famous dystopian book (it's a date):

     

     

    No Changes Have Been Made to This Item

    Back to the top


    Powered by Savane 3.1-cleanup