Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Very busy working shop now with errors


netmaker

Recommended Posts

For some reason my busy working shop is coming up with errors.

 

Sometimes when the customer is buying, sometimes when we are processing orders in admin and this recent one when we are doing a backup

 

Warning: mysql_query(): Unable to save result set in /var/www/html/shop/admin/includes/functions/database.php on line 45

1030 - Got error 127 from table handler

 

select sesskey,expiry,value from sessions

 

[TEP STOP]

 

Any thoughts would be gratefully received as this shop is our livlehood!

 

Thanks

 

Paul

Link to comment
Share on other sites

This is to do with deletion of table rows. I believe this is a bug in MySQL prior to version 4.0.18 (I think).

 

You should be able to use phpmyadmin or similar to "repair" the offending table(s), in this case "sessions".

 

If all else fails, speak with your host to find out what version MySQL you have.

Link to comment
Share on other sites

  • 1 year later...

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...