View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0002699 | JEDI VCS | Server | public | 2005-03-01 09:11 | 2005-06-13 17:14 |
| Reporter | anonymous | Assigned To | USchuster | ||
| Priority | normal | Severity | major | Reproducibility | always |
| Status | closed | Resolution | fixed | ||
| Product Version | 2.40 RC3 (Server) | ||||
| Target Version | Fixed in Version | 2.40 RC4 (Server) | |||
| Summary | 0002699: Deserted modules causes 400 because of case sensitivity in MySQL | ||||
| Description | The MySQL Server crashes when connected to a MySQL Server running on Unix as there is mixed case naming in the server for the tables. In the SQL Server all tables are lowercase but some calls from the JVCS Server are referring to "MODULES" or similar uppercase table. | ||||
| Additional Information | To resolve this simply always use lowercase when referring to table names. For further information and/or questions contact me via: xtra [-at-] bin-i [:dot:] ch | ||||
| Tags | No tags attached. | ||||
| Fix in JVCS version | |||||
| Releasedocumentation | |||||
|
|
By "The MySQL Server crashes" I was referring to the Midware ServerObject, not the Server application. |
|
|
From looking through the source the case of the tablenames should be a problem in SEARCH_MODULES and GET_DESERTED_MODULES. |
|
|
It's now solved in GET_DESERTED_MODULES and it wasn't a problem in SEARCH_MODULES because the code is commented out. It is still a problem in TJVCSDatabase.Upgrade240. |
|
|
It is now solved in TJVCSDatabase.Upgrade240 too. |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2005-03-01 09:11 | anonymous | New Issue | |
| 2005-03-01 09:19 | anonymous | Note Added: 0006622 | |
| 2005-03-12 05:35 | USchuster | Relationship added | child of 0002361 |
| 2005-03-12 05:38 | USchuster | Note Added: 0006688 | |
| 2005-03-12 05:40 | USchuster | Status | new => assigned |
| 2005-03-12 05:40 | USchuster | Assigned To | => USchuster |
| 2005-03-13 03:57 | USchuster | Note Added: 0006690 | |
| 2005-03-14 11:14 | USchuster | Status | assigned => resolved |
| 2005-03-14 11:14 | USchuster | Fixed in Version | => 2.40 RC4 (Server) |
| 2005-03-14 11:14 | USchuster | Resolution | open => fixed |
| 2005-03-14 11:14 | USchuster | Note Added: 0006705 | |
| 2005-06-13 17:14 | THuber | Status | resolved => closed |
