Vbulletin and server problem
 

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

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.

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.

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

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.

--------------- Added [DATE]1336664932[/DATE] at [TIME]1336664932[/TIME] ---------------

Are you running a separate DB server?

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

df shows no issues

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

Typical for a cant connect to mysql, is its either down or the login credentials are incorrect.

What does mysql show for up time?

--------------- Added [DATE]1336667179[/DATE] at [TIME]1336667179[/TIME] ---------------

I would suggest a server optimization.

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

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.

i rebuild server with out e Accelerator ... i wait to see result ...

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.

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

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

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

Repair the table.

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

--------------- Added [DATE]1336670541[/DATE] at [TIME]1336670541[/TIME] ---------------

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

--------------- Added [DATE]1336670597[/DATE] at [TIME]1336670597[/TIME] ---------------

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

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.

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.

i can not see tables via php my admin i click it .. it not open just send request

--------------- Added [DATE]1336671252[/DATE] at [TIME]1336671252[/TIME] ---------------

send my commant to do it ... plz

Nope, if you cant see your tables in phpmyadmin get in touch with your host as you have big troubles!

i can see tables ....
but when i click on postindex .... it is not open !

--------------- Added [DATE]1336672365[/DATE] at [TIME]1336672365[/TIME] ---------------

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

I would highly suggest you stop, before you lose the table, do NOT restart mysql either.

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

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

how can create new tmp file and mount it ?

--------------- Added [DATE]1336673711[/DATE] at [TIME]1336673711[/TIME] ---------------

i do this !
http://www.boxtutorials.com/how-to-i...ux-server.html

--------------- Added [DATE]1336673743[/DATE] at [TIME]1336673743[/TIME] ---------------

--------------- Added [DATE]1336673807[/DATE] at [TIME]1336673807[/TIME] ---------------

Wow God ! help me !
new err

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.

i think i fix problem ....