Ticket #330 (closed defect: fixed)

Opened 6 months ago

Last modified 5 months ago

ELGG 0.9.1 - MySQL5.0 out-of-the-box problems

Reported by: joerosa Assigned to: misja
Priority: normal Milestone: 0.9.2
Component: core Version: 0.9.0
Severity: normal Keywords:
Cc: dramirez, rho, renato, timh, ewout Patch Included: 1
Review Stage: needinfo

Description (Last modified by misja)

I'm having problems to install ELGG 0.9.1 - wsan't able to pin-down the issues yet, but this post in the forum is one of them:

======

# CommentAuthor?: lazybadger (http://elgg.org/mod/vanillaforum/vanilla/comments.php?DiscussionID=1046&page=1#Item_0) posted in the forum.

====

On installing Elgg on my host with MySQL "Server version: 5.0.51a-community-nt MySQL Community Edition" I got permanent errors on one table - ***_messages. Short exploration of trouble give me correct syntax (at least for my version). Diff shown below

--- mysql-orig.sql Mon May 14 00:11:32 2007 +++ mysql.sql Thu Feb 21 18:51:14 2008 @@ -496,8 +496,8 @@

CREATE TABLE prefix_messages ( ident int(11) NOT NULL auto_increment, - title text NOT NULL default , - body text NOT NULL default , + title text NOT NULL, + body text NOT NULL, from_id int(11) NOT NULL, to_id int(11) NOT NULL, posted int(11) NOT NULL,

Attachments

mysql.diff (476 bytes) - added by joerosa on 03/15/08 14:11:50.
MySQL - diff

Change History

(follow-up: ↓ 3 ) 03/13/08 11:14:37 changed by misja

  • status changed from new to assigned.
  • description changed.
  • cc set to dramirez, rho, renato, timh, ewout.
  • review_stage changed from unreviewed to needinfo.
  • milestone changed from 0.9.1 to 0.9.2.
  • owner changed from nobody to misja.

Have you tested if this change will work for version 4 too? Plus, please attach the patch as a file attachment :)

03/15/08 14:11:50 changed by joerosa

  • attachment mysql.diff added.

MySQL - diff

03/15/08 14:15:01 changed by joerosa

MySQL documentation states clearly:

"BLOB and TEXT columns cannot have DEFAULT values."

version 4: http://dev.mysql.com/doc/refman/4.1/en/blob.html

version 5: http://dev.mysql.com/doc/refman/5.0/en/blob.html

(in reply to: ↑ 1 ) 03/17/08 09:10:31 changed by lazybadger

  • haspatch set to 1.

Replying to misja:

Have you tested if this change will work for version 4 too?

It must work (according to docs) in 4.1 too, but I installed today Elgg with patched sql on a box with MySQL version 4.1.22-standard - and it's OK, work as expected

03/17/08 09:20:38 changed by misja

  • cc changed from dramirez, rho, renato, timh, ewout to dramirez, rho, renato, timh, ewout.
  • status changed from assigned to closed.
  • resolution set to fixed.

Thanks for testing, patch applied in r1567