I'm getting following error on saving Skills in the book example of chapter 6.

Couldn't run query: SELECT "Skill"."ClassName", "Skill"."Created", "Skill"."LastEdited", "Skill"."Title", "Skill"."ID", CASE WHEN "Skill"."ClassName" IS NOT NULL THEN "Skill"."ClassName" ELSE 'Skill' END AS "RecordClassName" FROM "Skill" WHERE (`Skill`.`Title` = "HTML") LIMIT 1 Unknown column 'HTML' in 'where clause'
Line 526 of MySQLDatabase.php

If I copy this in SQLYog and execute, it says the same. After changing double quotes into single qoutes (" in to ') it works all right.

Gerard

Problem SOLVED. I used the book code version. Latest version works all right.

Gerard

Hey Gerard, you have to ensure any SQL connection you're making (including SQLYog) is running in "ANSI" mode (main difference: double quotes rather than backticks). You can do this on a query by query level as well: SET sql_mode = 'ANSI';