PDA

View Full Version : Vbulletin and server problem


IRANCITY
05-08-2012, 02:35 PM
hi dear
i have problem in my server and forum
after i update server via Easy apache i have problem
i have receive very db err email
i fix very db err in my forum but my problem is Continue
...
when i send tread or post is very too long time and then send it ...
in forum home do not show last post (front forum title)
in cyber topposter do not show topic update

when i active vbblog i receive db err email

and i have 1 image upload script .... it have db err too...

what am i doing ?
i i try to repair db via whm , cpanel , admincp , tools.php , compareutility.php

but on compareutility.php and tools.php and admincp ... it 's not work ,,,, just send request in browser but nothing do !
i do this on phpmyadmin ... same do nothing

what am i doing ?

--------------- Added 1336491574 at 1336491574 ---------------

SOME ERROR


Database error in vBulletin 3.8.7:

Invalid SQL:

SELECT languageid,
phrasegroup_global AS phrasegroup_global,
phrasegroup_posting AS phrasegroup_posting,
phrasegroup_vbblogglobal AS phrasegroup_vbblogglobal,
phrasegroup_postbit AS phrasegroup_postbit,
phrasegroup_vbblogcat AS phrasegroup_vbblogcat,
phrasegroup_inlinemod AS phrasegroup_inlinemod,
options AS lang_options,
languagecode AS lang_code,
charset AS lang_charset,
locale AS lang_locale,
imagesoverride AS lang_imagesoverride,
dateoverride AS lang_dateoverride,
timeoverride AS lang_timeoverride,
registereddateoverride AS lang_registereddateoverride,
calformat1override AS lang_calformat1override,
calformat2override AS lang_calformat2override,
logdateoverride AS lang_logdateoverride,
decimalsep AS lang_decimalsep,
thousandsep AS lang_thousandsep
FROM language
WHERE languageid = 2;

MySQL Error : Unknown column 'phrasegroup_vbblogglobal' in 'field list'
Error Number : 1054
Request Date : Saturday, May 5th 2012 @ 06:54:07 PM
Error Date : Saturday, May 5th 2012 @ 06:54:07 PM







atabase error in vBulletin :

mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
/home/iecloob/public_html/forum/includes/class_core.php on line 311

MySQL Error :
Error Number :
Request Date : Friday, May 4th 2012 @ 01:42:16 PM
Error Date : Friday, May 4th 2012 @ 01:42:16 PM







Database error in vBulletin 3.8.7:

Invalid SQL:

SELECT user.*, (user.options & 512) AS invisible , avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustom, customavatar.dateline AS avatardateline, customavatar.filedata_thumb, customavatar.height AS avheight, customavatar.width AS avwidth, customavatar.width_thumb AS avwidth_thumb, customavatar.height_thumb AS avheight_thumb

FROM userlist AS userlist
INNER JOIN user AS user ON (user.userid = userlist.relationid)
LEFT JOIN avatar AS avatar ON (avatar.avatarid = user.avatarid)
LEFT JOIN customavatar AS customavatar ON (customavatar.userid = user.userid)

WHERE userlist.userid = 1
AND userlist.type = 'buddy'
AND userlist.friend = 'yes'

ORDER BY RAND()
LIMIT 0, 6;

MySQL Error : Got error 28 from storage engine
Error Number : 1030







Database error in vBulletin 3.8.7:

Invalid SQL:

SELECT
userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user.languageid AS saved_languageid,
IF(user.displaygroupid=0, user.usergroupid, user.displaygroupid) AS displaygroupid,
language.phrasegroup_global AS phrasegroup_global,
language.phrasegroup_posting AS phrasegroup_posting,
language.phrasegroup_vbblogglobal AS phrasegroup_vbblogglobal,
language.phrasegroup_postbit AS phrasegroup_postbit,
language.phrasegroup_vbblogcat AS phrasegroup_vbblogcat,
language.phrasegroup_inlinemod AS phrasegroup_inlinemod,
language.options AS lang_options,
language.languagecode AS lang_code,
language.charset AS lang_charset,
language.locale AS lang_locale,
language.imagesoverride AS lang_imagesoverride,
language.dateoverride AS lang_dateoverride,
language.timeoverride AS lang_timeoverride,
language.registereddateoverride AS lang_registereddateoverride,
language.calformat1override AS lang_calformat1override,
language.calformat2override AS lang_calformat2override,
language.logdateoverride AS lang_logdateoverride,
language.decimalsep AS lang_decimalsep,
language.thousandsep AS lang_thousandsep

