Page 1 of 2 12 LastLast
Results 1 to 10 of 12
  1. #1
    Join Date
    Aug 2006
    Posts
    102
    Plugin Contributions
    0

    Default Categories disappeared

    MY client was adding a category and a subcat. then decided to delete the category. From what she told me, the same thing she had done many times before, she deleted the unwanted category and every category on the website was deleted, i checked the DB and it was true, an empty cat. table. What could have caused this and what do i do?

  2. #2
    Join Date
    Jun 2003
    Posts
    33,823
    Plugin Contributions
    0

    Default Re: Categories disappeared

    First, restore the back up of the Database. Second, what version of Zen Cart is being used?
    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.

  3. #3
    Join Date
    Aug 2006
    Posts
    102
    Plugin Contributions
    0

    Default Re: Categories disappeared

    version is 1.30 and i am not to sure how to put backup back in. Also backup is quite old so lesson learned. I downloaded a .sql copy of DB and it is just one lone file of text. I only want to put the categories back in PLUS since the back up loads of other stuff has been added but they were not deleted so if i upload .sql file will it effect the stuff added after?

    It is strange she had a category i think she added sub cat in it then she clicked on the red cross to delete the cat after, something she had done many times and there were no yellow linked boxes to say products linked and when the sinlge cat selected to delete ALL were deleted, she is not impressed. could it be something or someone doing this or is there a problem, has this happened before or has she clicked on something by accident to link them all, i dont know but I need to know so i can make sure it doesnt happen again...

    Help...

    Paul

  4. #4
    Join Date
    Oct 2006
    Location
    Alberta, Canada
    Posts
    4,151
    Plugin Contributions
    0

    Default Re: Categories disappeared

    Contact your Hoster and explain your backup problem. They might have a recent backup they can provide, from before the db changes were made.

    Also, Kim has that 'tutorials' link in her posts for a reason.

  5. #5
    Join Date
    Aug 2006
    Posts
    102
    Plugin Contributions
    0

    Default Re: Categories disappeared

    Hosting cant help, they back up but dont help individual sites, for mass backup if server problems i guess. Any thought on my issues??

  6. #6
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    67,833
    Plugin Contributions
    6

    Default Re: Categories disappeared

    Good thing our hosting site does not follow those practices ... or we would be doomed ...
    Linda McGrath
    If you have to think ... you haven't been zenned ...

    Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!

    Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today: v1.5.3]
    Officially PayPal-Certified! Just click here

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...

  7. #7
    Join Date
    Aug 2006
    Posts
    102
    Plugin Contributions
    0

    Default Re: Categories disappeared

    I have a backup .sql file, thouh it is quite old but better than nothing. If i upload this backup will it mess with anything that was added after the backup was made, will it wipe everything and use the new upload or will it just add the additional entries. I have added the module for saving from db now, can i add the .sql file this way or must i go via the phpmyadmin panel

    I only want to add the categories from this .sql file because that is all that is missing when the problem occured and i dont know how it happened. Still a mystery, this is what the person it happened to said:

    "I was going to build a new category with sub categories….I put in the new category as I always do…gave it a title and then I added two sub categories as I have done so many times.

    I went to the live shop to press the refresh button to see if it appeared as I wanted…didn’t have to press the refresh button as it had already appeared…mmmm…

    I went back into admin and deleted the sub categories…successfully…as I have done before and then I clicked on the delete button for the category I had created…It came up with message …are you sure you want to delete this category…I clicked delete and everything dis-appeared before my very eyes…That is how I recollect the events leading up to this mystery…"

    Does anyone have any ideas, the site is www.edenspirit.co.uk if you need to look.

    Please advise, i cant have this happening again

    Paul

  8. #8
    Join Date
    Oct 2006
    Location
    Alberta, Canada
    Posts
    4,151
    Plugin Contributions
    0

    Default Re: Categories disappeared

    A mySQL database is nothing more than a text file in structured format. This means you can open with any Text Editor -- do not use a WordProcessor!

    The following is highly unorthodox but 'may' help with your situation.

    Download your current db
    Open current db and previous db in a Text Editor
    In both files, find this beginning: -- Table structure for table `categories`
    In previous db file, copy everything from beginning to this line: -- Table structure for table `configuration`
    In current db file highlight the same beginning and ending, replace (Paste) with code from previous db
    Save and upload

    Make sure you have an unaltered backup of your current db, in case the above does not work.
    Last edited by Website Rob; 28 Oct 2006 at 01:50 PM.

  9. #9
    Join Date
    Jan 2004
    Posts
    60,545
    Blog Entries
    4
    Plugin Contributions
    145

    Default Re: Categories disappeared

    Rob's right. You'll have to do the same with the 'categories_description' table too.
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donations always welcome: www.zen-cart.com/donate

    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.



  10. #10
    Join Date
    Oct 2006
    Location
    Alberta, Canada
    Posts
    4,151
    Plugin Contributions
    0

    Default Re: Categories disappeared

    Couldn't edit my earlier post but for the sake of clarity, wanted to point out that by copying / pasting everthing inbetween:

    Table structure for table `categories` and Table structure for table `configuration`

    you grab both TABLEs for 'catagory', including 'categories_description'.

 

 
Page 1 of 2 12 LastLast

Similar Threads

  1. Better Categories Contrib & ezpages
    By heavenlynights in forum All Other Contributions/Addons
    Replies: 184
    Last Post: 26 Oct 2012, 02:36 AM
  2. Better Categories - Show Sub Categories
    By mattys in forum Addon Sideboxes
    Replies: 1
    Last Post: 25 Oct 2006, 07:02 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
  •