Opened 10 years ago
Last modified 10 years ago
#11501 new defect
Error when migrating from sqlite to postgresql — at Initial Version
| Reported by: | Andrew | Owned by: | Jun Omae |
|---|---|---|---|
| Priority: | normal | Component: | MultiRepoSearchPlugin |
| Severity: | normal | Keywords: | |
| Cc: | Trac Release: |
Description
Hi,
I'm new to Trac but after using the MultiRepoSearchPlugin I find that the searches are pretty slow. I'm hoping that switching to a real database will speed up searches (full text indexes, etc).
Attempting to issue a migrate to switch over to postresql gives this error:
Copying tables:
attachment table... 0 records. auth_cookie table... 1 records. cache table... 3 records. component table... 4 records. enum table... 13 records. mastertickets table... 0 records. milestone table... 0 records. node_change table... 9641 records. permission table... 30 records. report table... 8 records. repository table... 8 records.
OperationalError: Could not decode to UTF-8 column 'contents' with text 'OggS'
repository_node table...
The same error occurs when attempting to use MySQL as well (which is what I prefer).
-Andrew
