Results 1 to 1 of 1
  1. #1
    Join Date
    Feb 2007
    Posts
    513
    Plugin Contributions
    2

    Default Deleted one product and all categories disappeared. DB ProductTable:0Records:Size3.2M

    I have a number of Godaddy Shared Linux Servers, on the last server account I setup on the first site I installed I was removing the example categories from a template and deleted a category and I got an error:
    0 DB_ERROR_NOT_CONNECTED
    in:
    [select * from project_version WHERE project_version_key = 'Zen-Cart Database' ]
    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.

    ^THEN ALL THE CATEGORIES WHERE DELETED

    I saw this again when I tried to change the left side box column width and I got the above error and the width disappeared (e.g. 190px) and I entered it again and it was fine.
    I contacted godaddy and reported the error and they asked for a screenshot , and as I could not reproduce the problem, I thought the problem may go away as I had only setup the account one day before.

    Now two months later on another site I setup for someone, the administrator deleted one product and hundreds of the products she added over the last month got deleted

    The phpMyAdmin Say there is 3.2 MiB in the products_description table but says there is 0 Records
    Please see attached. (Its not suppose to say 0 Records: Size 3.2 MiB)
    |
    The ZC Admin Version page says: Database Data Size: 4,507 kB
    The phpMyAdmin Say: Total Size 5.2 MiB
    When I tried to download the database in phpMyAdmin it downloaded as 1,750 kB


    The owner of the site really did spend the last month adding products and I only have an old backup, I really hope I fix this and get to the cause of it. I will give zen cart a donation if I do.
    Attached Images Attached Images  

 

 

Similar Threads

  1. v1.2.x Deleted All Categories - How to create a new one?
    By hoser-eh? in forum Setting Up Categories, Products, Attributes
    Replies: 3
    Last Post: 20 Aug 2012, 02:46 PM
  2. All products Disappeared from Categories Pages
    By Jorge05r in forum General Questions
    Replies: 5
    Last Post: 2 May 2011, 07:48 PM
  3. All fields deleted when one required field is missing during sign in.
    By clueless_in_berlin in forum Templates, Stylesheets, Page Layout
    Replies: 7
    Last Post: 31 May 2010, 05:07 PM
  4. Replies: 1
    Last Post: 30 Nov 2007, 05:05 PM
  5. Help! Product Categories all Deleted
    By jhaydon in forum Setting Up Categories, Products, Attributes
    Replies: 4
    Last Post: 6 Sep 2007, 07:32 PM

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