Page 1 of 1

crashed tables?

Posted: Fri Mar 10, 2023 6:55 pm
by mrdj1024
Script URL: https://djswebserver.dynet.com/support
Version of script: 3.4.2
Hosting company: myself(wampserver)
URL of phpinfo.php: n/a
URL of session_test.php: n/a
What terms did you try when SEARCHING for a solution: didnt search

Write your message below:
hello :)
i keep getting error messages in my error log
2023-03-10 13:49:10 47 [ERROR] mysqld.exe: Table '.\support\hesk_logins' is marked as crashed and should be repaired
2023-03-10 13:49:10 47 [Warning] Checking table: '.\support\hesk_logins'
2023-03-10 13:49:10 48 [ERROR] mysqld.exe: Table '.\support\hesk_online' is marked as crashed and should be repaired
2023-03-10 13:49:10 48 [Warning] Checking table: '.\support\hesk_online'
i have tried to repair those tables using phpmyadmin and it said it succeeded but later they keep getting marked as crashed,but this dont seem to affect the helpdesk(that i know of) it still seems to work just fine even with those errors.
i am using mariadb 10.5.19 if it makes any difference and php 8.1.16

Re: crashed tables?

Posted: Fri Mar 10, 2023 7:11 pm
by Klemen
Not sure why they are getting crashed, but this is usually a symptom of back-end problems, for example, see https://bobcares.com/blog/mysql-repair-crashed-table/

I would make sure the tables are repaired and the root cause fixed, there's no telling what can go wrong in the operation or what table will crash next.

Re: crashed tables?

Posted: Fri Mar 10, 2023 7:15 pm
by mrdj1024
im not too sure either,none of my other databases are showing errors.
would you need to see a copy of my wamp configuration?
i can put it in here and you could look at it in your free time,but im running this on a 1 tb ssd and it has plenty of free space.

Re: crashed tables?

Posted: Fri Mar 10, 2023 7:21 pm
by Klemen
Your wamp configuration file won't help. The two tables are not used as much as many other tables. Unfortunately figuring out why your tables are crashing is not something I can provide guidance on.

Re: crashed tables?

Posted: Fri Mar 10, 2023 8:38 pm
by mrdj1024
so i logged into phpmyadmin and went inside my hesk database and selected all tables and ran the check command.
they all say OK
so i guess there isnt an issue,other than for some weird reason its generating an error in the log thats meaningless.