mySQL database issue
Tiki 6.5 Linux Hosting
Issues with emails not having HTML comment tags stripped out and registration tracker failing to send emails.
On one occasion got this error on blank page:
Fatal error: Maximum execution time of 120 seconds exceeded in /hsphere/local/home/xxxxxx/xxxxxx.org.xx/lib/core/Zend/Filter/StripTags.php on line 247
Using "Check" command on DB from PhpMyAdmin it gives three warnings:
- Problems with indexes of table `tiki_link_cache`
- The indexes url and urlindex seem to be equal and one of them could possibly be removed.
- Problems with indexes of table `tiki_tracker_item_field_logs`
- The indexes itemId and fieldId seem to be equal and one of them could possibly be removed.
- Problems with indexes of table `tiki_untranslated`
- The indexes id and id_2 seem to be equal and one of them could possibly be removed.
If I repair and optimise the tables through the admin interface will this resolve this problem, IF it is a problem.
If individual fields/values have to be edited manually can someone knowledgeable please advise.
Thanks