Page 1 of 2 12 LastLast
Results 1 to 10 of 15
  1. #1
    Join Date
    Mar 2004
    Location
    Calgary, Alberta
    Posts
    290
    Plugin Contributions
    1

    Default 1.3.0.2 Install problem

    Using Windows, and MySQL 5.

    I had a 1.3.0.0 moved it to 1.3.0.1 and then tried upgrading to 1.3.0.2 and received this error....

    1364 Field 'query_keys_list' doesn't have a default value
    in:
    [INSERT INTO query_builder ( query_category , query_name , query_description , query_string ) VALUES ('email,newsletters', 'Administrator', 'Just the email account of the current administrator', 'select \'ADMIN\' as customers_firstname, admin_name as customers_lastname, admin_email as customers_email_address from TABLE_ADMIN where admin_id = $SESSION:admin_id');]

  2. #2
    Join Date
    Jan 2004
    Posts
    66,364
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: 1.3.0.2 Install problem

    Hmmm... not sure why the table doesn't have a default set for that field.
    However, if you run this command via phpMyAdmin or perhaps the SQL Patch tool, you should be able to proceed:

    Code:
    ALTER TABLE query_builder CHANGE COLUMN query_keys_list query_keys_list TEXT NOT NULL default '' ;

    EDIT: Looks like you must have upgraded from v1.2.5 or earlier at some point, and this change didn't get set in your database.
    Thus, you should in fact do all of the following:

    Code:
    ALTER TABLE query_builder CHANGE COLUMN query_category query_category varchar(40) NOT NULL default '';
    ALTER TABLE query_builder CHANGE COLUMN query_name query_name varchar(80) NOT NULL default '';
    ALTER TABLE query_builder CHANGE COLUMN query_description query_description TEXT NOT NULL default '';
    ALTER TABLE query_builder CHANGE COLUMN query_string query_string TEXT NOT NULL default '';
    ALTER TABLE query_builder CHANGE COLUMN query_keys_list query_keys_list TEXT NOT NULL default '';
    The above is not necessary if you started with a fresh v1.2.6 or newer database at some point.
    Last edited by DrByte; 22 Jun 2006 at 06:32 AM.
    .

    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.

  3. #3
    Join Date
    Mar 2004
    Location
    Calgary, Alberta
    Posts
    290
    Plugin Contributions
    1

    Default Re: 1.3.0.2 Install problem

    Thanks that really helped.

    It worked but gave this as a warning. Thought I'd mention them just in case they were required.

    SKIPPED: Cannot insert configuration_key "UPLOAD_PREFIX" because it already exists
    SKIPPED: Cannot insert configuration_key "TEXT_PREFIX" because it already exists
    SKIPPED: Cannot insert configuration_key "MAX_META_TAG_DESCRIPTION_LENGTH" because it already exists
    SKIPPED: Cannot insert configuration_key "MAX_META_TAG_DESCRIPTION_LENGTH" because it already exists
    SKIPPED: Cannot insert configuration_key "MAX_META_TAG_DESCRIPTION_LENGTH" because it already exists

  4. #4
    Join Date
    Jan 2004
    Posts
    66,364
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: 1.3.0.2 Install problem

    Those are to be expected given partial updates already completed prior to the previously-failed statement that threw the error.
    .

    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.

  5. #5
    Join Date
    Feb 2006
    Location
    Switzerland
    Posts
    16
    Plugin Contributions
    0

    Default Re: 1.3.0.2 Install problem

    Thanks also, I had the same problem as well (upgrading step by step from 1.2.7, this occured wun upgrading from 1.3.0.1 to 1.3.0.2)

    Should we consider everything is okay even with this warnings ? Or did the rest of the upgrade stopped ?

  6. #6
    Join Date
    Jan 2004
    Posts
    66,364
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: 1.3.0.2 Install problem

    These "skipped" warnings can be safely ignored:
    Quote Originally Posted by quentinjs
    SKIPPED: Cannot insert configuration_key "UPLOAD_PREFIX" because it already exists
    SKIPPED: Cannot insert configuration_key "TEXT_PREFIX" because it already exists
    SKIPPED: Cannot insert configuration_key "MAX_META_TAG_DESCRIPTION_LENGTH" because it already exists
    SKIPPED: Cannot insert configuration_key "MAX_META_TAG_DESCRIPTION_LENGTH" because it already exists
    SKIPPED: Cannot insert configuration_key "MAX_META_TAG_DESCRIPTION_LENGTH" because it already exists
    .

    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.

  7. #7
    Join Date
    May 2006
    Posts
    51
    Plugin Contributions
    0

    Default Re: 1.3.0.2 Install problem

    I had an issue with my upgrade as well, telling that it skipped 9 updates in the database because ... already existed.

    Now, I have two problems:
    1. In the Admin panel, there is a message at the top saying:
    "Your database appears to need patching to a higher level. See Tools->Server Information to review patch levels."
    And in the Server Info, it stills has it listed as 1.3.0.1.

    2. I can get into the Admin area, but when I try to go to the home page, I get the following error and won't display the page:
    "Parse error: parse error, unexpected $ in /home/public_html/includes/functions/html_output.php on line 145


    I'm not sure what to do.

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

    Default Re: 1.3.0.2 Install problem

    What version where you upgrading from?

    If you check the /zc_install Upgrade Database ... does it indicate that something is still needing upgrading?

    Did you load all of the new files to your site?
    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!

  9. #9
    Join Date
    May 2006
    Posts
    51
    Plugin Contributions
    0

    Default Re: 1.3.0.2 Install problem

    I tried to upgrade from 1.3.0.1.

    Running the / zc_install Upgrade Database does not check the box for "Upgrade DB from 1.3.0.1 to 1.3.0.2"

    and if I do check the "Upgrad DB from 1.3.0.1 to 1.3.0.2" I get the following displayed:
    Code:
    1062 Duplicate entry 'Administrator' for key 2
    in:
    [INSERT INTO zcart_query_builder ( query_category , query_name , query_description , query_string ) VALUES ('email,newsletters', 'Administrator', 'Just the email account of the current administrator', 'select \'ADMIN\' as customers_firstname, admin_name as customers_lastname, admin_email as customers_email_address from TABLE_ADMIN where admin_id = $SESSION:admin_id');]
    Ignore my "parse error" - I did forget to upload the new html_output file.

    So, the only problem I'm having is the database upgrade message.

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

    Default Re: 1.3.0.2 Install problem

    Are you sure that all of your files on the site were all upgraded properly?

    What do you have in:
    /includes/version.php
    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!

 

 
Page 1 of 2 12 LastLast

Similar Threads

  1. Install Problem
    By susieQ in forum Installing on a Windows Server
    Replies: 8
    Last Post: 29 Oct 2007, 07:28 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
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR