Opened 2 years ago

Closed 22 months ago

#1486 closed defect (fixed)

SQL syntax error with MySQL 5.5

Reported by: DJPaul Owned by:
Priority: normal Milestone: 1.1
Component: Installation/Upgrade Version: 1.1-alpha
Severity: blocker 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 2 years ago.

Download all attachments as: .zip

Change History (8)

DJPaul — 2 years ago

comment:1   mr_pelle — 2 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   ramoonus — 2 years ago

this bug also occurs in 1.0.x

comment:3   GautamGupta — 2 years ago

  • Cc gautam.2011@… added

comment:4   liping — 2 years ago

  • Cc liping.ong@… added

comment:5   mr_pelle — 2 years ago

  • Severity changed from critical to blocker

Is anybody still caring about this??

comment:6   herzcthu — 2 years ago

I got that error in 1.0.3 with MySql? 5.5.12

comment:7   johnjamesjacoby — 22 months 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.