MTU.Community

MTU.Community (http://forum.mtu.com/index.php)
-   Hoster Help (http://forum.mtu.com/forumdisplay.php?f=71)
-   -   Hoster ! (http://forum.mtu.com/showthread.php?t=8430)

taco98 January 24th, 2007 02:40 PM

Hoster !
 
When I am building my database I am getting a warning:

Field 'songs.MfgName' cannot be zero-length string. (3315)
Would you like to see help?

I click yes; it finishes the database, saying it successfully created my files. Then it was saying that it could not find jeterr.chm file,, woould i like to find it myself.

This last message is not coming up now, but the first one is. Any ideas how to fix this?

taco98

taco98 January 24th, 2007 02:48 PM

hoster!
 
The exact message for the second box says:

Cannot find the jeterr40chn Help File. Check to see if the file exists on your disk. If it doesn't, you need to reinstall it.

Thanks,
Taco98

ddouglass January 24th, 2007 04:58 PM

Delete the songs.mdb file and then open Hoster and rebuild the database.

taco98 January 24th, 2007 05:24 PM

song.mdb
 
Where is this file located?

lmcmains January 24th, 2007 05:33 PM

c:\program files\Micro Technology\hoster\song.mdb

mindonstrike January 24th, 2007 05:33 PM

After searching the forum I could not find any reference to jeterr40 though I did find a few jeterr35's. From what I could glean it seems that the jeterr errors are database related.

What seemed to work for those was:

1) Go to the C:\Program Files\Micro Technology Unlimited\Hoster\Databases. Find the file songs.mdb, and delete this file. Hoster will rebuild this automaticaly when you reopen Hoster

and/or

2) If you are storing your KMA's in a location other than the default folder(C:\Program Files\Micro Technology Unlimited\Hoster\Songs), make sure that the location you do use is in the top spot in the "Build Songs Database" (Probably should do this before doing #1 above). Can't hurt to remove any unused locations from this list.

and/or

3) Re-instal Hoster


None of these things will harm your computer so it can't trying them.
Hope something here will help

Sam

Beavis January 24th, 2007 07:17 PM

are you sure it didnt say jeterr40.chm


look here:
http://forum.mtu.com/showthread.php?...t=jeterr40.chm

taco98 January 25th, 2007 03:10 AM

jeterr40.chm
 
Yes that is what it said. I reinstalled everything and i am still getting the 2 errors.

one being:

Field 'Songs.MfgName' cannot be a zero-length string. (3315)

Would you like to see help?

Yes No

I click yes and it sucessfully creates the database and then comes up with error 2:

Cannot find the jeterr40.chm file. Do you want to try and find this yourself?

I clcik yes, but to no avail, can't find the file.

I appreciate any help that I can get on this.

Thanks,

Pete

Beavis January 25th, 2007 08:47 AM

are you up to date with windows updates ?

ddouglass January 25th, 2007 09:21 AM

Quote:

Originally Posted by taco98 (Post 58610)
Field 'Songs.MfgName' cannot be a zero-length string. (3315)

This is telling you you have one or more song files that have nothing in the Brand Name field. You will need to find them, delete those files through the Hoster Edit tool and then re-import them and be sure to assign a Brand Name and Disc-id when you do.

If you chech the folder where your KMA files are located you will probably see a higher number of files are there than what the database reported when it completed.

Quote:

Originally Posted by taco98 (Post 58610)
Cannot find the jeterr40.chm file.

This help file that the computer is looking for is a Microsoft Office help file for Access. If you do not have MS Office or at least MS Access installed on your computer you will not be able to see this help.

taco98 January 25th, 2007 12:02 PM

database versus kma files in song folder
 
The files in the kma folder match the amount of files that the database has. I looked through my folder and did not find any blank disc ids in there. Everything has a disc id and a manufacturer. I'm still getting the errors. Any other suggestions or other ideas?

Thanks,

Pete

ddouglass January 25th, 2007 01:42 PM

Quote:

Originally Posted by taco98 (Post 58621)
The files in the kma folder match the amount of files that the database has. I looked through my folder and did not find any blank disc ids in there. Everything has a disc id and a manufacturer. I'm still getting the errors. Any other suggestions or other ideas?

Thanks,

Pete

Do you have Access?

taco98 January 25th, 2007 03:21 PM

access
 
Yes I have access and all the files I have tried to play seem to be working as well.

Pete

ddouglass January 25th, 2007 04:08 PM

Quote:

Originally Posted by taco98 (Post 58632)
Yes I have access and all the files I have tried to play seem to be working as well.

Pete

Copy the songs.mdb then open the copy in Access. Open the table and look for "MfgName" column and find any records that show blank in that column. Note the BookID, so you can delete them from Hoster and re-import.

taco98 January 25th, 2007 04:56 PM

access
 
I'm not sure what you mean by open it in access. I will be gone to a show tonight, i will check the forum again tomorrow.

Thank you for your time,

Pete

ddouglass January 25th, 2007 09:47 PM

When I said do you have Access I was talking about Microsoft Access (the database program).

taco98 January 26th, 2007 04:48 PM

Hoster!
 
I Have the program, but for some reason it wont open the songs.mdb. Is there a place that I can get and reinstall that particular program?

admin January 26th, 2007 05:51 PM

Quote:

Originally Posted by taco98 (Post 58681)
I Have the program, but for some reason it wont open the songs.mdb. Is there a place that I can get and reinstall that particular program?

Warning! If you don't understand what has already been posted, you should NOT go any further. You are over your head in trying to open the Songs.mdb.

That is my humble opinion. :)


All times are GMT -4. The time now is 11:41 AM.

Powered by vBulletin® Version 3.7.1
Copyright ©2009 - 2025, Jelsoft Enterprises Ltd.
The contents of this forum are copyrighted by Micro Technology Unlimited, 2000-2008. Use of any material from these Forums is prohibited without written agreement from MTU.