Thread: starting over

Page 1 of 2 12 LastLast
Results 1 to 10 of 11
  1. #1
    Join Date
    Sep 2007
    Location
    Niagara Falls, Ontario
    Posts
    377
    Plugin Contributions
    0

    Default starting over

    I tried to re-install ZC 1.3.8a today and thought that as long I have the correct info for the mySQL database it would find all the items in it. Alas, it did not.
    There were no unusual errors during the install other than the "i can't write to this file or that file" which were easily fixed.

    What did I do wrong?

    I have the install the same IP address for the DB and gave it the correct DB name, user name and password, yet when I went to the store after the install was done, there was no items at all and it was basically back to a vanilla install waiting to be configured from scratch.

    Happy New Year to all.

  2. #2
    Join Date
    Oct 2007
    Location
    Fairbanks, Alaska
    Posts
    426
    Plugin Contributions
    0

    Idea or Suggestion Re: starting over

    When you got to the database part of the install did you upgrade or install?

    If you did not upgrade do you have a backup of the database?

    pete
    Last edited by colemanpa; 1 Jan 2009 at 06:06 AM. Reason: changed something

  3. #3
    Join Date
    Sep 2007
    Location
    Niagara Falls, Ontario
    Posts
    377
    Plugin Contributions
    0

    Default Re: starting over

    I did an install and gave it the info the existing mySQL.
    I made a backup before I did anything, just in case.

    Thanks for the speedy reply.

  4. #4
    Join Date
    Oct 2007
    Location
    Fairbanks, Alaska
    Posts
    426
    Plugin Contributions
    0

    Idea or Suggestion Re: starting over

    you need to restore your database and run the installer again.

    pete

  5. #5
    Join Date
    Sep 2007
    Location
    Niagara Falls, Ontario
    Posts
    377
    Plugin Contributions
    0

    Default Re: starting over

    tried that several times and I'm still stuck with a vanilla site.

    robertensing.com

  6. #6
    Join Date
    Sep 2007
    Location
    Niagara Falls, Ontario
    Posts
    377
    Plugin Contributions
    0

    Default Re: starting over

    I tried to restore the data base again and this time noticed this error:

    -- phpMyAdmin SQL Dump
    -- version 2.11.9.2
    -- http://www.phpmyadmin.net
    --
    -- Host: localhost
    -- Generation Time: Dec 31, 2008 at 08:04 PM
    -- Server version: 5.0.67
    -- PHP Version: 5.2.6
    SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";# MySQL returned an empty result set (i.e. zero rows).
    /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;# MySQL returned an empty result set (i.e. zero rows).
    /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;# MySQL returned an empty result set (i.e. zero rows).
    /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;# MySQL returned an empty result set (i.e. zero rows).
    /*!40101 SET NAMES utf8 */;# MySQL returned an empty result set (i.e. zero rows).

    what does that mean?

  7. #7
    Join Date
    Sep 2007
    Location
    Niagara Falls, Ontario
    Posts
    377
    Plugin Contributions
    0

    Default Re: starting over

    FWIW, I did the same steps from my PC (the other machine is an iMac running 10.5.6) and did not get the error.

    Still stuck with a vanilla site though.

  8. #8
    Join Date
    Aug 2005
    Location
    Arizona
    Posts
    27,761
    Plugin Contributions
    9

    Default Re: starting over

    Are you following the correct steps when producing your DB backup??

    https://www.zen-cart.com/tutorials/i...hp?article=103
    Zen-Venom Get Bitten

  9. #9
    Join Date
    Sep 2007
    Location
    Niagara Falls, Ontario
    Posts
    377
    Plugin Contributions
    0

    Default Re: starting over

    Yes I am following the correct steps. I have the steps printed out and use them every time I do a DB backup. I actually have the link you mentioned printer out as my instruction sheet.
    It shows the correct data when I look at it in phpAdmin, just can't get the site to see it.

  10. #10
    Join Date
    Dec 2005
    Posts
    1,059
    Plugin Contributions
    2

    Default Re: starting over

    What about a DB table prefix? Does your DB backup have them,
    but not your new DB? See DB_PREFIX here:

    https://www.zen-cart.com/tutorials/i...hp?article=370
    [FONT=Arial]Country Kitty Crafts[/FONT][FONT=Arial]
    [/FONT] [FONT=Garamond]
    [/FONT]

 

 
Page 1 of 2 12 LastLast

Similar Threads

  1. Starting All Over
    By sammirah in forum Upgrading to 1.5.x
    Replies: 4
    Last Post: 9 Apr 2012, 02:02 PM
  2. starting over?
    By sham in forum Upgrading to 1.5.x
    Replies: 2
    Last Post: 8 Jan 2012, 09:28 PM
  3. Starting Site Completely Over
    By nolsowski in forum General Questions
    Replies: 12
    Last Post: 23 Jun 2011, 09:55 PM
  4. Almost starting over
    By wwwursa in forum General Questions
    Replies: 1
    Last Post: 23 Nov 2010, 02:02 AM

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