netmaker Posted July 8, 2004 Posted July 8, 2004 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
burt Posted July 8, 2004 Posted July 8, 2004 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.
netmaker Posted July 9, 2004 Author Posted July 9, 2004 Thats done it Thank you very very very much burt Dont know what I would do without the expert help on this forum Regards paul
macvk Posted October 22, 2005 Posted October 22, 2005 Thats done it Thank you very very very much burt Dont know what I would do without the expert help on this forum Regards paul MAC
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.