Results 1 to 5 of 5
  1. #1
    Join Date
    May 2006
    Location
    Gardiner, Maine
    Posts
    2,296
    Plugin Contributions
    22

    Default installer didn't add new field to customer table.

    Updating from 1.5.6c, the new field for registration_ip was not added in the upgrade. I do see it in the present sql file but not as added since I did that update. This was on a website where 71 logs were created during the upgrade. Do I then assume this was due to the state of that website and not a bug in the upgrade? I have another upgrade from 1.5.6 coming up this week.
    The full-time Zen Cart Guru. WizTech4ZC.com

  2. #2
    Join Date
    Feb 2006
    Location
    Tampa Bay, Florida
    Posts
    9,705
    Plugin Contributions
    123

    Default Re: installer didn't add new field to customer table.

    Typically this occurs because there's a date in the table that's in the old format.

    https://docs.zen-cart.com/user/upgra...andardization/

    If the site uses the GDPR mod, note that several tables may have this issue - check carefully.
    That Software Guy. My Store: Zen Cart Modifications
    Available for hire - See my ad in Services
    Plugin Moderator, Documentation Curator, Chief Cook and Bottle-Washer.
    Do you benefit from Zen Cart? Then please support the project.

  3. #3
    Join Date
    May 2006
    Location
    Gardiner, Maine
    Posts
    2,296
    Plugin Contributions
    22

    Default Re: installer didn't add new field to customer table.

    yeah, the GDPR was there. You had mentioned that before. Good. Next one will be easier!! Thanks.
    The full-time Zen Cart Guru. WizTech4ZC.com

  4. #4
    Join Date
    Feb 2006
    Location
    Tampa Bay, Florida
    Posts
    9,705
    Plugin Contributions
    123

    Default Re: installer didn't add new field to customer table.

    Look very carefully at the logs created by the install process - they will tell you when things go wrong.
    That Software Guy. My Store: Zen Cart Modifications
    Available for hire - See my ad in Services
    Plugin Moderator, Documentation Curator, Chief Cook and Bottle-Washer.
    Do you benefit from Zen Cart? Then please support the project.

  5. #5
    Join Date
    Jul 2012
    Posts
    16,734
    Plugin Contributions
    17

    Default Re: installer didn't add new field to customer table.

    General suggestion would be to fix the identified issues back on the live site, again make a backup of the database and then perform the update/update test to correct any remaining issues.
    ZC Installation/Maintenance Support <- Site
    Contribution for contributions welcome...

 

 

Similar Threads

  1. v150 Help with addon MSRP: Add a new field to the products table
    By Johnnycopilot in forum All Other Contributions/Addons
    Replies: 5
    Last Post: 5 Jan 2014, 11:28 PM
  2. should I add new table to store new field?
    By linjuming in forum General Questions
    Replies: 4
    Last Post: 21 Feb 2013, 06:35 PM
  3. Additional Customer Field Using a New Table
    By perlgerl in forum General Questions
    Replies: 0
    Last Post: 18 Oct 2009, 03:05 PM
  4. Add new field to product table?
    By ckad79 in forum Setting Up Categories, Products, Attributes
    Replies: 1
    Last Post: 19 May 2009, 11:24 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