Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2003
    Posts
    1,155
    Plugin Contributions
    0

    Default Upgrade from 1.27d - Skipped: Cannot change column month because it does not exist.

    Hi All

    Upgrading from 1.27d

    In the mysql_upgrade_zencart_127_to_130.sql file there is the following:

    ALTER TABLE counter_history CHANGE month startdate CHAR( 8 ) NULL DEFAULT NULL;

    However, when I run that upgrade, I get the following error/exception:

    SKIPPED: Cannot CHANGE column month because it does not exist.

    Should there be a month column in the counter_history table?

    I don't see it in the 1.3.7.1 db for a fresh install

    Many thanks

  2. #2
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,402
    Plugin Contributions
    6

    Default Re: Upgrade from 1.27d - Cannot CHANGE column month because it does not exist.

    In the old days there was a month ... this is now startdate and holds the actual date ...
    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.5]
    Officially PayPal-Certified! Just click here

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...
    Signup for our Announcements Forums to stay up to date on important changes and updates!

  3. #3
    Join Date
    Nov 2003
    Posts
    1,155
    Plugin Contributions
    0

    Default Re: Upgrade from 1.27d - Cannot CHANGE column month because it does not exist.

    Thanks so much, Linda

 

 

Similar Threads

  1. v139h Not passing PCI compliance because 404 does not occur with a ~
    By jpietrowiak in forum General Questions
    Replies: 4
    Last Post: 4 Mar 2012, 05:07 AM
  2. Statements skipped during the upgrade from 1.38a to 1.3.9h
    By musicfreer in forum Upgrading from 1.3.x to 1.3.9
    Replies: 1
    Last Post: 13 Jan 2011, 08:40 PM
  3. Skipped:cannot .... because it already exists
    By Wilfred in forum Installing on a Linux/Unix Server
    Replies: 26
    Last Post: 22 Nov 2010, 08:48 PM
  4. The page you tried to access does not exist on this server. This page may not exist d
    By tman4j in forum Setting Up Categories, Products, Attributes
    Replies: 5
    Last Post: 1 May 2010, 10:44 PM
  5. i can't upgrade the special prices from month to month?
    By zooma in forum Setting Up Specials and SaleMaker
    Replies: 2
    Last Post: 1 Oct 2009, 06:56 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