Thanks, doesn't want to play
disabled autonumber on MYSQL side didn't like that:
ERROR: 1061, Duplicate key name 'idx_Permission'
Check C:\Program Files\SQLyog Enterprise Trial\sja.log for complete error details
Check C:\Program Files\SQLyog Enterprise Trial\sja.log for complete error details
same error if I did it on the MS side too,
also disabled the PK for Permission Id, same response.
Cheers
Mark
On 2/24/06, Geoff Bowers <[EMAIL PROTECTED]> wrote:
No good news here. You will need to disable the autonumber field that
is the primary key. migrate data.. then alter the column back.
-- geoff
http://www.daemon.com.au/
M Wheeler wrote:
> Hi
>
> Have successfully migrated my farcry app from mssql 2000 to mysql 4,
> one problem I have though is when I tried to migrate the dm
> permissions table I got this error:
>
> <error>*ERROR: 1061, Duplicate key name 'idx_Permission' *</error>
> * * < error>*ERROR: Import aborted...*</ error>
>
> So if I choose not to import foreign keys or index, then data is
> migrated but when trying to visit the site, get this
>
> Error Occurred While Processing Request
>
>
> Error Executing Database Query.
>
> Syntax error or access violation: You have an error in your SQL
> syntax. Check the manual that corresponds to your MySQL server version
> for the right syntax to use near 'SELECT g.policyGroupId,
> p.permissionId FROM dmPolicyGroup g
>
>
> Please try the following:
>
> * Enable Robust Exception Information to provide greater detail
> about the source of errors. In the Administrator, click
> Debugging & Logging > Debugging Settings, and select the Robust
> Exception Information option.
> * Check the ColdFusion documentation
> <http://www.macromedia.com/go/proddoc_getdoc> to verify that you
> are using the correct syntax.
> * Search the Knowledge Base
> <http://www.macromedia.com/support/coldfusion/> to find a
> solution to your problem.
>
> Browser Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1;
> FunWebProducts; .NET CLR 1.1.4322)
> Remote Address 192.x.x.xxx
> Referrer http://IP/farcry/index.cfm?
> Date/Time 24-Feb-06 11:48 AM
>
>
> I am sure it is related, does anyone have any ideas please how to fix
> the dmpermissions table, very frustrating as the farcry admin seems
> to work no problem.
>
> Cheers
> Mark
>
--
Message protected by MailGuard: e-mail anti-virus, anti-spam and content filtering.
http://www.mailguard.com.au/mg
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "farcry-dev" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/farcry-dev
-~----------~----~----~----~------~----~------~--~---
