Thread: Errcode: 28

Results 1 to 5 of 5
  1. #1
    Join Date
    Jan 2011
    Posts
    42
    Plugin Contributions
    0

    Default Errcode: 28

    My site was going ok until this morning when I got this message when viewing products that I had recently uploaded.

    The same message appears in my admin if I go to the catalogue

    Is this the same problem as error code 13?

    1 Can't create/write to file '/tmp/#sql_1d68_0.MYI' (Errcode: 28)
    in:
    [select p.products_image, 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 products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join 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 = '80' order by p.products_sort_order, pd.products_name]

  2. #2
    Join Date
    Oct 2011
    Location
    AZ
    Posts
    384
    Plugin Contributions
    0

    Default Re: Errcode: 28

    I think Error 28 is a space issue. Something has gotten too large. Unfortunately that's all I know. And it's not really a "know", just a "think.".

  3. #3
    Join Date
    Jan 2011
    Posts
    42
    Plugin Contributions
    0

    Default Re: Errcode: 28

    Thanks for the quick response. I am not sure if I should contact my hosting provider as suggested in the forum for error 13 or if it is another sql problem.

  4. #4
    Join Date
    Jan 2004
    Posts
    66,446
    Plugin Contributions
    81

    Default Re: Errcode: 28

    Yes, with ANY database problem like that, contact your hosting company IMMEDIATELY.
    .

    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.

  5. #5
    Join Date
    Jan 2011
    Posts
    42
    Plugin Contributions
    0

    Default Re: Errcode: 28

    Quote Originally Posted by DrByte View Post
    Yes, with ANY database problem like that, contact your hosting company IMMEDIATELY.
    Thanks for your reply. I have contacted my hosting company and they have fixed the problem for me.

 

 

Similar Threads

  1. (Errcode: 13)
    By Oredayo in forum Setting Up Categories, Products, Attributes
    Replies: 1
    Last Post: 24 Dec 2010, 11:55 PM
  2. Help! Errcode
    By theladebug in forum General Questions
    Replies: 0
    Last Post: 6 Sep 2008, 04:28 AM
  3. What? Errcode: 22
    By DiZZ in forum General Questions
    Replies: 0
    Last Post: 2 Jun 2007, 03:52 PM
  4. errcode=13
    By infinite1 in forum Installing on a Linux/Unix Server
    Replies: 2
    Last Post: 28 Sep 2006, 08:18 AM

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