Zen Cart Logo
Forums / Bug Reports / installer didn't add new field to customer table.

installer didn't add new field to customer table.

Views: 1,237

Results 1 to 5 of 5
26 Feb 2023, 5:24 PM
#1
delia avatar

delia

Totally Zenned

Join Date:
May 2006
Location:
Gardiner, Maine
Posts:
2,383
Plugin Contributions:
7

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.

26 Feb 2023, 8:31 PM
#2
swguy avatar

swguy

Administrator

Join Date:
Feb 2006
Location:
Tampa Bay, Florida
Posts:
10,682
Plugin Contributions:
56

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/upgrading/date_standardization/

If the site uses the GDPR mod, note that several tables may have this issue - check carefully.

26 Feb 2023, 9:01 PM
#3
delia avatar

delia

Totally Zenned

Join Date:
May 2006
Location:
Gardiner, Maine
Posts:
2,383
Plugin Contributions:
7

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.

26 Feb 2023, 9:58 PM
#4
swguy avatar

swguy

Administrator

Join Date:
Feb 2006
Location:
Tampa Bay, Florida
Posts:
10,682
Plugin Contributions:
56

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.

27 Feb 2023, 1:06 PM
#5
mc12345678 avatar

mc12345678

Totally Zenned

Join Date:
Jul 2012
Posts:
16,908
Plugin Contributions:
2

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.