|
|
Rank: Member
Groups: Member
Joined: 4/28/2006
Posts: 23
Points: 0
|
Hey - I am getting the following error when trying to creat a new child node:
An error occured: could not insert collection: [Cuyahoga.Core.Domain.Node.NodePermissions#0], Duplicate entry '0' for key 1
Using MySql. Anyone have any ideas?
Lev
|
|
Rank: Administration
Groups: Administration
, Member
Joined: 12/30/2004
Posts: 1,674
Points: 1,824
Location: Wageningen (NL)
|
Has the noderoleid field in the cuyahoga_noderole table the AUTO_INCREMENT attribute?
|
|
Rank: Member
Groups: Member
Joined: 4/28/2006
Posts: 23
Points: 0
|
martijnb wrote:Has the noderoleid field in the cuyahoga_noderole table the AUTO_INCREMENT attribute? Nope, that was it. Any idea why? I exported from a MySql 5 database into a MySql 4, so that could be the problem.
|
|
Rank: Administration
Groups: Administration
, Member
Joined: 12/30/2004
Posts: 1,674
Points: 1,824
Location: Wageningen (NL)
|
No idea. I'm really not that much into MySQL to be honest  . Maybe some others have experiences with this?
|
|
Rank: Advanced Member
Groups: Member
Joined: 12/11/2007
Posts: 89
Points: 267
|
Same thing happened to me when I copied databases in SQL Management Studio. the identity specification was not set. Strange. All I did was create new database then import everything from an existing one.
Web Developer, Kent - Coolbytes
|
|
Rank: Advanced Member
Groups: Member
Joined: 6/18/2007
Posts: 39
Points: 117
|
hobbis wrote:Same thing happened to me when I copied databases in SQL Management Studio. the identity specification was not set. Strange. All I did was create new database then import everything from an existing one. SQL Management Studio just imports the data , not the structure , you must first create the tables by CUY or script then import the data.
|
|
|
Guest |