FROM user AS user
LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid)
LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid) LEFT JOIN language AS language ON (language.languageid = IF(user.languageid = 0, 2, user.languageid))

WHERE user.userid = 1;

MySQL Error : Unknown column 'language.phrasegroup_vbblogglobal' in 'field list'
Error Number : 1054

snakes1100
05-08-2012, 03:38 PM
Due to you updating the server, we wouldnt know what all is wrong at this point, without seeing the server itself.

1. Verify the phrasegroup_vbblogglobal actually exists, if it doesnt, verify you removed the hack/addon and its files, so its not called anymore.

2. The error 28 means you've ran out of disk space, but again, we wouldnt know if its related to /tmp or a overall disk space issue, so verify your disk space on the server.

Lynne
05-08-2012, 03:39 PM
First error to take care of NOW is the error 28:
One or more partitions on your server is out of space or doesn't have enough space to complete this operation. You need to shutdown your forums and contact your host immediately. You or your host will need to find out which partition is low on disk space and either add more space or free up some.

You cannot deal with the other errors until you take care of that one NOW.

IRANCITY
05-08-2012, 04:19 PM
thanks a lot dear friends
i access to ssh and whm ...
please tel me what am i doing ?

snakes1100
05-08-2012, 04:47 PM
If you have no understanding of what to do via ssh, i would suggest someone other than yourself fix the issues.

There is not a lot anyone can say, when we dont have access to the server, to verify what the actual issues are.

IRANCITY
05-10-2012, 02:48 PM
root@vmd665 [~]# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/sda3 95G 46G 45G 51% /
/dev/sda1 99M 24M 70M 26% /boot
none 1006M 0 1006M 0% /dev/shm
/var/tmpMnt 1008M 110M 848M 12% /tmp


--------------- Added 1336664932 at 1336664932 ---------------


mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
/home/iecloob/public_html/forum/includes/class_core.php on line 311

MySQL Error :
Error Number :
Request Date : Tuesday, May 8th 2012 @ 07:39:26 PM
Error Date : Tuesday, May 8th 2012 @ 07:39:26 PM

snakes1100
05-10-2012, 02:54 PM
Are you running a separate DB server?

Did you verify the host, database, user & pass credentials set in config.php?

df shows no issues

IRANCITY
05-10-2012, 03:17 PM
1 - No ... local DB
2 - i can post in forum but it cannot show in forumhome ! and every day send me alot of db err mail ... !!

snakes1100
05-10-2012, 03:22 PM
Typical for a cant connect to mysql, is its either down or the login credentials are incorrect.

What does mysql show for up time?

IRANCITY
05-10-2012, 03:25 PM
Database error in vBulletin 3.8.7:

Invalid SQL:

INSERT IGNORE INTO postindex
(wordid, postid, score, intitle)
SELECT DISTINCT wordid, 518683, CASE title WHEN 'gfgfgfgf' THEN 2 WHEN 'fdgfgdfg' THEN 1 ELSE 1 END, CASE title WHEN 'gfgfgfgf' THEN 2 WHEN 'fdgfgdfg' THEN 0 ELSE 0 END
FROM word
WHERE title IN ('gfgfgfgf','fdgfgdfg');

MySQL Error : Lost connection to MySQL server during query
Error Number : 2013

--------------- Added 1336667179 at 1336667179 ---------------

Server version 5.1.62-cll
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /tmp/mysql.sock
Uptime: 1 day 22 hours 16 min 24 sec

snakes1100
05-10-2012, 03:31 PM
I would suggest a server optimization.

You could raise your timeout's in my.cnf & restart sql.

Simon Lloyd
05-10-2012, 03:39 PM
It doesn't help with you obliterating the table and column calls in that sql, so we cant help you with that. You have probably got a poorly configured server, if you have eAccelerator enabled and you are running SuPHP you will find this simply doesn't work as intended. You'll certainly not see any performance benefits and depending how it's configured, you may find that it actually decreases performance and fills up your "/tmp/eaccelerator" folder with thousands of files. Opcode caching tools only work when running PHP scripts under DSO or similar. So that could be a reason for your server being full.

IRANCITY
05-10-2012, 03:54 PM
i rebuild server with out e Accelerator ... i wait to see result ...

snakes1100
05-10-2012, 04:02 PM
As df shows on 12% usage on /tmp, this is not a tmp w/eac issue, the sql error is the problem at this point if it keeps sending out cant connect emails.

