View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0003825 | MMW v4 | DB/FileMonitor | public | 2007-10-25 03:17 | 2007-10-25 13:56 |
| Reporter | rusty | Assigned To | |||
| Priority | immediate | Severity | block | Reproducibility | always |
| Status | closed | Resolution | fixed | ||
| Product Version | 3.0 | ||||
| Fixed in Version | 3.0 | ||||
| Summary | 0003825: SQL Error when running 3.0.0.1093 | ||||
| Description | When I run 3.0.0.1093 for the first time, on a machine that previously had 1092 installed (1092 wasn't uninstalled prior to installing 1093), the following error appears: There wasa problem querying the database: Erro executing SQL "UPDATE SynchAlbum SET FilterID=1 WHERE Filter='Audiobooks' ":nosuch column: Filter (1,1) After clicking 'Cancel', another error message appear. | ||||
| Additional Information | Posting db to the ftp server. | ||||
| Tags | No tags attached. | ||||
| Fixed in build | |||||
|
|
I've looked into it. The only way to reproduce is: you obviously created a new DB by using 1092 and then you start 1093 when DB upgrader found that the column no more exists (because the column hasn't been created in the clean DB from 1092). Yes, this was a small tweak between 1092 and 1093, but it should not no more occur. This will not affect our users, because they will not have 1092 and by using the earlier or the later builds the problem will not occur. So there is no need to a fix. |
|
|
Closing. Upgrade from 1091 works fine. |
