Server Upload Error

goblue20

Joined: 2010-04-22
Posts: 24
Posted: Wed, 2012-04-25 20:46

Hello, thanks for any help you can provide.

Everything has been working great with this site for a few years. Today during a server upload, it seemed to go very fast and complete rather quickly. None of the images showed up and I realized there was some sort of problem. When going in to the maintenance area it gave the crash error. Any ideas on how to proceed? I am unable to server upload (add on) and I am unable to upload through the site regularly. Thanks for reading and I appreciate any input.

Database_Exception [ Database Error ]: #145: Table './mowin_galleryDB3/search_records' is marked as crashed and should be repaired [ DELETE FROM `search_records` WHERE `item_id` NOT IN (SELECT `id` FROM `items`) ]

 
goblue20

Joined: 2010-04-22
Posts: 24
Posted: Wed, 2012-04-25 20:47

Rest of the errors:

SYSPATH/libraries/Database_Mysqli_Result.php[ 27 ]
22 } 23 elseif (is_bool($result)) 24 { 25 if ($result == FALSE) 26 { 27 throw new Database_Exception('#:errno: :error [ :query ]', 28 array(':error' => $link->error, 29 ':query' => $sql, 30 ':errno' => $link->errno)); 31 } 32 else

SYSPATH/libraries/Database_Mysqli.php[ 79 ] » Database_Mysqli_Result_Core->__construct( arguments )

SYSPATH/libraries/Database.php[ 272 ] » Database_Mysqli_Core->query_execute( arguments )

MODPATH/gallery/libraries/MY_Database.php[ 45 ] » Database_Core->query( arguments )

SYSPATH/libraries/Database_Builder.php[ 973 ] » Database->query( arguments )

MODPATH/search/helpers/search_task.php[ 26 ] » Database_Builder_Core->execute()

MODPATH/gallery/helpers/task.php[ 29 ] » search_task_Core::available_tasks()

MODPATH/gallery/controllers/admin_maintenance.php[ 44 ] » task_Core::get_definitions( arguments )

MODPATH/gallery/controllers/admin.php[ 57 ] » Admin_Maintenance_Controller->index()

{PHP internal call} » Admin_Controller->__call()

SYSPATH/core/Kohana.php[ 330 ] » ReflectionMethod->invokeArgs( arguments )

SYSPATH/core/Event.php[ 208 ] » Kohana_Core::instance( arguments )

APPPATH/Bootstrap.php[ 67 ] » Event_Core::run( arguments )

DOCROOT/index.php[ 91 ] » require( arguments )

 
floridave
floridave's picture

Joined: 2003-12-22
Posts: 25948
Posted: Wed, 2012-04-25 22:20
Quote:
is marked as crashed and should be repaired

You will have to use your DB admin tool ( phpMyAdmin is a very common one ) to go to the DB and select that table for repair.

Dave
_____________________________________________
Blog & G2 || floridave - Gallery Team
 
floridave
floridave's picture

Joined: 2003-12-22
Posts: 25948
Posted: Wed, 2012-04-25 22:29

http://php.about.com/od/mysqladministration/qt/repair_mysql.htm

Dave
_____________________________________________
Blog & G2 || floridave - Gallery Team
 
goblue20

Joined: 2010-04-22
Posts: 24
Posted: Thu, 2012-04-26 01:25

Thanks Dave. It is damn good to see you still here at the forums helping people out and offering your time. You were a life saver for me years ago and it appears you haven't missed a beat. I appreciate your time immensely and thank you. Ill give it a shot and get back to you if I have issues.

As always it is appreciated very much.
 
goblue20

Joined: 2010-04-22
Posts: 24
Posted: Thu, 2012-04-26 03:24

Yeah that did it. Worked like a charm. Thanks again floridave, you are, the man