Forum

Ask, reply and learn. Join the community of Akaunting.

New Discussion

city, state, zip_code, country missing from wj9_contacts

Scott Carson   ( User )

Commented 3 years ago

Hey,

Similar to my post about "created_from" and "created_by", an upgrade from 2.1.23 to 2.1.27 resulted in an error upon saving a customer that the columns city, state, zip_code, and country are missing from the wj9_contacts table. I took a guess and added them after the address column as follows:

city - varchar(191) - default NULL
state - varchar(191) - default NULL
zip_code - varchar(10) - default NULL
country - varchar(191) - default NULL

... but I have no clue if varchar or the length is correct.

Hope this helps?
-S.

Please login or register to leave a response.

Showing 1 to 1 of 1 discussions