.NET Crash

[joshuatree44]

Just had RDJ crash on me. it said .NET error. I am looking through my error logs to locate the issue. So far not able to see anything there. However I am finding lots of MySQL errors. Not sure what is going on there but MariaDB has been a non issue but now whoops.

[Marius]

What type of SQL errors? Did you checked your database for a crash?

[joshuatree44]

mysqld.exe: Table '.\radiodj162\events' is marked as crashed and should be repaired

For more information, see Help and Support Center at http://www.mysql.com. 

mysqld.exe: Table '.\radiodj162\events' is marked as crashed and should be repaired

For more information, see Help and Support Center at http://www.mysql.com. 

mysqld.exe: Table '.\radiodj162\songs' is marked as crashed and should be repaired

For more information, see Help and Support Center at http://www.mysql.com. 

mysqld.exe: Table '.\radiodj162\songs' is marked as crashed and should be repaired

For more information, see Help and Support Center at http://www.mysql.com. 

What type of SQL errors? Did you checked your database for a crash?

[joshuatree44]

I also have several warnings as well with mainly the same information. Otherwise it has been flawless.

[joshuatree44]

Also, I just used HeidiSQL and ran a check, repair over the DB. so it shows all is fine. So Not sure what happened, but something wacky did.

[joshuatree44]

Additionally I have noticed lots of hangs with different tracks. I am assuming that is also due to the SQL issues as well. I have my rotations running and it is just stopping for 30 seconds or more and then goes. Not sure what is going on but never had this issue with previous versions. I am thinking of reinstalling MariaDB after an uninstall. Not sure it will help but I will wait until I hear back from Marius.

[Marius]

If the events table was crashed, i would run also an optimize on the songs table, or even on the whole database.
You should check also the history table for errors.
I don't think it's necessary to reinstall MariaDB at this point.

[joshuatree44]

Done that a few times. It seems it does not help. Everything says it is fine and then it craps out like this. So I am not sure what else I can do here.  I PMed you a copy of the DB Marius. Let me know if that works for you or not.

If the events table was crashed, i would run also an optimize on the songs table, or even on the whole database.
You should check also the history table for errors.
I don't think it's necessary to reinstall MariaDB at this point.

[ufratetoto]

I've the same problem 

I'm using mysql on xampp fine until yesterday, then yesterday afternoon I've noticed the problem:

"mysqld.exe: Table '.\radiodj181\songs' is marked as crashed and should be repaired"

I've tried to repair the database and to optimize it but....nothing seems to be changed 

[ghm72]

I've the same problem 

I'm using mysql on xampp fine until yesterday, then yesterday afternoon I've noticed the problem:

"mysqld.exe: Table '.\radiodj181\songs' is marked as crashed and should be repaired"

I've tried to repair the database and to optimize it but....nothing seems to be changed 

Try this tutorial on repairing a database with Heidi SQL http://www.radiodj.ro/tutorials/video-tutorials/how-to-repair-a-mysqlmariadb-corrupted-database-using-heidisql.html

It may require you go into the database tables and repair it that way.

P.S Ufratetoto next time you require help can you please start a new topic. Thanks.