0

If anyone is an X-Cart 4 user, or has experience, I am experiencing an issue with the table xcart_variants. It keeps getting "corrupted" or something. It's giving an error Table './elements_xcart/xcart_variants' is marked as crashed and last (automatic?) repair failed

When I try to REPAIR TABLE xcart_variants I get the following error Can't create new tempfile:

Please help!

migrated from stackoverflow.com Dec 17 '18 at 11:50

This question came from our site for professional and enthusiast programmers.

  • Look in the mysql error log. I'd suspect the temporary directory doesn't have any space or doesn't have the required permission settings to create a file. After you recover, recommend changing to using innodb. – danblack Dec 16 '18 at 21:21
  • This does not really sound like a programming task, more like a DBA task (how to recover / repair a corrupted table). You may get a lot more help at SO's DBA sister site. – Shadow Dec 17 '18 at 1:53
  • Try InnoDB engine. – Ildar Amankulov Dec 17 '18 at 4:51

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy