Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

Very busy working shop now with errors


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




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





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...


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

  • Create New...