Page 1 of 3 123 LastLast
Results 1 to 10 of 25
  1. #1
    Join Date
    Apr 2015
    Location
    Royal Palm Beach, Florida, USA
    Posts
    20
    Plugin Contributions
    0

    Default Unable to upgrade SQL from 139 to 154

    Please help!!
    I have uploaded parts of old database and converted to csv, but when importing to to new database I get message: Invalid field count in CSV input on line 1. I do not know how fix the problem. Otherwise the store seem to be working.

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

    Default Re: Unable to upgrade SQL from 139 to 154

    I have uploaded parts of old database
    You are supposed to import the "complete" database then re-run zc_install selecting "Upgrade Database Only"
    Zen-Venom Get Bitten

  3. #3
    Join Date
    Jan 2004
    Location
    N of San Antonio TX
    Posts
    9,103
    Plugin Contributions
    11

    Default Re: Unable to upgrade SQL from 139 to 154

    CSV?!?
    Really? Are you not with a host providing Cpanel or a similar product?

  4. #4
    Join Date
    Apr 2015
    Location
    Royal Palm Beach, Florida, USA
    Posts
    20
    Plugin Contributions
    0

    Default Re: Unable to upgrade SQL from 139 to 154

    Yes I have Cpanel. I do not want to transfer everything, just customers and address book. I will build rest from scratch. I have tried to move these from old SQL to new SQL, but I get always some error message. I simply want to get my customers and address book transfered to the new zencart. Is there a simple way to do it? My host is Ipage and they refuse to have anything to do with the installation!PLease I need help here!!

  5. #5
    Join Date
    Jan 2004
    Location
    N of San Antonio TX
    Posts
    9,103
    Plugin Contributions
    11

    Default Re: Unable to upgrade SQL from 139 to 154

    Quote Originally Posted by Jukor View Post
    I do not want to transfer everything, just customers and address book. I will build rest from scratch. I have tried to move these from old SQL to new SQL, but I get always some error message. I simply want to get my customers and address book transfered to the new zencart. Is there a simple way to do it? My host is Ipage and they refuse to have anything to do with the installation!PLease I need help here!!
    It's not unusual for someone to decide they know enough about coding, etc. to feel that they can come up with an easier method to do something with Zen Cart other than what methods are found here. Most of us went through the same thing at first. There are some very knowledgeable folks here when it comes to databases and 99.9% would not do what you are attempting.

    Here's the best help we can give... DO NOT attempt to just do part of the database. It is (as you may have noticed) a recipe for disaster.

    Please see http://tinyurl.com/hs3cxk5. Read through it. Try your best to follow it. Murphy was an optimist, adapters don't, and shortcuts AREN'T.

  6. #6
    Join Date
    Jul 2012
    Posts
    16,710
    Plugin Contributions
    17

    Default Re: Unable to upgrade SQL from 139 to 154

    DrByte posted a solution to a similar issue "somewhere".

    What you are trying to do is considered a no no (causes errors like you are seeing) because it is like doing an upgrade and a server change at the same time...

    A way around the issue(s) would be to 1) do as previously suggested of doing a database upgrade of the previous version (do so in some "secondary"/"tertiary" location) and then 2) transfer only those tables desired from that "upgrade"...

    A method to accomplish the upgrade would be: http://www.zen-cart.com/entry.php?3-...d-of-upgrading

    Just don't worry about the code "updates" and deal only with the database...
    ZC Installation/Maintenance Support <- Site
    Contribution for contributions welcome...

  7. #7
    Join Date
    Apr 2015
    Location
    Royal Palm Beach, Florida, USA
    Posts
    20
    Plugin Contributions
    0

    Default Re: Unable to upgrade SQL from 139 to 154

    I've tried to do this upgrade from inside the installed 154, but I don't seem find the right place to start the SQL upgrade. I found under the ZC_old the different SQL upgrades, but not the button to start the upgrade. Should I start the whole thing from the start.

  8. #8
    Join Date
    Apr 2015
    Location
    Royal Palm Beach, Florida, USA
    Posts
    20
    Plugin Contributions
    0

    Default Re: Unable to upgrade SQL from 139 to 154

    How come I am unable to get pass zencart license page.

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

    Default Re: Unable to upgrade SQL from 139 to 154

    ZC_old
    You have renamed this as it initially is named zc_install

    Rename it back to original and run it
    domain_name/zc_install
    How come I am unable to get pass zencart license page
    Please provide what you have done to this point
    Zen-Venom Get Bitten

  10. #10
    Join Date
    Apr 2015
    Location
    Royal Palm Beach, Florida, USA
    Posts
    20
    Plugin Contributions
    0

    Default Re: Unable to upgrade SQL from 139 to 154

    I am sorry, but it seems I messed the thing up. I was getting a message that I don't have admin/include/configure.php. This was there, but the installer somehow did not recognize it. So I noticed that Ipage when they had renamed it to zc_admin. I thought this is the problem and changed it to admin, but I lost the access to the store. The store still functions ok, but I have no way of administer it.How do I get working again?

 

 
Page 1 of 3 123 LastLast

Similar Threads

  1. v154 Upgrade from 150 to 154 did not change passwords in DB to $2Y format
    By spyderrobotics in forum General Questions
    Replies: 6
    Last Post: 11 Jan 2016, 07:31 PM
  2. Wich SQL to choose? upgr 138 to 139 or only sgl??
    By stefanl in forum Upgrading from 1.3.x to 1.3.9
    Replies: 39
    Last Post: 11 Jun 2010, 06:31 PM
  3. Unable to upgrade from 1.3.7 to 1.3.8a
    By adromidon in forum Upgrading from 1.3.x to 1.3.9
    Replies: 9
    Last Post: 3 Mar 2009, 12:31 AM
  4. unable to upgrade from 1.3.7 to 1.3.8
    By 2webbedfeet in forum Upgrading from 1.3.x to 1.3.9
    Replies: 6
    Last Post: 28 Jun 2008, 08:08 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