IRANCITY
05-10-2012, 04:11 PM
Invalid SQL:
SHOW CREATE TABLE postindex;

MySQL Error : Table './iecloob_db/postindex' is marked as crashed and last (automatic?) repair failed
Error Number : 144
Request Date : Thursday, May 10th 2012 @ 07:10:30 PM
Error Date : Thursday, May 10th 2012 @ 07:10:31 PM

--------------- Added 1336670142 at 1336670142 ---------------

Deprecated: Assigning the return value of new by reference is deprecated i

i upgrade php to new version but ... Deprecated ...

snakes1100
05-10-2012, 04:18 PM
Repair the table.

I would suggest you let/hire some one to fix the server correctly.

IRANCITY
05-10-2012, 04:21 PM
Repair / Optimize Tables
Table Data Length Index Length Overhead Check All
access 4.5 KB 8.0 KB 0 Yes
action 0 1.0 KB 0 Yes
ad 0 1.0 KB 0 Yes
adcriteria 0 1.0 KB 0 Yes
adminhelp 89.3 KB 56.0 KB 0 Yes
administrator 128 Bytes 2.0 KB 0 Yes
adminlog 306.0 KB 77.0 KB 0 Yes
adminmessage 104 Bytes 5.0 KB 0 Yes
adminutil 24 Bytes 2.0 KB 0 Yes
album 12.1 KB 10.0 KB 0 Yes
albumpicture 8.4 KB 31.0 KB 0 Yes
albumupdate 0 1.0 KB 0 Yes
announcement 5.3 KB 4.0 KB 0 Yes
announcementread 189 Bytes 3.0 KB 0 Yes
attachment 22.2 KB 35.0 KB 0 Yes
attachmentcategory 0 1.0 KB 0 Yes
attachmentcategoryuser 8.8 KB 23.0 KB 0 Yes
attachmentpermission 0 1.0 KB 0 Yes
attachmenttype 252 Bytes 3.0 KB 0 Yes
attachmentviews 0 1.0 KB 0 Yes
automediaembed 4.7 KB 2.0 KB 0 Yes
avatar 0 1.0 KB 0 Yes
award 1.7 KB 2.0 KB 0 Yes
award_cat 40 Bytes 3.0 KB 0 Yes
award_user 7.4 KB 4.0 KB 0 Yes
bbcode 0 1.0 KB 0 Yes
bbcode_video 2.7 KB 5.0 KB 0 Yes
block 0 1.0 KB 0 Yes
blockconfig 0 1.0 KB 0 Yes
blocktype 392 Bytes 4.0 KB 0 Yes
bookmarksite 780 Bytes 2.0 KB 0 Yes
cache 2.9 KB 2.0 KB 0 Yes
cacheevent 132 Bytes 2.0 KB 0 Yes
calendar 56 Bytes 3.0 KB 0 Yes
calendarcustomfield 0 1.0 KB 0 Yes
calendarmoderator 0 1.0 KB 0 Yes
calendarpermission 0 1.0 KB 0 Yes
contentpriority 0 1.0 KB 0 Yes
contenttype 420 Bytes 3.0 KB 0 Yes
cron 2.0 KB 4.0 KB 0 Yes
cronlog 867.6 KB 269.0 KB 0 Yes
customavatar 29.3 KB 8.0 KB 0 Yes
customprofilepic 18.1 KB 7.0 KB 0 Yes
cyb_logintouser 20 Bytes 2.0 KB 0 Yes
cybvilxh_guests 77.7 KB 32.0 KB 2.5 KB Yes
datastore 1.02 MB 2.0 KB 0 Yes
deletionlog 519.5 KB 249.0 KB 0 Yes
discussion 2.3 KB 3.0 KB 0 Yes
discussionread 0 1.0 KB 0 Yes
editlog 150.6 KB 49.0 KB 0 Yes
event 124 Bytes 6.0 KB 0 Yes
externalcache 1.8 KB 4.0 KB 0 Yes
faq 1.8 KB 4.0 KB 0 Yes
filedata 14.19 MB 37.0 KB 0 Yes
filedata122876 14.19 MB 37.0 KB 0 Yes
force_read_guests 0 1.0 KB 0 Yes
force_read_users 1.7 KB 5.0 KB 0 Yes
forum 151.2 KB 8.0 KB 0 Yes
forumpermission 1,014 Bytes 3.0 KB 0 Yes
forumprefixset 640 Bytes 2.0 KB 0 Yes
forumread 0 1.0 KB 0 Yes
groupmessage 238.7 KB 53.0 KB 0 Yes
groupmessage_hash 35.7 KB 40.0 KB 0 Yes
groupread 0 1.0 KB 0 Yes
holiday 0 1.0 KB 0 Yes
humanverify 13.66 MB 18.03 MB 0 Yes
hvanswer 0 1.0 KB 0 Yes
hvquestion 40 Bytes 2.0 KB 0 Yes
icon 560 Bytes 2.0 KB 0 Yes
imagecategory 100 Bytes 2.0 KB 0 Yes
imagecategorypermission 0 1.0 KB 0 Yes
indexqueue 0 1.0 KB 0 Yes
infraction 1.1 KB 7.0 KB 0 Yes
infractionban 0 1.0 KB 0 Yes
infractiongroup 0 1.0 KB 0 Yes
infractionlevel 72 Bytes 2.0 KB 0 Yes
language 1.10 MB 2.0 KB 45.8 KB Yes
linkback 0 1.0 KB 0 Yes
mailqueue 0 1.0 KB 0 Yes
moderation 110 Bytes 3.0 KB 0 Yes
moderator 663 Bytes 3.0 KB 0 Yes
moderatorlog 7.39 MB 3.19 MB 0 Yes
music_album 32 Bytes 2.0 KB 0 Yes
music_artist 28 Bytes 2.0 KB 0 Yes
music_cat 296 Bytes 2.0 KB 0 Yes
music_comment 0 1.0 KB 0 Yes
music_logo 0 1.0 KB 0 Yes
music_news 0 1.0 KB 0 Yes
music_playlist 168 Bytes 2.0 KB 0 Yes
music_song 572 Bytes 2.0 KB 0 Yes
notice 0 1.0 KB 0 Yes
noticecriteria 0 1.0 KB 0 Yes
noticedismissed 0 1.0 KB 0 Yes
package 28 Bytes 3.0 KB 0 Yes
passwordhistory 1.14 MB 273.0 KB 0 Yes
paymentapi 2.0 KB 2.0 KB 0 Yes
paymentinfo 0 1.0 KB 0 Yes
paymenttransaction 0 1.0 KB 0 Yes
phpkd_maus 112 Bytes 2.0 KB 0 Yes
phrase 3.11 MB 959.0 KB 64.9 KB Yes
phrasetype 2.3 KB 2.0 KB 0 Yes
picture 25.80 MB 17.0 KB 0 Yes
picturecomment 13.4 KB 10.0 KB 0 Yes
picturecomment_hash 6.7 KB 11.0 KB 0 Yes
picturelegacy 4.1 KB 7.0 KB 0 Yes
plugin 268.4 KB 8.0 KB 133.4 KB Yes
pm 740.7 KB 1.13 MB 0 Yes
pmreceipt 7.6 KB 11.0 KB 0 Yes
pmtext 47.49 MB 838.0 KB 0 Yes
pmthrottle 0 1.0 KB 0 Yes
podcast 0 1.0 KB 0 Yes
podcastitem 0 1.0 KB 0 Yes
poll 8.9 KB 2.0 KB 0 Yes
pollvote 11.8 KB 25.0 KB 0 Yes
post 866.66 MB 19.70 MB 0 Yes
post_thanks 6.36 MB 4.27 MB 0 Yes
postedithistory 43.65 MB 277.0 KB 0 Yes
posthash 343 Bytes 3.0 KB 0 Yes
postindex 0 0 0 Yes
postlog 378.8 KB 117.0 KB 226.3 KB Yes
postparsed 21.69 MB 455.0 KB 17.53 MB Yes
prefix 240 Bytes 3.0 KB 0 Yes
prefixpermission 720 Bytes 2.0 KB 0 Yes
prefixset 40 Bytes 2.0 KB 0 Yes
product 5.8 KB 2.0 KB 1.3 KB Yes
productcode 132.7 KB 3.0 KB 96.8 KB Yes
productdependency 408 Bytes 2.0 KB 100 Bytes Yes
profileblockprivacy 20.9 KB 23.0 KB 0 Yes
profilefield 96 Bytes 4.0 KB 0 Yes
profilefieldcategory 0 1.0 KB 0 Yes
profilevisitor 168.0 KB 380.0 KB 68 Bytes Yes
ranks 588 Bytes 3.0 KB 0 Yes
reminder 0 1.0 KB 0 Yes
reputation 0 1.0 KB 0 Yes
reputationlevel 135 Bytes 3.0 KB 0 Yes
route 24 Bytes 4.0 KB 0 Yes
rssfeed 0 1.0 KB 0 Yes
rsslog 83 Bytes 3.0 KB 0 Yes
search 63.9 KB 4.0 KB 61.7 KB Yes
searchcore 0 1.0 KB 0 Yes
searchcore_text 0 1.0 KB 0 Yes
searchgroup 732.3 KB 985.0 KB 0 Yes
searchgroup_text 1.51 MB 362.0 KB 0 Yes
searchlog 184.7 KB 7.0 KB 0 Yes
setting 115.2 KB 27.0 KB 40.7 KB Yes
settinggroup 2.8 KB 4.0 KB 180 Bytes Yes
sigparsed 217.6 KB 10.0 KB 0 Yes
sigpic 380 Bytes 2.0 KB 0 Yes
smilie 51.0 KB 4.0 KB 0 Yes
socialgroup 5.3 KB 10.0 KB 160 Bytes Yes
socialgroupcategory 280 Bytes 3.0 KB 0 Yes
socialgroupicon 840 Bytes 2.0 KB 40 Bytes Yes
socialgroupmember 3.7 KB 17.0 KB 0 Yes
socialgrouppicture 286 Bytes 4.0 KB 0 Yes
spamlog 0 1.0 KB 0 Yes
stats 22.1 KB 16.0 KB 0 Yes
strikes 748 Bytes 3.0 KB 708 Bytes Yes
style 188.9 KB 2.0 KB 70.7 KB Yes
stylevar 41.8 KB 17.0 KB 0 Yes
stylevardfn 20.9 KB 19.0 KB 0 Yes
subscribediscussion 15 Bytes 4.0 KB 0 Yes
subscribeevent 21 Bytes 4.0 KB 0 Yes
subscribeforum 481 Bytes 4.0 KB 0 Yes
subscribegroup 84 Bytes 4.0 KB 0 Yes
subscribethread 223.9 KB 424.0 KB 0 Yes
subscription 0 1.0 KB 0 Yes
subscriptionlog 0 1.0 KB 0 Yes
subscriptionpermission 0 1.0 KB 0 Yes
tachyforumcounter 0 1.0 KB 0 Yes
tachyforumpost 0 1.0 KB 0 Yes
tachythreadcounter 0 1.0 KB 0 Yes
tachythreadpost 0 1.0 KB 0 Yes
tag 1.96 MB 2.84 MB 0 Yes
tagcontent 3.23 MB 9.43 MB 0 Yes
tagsearch 888.9 KB 1.19 MB 291.9 KB Yes
tagthread 8.21 MB 18.13 MB 0 Yes
template 5.64 MB 60.0 KB 2.62 MB Yes
templatehistory 215.9 KB 3.0 KB 0 Yes
templatemerge 0 1.0 KB 0 Yes
thread 14.91 MB 4.94 MB 0 Yes
thread_serviceupdate 0 1.0 KB 0 Yes
threadrate 186.2 KB 159.0 KB 0 Yes
threadread 0 1.0 KB 0 Yes
threadredirect 36 Bytes 3.0 KB 36 Bytes Yes
threadviews 315 Bytes 2.0 KB 0 Yes
upgradelog 2.9 KB 2.0 KB 0 Yes
user 5.21 MB 2.28 MB 0 Yes
useractivation 216 Bytes 3.0 KB 216 Bytes Yes
userban 5.1 KB 3.0 KB 0 Yes
userchangelog 79.8 KB 110.0 KB 0 Yes
usercss 32.8 KB 33.0 KB 0 Yes
usercsscache 60.8 KB 2.0 KB 0 Yes
userfield 546.5 KB 270.0 KB 0 Yes
usergroup 2.7 KB 2.0 KB 0 Yes
usergroupleader 0 1.0 KB 0 Yes
usergrouprequest 0 1.0 KB 0 Yes
userlist 77.2 KB 287.0 KB 0 Yes
usernote 65.6 KB 4.0 KB 0 Yes
userpromotion 0 1.0 KB 0 Yes
usertextfield 1.82 MB 270.0 KB 0 Yes
usertitle 771 Bytes 2.0 KB 0 Yes
vbseo_blacklist 20 Bytes 3.0 KB 0 Yes
vbseo_likes 330.2 KB 256.0 KB 0 Yes
vbseo_linkback 827.2 KB 175.0 KB 0 Yes
vbseo_serviceupdate 714.5 KB 464.0 KB 0 Yes
visitormessage 14.87 MB 3.04 MB 0 Yes
visitormessage_hash 0 1.0 KB 0 Yes
word 94.71 MB 51.68 MB 0 Yes

