User Forum
Xequte User Forums
Profile    Active Topics    Forum FAQ    Search this forumSearch
Forum membership is Free!  Click Join to sign-up
Username:
 Password:
Save Password
Forgot your Password?

     
Forum Tips
» This forum is for users to discuss their software problems and suggestions for improvement.  Remember that only a tiny percentage of our users experience such problems (To be precise less than 0.7% have ever posted on this forum)
» Include your software version number (as displayed in the About Box)
» Check the FAQ before posting as most common questions have already been answered
» You don't need to also e-mail us separately as our support team will respond to all questions on this forum
 
 All Forums
 Xequte User Forums
 MailList King
 Error tblhistory no index for fields "date"		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

jimbo69

USA
35 Posts
Posted - Dec 21 2009 :  11:01:06  Show Profile  Reply
Hi we ares still using version 6.28 and we had a computer crash. I tried to rebuild the database system utility which might have been a mistake. We keep getting the same message

tblhistory no index for fields "date"
Do you want MLK to attempt to repair it?

Would upgrading to version 7 fix this error?

jimbo69

USA
35 Posts
Posted - Dec 22 2009 :  13:22:30  Show Profile  Reply
Hi I might add that I used the database utility to try and rebuild the history table and main table. I forced reindexing.
Thanks
Go to Top of Page

xequte

7504 Posts
Posted - Dec 23 2009 :  02:50:06  Show Profile  Reply
Hi

Hmmm, I assume you mean you database a "repair" using the database utility? It is hard to imagine how that could be distructive.

If your mlk_hist.* files are not too large you might want to put them in a zip and email them to use for repair.



Nigel
Xequte Software
nigel@xequte.com
Go to Top of Page

jimbo69

USA
35 Posts
Posted - Dec 23 2009 :  09:54:09  Show Profile  Reply
Yes I did use the utility. The files are huge, can I just delete them? I don't think we need them anyway.
Go to Top of Page

xequte

7504 Posts
Posted - Dec 24 2009 :  19:47:11  Show Profile  Reply
That table stores all the information you see under View>History and Errors, History tab.

You can delete all mlk_hist.* files, but you MUST copy new mlk_hist.* files to replace them (e.g. by creating a new blank database using File>new Database).



Nigel
Xequte Software
nigel@xequte.com
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To: