mysql not working

When I do a check mysql  everything works but get this, am at sea right now with very limited bandwidth.. hope i can get support soon..

attached is a screen shot.  Please help while  have some interest access  :)

[christia_awd.db_geo_locations] Error: Unknown storage engine 'InnoDB'

[christia_awd.db_geo_locations] Error: Unknown storage engine 'InnoDB'
[christia_awd.db_geo_locations] error: Corrupt

This might help  :)

 - - - copy and paste - ---

Found error in the file '/home/christia/public_html/adventistdate.com/inc/banners.inc.php' at line 32.
Called 'db_arr' function with erroneous argument #0.


Debug backtrace:

Array
(
    [1] => Array
        (
            [file] => /home/christia/public_html/adventistdate.com/inc/classes/BxDolDb.php
            [line] => 237
            [function] => error
            [class] => BxDolDb
            [object] => BxDolDb Object
                (
                    [error_checking] => 1
                    [error_message] => Can't create/write to file '/tmp/#sql_7f7_0.MYI' (Errcode: 28)
                    [host] => localhost
                    [port] => 
                    [socket] => 
                    [dbname] => christia_awd
                    [user] => *****
                    [password] => *****
                    [link] => Resource id #23
                    [current_res] => 
                    [current_arr_type] => 1
                    [oParams] => BxDolParams Object
                        (
                            [_oDb] => BxDolDb Object
 *RECURSION*
                            [_oCache] => BxDolCacheFile Object
                                (
                                    [sPath] => /home/christia/public_html/adventistdate.com/cache/
                                )

                            [_sCacheFile] => sys_options_db585050a608b6fe4f7ed8b64d634860.php
                            [_aParams] => [truncated]
                        )

                    [oDbCacheObject] => BxDolCacheFile Object
                        (
                            [sPath] => /home/christia/public_html/adventistdate.com/cache/
                        )

                )

            [type] => ->
            [args] => Array
                (
                    [0] => Database query error
                    [1] => 
                    [2] => SELECT * FROM `sys_banners` WHERE `Active` <> 0 AND `campaign_start` <= NOW() AND `campaign_end` >= NOW()  AND `Position` LIKE '%2%' ORDER BY RAND() LIMIT 1
                )

        )

    [2] => Array
        (
            [file] => /home/christia/public_html/adventistdate.com/inc/classes/BxDolDb.php
            [line] => 101
            [function] => res
            [class] => BxDolDb
            [object] => BxDolDb Object
                (
                    [error_checking] => 1
                    [error_message] => Can't create/write to file '/tmp/#sql_7f7_0.MYI' (Errcode: 28)
                    [host] => localhost
                    [port] => 
                    [socket] => 
                    [dbname] => christia_awd
                    [user] => *****
                    [password] => *****
                    [link] => Resource id #23
                    [current_res] => 
                    [current_arr_type] => 1
                    [oParams] => BxDolParams Object
                        (
                            [_oDb] => BxDolDb Object
 *RECURSION*
                            [_oCache] => BxDolCacheFile Object
                                (
                                    [sPath] => /home/christia/public_html/adventistdate.com/cache/
                                )

Did you do anything before this happened? For example, did you install a new module or so?

If that's not the case, did your hosting provider (or you) did any maintenance on the server?

If none of this is the case, check your mysql logs for clues as to why this has happened.

Try and do a repair from phpmyadmin, but I'm afraid it will require a restore of the database.

If you like send me a PM and i'll see what i can do... 

Nothing like waking up in the middle of the night, and remember what you did to  a site.

I had installed the Spanish Language as an option..  suspect that might be the problem..

How can I uninstall that when I can not go to the Control Panel?  I still have ftp acress

Thanks

hello StanCA 

i think if you try with ftp to change folder language  spanish to spanish1 

and look if you can acces the site again

thanks..... I can not a folder named spanish..  i found a php file inland ending with es.php...  

Your going to need to contact your host.

This error which is in the report you posted in your 3'rd post is the main issue.

[error_message] => Can't create/write to file '/tmp/#sql_7f7_0.MYI' (Errcode: 28)

That error. (Errcode: 28) means no space. The tmp partition on your server which is used by mysql when it writes temporary tables has no drive space left, so it cannot do it's job.

Your host is going to need to increase the size of that partition. You may be able to temporary solve the problem by rebooting the server which should clear that tmp partition when the server reboots. But more space will be needed to truly solve the problem.

thanks I have contacted the host...  I have the full server..  any idea what the command is to make that bigger?

 I am not sure if you should be doing this without experience.  Will your host be wiling to do this for you?  You can also direct where MySQL should place its temp files.

Thanks for the  replies... here is what i got from there host..

 - - -copy and paste  -- - -

There is plenty of space in the /tmp folder:

/usr/tmpDSK           4.0G  323M  3.5G   9% /tmp

The problem is that the table that they are trying to work with is overflowing 4GB not that there is anything wrong with /tmp.

So what the heck are they doing with 4GB of data in a temp table?

 - - - Thoughts?  -- - -

Then the table sys_banners which is the table it is trying to work with when the error occurs may be damaged.

You can try a repair of that table from phpMyAdmin