Jump to content

Problem with Sambc/MYSQL


jerryc
 Share

Recommended Posts

This morning I awoke to find that my station went offline. In the event log it states "unhandled exception (table'.\samdb\queuelist' is marked as crashed and should be repaired"

 

I found some repair commands to input but I cannot get the command prompt to open so I can input the commands. Any suggestions?

Jerry

Link to comment
Share on other sites

1) Log out of SAM.

 

2) from a DOS prompt enter:

 

net stop mysql

c:/mysql/bin/myisamchk -r -f c:/mysql/data/samdb/*.myi

net start mysql

 

3) Restart SAM

 

>>>>>>>>>>>>>>>>>>>>>

 

You have to do this in a command prompt. If you can't get it open, reboot and try again.

 

NOTE: Change the mySQL location to your actual location, it may be different.

  • Thanks 1

SCS - Dedicated Bandwidth Servers

Shoutcast / Icecast / Windows Media

Transcoding - Auto DJ - Mobile Radio - FLASH Players - Auto DJ

Broadcasting World's Stream Host of the Month

Link to comment
Share on other sites

"unhandled exception (table'.\samdb\queuelist' is marked as crashed and should be repaired"

 

 

I used to get those SQL errors like that all the time with SAM.......since i moved to RadioDJ i haven't had any SQL errors...... Maybe a change of software with a more robust SQL would help.

My Blog https://djgarybaldy.blogspot.com

User of RadioDJ FREE radio playout software since 2010.

How to Install RadioDJ: https://djgarybaldy.blogspot.com/2020/08/how-to-install-radiodj-free-radio.html

RadioDJ is my FAVOURITE piece of software it works when I need It

 

 

Link to comment
Share on other sites

Thanks everyone for the help, unfortunately something was wrong with the hard drive or O/S and the entire system crashed this morning. Hopefully my IT guy can get everything back. He did say he could not copy the msql file from the hard drive. Is that going to be a big problem or do I simply import my playlist again and make all the changes in Sam? Thanks everyone again for taking the time to help me out.

 

Jerry

Link to comment
Share on other sites

Thanks everyone for the help, unfortunately something was wrong with the hard drive or O/S and the entire system crashed this morning. Hopefully my IT guy can get everything back. He did say he could not copy the msql file from the hard drive. Is that going to be a big problem or do I simply import my playlist again and make all the changes in Sam? Thanks everyone again for taking the time to help me out.

 

Jerry

 

I, once a month, save all the ID3 tags so that if my SAM were to crash I could import the songs back in. I ALWAYS keep 2 copies of my songs. One on a DEDICATED internal HD, and one on a backup external HD. I also backup my SAM DB and website to both of those drives weekly...just in case!

Stream101 | Affordable Media Solutions

Shared cPanel? Web Hosting | WordPress Hosting | Premium Stream Hosting

TOLL-FREE: (616) 277-7280 | 30 Day NO QUESTIONS Money-Back Guarantee

100% Cogent Free Network | CloudLinux OS | Tier 1 Bandwidth | Grand Rapids, MI

Link to comment
Share on other sites

I do have the songs backed up on another hard drive, but a lot of the track titles, and other information I had to input. It was a lesson hard learned about backing up data. Hopefully I will get off auto dj and get back to streaming today. Thanks again for all the help and information.

Jerry

Link to comment
Share on other sites

Hey everyone got my computer back today, hard drive took a crap. I reinstalled everything and Im still getting the same error message. I tried doing what shoutcast reccommended, but it says the file path is wrong. Im not that savy so Im not sure where to go from here. I may uninstall and just go with the firebird that comes with Sam BC. Not sure what to do. Thanks

Jerry

Link to comment
Share on other sites

Like I said in my post, you need to know what folder your mySQL data base resides.

 

You can search for it in a command prompt:

 

dir samdb.* /s/p

 

Make sure you display hidden folders.

SCS - Dedicated Bandwidth Servers

Shoutcast / Icecast / Windows Media

Transcoding - Auto DJ - Mobile Radio - FLASH Players - Auto DJ

Broadcasting World's Stream Host of the Month

Link to comment
Share on other sites

  • 1 month later...

You can also run a SQL script from MySQL Workbench, using something like this in the query area:

 

use samdb;

check table adz;
check table category;
check table categorylist;
check table disk;
check table event;
check table eventtime;
check table fixedlist;
check table fixedlist_item;
check table historylist;
check table queuelist;
check table requestlist;
check table songlist;
repair table adz;
repair table category;
repair table categorylist;
repair table disk;
repair table event;
repair table eventtime;
repair table fixedlist;
repair table fixedlist_item;
repair table historylist;
repair table queuelist;
repair table requestlist;
repair table songlist;
optimize table adz;
optimize table category;
optimize table categorylist;
optimize table disk;
optimize table event;
optimize table eventtime;
optimize table fixedlist;
optimize table fixedlist_item;
optimize table historylist;
optimize table queuelist;
optimize table requestlist;
optimize table songlist;

 

You probably only need the repair part for each table, but I run 'em all once I'm doing it...

Hope that helps.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...