Wiki problem

Wiki problem

by Birdie Newborn -
Number of replies: 0
Installation worked fine, upgrading from 1.3, until it got to Wiki. I get this page, listing errors. What do I do to correct the errors?

wiki

(mysql): CREATE TABLE `moo_wiki` ( `id` int(10) unsigned NOT NULL auto_increment, `course` int(10) unsigned NOT NULL default '0', `name` varchar(255) NOT NULL default '', `summary` text NOT NULL, `pagename` varchar(255) default NULL, `wtype` enum('teacher', 'group', 'student') NOT NULL default 'group', `ewikiprinttitle` tinyint(4) NOT NULL default '1', `htmlmode` tinyint(4) NOT NULL default '0', `ewikiacceptbinary` tinyint(4) NOT NULL default '0', `disablecamelcase` tinyint(4) NOT NULL default '0', `setpageflags` tinyint(4) NOT NULL default '1', `strippages` tinyint(4) NOT NULL default '1', `removepages` tinyint(4) NOT NULL default '1', `revertchanges` tinyint(4) NOT NULL default '1', `initialcontent` varchar(255) default NULL, `timemodified` int(10) NOT NULL default '0', PRIMARY KEY (`id`), KEY `course` (`course`)) TYPE=MyISAM COMMENT='Main wiki table'
1050: Table 'moo_wiki' already exists
adodb_mysql._execute(CREATE TABLE `moo_wiki` ( `id` int(10) unsigned NOT NULL auto_increment, `course` int(10) unsigned NOT NULL default '0', `nam..., false) % line 837, file: adodb.inc.php
adodb_mysql.execute(CREATE TABLE `moo_wiki` ( `id` int(10) unsigned NOT NULL auto_increment, `course` int(10) unsigned NOT NULL default '0', `nam...) % line 55, file: datalib.php
execute_sql(CREATE TABLE `moo_wiki` ( `id` int(10) unsigned NOT NULL auto_increment, `course` int(10) unsigned NOT NULL default '0', `nam...) % line 185, file: datalib.php
modify_database(/home/share/b/beachcollege/public_html/m/mod/wiki/db/mysql.sql) % line 205, file: adminlib.php
upgrade_activity_modules(http://www.beachcollege.net/m/admin/index.php) % line 236, file: index.php
Error

(mysql): CREATE TABLE `moo_wiki_entries` ( `id` int(10) NOT NULL auto_increment, `wikiid` int(10) NOT NULL default '0', `course` int(10) NOT NULL default '0', `groupid` int(10) NOT NULL default '0', `userid` int(10) NOT NULL default '0', `pagename` varchar(255) NOT NULL default '', `timemodified` int(10) NOT NULL default '0', PRIMARY KEY (`id`), KEY `wikiid` (`wikiid`), KEY `course` (`course`), KEY `gropuid` (`groupid`), KEY `userid` (`userid`), KEY `pagename` (`pagename`)) TYPE=MyISAM COMMENT='Holds entries for each wiki start instance.'
1050: Table 'moo_wiki_entries' already exists
adodb_mysql._execute(CREATE TABLE `moo_wiki_entries` ( `id` int(10) NOT NULL auto_increment, `wikiid` int(10) NOT NULL default '0', `course` int(1..., false) % line 837, file: adodb.inc.php
adodb_mysql.execute(CREATE TABLE `moo_wiki_entries` ( `id` int(10) NOT NULL auto_increment, `wikiid` int(10) NOT NULL default '0', `course` int(1...) % line 55, file: datalib.php
execute_sql(CREATE TABLE `moo_wiki_entries` ( `id` int(10) NOT NULL auto_increment, `wikiid` int(10) NOT NULL default '0', `course` int(1...) % line 185, file: datalib.php
modify_database(/home/share/b/beachcollege/public_html/m/mod/wiki/db/mysql.sql) % line 205, file: adminlib.php
upgrade_activity_modules(http://www.beachcollege.net/m/admin/index.php) % line 236, file: index.php
Error

(mysql): CREATE TABLE `moo_wiki_pages` ( `id` int(10) unsigned NOT NULL auto_increment, `pagename` VARCHAR(160) NOT NULL, `version` INTEGER UNSIGNED NOT NULL DEFAULT 0, `flags` INTEGER UNSIGNED DEFAULT 0, `content` MEDIUMTEXT, `author` VARCHAR(100) DEFAULT 'ewiki', `userid` INTEGER UNSIGNED NOT NULL DEFAULT 0, `created` INTEGER UNSIGNED DEFAULT 0, `lastmodified` INTEGER UNSIGNED DEFAULT 0, `refs` MEDIUMTEXT, `meta` MEDIUMTEXT, `hits` INTEGER UNSIGNED DEFAULT 0, `wiki` int(10) unsigned NOT NULL, PRIMARY KEY `id` (`id`), UNIQUE KEY `wiki_pages_uk` (`pagename`, `version`, `wiki`)) TYPE=MyISAM COMMENT='Holds the Wiki-Pages'
1050: Table 'moo_wiki_pages' already exists
adodb_mysql._execute(CREATE TABLE `moo_wiki_pages` ( `id` int(10) unsigned NOT NULL auto_increment, `pagename` VARCHAR(160) NOT NULL, `version` IN..., false) % line 837, file: adodb.inc.php
adodb_mysql.execute(CREATE TABLE `moo_wiki_pages` ( `id` int(10) unsigned NOT NULL auto_increment, `pagename` VARCHAR(160) NOT NULL, `version` IN...) % line 55, file: datalib.php
execute_sql(CREATE TABLE `moo_wiki_pages` ( `id` int(10) unsigned NOT NULL auto_increment, `pagename` VARCHAR(160) NOT NULL, `version` IN...) % line 185, file: datalib.php
modify_database(/home/share/b/beachcollege/public_html/m/mod/wiki/db/mysql.sql) % line 205, file: adminlib.php
upgrade_activity_modules(http://www.beachcollege.net/m/admin/index.php) % line 236, file: index.php
Error



(mysql): SELECT COUNT(*) FROM moo_message WHERE useridto = '1' AND timecreated > '0'

wiki tables could NOT be set up successfully!

(mysql): SELECT * FROM moo_user WHERE id = '1' AND username = 'guest' LIMIT 1
Average of ratings: -