OpenCart Community

I added some new products two days ago and tested the site and it was working just fine. Today I went to login to the Open Cart admin page and it just keeps taking me back to the login. It won't go to the dashboard.

So I went to check the site and all the comes up is the following:

"Error: Got error 28 from storage engine
Error No: 1030
SELECT *, pd.name AS name, p.image, m.name AS manufacturer, ss.name AS stock, (SELECT AVG(r.rating) FROM review r WHERE p.product_id = r.product_id GROUP BY r.product_id) AS rating FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id) LEFT JOIN stock_status ss ON (p.stock_status_id = ss.stock_status_id) WHERE p.status = '1' AND p.date_available <= NOW() AND pd.language_id = '1' AND p2s.store_id = '0' AND ss.language_id = '1' ORDER BY p.date_added DESC LIMIT 8Warning: Unknown: write failed: No space left on device (28) in Unknown on line 0Warning: Unknown: Failed to write session data (files). Please verify that the current setting of session.save_path is correct () in Unknown on line 0"

Anyone have any ideas? Maybe reinstall?? If I do reinstall, will it remove my products I've imported so far?

Thanks for any help.

Todd

Well, you "should" have a back-up of your products and data anyways, if you don't and need to re-add all products after re-installing that's your fault. You should make a solid back-up EVERYTIME you change something, and make sure you keep the previous back-up prior to the current one, rotating as you go along. Sadly, I can't solve this issue, but only shack the "back-up, back-up, back-up" stick at you!

ssandecki wrote:I can't solve this issue, but only shack the "back-up, back-up, back-up" stick at you!

I DO have a back-up of the catalog, it's just missing a few things to import. However, I never made a back-up of all the information pages I made. I wasn't really sure how to back them up. I paid a guy to set this up for me. Previously, I used FrontPage for my site and it was ugly and difficult to add product to. So now I'm trying hard to learn this new stuff and, well, I'm OLD. lol It's hard for me.

If it makes you feel even better, for my Point-of-Sale systems at my brick and mortar store (I have two systems, one for a gift side and one for my restaurant), both systems are backed up daily in three different places using 5 revisions. That better? Oh yeah, two of those three are off site. One at my home and one through an online back-up.

Well, this am I checked and everything is working just fine.

Could this just have been a problem with my hosts server that got taken care of last night??

Yep, I've had storage engine problems on shared hosts before. No technical explanation was given, but some of the hard disks seemed to have reached their limits. They fixed the issue pretty quickly, so it wasn't a huge problem.
I'd say it was a disk space problem, but I can't be sure.
If it happens again, contact your host immediately. If you haven't made any changes to your website, then it's safe to assume that there is something happening on the server side that is affecting the scripts.
Also, check your error log file to see if there was some error before the current one, that might give you some idea of the underlying issue.

I previously had the same problem.

My guess is that the database is "overloaded" when you get an error message like this.

In my case, I had to wait for a 15 mins and then everything went back to normal again. My problem occoured after I had added 100 options to a product using Qphorias Option plus.

From then, Im adding around 20 entries at once and I havent got this kind of message any more.