crashed tables?

Helpdesk for my helpdesk software

Moderator: mkoch227

Post Reply
mrdj1024
Posts: 6
Joined: Sun Jan 15, 2023 2:26 pm

crashed tables?

Post 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
Klemen
Site Admin
Posts: 10142
Joined: Fri Feb 11, 2005 4:04 pm

Re: crashed tables?

Post 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.
Klemen, creator of HESK and PHPJunkyardWas this helpful? You can buy me a drink here Image

Image You should follow me on Twitter here

Help desk software | Cloud help desk | Guestbook | Link manager | Click counter | more PHP Scripts ...

Also browse for php hosting companies, read php books, find php resources and use webmaster tools
mrdj1024
Posts: 6
Joined: Sun Jan 15, 2023 2:26 pm

Re: crashed tables?

Post 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.
Klemen
Site Admin
Posts: 10142
Joined: Fri Feb 11, 2005 4:04 pm

Re: crashed tables?

Post 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.
Klemen, creator of HESK and PHPJunkyardWas this helpful? You can buy me a drink here Image

Image You should follow me on Twitter here

Help desk software | Cloud help desk | Guestbook | Link manager | Click counter | more PHP Scripts ...

Also browse for php hosting companies, read php books, find php resources and use webmaster tools
mrdj1024
Posts: 6
Joined: Sun Jan 15, 2023 2:26 pm

Re: crashed tables?

Post 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.
Post Reply