Results 1 to 5 of 5
  1. #1
    Join Date
    Oct 2006
    Posts
    170
    Plugin Contributions
    0

    Default Error Message - two different carts?!?

    Hi all,

    I've received the following error message from two separate clients with completely separate web sites & catalogs:

    1030 Got error -1 from table handler
    in:
    [select p.products_image, pd.products_name, p.products_quantity, p.products_id, p.products_type, 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 = '7' order by p.products_sort_order, pd.products_name limit 0, 10]

    It is occuring when the client tries to add an additional product. All had been working well until I got two calls this week regarding this problem. Both are running ZenCart v.1.3.7 - any idea what this is and/or how to correct it?!?

  2. #2
    Join Date
    Oct 2006
    Posts
    170
    Plugin Contributions
    0

    Default Re: Error Message - two different carts?!?

    Now this is showing up when hitting the 'Categories/Products' button in admin area:

    1030 Got error 28 from table handler
    in:
    [select c.categories_id, cd.categories_name, cd.categories_description, c.categories_image, c.parent_id, c.sort_order, c.date_added, c.last_modified, c.categories_status from zen_categories c, zen_categories_description cd where c.parent_id = '0' and c.categories_id = cd.categories_id and cd.language_id = '1' order by c.sort_order, cd.categories_name]
    If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

    Why could have happened to cause this, and what can be done to fix it?!?

  3. #3
    Join Date
    Jun 2003
    Posts
    33,721
    Plugin Contributions
    0

    Default Re: Error Message - two different carts?!?

    Server changes? Restored from a back up?
    Please do not PM for support issues: a private solution doesn't benefit the community.

    Be careful with unsolicited advice via email or PM - Make sure the person you are talking to is a reliable source.

  4. #4
    Join Date
    Oct 2006
    Posts
    170
    Plugin Contributions
    0

    Default Re: Error Message - two different carts?!?

    I cannot say for certain that there were not server changes since I am not the server admin, but the two clients have separate hosting companies - seems to be too much of a coincidence to me.

    I can say for certain that no DB backups were restored as I do handle the administration of the database. Basically, neither site has been administered in over a month and then in the same week these messages appeared. What do they mean?

  5. #5
    Join Date
    Oct 2006
    Posts
    170
    Plugin Contributions
    0

    Default Re: Error Message - two different carts?!?

    Well it must have been a server issue - both carts are back to normal without any adjustments from me - very strange?!?!

 

 

Similar Threads

  1. Can I run two carts on one server with different limits?
    By Rob905 in forum Templates, Stylesheets, Page Layout
    Replies: 2
    Last Post: 29 Jun 2009, 03:53 PM
  2. Auto Return with PayPal and two different carts
    By nettasaura in forum Built-in Shipping and Payment Modules
    Replies: 1
    Last Post: 2 Aug 2008, 04:42 PM
  3. Two different flat rate shipping prices for two different locations
    By attroll in forum Built-in Shipping and Payment Modules
    Replies: 7
    Last Post: 25 Jul 2008, 12:58 PM
  4. Paypal and two different IPNs for two different stores
    By davemehta in forum General Questions
    Replies: 5
    Last Post: 29 Jun 2007, 05:31 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