Thread: hellllpppppp !!

Results 1 to 8 of 8
  1. #1
    Join Date
    Oct 2007
    Posts
    6
    Plugin Contributions
    0

    Default hellllpppppp !!

    hi i was changing some thing via shop/admin and now i cant get in!

    it returns 1146 Table 'MYSQL0669.sessions' doesn't exist been on the phone with my isp and all they are saying is the file sessions.MYL is not in the database i have worked out how to add a new one but as for how many fields i need iam a bit lost!!

    please help
    many thanks

  2. #2
    Join Date
    Mar 2004
    Posts
    16,042
    Plugin Contributions
    5

    Default Re: hellllpppppp !!

    open the zc_install/sql/mysql.sql

    scroll down to where you see the drop table if exsists sessions;

    grab that entire drop and insert and run it in phpmyadmin
    Zen cart PCI compliant Hosting

  3. #3
    Join Date
    Oct 2007
    Posts
    6
    Plugin Contributions
    0

    Default Re: hellllpppppp !!

    thanks very much got it up and running again but i have lost all items (42) that i had all ready put in are they now hiding somewhere or do i have to start again ?

  4. #4
    Join Date
    Sep 2007
    Location
    Somewhere in Southern Cal
    Posts
    330
    Plugin Contributions
    0

    Default Re: hellllpppppp !!

    When you drop a table your info is gone unless you made a backup.

    you might still have the data, depends on what table you dropped
    go to your all your table and look for the data

    sorry
    nomad

  5. #5
    Join Date
    Jan 2004
    Posts
    66,443
    Plugin Contributions
    279

    Default Re: hellllpppppp !!

    Quote Originally Posted by jonothetigger View Post
    hi i was changing some thing via shop/admin and now i cant get in!

    it returns 1146 Table 'MYSQL0669.sessions' doesn't exist been on the phone with my isp and all they are saying is the file sessions.MYL is not in the database i have worked out how to add a new one but as for how many fields i need iam a bit lost!!
    Quote Originally Posted by jonothetigger View Post
    thanks very much got it up and running again but i have lost all items (42) that i had all ready put in are they now hiding somewhere or do i have to start again ?
    Sounds like your host is having database problems, whether they're owning up to it or not.
    Tables don't just "disappear", and content doesn't just "disappear".
    The only way Zen Cart lets you delete products is via the admin interface, one at a time (or one whole category at a time by deleting the category).
    If all your products have disappeared and individual parts of MySQL engine structural files are disappearing, then your hosting company is clearly having database problems or else is being hacked.

    If they won't own up to it and commit to finding out the cause and fixing it, then ... run to another host. You can't run a business on such a host.

    Now, maybe they're trying to be helpful and figure things out for you -- that's great. One would have expected them to react by looking at a backup ... but then again if they don't do regular backups of their server I suppose they wouldn't have that option.

    If you've made your own backups, you should be able to recover the data. If not, you'll have to start over.
    .

    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.

  6. #6
    Join Date
    Oct 2007
    Posts
    6
    Plugin Contributions
    0

    Default Re: hellllpppppp !!

    right got to up and running again i have got some pic's left in there but on products for sale or Categories but i have got the logo still and a ez-page ive done !!

    so some of its there !!

    it not to bad if i have lost all the products i done 42 in 4-5 hours and that was with scanning in and modding the pic before posting so i think i done well !!!

    NOW READING ON HOW TO DO BACK UPS

  7. #7
    Join Date
    Sep 2007
    Location
    Somewhere in Southern Cal
    Posts
    330
    Plugin Contributions
    0

    Default Re: hellllpppppp !!

    Quote Originally Posted by DrByte View Post
    If you've made your own backups, you should be able to recover the data. If not, you'll have to start over.
    This is very important issue backing up your db before you do something. I back my db at least twice a week and my catalog every week)
    Ask your host how often they do backups and if its a Hot or Cold backup.
    Don't rely on your host to do this. It only take a few minutes in most case to do a backup.
    If you do not know how then please let us know and we will figure it out for you.

    nomad

  8. #8
    Join Date
    Mar 2004
    Posts
    16,042
    Plugin Contributions
    5

    Default Re: hellllpppppp !!

    back up your database DAILY

    and your files whenever you make changes


    and running the drop table for the sessions would have had NOTHING to do with dropping products
    Zen cart PCI compliant Hosting

 

 

Similar Threads

  1. Hellllpppppp Time Out..!
    By Mike_Dean in forum Basic Configuration
    Replies: 1
    Last Post: 18 May 2006, 12:24 PM

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