Skip to:
Content

bbPress.org

Opened 14 years ago

Closed 14 years ago

#1486 closed defect (bug) (fixed)

SQL syntax error with MySQL 5.5

Reported by: djpaul's profile DJPaul Owned by:
Milestone: 1.1 Priority: normal
Severity: blocker Version: 1.1-alpha
Component: API - Installation/Upgrade Keywords: has-patch
Cc: gautam.2011@…, liping.ong@…

Description

The CREATE TABLE ... TYPE = MYISAM syntax has been removed in MySQL 5.5. This is causing invalid SQL which is preventing bbPress from installing properly. This was initially reported on the ​BuddyPress forums.

Source: ​dev.mysql.com ("The older TYPE option was synonymous with"...)

Backwards-compatible (MySQL 4.0 onwards) patch attached.

Attachments (1)

1486.patch​ (500 bytes) - added by DJPaul 14 years ago.

Download all attachments as: .zip

Change History (8)

@DJPaul
14 years ago

#1 @mr_pelle
14 years ago

  • Milestone set to 1.1
  • Severity changed from normal to critical
  • Version set to 1.1-alpha

I can confirm this bug to exist. Thank you so much for the patch!!

#2 @ramoonus
14 years ago

this bug also occurs in 1.0.x

#3 @GautamGupta
14 years ago

  • Cc gautam.2011@… added

#4 @liping
14 years ago

  • Cc liping.ong@… added

#5 @mr_pelle
14 years ago

  • Severity changed from critical to blocker

Is anybody still caring about this??

#6 @herzcthu
14 years ago

I got that error in 1.0.3 with MySql 5.5.12

#7 @johnjamesjacoby
14 years ago

  • Resolution set to fixed
  • Status changed from new to closed

(In [3370]) Fix MySQL installation error with table type MYISAM in 5.5 and above. Props !DJPaul. Fixes #1486. (trunk)

Note: See TracTickets for help on using tickets.