Skip to:

Opened 5 years ago

Closed 4 years ago

#1486 closed defect (fixed)

SQL syntax error with MySQL 5.5

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


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: ("The older TYPE option was synonymous with"...)

Backwards-compatible (MySQL 4.0 onwards) patch attached.

Attachments (1)

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

Download all attachments as: .zip

Change History (8)

5 years ago

#1 @mr_pelle
5 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
5 years ago

this bug also occurs in 1.0.x

#3 @GautamGupta
5 years ago

  • Cc gautam.2011@… added

#4 @liping
5 years ago

  • Cc… added

#5 @mr_pelle
5 years ago

  • Severity changed from critical to blocker

Is anybody still caring about this??

#6 @herzcthu
4 years ago

I got that error in 1.0.3 with MySql 5.5.12

#7 @johnjamesjacoby
4 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.