How to "Clean" TikiWiki Database
Hello,
I have had several recent posts about some strange things happening with our TikiWiki, some of the permissions suddenly changing, all of a suddent cant post comments to a blog, unable to see wiki tabs for items put into anonymous category, etc.
The latest was I was changing permissions for different groups, and now all of a sudden instead of showing 100+ permissions for a group, it only shows three, although they show below where you checkmark the permissions.
I am beginning to think that with all the changes and upgrade we have been doing (we are using development 1.10) that maybe the mysql database is getting a little wonky....tikiwiki is doing a good job of not totally crashing, but things are strange.....
my question is what is the best way to "clean" up a tikiwiki database?
1) run normaly mysql repair commands from command line?
2) run the tiki-wiki-install.php and do the upgrade to 1.10 version?
will any of these help or hurt? any other ideas? any documentation on manually going into tikiwiki with an editor and cleaning things up?