video session

thiva7 · 2011-05-15 01:30:44

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

ebizzz · 2011-05-15 01:44:47

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)

symtab · 2011-05-15 09:14:24

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

thiva7 · 2011-05-15 11:56:12

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

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 !

thiva7 · 2011-05-15 12:00:10

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

symtab · 2011-05-15 12:46:00

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 [~]#

thiva7 · 2011-05-15 12:56:49

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

thiva7 · 2011-05-15 12:59:41

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--

symtab · 2011-05-15 14:05:04

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?

thiva7 · 2011-05-15 14:46:57

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

symtab · 2011-05-15 17:37:10

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).

thiva7 · 2011-05-15 22:33:08

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 !!!!

symtab · 2011-05-15 23:50:47

How fast can they add the disk? I cannot give you a exact hour for tomorrow 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.

thiva7 · 2011-05-16 00:16:33

ok reply tomorrow and lets see

thank you

symtab · 2011-05-16 10:02:51

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).

symtab · 2011-05-16 10:15:52

Drop me a email so i see your message faster.

thiva7 · 2011-05-16 10:47:34

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

thiva7 · 2011-05-16 11:01:37

i just send u mail adrian

symtab · 2011-05-16 13:22:21

Got it. Happy everything worked out :-)

thiva7 · 2011-05-16 13:59:54

yes is work without to change anything on server.

thank you adrian !!!!!

Adult Script Pro Community Forums

#1 2011-05-15 01:30:44

video session

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

Re: video session

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

Re: video session

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

Re: video session

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

Re: video session

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

Re: video session

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

Re: video session

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

Re: video session

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

Re: video session

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

Re: video session

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

Re: video session

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

Re: video session

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

Re: video session

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

Re: video session

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

Re: video session

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

Re: video session

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

Re: video session

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

Re: video session

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

Re: video session

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

Re: video session

Board footer