Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #16  
Old 10 May 2012, 18:18
snakes1100 snakes1100 is offline
 
Join Date: Dec 2001
Real name: Anthony
Repair the table.

I would suggest you let/hire some one to fix the server correctly.
Reply With Quote
  #17  
Old 10 May 2012, 18:21
IRANCITY's Avatar
IRANCITY IRANCITY is offline
 
Join Date: Nov 2007

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

--------------- Added 10 May 2012 at 18:22 ---------------

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

--------------- Added 10 May 2012 at 18:23 ---------------

postindex 0 0 0 !!!! is it clear ?
Reply With Quote
  #18  
Old 10 May 2012, 18:29
snakes1100 snakes1100 is offline
 
Join Date: Dec 2001
Real name: Anthony
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.
Reply With Quote
  #19  
Old 10 May 2012, 18:30
Simon Lloyd's Avatar
Simon Lloyd Simon Lloyd is offline
 
Join Date: Aug 2008
Real name: Simon
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.
__________________
Kind regards,
Simon Microsoft Office Help
My Mods: Find my modifications here
Please do not pm me for support unless i have invited you to!
Reply With Quote
  #20  
Old 10 May 2012, 18:33
IRANCITY's Avatar
IRANCITY IRANCITY is offline
 
Join Date: Nov 2007
i can not see tables via php my admin i click it .. it not open just send request

--------------- Added 10 May 2012 at 18:34 ---------------

send my commant to do it ... plz
Reply With Quote
  #21  
Old 10 May 2012, 18:41
Simon Lloyd's Avatar
Simon Lloyd Simon Lloyd is offline
 
Join Date: Aug 2008
Real name: Simon
Nope, if you cant see your tables in phpmyadmin get in touch with your host as you have big troubles!
__________________
Kind regards,
Simon Microsoft Office Help
My Mods: Find my modifications here
Please do not pm me for support unless i have invited you to!
Reply With Quote
  #22  
Old 10 May 2012, 18:46
IRANCITY's Avatar
IRANCITY IRANCITY is offline
 
Join Date: Nov 2007
i can see tables ....
but when i click on postindex .... it is not open !

--------------- Added 10 May 2012 at 18:52 ---------------

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
Reply With Quote
  #23  
Old 10 May 2012, 18:56
snakes1100 snakes1100 is offline
 
Join Date: Dec 2001
Real name: Anthony
I would highly suggest you stop, before you lose the table, do NOT restart mysql either.
Reply With Quote
  #24  
Old 10 May 2012, 18:58
IRANCITY's Avatar
IRANCITY IRANCITY is offline
 
Join Date: Nov 2007
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 10 May 2012 at 18:58 ---------------

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 10 May 2012 at 18:59 ---------------

how can create new tmp file and mount it ?

--------------- Added 10 May 2012 at 19:15 ---------------

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

--------------- Added 10 May 2012 at 19:15 ---------------


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

--------------- Added 10 May 2012 at 19:16 ---------------

Wow God ! help me !
new err

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

Reply With Quote
  #25  
Old 10 May 2012, 19:22
snakes1100 snakes1100 is offline
 
Join Date: Dec 2001
Real name: Anthony
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.
Reply With Quote
  #26  
Old 10 May 2012, 19:38
IRANCITY's Avatar
IRANCITY IRANCITY is offline
 
Join Date: Nov 2007
i think i fix problem ....
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 05:20.

Layout Options | Width: Wide Color: