Skip to:
Content

Opened 3 years ago

Closed 3 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: 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 3 years ago.

Download all attachments as: .zip

Change History (8)

DJPaul3 years ago

comment:1 mr_pelle3 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!!

comment:2 ramoonus3 years ago

this bug also occurs in 1.0.x

comment:3 GautamGupta3 years ago

  • Cc gautam.2011@… added

comment:4 liping3 years ago

  • Cc liping.ong@… added

comment:5 mr_pelle3 years ago

  • Severity changed from critical to blocker

Is anybody still caring about this??

comment:6 herzcthu3 years ago

I got that error in 1.0.3 with MySql 5.5.12

comment:7 johnjamesjacoby3 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.