--------------- Added 1336670541 at 1336670541 ---------------

tables cannot fix .... broweser just send request but no action show !

--------------- Added 1336670597 at 1336670597 ---------------

postindex 0 0 0 !!!! is it clear ?

snakes1100
05-10-2012, 04:29 PM
I would suggest that your stop at this point, do NOT restart mysql at this point.

Repair that table from the cmd line via a shell.

Simon Lloyd
05-10-2012, 04:30 PM
If you cant repair it you'll need to use ssh to find the postindex.TMD file and delete it, when i file is attempting to repair they make another temporary file, if the databse crashes for some reason when this is taking place it leaves that file unfinished, trying to repair again does nothing as that file still exists, i suggest you backup your postindex table as it is then via ssh find that file, delete it, and repair again, you could run the Check table or analyse table first, when you see the full text it will give you the name of the file that already exists.

IRANCITY
05-10-2012, 04:33 PM
i can not see tables via php my admin i click it .. it not open just send request

--------------- Added 1336671252 at 1336671252 ---------------

send my commant to do it ... plz

Simon Lloyd
05-10-2012, 04:41 PM
Nope, if you cant see your tables in phpmyadmin get in touch with your host as you have big troubles!

IRANCITY
05-10-2012, 04:46 PM
i can see tables ....
but when i click on postindex .... it is not open !

