database is locked

Answered

Follow

Permanently deleted user

• September 07, 2018 01:59

when trying to import a CSV stock file I get the database is locked error msg
Was using Products/ import/basic 

I have closed the csv file (in excel) after updating it so cant be this

what could be causing this

0

• 

  Aronium Support

  • September 11, 2018 10:36

  Hi Pete,

  After some investigation with users who had similar issues we have found that big images set on products in Aronium are causing this error. If this is the case for you, try using smaller images for your products.

  Putting big images on products is not the best practice due to database size and load time. Also, images are resized to something like 150x150px, so having this large images will have no positive effect on performance.

  On the other hand, if you do not have images set on products, please let us know, so we can investigate this further.

  Thanks, Aronium team.

  0

  Comment actions Permalink
• 

  Pete

  • October 01, 2018 13:25

  Solved by using small images of 150x150 pixels as suggested
  
  thanks

  0

  Comment actions Permalink
• 

  Pete

  • October 15, 2018 07:46

  Can you please tell me, once we add images to products, do we need to keep the images in a directory or can i delete them as they are in the database??

  0

  Comment actions Permalink
• 

  Aronium Support

  • October 15, 2018 08:42

  Hi Pete,

  Images are saved to database, so you do not need to keep them in directory.

  0

  Comment actions Permalink
• 

  Pete

  • October 15, 2018 09:30

  Great Thanks

   

  0

  Comment actions Permalink
• 

  Num Per

  • September 10, 2024 14:49
  • Edited

  database is locked

  reset database

  0

  Comment actions Permalink

Please sign in to leave a comment.