Details
-
Type:
Bug
-
Status:
Open
-
Priority:
Major
-
Resolution: Unresolved
-
Affects Version/s: 1.9
-
Fix Version/s: None
-
Component/s: Wiki (1.x)
-
Labels:None
-
Environment:apache 2 , mysql 5 , php 5 , moodle 1.9.2
-
Database:MySQL
-
Affected Branches:MOODLE_19_STABLE
Description
i have upgraded a moodle 1.9.2 version with nwiki 2008040101
i got errors while installing:
(mysql): SHOW TABLES (mysql): SHOW INDEX FROM mdl_wiki_pages (mysql): CREATE UNIQUE INDEX mdl_wikipage_pagverdfwgrou_uix ON mdl_wiki_pages (pagename, version, dfwiki, groupid, userid, ownerid) 1062: Duplicate entry 'Game List-2-0-0-2-0' for key 2
ADOConnection._Execute(CREATE UNIQUE INDEX mdl_wikipage_pagverdfwgrou_uix ON mdl_wiki_pages (pagename, version, dfwiki, groupid, userid, ownerid), false) % line 891, file: adodb.inc.php
ADOConnection.Execute(CREATE UNIQUE INDEX mdl_wikipage_pagverdfwgrou_uix ON mdl_wiki_pages (pagename, version, dfwiki, groupid, userid, ownerid)) % line 89, file: dmllib.php
execute_sql(CREATE UNIQUE INDEX mdl_wikipage_pagverdfwgrou_uix ON mdl_wiki_pages (pagename, version, dfwiki, groupid, userid, ownerid), true) % line 2256, file: dmllib.php
execute_sql_arr(Array[1], true, true) % line 1344, file: ddllib.php
add_key(Object:XMLDBTable, Object:XMLDBKey) % line 146, file: upgrade.php
=========== and later ...
(mysql): CREATE UNIQUE INDEX mdl_wikipage_pagverdfwgrou_uix ON mdl_wiki_pages (pagename, version, dfwiki, groupid, userid, ownerid) 1062: Duplicate entry 'Game List-2-0-0-2-0' for key 2
ADOConnection._Execute(CREATE UNIQUE INDEX mdl_wikipage_pagverdfwgrou_uix ON mdl_wiki_pages (pagename, version, dfwiki, groupid, userid, ownerid), false) % line 891, file: adodb.inc.php
ADOConnection.Execute(CREATE UNIQUE INDEX mdl_wikipage_pagverdfwgrou_uix ON mdl_wiki_pages (pagename, version, dfwiki, groupid, userid, ownerid)) % line 89, file: dmllib.php
execute_sql(CREATE UNIQUE INDEX mdl_wikipage_pagverdfwgrou_uix ON mdl_wiki_pages (pagename, version, dfwiki, groupid, userid, ownerid), true) % line 2256, file: dmllib.php
execute_sql_arr(Array[1], true, true) % line 1344, file: ddllib.php
add_key(Object:XMLDBTable, Object:XMLDBKey) % line 360, file: upgrade.php
Upgrading wiki from 2007101509 to 2008040101 FAILED!
======================
ok,
i was changing (manually) the different parameters in the table 'mdl_wiki_pages' so their are no duplicates for the creation of this index... and finally it worked.
CREATE UNIQUE INDEX mdl_wikipage_pagverdfwgrou_uix ON mdl_wiki_pages (pagename, version, dfwiki, groupid, userid, ownerid)
i was useing WIKIs with group & students options ON so each student can have his/her own version of each wiki page (the teacher asked for this) it worked fine, but it made the creation of the index impossible because of the several duplicates.
maybe you need to update this index ?
another major issue...
i can not access old wiki data.
writing new wiki works fine, BUT the history is gone.
thou, i still see it inside the sql tables.
Thanks for reporting this issue.
We have detected that this issue has been inactive for over a year has been recorded as affecting versions that are no longer supported.
If you believe that this issue is still relevant to current versions (2.1 and beyond), please comment on the issue. Issues left inactive for a further month will be closed.
Michael d;
lqjjLKA0p6