Database query error

Since a few weeks I get database query error after login on most of my sites.

When I clean cache it is ok for one click on account then next click again database error.

My sites are 7.1.1 and one site I did upgrade to 7.1.2 but still the same.

I did nothing on my sites and woop there it is this bloody error.

All it says is:

 <div style="border:2px solid red;padding:4px;width:600px;margin:0px auto;">
                    <div style="text-align:center;background-color:red;color:white;font-weight:bold;">Error</div>
                    <div style="text-align:center;">Database query error</div>
                            </div>

Edit /inc/classes/BxDolDb.php and enable database debugging, then post the full output.

Thanks Nathan :-)

Incorrect key file for table '/tmp/#sql_1241_0.MYI'; try to repair it

Found error in the file '/home/xxxxx/public_html/xxxxxxxxxxx.net/inc/profiles.inc.php' at line459.
Called 'db_res' function with erroneous argument #0.