Adult Script Pro Community Forums

The forum is here for legacy reasons. No new posts will be created. User registration is disabled! If you have any questions, please email us or check https://www.adultscriptpro.com for more details!

You are not logged in.

#1 2013-01-22 10:18:22

unsub
Member
From: Shumen
Registered: 2012-04-13
Posts: 145
Website

Strange database error

I see these:
Query: SELECT video_id, title, slug, rating, rated_by, duration, thumb, thumbs, total_views, ext, add_time FROM video WHERE status = 1 ORDER BY view_time DESC LIMIT 8
Error Message: Table './freesexportal_asp/video' is marked as crashed and should be repaired
Error Number: 145

two times for week when I click repair everything is okay for few days.

Any idea where is problem ?

Offline

#2 2013-01-22 11:12:25

symtab
Administrator
Registered: 2010-08-23
Posts: 7,501
Website

Re: Strange database error

Its not necesarily related to the script itself (if this would be the case, it would happen to everyone). I cant tell you exactly where the problem is, because there are many reasons for a table to crash.


Adult Scripts: Adult Script Pro - Adult Search Script
Adult Advertising/Traffic: Plug Rush - EXOClick - PopAds

Offline

#3 2013-01-23 09:34:56

unsub
Member
From: Shumen
Registered: 2012-04-13
Posts: 145
Website

Re: Strange database error

Thank You just if I have same problem again I will write You... :-)

Offline

#4 2013-01-23 10:24:36

ful2fun.com
Member
From: Usa
Registered: 2011-09-16
Posts: 1,048
Website

Re: Strange database error

Table Crash Main reason Is to many users using same table at same time and due to low resources live ram and hard disk it cant run efficiently..... you need to optimize the table and see if ram is efficient or not....

Offline

#5 2013-01-24 02:07:49

unsub
Member
From: Shumen
Registered: 2012-04-13
Posts: 145
Website

Re: Strange database error

Ram is used only on 30 % (maximum) I test this. Site don't have any problems now. :-)

Offline

#6 2013-01-24 17:43:04

ful2fun.com
Member
From: Usa
Registered: 2011-09-16
Posts: 1,048
Website

Re: Strange database error

Then You Need To Rebuild Mysql Server It Crashes Basically Due To Server Resources............As Per My Experience

Offline

Board footer

Powered by FluxBB