openphoto/frontend — Issue #532: mysql - unable to upload photo
Author: Benvii
Created: 2012-03-02 18:23:20+00:00
State: open

I experienced a problem with a new installation using mysql.
I was unable to upload photo, il looked into the logs and find the "filenameOriginal" column was missing in the "photo" table :

```
Query error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'filenameOriginal' in 'field list' - INSERT INTO `photo` (appId,host,views,status,permission,license,hash,size,filenameOriginal,width,height,dateTaken,dateTakenDay,dateTakenMonth,dateTakenYear,dateUploaded,dateUploadedDay,dateUploadedMonth,dateUploadedYear,pathOriginal,pathBase,tags,title,description,latitude,longitude,id,owner,exif) VALUES (:appId,:host,:views,:status,:permission,:license,:hash,:size,:filenameOriginal,:width,:height,:dateTaken,:dateTakenDay,:dateTakenMonth,:dateTakenYear,:dateUploaded,:dateUploadedDay,:dateUploadedMonth,:dateUploadedYear,:pathOriginal,:pathBase,:tags,:title,:description,:latitude,:longitude,:id,:owner,:exif)", additional:},
```

I add the column and then it works :)

So if you can update the SQL schema ....