--------------- Added 1336672365 at 1336672365 ---------------

root@vmd665 [~]# locate postindex
/var/lib/mysql/iecloob_db/postindex.MYD
/var/lib/mysql/iecloob_db/postindex.MYI
/var/lib/mysql/iecloob_db/postindex.frm

snakes1100
05-10-2012, 04:56 PM
I would highly suggest you stop, before you lose the table, do NOT restart mysql either.

IRANCITY
05-10-2012, 04:58 PM
Invalid SQL:

SELECT setting.*, settinggroup.grouptitle
FROM settinggroup AS settinggroup
LEFT JOIN setting AS setting USING(grouptitle)
WHERE settinggroup.displayorder <> 0
ORDER BY settinggroup.displayorder, setting.displayorder;

MySQL Error : Got error 28 from storage engine
Error Number : 1030

--------------- Added 1336672716 at 1336672716 ---------------

root@vmd665 [~]# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/sda3 95G 46G 45G 51% /
/dev/sda1 99M 24M 70M 26% /boot
none 1006M 0 1006M 0% /dev/shm
/var/tmpMnt 1008M 958M 0 100% /tmp

--------------- Added 1336672794 at 1336672794 ---------------

how can create new tmp file and mount it ?

--------------- Added 1336673711 at 1336673711 ---------------

