User Forum
Xequte User Forums
Profile    Active Topics    Forum FAQ    Search this forumSearch
     
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"

Note: You must be registered in order to post a reply.

Size 
UserName:
Password:
Mode 
Format  BoldItalicizedUnderline Align LeftCenteredAlign Right Horizontal Rule Insert HyperlinkInsert EmailBrowse for an image to attach to your post Insert CodeInsert QuoteInsert List
   
Message 

 

Emoji
Smile [:)] Big Smile [:D] Cool [8D] Blush [:I]
Tongue [:P] Evil [):] Wink [;)] Black Eye [B)]
Frown [:(] Shocked [:0] Angry [:(!] Sleepy [|)]
Kisses [:X] Approve [^] Disapprove [V] Question [?]

 
Check here to subscribe to this topic.
   

T O P I C    R E V I E W
jimbo69 Posted - Dec 21 2009 : 11:01:06
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?
4   L A T E S T    R E P L I E S    (Newest First)
xequte Posted - Dec 24 2009 : 19:47:11
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
jimbo69 Posted - Dec 23 2009 : 09:54:09
Yes I did use the utility. The files are huge, can I just delete them? I don't think we need them anyway.
xequte Posted - Dec 23 2009 : 02:50:06
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
jimbo69 Posted - Dec 22 2009 : 13:22:30
Hi I might add that I used the database utility to try and rebuild the history table and main table. I forced reindexing.
Thanks