Page 1 of 2 12 LastLast
Results 1 to 10 of 18
  1. #1
    Join Date
    Dec 2005
    Location
    Maryland
    Posts
    12
    Plugin Contributions
    0

    Default "1030 Got error 28 from storage engine" while updating category/attributes

    NOW Products will not display in the cart as items display similar messages
    http://www.seasidestampin.com/zencar...=index&cPath=1
    Now what? version 1.3.8
    Please help....


    1030 Got error 28 from storage engine
    in:
    [select p.products_image, p.products_model, pd.products_name, p.products_quantity, p.products_id, p.products_type, p.master_categories_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, pd.products_description, IF(s.status = 1, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status =1, s.specials_new_products_price, p.products_price) as final_price, p.products_sort_order, p.product_is_call, p.product_is_always_free_shipping, p.products_qty_box_status from zen_products_description pd, zen_products p left join zen_manufacturers m on p.manufacturers_id = m.manufacturers_id, zen_products_to_categories p2c left join zen_specials s on p2c.products_id = s.products_id where p.products_status = 1 and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '1' order by p.products_sort_order, pd.products_name]

  2. #2
    Join Date
    Apr 2006
    Location
    London, UK
    Posts
    10,569
    Plugin Contributions
    25

    Default Re: "1030 Got error 28 from storage engine" while updating category/attributes

    Never experienced it personally, but I believe that it means your database doesn't have enough space left to complete the query.
    Kuroi Web Design and Development | Twitter

    (Questions answered in the forum only - so that any forum member can benefit - not by personal message)

  3. #3
    Join Date
    Jan 2004
    Posts
    66,364
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: "1030 Got error 28 from storage engine" while updating category/attributes

    Error code 28: No space left on device

    One or more partitions on your server is out of space or doesn't have enough space to complete this operation. You need to contact your host immediately. You or your host will need to find out which partition is low on disk space and either add more space or free up some.

    Or maybe your hosting account has reached the limit of disk space allowed.
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

  4. #4
    Join Date
    Apr 2007
    Posts
    30
    Plugin Contributions
    0

    Default Re: "1030 Got error 28 from storage engine" while updating category/attributes

    Quote Originally Posted by ocsand View Post
    NOW Products will not display in the cart as items display similar messages
    http://www.seasidestampin.com/zencar...=index&cPath=1
    Now what? version 1.3.8
    Please help....


    1030 Got error 28 from storage engine
    in:
    [select p.products_image, p.products_model, pd.products_name, p.products_quantity, p.products_id, p.products_type, p.master_categories_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, pd.products_description, IF(s.status = 1, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status =1, s.specials_new_products_price, p.products_price) as final_price, p.products_sort_order, p.product_is_call, p.product_is_always_free_shipping, p.products_qty_box_status from zen_products_description pd, zen_products p left join zen_manufacturers m on p.manufacturers_id = m.manufacturers_id, zen_products_to_categories p2c left join zen_specials s on p2c.products_id = s.products_id where p.products_status = 1 and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '1' order by p.products_sort_order, pd.products_name]
    Hi
    I am getting the same error all of a sudden when going into admin-catalog and also on the site only some categories display the error, other categories display the products just fine?
    ZC 1.3.7

  5. #5
    Join Date
    Dec 2005
    Location
    Maryland
    Posts
    12
    Plugin Contributions
    0

    Default Re: "1030 Got error 28 from storage engine" while updating category/attributes

    will the problem resolve itself when host-99 frees up enough space?

  6. #6
    Join Date
    Dec 2005
    Location
    Maryland
    Posts
    12
    Plugin Contributions
    0

    Default Re: "1030 Got error 28 from storage engine" while updating category/attributes

    do you usse host-99 as your cart and webhost?

  7. #7
    Join Date
    Apr 2007
    Posts
    30
    Plugin Contributions
    0

    Default Re: "1030 Got error 28 from storage engine" while updating category/attributes

    Quote Originally Posted by ocsand View Post
    do you usse host-99 as your cart and webhost?
    I use host-99 and it has just started


    Thanks Dr Byte for the heads up

  8. #8
    Join Date
    Dec 2005
    Location
    Maryland
    Posts
    12
    Plugin Contributions
    0

    Default Re: "1030 Got error 28 from storage engine" while updating category/attributes

    Quote Originally Posted by agamic View Post
    I use host-99 and it has just started


    Thanks Dr Byte for the heads up
    i just cut & pasted the replies here and e-mailed them to host-99 support...

  9. #9
    Join Date
    Aug 2005
    Location
    Johnstown, PA, USA
    Posts
    45
    Plugin Contributions
    0

    Default Re: "1030 Got error 28 from storage engine" while updating category/attributes

    You can add me to this list also and yes, I too use Host-99. Is there an issue with Host-99?

  10. #10
    Join Date
    Dec 2005
    Location
    Cincinnati Ohio
    Posts
    1,030
    Plugin Contributions
    13

    Default Re: "1030 Got error 28 from storage engine" while updating category/attributes

    Hello,

    NO there is not an issue with our servers the issue is that you maybe on a plan that is to small for your business and the tmp folder fills a lot quicker on smaller servers.

    The bigger your website grows the more resources it requires. There were only a few hard drives effected and apparently your two websites were the hardrives effected.

    However we cleaned your database and optimized this for you, we recommend keeping your database optimized and well maintained for future issues.

    Or maybe think about upgrading to a plan that can handle your needs. (Means bigger plan = bigger hardrives)

    We are keeping an eye on this for a few days and see what happens.
    Last edited by knuckle-101; 23 Jul 2008 at 09:08 PM.
    PCI Certified Web Hosting - ControlScan, Security Metrics (Platinum Partner), McAfee, TrustKeeper
    Business Class Web Hosting - Linux and cPanel Powered

 

 
Page 1 of 2 12 LastLast

Similar Threads

  1. 1030 Got error 28 from storage engine in
    By cshart in forum General Questions
    Replies: 1
    Last Post: 21 Nov 2011, 04:40 AM
  2. 1030 Got error 28 from storage engine
    By res in forum General Questions
    Replies: 1
    Last Post: 28 Jul 2010, 09:42 PM
  3. 1030 Got error 28 from storage engine
    By spec in forum General Questions
    Replies: 1
    Last Post: 24 Jul 2010, 07:31 PM
  4. 1030 Got error 28 from storage engine
    By bowerstech in forum General Questions
    Replies: 2
    Last Post: 17 Mar 2010, 07:26 AM
  5. 1030 Got error 28 from storage engine
    By jorsara in forum General Questions
    Replies: 2
    Last Post: 10 Mar 2010, 08:43 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR