yesodweb / yesodweb/persistent
WARNING: New column type ColumnType: 'int4' p31 s0 w0 is different type than existing column type ColumnType: 'int8' p19 s0 w0; update not supported by MDSPostgreSQLPlugIn
Nobody has claimed this yet.
- Dominant language
- Haskell
- Stars
- 486
- Forks
- 306
- PR merge metrics
- No merged PRs in 30d
Description
Hi All,
I want to reach out to your team as I have a friend with an issue converting MySQL to Postgre, they are getting an error:
WARNING: New column type ColumnType: 'int4' p31 s0 w0 is different type than existing column type ColumnType: 'int8' p19 s0 w0; update not supported by MDSPostgreSQLPlugIn
This is when they try to use the converted SQL to Web Help Desk.
Hope we can get some help.
Thanks.
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
The report names a MySQL-to-PostgreSQL conversion involving Web Help Desk and MDSPostgreSQLPlugIn, but provides no repository file, test, schema, or reproduction steps. First determine whether this warning originates in persistent, then obtain a minimal failing conversion; done should mean the responsible component handles the column-type difference or clearly documents that it is unsupported, with a regression test.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- mysql, postgresql
- Domain
- databases
- Issue type
- Bug
- Difficulty
- 5/5
- Estimated time
- Over a week
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 20/100