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 2011-05-15 01:30:44

thiva7
Member
Registered: 2011-04-30
Posts: 1,022

video session

in admin panel i can see videos i get this error

Query: SELECT v.*, (SELECT username FROM user WHERE user_id = v.user_id) AS username, GROUP_CONCAT(vc.cat_id) AS category, GROUP_CONCAT(c.name) AS name FROM video AS v, video_category AS vc LEFT JOIN video_categories AS c ON (vc.cat_id = c.cat_id) WHERE vc.video_id = v.video_id GROUP BY vc.video_id ORDER BY v.video_id DESC LIMIT 10
Error Message: Can't create/write to file '/tmp/#sql_b74_0.MYI' (Errcode: 30)
Error Number: 1

Offline

#2 2011-05-15 01:44:47

ebizzz
Banned
Registered: 2011-05-14
Posts: 25

Re: video session

Are you sure you have your TMP folder and chmod to 777 ??

# chown root:root /tmp
# chmod 1777 /tmp
# /etc/init.d/mysqld start

Last edited by ebizzz (2011-05-15 02:25:08)

Offline

#3 2011-05-15 09:14:24

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

Re: video session

Also are you sure you have enough space in the /tmp folder (partition)?


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

Offline

#4 2011-05-15 11:56:12

thiva7
Member
Registered: 2011-04-30
Posts: 1,022

Re: video session

ebizzz wrote:

Are you sure you have your TMP folder and chmod to 777 ??

# chown root:root /tmp
# chmod 1777 /tmp
# /etc/init.d/mysqld start


yes i have do that but i do not get any result hmm

symtab wrote:

Also are you sure you have enough space in the /tmp folder (partition)?

i cant understund for what u are talking .all heppents after my server reboot !

Offline

#5 2011-05-15 12:00:10

thiva7
Member
Registered: 2011-04-30
Posts: 1,022

Re: video session

root@server1 [~]# df -h /tmp
Filesystem            Size  Used Avail Use% Mounted on
/usr/tmpDSK           485M   32M  428M   7% /tmp

Offline

#6 2011-05-15 12:46:00

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

Re: video session

Your /tmp partition is mounted read only. Please contact your hosting company and ask them to mount the /tmp partition read-write.

root@server1 [~]# touch /tmp/abc
touch: cannot touch `/tmp/abc': Read-only file system
root@server1 [~]# 

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

Offline

#7 2011-05-15 12:56:49

thiva7
Member
Registered: 2011-04-30
Posts: 1,022

Re: video session

my hosting company is unmanaged and will not help with that....and i dont know how i will do that smile

Offline

#8 2011-05-15 12:59:41

thiva7
Member
Registered: 2011-04-30
Posts: 1,022

Re: video session

wait..... maybe i have more problem than that.......


S.M.A.R.T Errors on /dev/sda
                From Command: /usr/sbin/smartctl -q errorsonly -H -l selftest -l error /dev/sda
                ATA Error Count: 72 (device log contains only the most recent five errors)
Error 72 occurred at disk power-on lifetime: 2388 hours (99 days + 12 hours)
Error 71 occurred at disk power-on lifetime: 2388 hours (99 days + 12 hours)
Error 70 occurred at disk power-on lifetime: 2388 hours (99 days + 12 hours)
Error 69 occurred at disk power-on lifetime: 2388 hours (99 days + 12 hours)
Error 68 occurred at disk power-on lifetime: 2388 hours (99 days + 12 hours)
                ----END /dev/sda--

Offline

#9 2011-05-15 14:05:04

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

Re: video session

I'm not sure, but i remember i've read somewhere on the internet, that you cannot count SMART errors as FATAL. Basically you cannot rely on smart for drive error reporting.

I dont know what to say, the best way would be to change server (or drive) and also get a hosting company that will check your server in case this happens again.

Do you want me to try and remount the /tmp partition read-write?


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

Offline

#10 2011-05-15 14:46:57

thiva7
Member
Registered: 2011-04-30
Posts: 1,022

Re: video session

drive will change when i find some one to transfer from broken disk to new one.

i dont know do that becuse need something mount -unmount and i dont know how do it .

they told me from host when i find someone ,will replace disk and they gave me 48 h to get my files from broken disk to new one

Offline

#11 2011-05-15 17:37:10

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

Re: video session

I can move the files for you if you want. Will this be on a new server or same server and new hard drive? (i can do this only tomorrow).


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

Offline

#12 2011-05-15 22:33:08

thiva7
Member
Registered: 2011-04-30
Posts: 1,022

Re: video session

will be same server and new hard drive. from my host they alow me to have on my server old disk ( broken disk ) for 48 h to can move my files.you can do that??? please tell me if yes when and what time becuse i need to tell my host to add new  disk !!!!

Offline

#13 2011-05-15 23:50:47

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

Re: video session

How fast can they add the disk? I cannot give you a exact hour for tomorrow sad Its already late here and i might need more sleep to be able to focus tomorrow. I'll reply to this topic once i'm online tomorrow and then we can discuss.


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

Offline

#14 2011-05-16 00:16:33

thiva7
Member
Registered: 2011-04-30
Posts: 1,022

Re: video session

ok reply tomorrow and lets see tongue

thank you

Offline

#15 2011-05-16 10:02:51

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

Re: video session

Ok. Whenever you want you can tell your hosting company to add a second hardrive (as long as they do it in 5 hours, so that we have time to move everything).


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

Offline

#16 2011-05-16 10:15:52

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

Re: video session

Drop me a email so i see your message faster.


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

Offline

#17 2011-05-16 10:47:34

thiva7
Member
Registered: 2011-04-30
Posts: 1,022

Re: video session

ok i will send them an mail now to  start add the new drive

Offline

#18 2011-05-16 11:01:37

thiva7
Member
Registered: 2011-04-30
Posts: 1,022

Re: video session

i just send u mail adrian

Offline

#19 2011-05-16 13:22:21

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

Re: video session

Got it. Happy everything worked out :-)


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

Offline

#20 2011-05-16 13:59:54

thiva7
Member
Registered: 2011-04-30
Posts: 1,022

Re: video session

yes is work without to change anything on server.

thank you adrian !!!!!

Offline

Board footer

Powered by FluxBB