Vbulletin and server problem

[Simon Lloyd]

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

[IRANCITY]

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

[snakes1100]

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

[IRANCITY]

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

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

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]

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]

i think i fix problem ....