Post by LilShoppe » Thu Jun 03, 2010 5:36 am

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

Thank You,
Todd R Ray - President/Head Chef
TCCT Enterprises, INC. - dba Lil' Shoppe
1026 Palisades Blvd., Ste. 10, Osage Beach, Missouri 65065
(573) 348-1890 Store - (573) 302-0068 Cafe - (573) 302-0078 Fax
www.LilShoppe.com


User avatar
New member

Posts

Joined
Thu Jun 03, 2010 5:32 am
Location - Osage Beach, MO

Post by ssandecki » Thu Jun 03, 2010 6:06 am

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!

Newbie

Posts

Joined
Mon May 31, 2010 11:35 pm

Post by LilShoppe » Thu Jun 03, 2010 6:50 am

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

Thank You,
Todd R Ray - President/Head Chef
TCCT Enterprises, INC. - dba Lil' Shoppe
1026 Palisades Blvd., Ste. 10, Osage Beach, Missouri 65065
(573) 348-1890 Store - (573) 302-0068 Cafe - (573) 302-0078 Fax
www.LilShoppe.com


User avatar
New member

Posts

Joined
Thu Jun 03, 2010 5:32 am
Location - Osage Beach, MO

Post by LilShoppe » Thu Jun 03, 2010 8:31 pm

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

Thank You,
Todd R Ray - President/Head Chef
TCCT Enterprises, INC. - dba Lil' Shoppe
1026 Palisades Blvd., Ste. 10, Osage Beach, Missouri 65065
(573) 348-1890 Store - (573) 302-0068 Cafe - (573) 302-0078 Fax
www.LilShoppe.com


User avatar
New member

Posts

Joined
Thu Jun 03, 2010 5:32 am
Location - Osage Beach, MO

Post by readyman » Fri Jun 04, 2010 12:28 am

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.

http://www.alreadymade.com
Follow me on twitter.com/alreadymade


User avatar
Global Moderator

Posts

Joined
Wed May 20, 2009 5:16 am
Location - Sydney

Post by karlpers » Fri Jun 11, 2010 7:42 am

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.

O0

Active Member

Posts

Joined
Tue Jun 09, 2009 10:35 pm
Who is online

Users browsing this forum: Google [Bot] and 105 guests