mysql.sh

mysql> describe PreviewableProduct;                                     
+-------------+--------------+------+-----+---------+----------------+  
| Field       | Type         | Null | Key | Default | Extra          |  
+-------------+--------------+------+-----+---------+----------------+  
| ID          | int(11)      | NO   | PRI | NULL    | auto_increment |  
| URLSegment  | varchar(255) | YES  |     | NULL    |                |  
| ProductName | varchar(255) | YES  |     | NULL    |                |  
| ProductCode | varchar(255) | YES  |     | NULL    |                |  
| Description | mediumtext   | YES  |     | NULL    |                |  
| Features    | mediumtext   | YES  |     | NULL    |                |  
| CategoryID  | int(11)      | NO   | MUL | 0       |                |  
| BrandID     | int(11)      | NO   | MUL | 0       |                |  
| ManualID    | int(11)      | NO   | MUL | 0       |                |  
| ImagesID    | int(11)      | NO   | MUL | 0       |                |  
+-------------+--------------+------+-----+---------+----------------+  
10 rows in set (0.00 sec)                                               

silverstripe.log

[04-Nov-2014 11:10:43] Error at framework/model/MySQLDatabase.php line 598: Couldn't run query:                                         
SELECT DISTINCT "PreviewableDataObject_Live"."ClassName", "PreviewableDataObject_Live"."Created", "PreviewableDataObject_Live"."LastEdit
ed", "PreviewableDataObject_Live"."Version", "PreviewableProduct_Live"."URLSegment", "PreviewableProduct_Live"."ProductName", "Previewab
leProduct_Live"."ProductCode", "PreviewableProduct_Live"."Description", "PreviewableProduct_Live"."Features", "PreviewableProduct_Live".
"CategoryID", "PreviewableProduct_Live"."BrandID", "PreviewableProduct_Live"."ManualID", "PreviewableProduct_Live"."ImagesID", "Previewa
bleDataObject_Live"."ID", CASE WHEN "PreviewableDataObject_Live"."ClassName" IS NOT NULL THEN "PreviewableDataObject_Live"."ClassName" E
LSE 'PreviewableDataObject' END AS "RecordClassName"                                                                                    
FROM "PreviewableDataObject_Live"                                                                                                       
LEFT JOIN "PreviewableProduct_Live" ON "PreviewableProduct_Live"."ID" = "PreviewableDataObject_Live"."ID"                               
WHERE (URLSegment = 'hello' AND PreviewableProduct.ID != 1) AND ("PreviewableDataObject_Live"."ClassName" IN ('PreviewableProduct'))    
LIMIT 1                                                                                                                                 
                                                                                                                                        
Unknown column 'PreviewableProduct.ID' in 'where clause' (http://staging.asiapacbrands.com/admin/developer/PreviewableProduct/EditForm/f
ield/PreviewableProduct/item/new/ItemEditForm)