Database Error Preoblem. Please Help!

My site is down due to this database error:

Database error in Dealsaround | Connect and share!

Query:

SELECT a.`ID` as `id`,
        					a.`Ext` as `ext`,
        					a.`Title` as `title`,
        					a.`Desc` as `description`,
        					a.`Uri` as `uri`,
        					a.`Owner` as `owner`,
        					a.`Date` as `date`,
        					a.`Rate` as `rate`,
        					a.`Hash`,
        					b.`id_album` as `album_id`
							FROM `bx_photos_main` as a
							LEFT JOIN `sys_albums_objects` as b ON b.`id_object` = a.`ID`
							LEFT JOIN `sys_albums` as c ON c.`ID`=b.`id_album`
							WHERE a.`ID`='1555' AND a.`Status`<>'disapproved' and c.`Type`='bx_photos'

Mysql error: Table './nobsany_dealsnetwork/sys_albums_objects' is marked as crashed and last (automatic?) repair failed

Found error in the file '/public_html/dealsaround.com/modules/boonex/photos/classes/BxPhotosSearch.php' at line 218.
Called 'db_arr' function with erroneous argument #0.

This was after my host asked me to do a database repair which I did. 

Please does anyone know how to resolve this?

...........................................
Quote · 7 Feb 2012

enable DB debug in inc/classes/BxDolDb.php at line 26

change this

define( 'DB_FULL_DEBUG_MODE', false );

to this

define( 'DB_FULL_DEBUG_MODE', true );

so much to do....
Quote · 7 Feb 2012

Thanks for the response,but I did that and got even more error:

database query error

 

Query:
SELECT a.`ID` as `id`, a.`Ext` as `ext`, a.`Title` as `title`, a.`Desc` as `description`, a.`Uri` as `uri`, a.`Owner` as `owner`, a.`Date` as `date`, a.`Rate` as `rate`, a.`Hash`, b.`id_album` as `album_id` FROM `bx_photos_main` as a LEFT JOIN `sys_albums_objects` as b ON b.`id_object` = a.`ID` LEFT JOIN `sys_albums` as c ON c.`ID`=b.`id_album` WHERE a.`ID`='1555' AND a.`Status`<>'disapproved' and c.`Type`='bx_photos'

 

Mysql error:
Table './xxxxxxxxx/sys_albums_objects' is marked as crashed and last (automatic?) repair failed
...........................................
Quote · 7 Feb 2012

are you doing some backup or something with the DB because its looks like a table got damaged. Maybe a power failer or server crash. try to repair that table from phpmyadmin but download a full backup first.

Edit: try to reupload a fresh BxPhotosSearch.php

so much to do....
Quote · 7 Feb 2012

There was no power failure,but I wont rule out a server crash while the repair was being done because my server is always crashing. What do I do now

...........................................
Quote · 7 Feb 2012

did you tried repairing it from phpmyadmin and did you have any previous backup.

so much to do....
Quote · 7 Feb 2012

You are very right, the server crashed while I was doing a database repair. I repaired the database again and it took care of it. Thanks a million

...........................................
Quote · 7 Feb 2012

you're welcome :)

good luck

so much to do....
Quote · 7 Feb 2012
 
 
Below is the legacy version of the Boonex site, maintained for Dolphin.Pro 7.x support.
The new Dolphin solution is powered by UNA Community Management System.