storage engine prob

[Guest]

First, my apologies for readressing the same problem I posted some days earlier, but I've searched the forum thoroughly and can't find any solution.

 

I'm getting the following warning at the bottom of my site:

 

Warning: mysql_query() [function.mysql-query]: Unable to save result set in /usr/home/c2820sec/domains/boardfun.nl/public_html/shop/includes/functions/database.php on line 44

1030 - Got error 127 from storage engine

 

select counter FROM visitors where browser_ip = '80.127.3.173' AND browser_language = 'nl' AND to_days(now()) - to_days(date) < 1

 

[TEP STOP]

 

Some say the "1030 - Got error 127 from storage engine" is server-related, others say one should repair database via myadminphp. In the first case I would think the problem would eventually solve itself (but it hasn't now for some days)... In the second case I honestly wouldn't know what to do :S

 

The error occurred out of the blue, at least so it seems to me. I've only been changing the stylesheet and header.php, so I can't think of any reason why this warning is related to my actions.

 

Anyone knows what to do to fix this? Perhaps point me to a statement that I can delete/change in order to get rid of the warning?

[abra123cadabra]

A quick lookup in google gives this nice little tutorial on how to repair a database with phpMyAdmin: http://paulstamatiou.com/2006/05/31/how-to...-in-phpmyadmin/

 

No harm done to do this once in a while anyway so just give it a go.

 

If your problem isn't solved like this, contact your hosting company as to what they think the error message means and if they can do something about it or give you a tip on what you have to change.

 

abra

[Guest]

Thanks a bunch Abra. Im on it right away. Will let you know if a database repair solves this problem or not..

[Guest]

Over two weeks have passed now and I'm still struggling to get rid of this nasty warning. As you can see, I've changed the background color to black so the error message at the bottom of the page is partly hidden. I think this measure well points out my despair :(

 

I found out that when I remove the following code from my footer.php, the warning disappears:

 

<!-- Visitors Start -->
<?php require(DIR_WS_INCLUDES . 'visitors_count.php'); ?>
<!-- Visitors End -->

 

The problem seems to be somewhere in visitors_count.php, but this is all mumbo jumbo to me (since I'm a php rookie). Can someone tell me what is causing the error, and how to fix it?

 

PS: the database repair didn't work either...

[abra123cadabra]

I haven't got this file visitors_count.php in my osC installation. Was it part of a contribution?

 

Maybe it helps if you post the content of the file here plus the first 50 lines of your database.php file (mark which one is line 44, causing the error).

 

abra