Great. So I try and do things all properly-like, using migrate scripts to make the data­base and stuff, and it goes and dies on me.

josh@whisper:~/public_html/XX/db/migrate$ rake migrate
(in /home/josh/public_html/XX)
rake aborted!
You have an error in your SQL syntax.  Check the manual that corresponds
to your MySQL server version for the right syntax to use near
'desc varchar(255)) ENGINE=InnoDB' at line 1:
CREATE TABLE courses (id int(11) DEFAULT NULL auto_increment
PRIMARY KEY, name varchar(255), desc varchar(255)) ENGINE=InnoDB
./Rakefile:200

Nyaaaah. I think it’s coz I’m using the only ver­sion of Ruby that the Rails team don’t recommend:

We rec­om­mend Ruby 1.8.4 for use with Rails. Ruby 1.8.2 is fine too, but ver­sion 1.8.3 is not.

Hah. Yeah, I’m using 1.8.3. It’s Ubuntu’s fault! That’s just what hap­pened to be sit­ting in stu­pid apt repos­i­to­ries. So now I need to add back­ports to an otherwise-clean com­puter. *shud­ders* Well, I guess the alter­na­tive is com­pil­ing and try­ing to stay on top of all that… *Josh is seen hur­riedly run­ning to add back­ports sources*

Well, maybe not tonight. *wan­ders off to post on τρανσλιτερατιον before sleeping*

Tags: HTML, SQL, Ubuntu