error messages after upgrade

error messages after upgrade

by Brian Every -
Number of replies: 1

My host upgraded me to the newer version 1.4.3 mid/end of February. and to 1.4.4 today. I still have this problem when I try to log in from the front page. (I had it in 1.4.3 too) before logging in, it looks fine, after logging in I get what you see below. I can log in from any of my courses ok, but when I navigate to the front page I get this too. Consequently I am unable to add students and make other changes as needed.

Can you help?

brian

wiki


(mysql): CREATE TABLE `mdl_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 'mdl_wiki' already exists
         
      
   


Error


(mysql): CREATE TABLE `mdl_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 'mdl_wiki_entries' already exists
         
      
   


Error


(mysql): CREATE TABLE `mdl_wiki_pages` ( `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 (pagename, version, wiki)) TYPE=MyISAM COMMENT='Holds the Wiki-Pages'  
1050: Table 'mdl_wiki_pages' already exists
         
      
   


Error


wiki tables could NOT be set up successfully!

Continue


(mysql): SELECT * FROM mdl_course WHERE category = '0' LIMIT 1  

(mysql): SELECT * FROM mdl_user WHERE id = '1' AND username = 'guest' LIMIT 1  

You are logged in as Brian Every (Logout)

Average of ratings: -
In reply to Brian Every

Re: error messages after upgrade

by Brian Every -

Problem is solved.  I copied solution below incase others have same difficulty.

brian

Your problem turned out to be a redundancy in 3 MySQL database tables

(which I deleted and then recreated). This is why you were receiving the

"already exists" error. Your site has been upgraded and everything seems

to work now (including the admin secion and all of the configuration

options). Additionally, I have created a MySQL backup of your database.