Vbulletin and server problem

[IRANCITY]

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 [DATE]1336491574[/DATE] at [TIME]1336491574[/TIME] ---------------

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]

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]

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]

thanks a lot dear friends
i access to ssh and whm ...
please tel me what am i doing ?

[snakes1100]

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]

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 [DATE]1336664932[/DATE] at [TIME]1336664932[/TIME] ---------------

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]

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]

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]

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]

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 [DATE]1336667179[/DATE] at [TIME]1336667179[/TIME] ---------------

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