i do this !
http://www.boxtutorials.com/how-to-increase-the-size-of-disk-space-tmp-usrtmpdsk-partition-in-linux-server.html

--------------- Added 1336673743 at 1336673743 ---------------

root@vmd665 [~]# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/sda3 95G 46G 45G 51% /
/dev/sda1 99M 24M 70M 26% /boot
none 1006M 0 1006M 0% /dev/shm
/usr/tmpDSK 2.0G 3.0M 1.9G 1% /tmp


--------------- Added 1336673807 at 1336673807 ---------------

Wow God ! help me !
new err
Database error in vBulletin 3.8.7:

Invalid SQL:

SELECT setting.*, settinggroup.grouptitle
FROM settinggroup AS settinggroup
LEFT JOIN setting AS setting USING(grouptitle)
WHERE settinggroup.displayorder <> 0
ORDER BY settinggroup.displayorder, setting.displayorder;

MySQL Error : Can't create/write to file '/tmp/#sql_6e8a_0.MYI' (Errcode: 13)
Error Number : 1

snakes1100
05-10-2012, 05:22 PM
I would highly suggest you stop, before you lose the table, do NOT restart mysql.

Have your host help you or hire some one that knows what they are doing.

There are numerous things on the server that need to be addressed, mysql's tmp dir as well as a few other things.

IRANCITY
05-10-2012, 05:38 PM
i think i fix problem ....