PhotoPost Community - View Single Post - RP 4.1: Maximum number of letter in extra fields and line break

Chuck S · April 17th, 2009, 11:37 AM

The regular extra fields are VARCHAR 64 character fields. You would need to modify those to be bigger like this

ALTER TABLE rp_products CHANGE extra1 extra1 VARCHAR(255) DEFAULT NULL;
ALTER TABLE rp_products CHANGE extra2 extra2 VARCHAR(255) DEFAULT NULL;
ALTER TABLE rp_products CHANGE extra3 extra3 VARCHAR(255) DEFAULT NULL;
ALTER TABLE rp_products CHANGE extra4 extra4 VARCHAR(255) DEFAULT NULL;
ALTER TABLE rp_products CHANGE extra5 extra5 VARCHAR(255) DEFAULT NULL;
ALTER TABLE rp_products CHANGE extra6 extra6 VARCHAR(255) DEFAULT NULL;

April 17th, 2009, 11:37 AM	#8 (permalink)
Chuck S Photopost Developer Verified Customer Join Date: Jun 2002 Location: Abingdon,MD Posts: 71,689	The regular extra fields are VARCHAR 64 character fields. You would need to modify those to be bigger like this ALTER TABLE rp_products CHANGE extra1 extra1 VARCHAR(255) DEFAULT NULL; ALTER TABLE rp_products CHANGE extra2 extra2 VARCHAR(255) DEFAULT NULL; ALTER TABLE rp_products CHANGE extra3 extra3 VARCHAR(255) DEFAULT NULL; ALTER TABLE rp_products CHANGE extra4 extra4 VARCHAR(255) DEFAULT NULL; ALTER TABLE rp_products CHANGE extra5 extra5 VARCHAR(255) DEFAULT NULL; ALTER TABLE rp_products CHANGE extra6 extra6 VARCHAR(255) DEFAULT NULL; __________________ Photopost Developer and Support Engineer Please do not PM me for support or sales questions. Thank you for your understanding.