vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Forum and Server Management (https://vborg.vbsupport.ru/forumdisplay.php?f=232)
-   -   Vbulletin and server problem (https://vborg.vbsupport.ru/showthread.php?t=282619)

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

Code:

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

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


All times are GMT. The time now is 11:09 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01174 seconds
  • Memory Usage 1,729KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_code_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (6)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete