Expanding Related Field Sizes
The size of the field that is used to store "related" IDs is 250 characters by default. If you have a large number of categories, products or product options that use product option selection items OR the IDs you use for any of those things are quite long you may bump into the 255 character limit of the "related" columns. The instructions below explain how to increase the size of the "related" columns to 65,535 characters which should be more than enough for anyone.
Note: If you are using the Microsoft SQL server, MS SQL, these instructions must NOT be used due to a restriction in how columns may be selected. Changing these when using MS SQL will "break" ClickCartPro.
In each section below you will find the commands for the US and UK/EU versions of ClickCartPro.
All of the commands may be entered using the admin area of ClickCartPro. In admin under Home > Hybrid X Core > Database: Connections, Backups and Raw Admin > Raw Database Admin
click on SQL Statement: Submit a Raw SQL Statement and enter the commands shown one at a time.
Related Product Options field in the product table
US
ALTER TABLE `ccp0_prod` CHANGE `xprodoptions` `xprodoptions` TEXT NULL
UPDATE `khxc_columndefs` SET `cnumeric` = '' WHERE `khxc_columndefs`.`cid` = 'ccp0_prod.xprodoptions' LIMIT 1
UK/EU
ALTER TABLE `gbu0_prod` CHANGE `xprodoptions` `xprodoptions` TEXT NULL
UPDATE `khxc_columndefs` SET `cnumeric` = '' WHERE `khxc_columndefs`.`cid` = 'gbu0_prod.xprodoptions' LIMIT 1
Related Categories field in the product table
US
ALTER TABLE `ccp0_prod` CHANGE `xcat` `xcat` TEXT NULL
UPDATE `khxc_columndefs` SET `cnumeric` = '' WHERE `khxc_columndefs`.`cid` = 'ccp0_prod.xcat' LIMIT 1
UK/EU
ALTER TABLE `gbu0_prod` CHANGE `xcat` `xcat` TEXT NULL
UPDATE `khxc_columndefs` SET `cnumeric` = '' WHERE `khxc_columndefs`.`cid` = 'gbu0_prod.xcat' LIMIT 1
Related Products field in the product table
US
ALTER TABLE `ccp0_prod` CHANGE `xprod` `xprod` TEXT NULL
UPDATE `khxc_columndefs` SET `cnumeric` = '' WHERE `khxc_columndefs`.`cid` = 'ccp0_prod.xprod' LIMIT 1
UK/EU
ALTER TABLE `gbu0_prod` CHANGE `xprod` `xprod` TEXT NULL
UPDATE `khxc_columndefs` SET `cnumeric` = '' WHERE `khxc_columndefs`.`cid` = 'gbu0_prod.xprod' LIMIT 1
Related Categories field in the category table
US
ALTER TABLE `ccp0_cat` CHANGE `xcat` `xcat` TEXT NULL
UPDATE `khxc_columndefs` SET `cnumeric` = '' WHERE `khxc_columndefs`.`cid` = 'ccp0_cat.xcat' LIMIT 1
UK/EU
ALTER TABLE `gbu0_cat` CHANGE `xcat` `xcat` TEXT NULL
UPDATE `khxc_columndefs` SET `cnumeric` = '' WHERE `khxc_columndefs`.`cid` = 'gbu0_cat.xcat' LIMIT 1
Related Product Option Selection Items field in the product options table
US
ALTER TABLE `ccp0_prodoptions` CHANGE `xprodoptionsel` `xprodoptionsel` TEXT NULL
UPDATE `khxc_columndefs` SET `cnumeric` = '' WHERE `khxc_columndefs`.`cid` = 'ccp0_prodoptions.xprodoptionsel' LIMIT 1
UK/EU
ALTER TABLE `gbu0_prodoptions` CHANGE `xprodoptionsel` `xprodoptionsel` TEXT NULL
UPDATE `khxc_columndefs` SET `cnumeric` = '' WHERE `khxc_columndefs`.`cid` = 'gbu0_prodoptions.xprodoptionsel' LIMIT 1
CategoryAdministration
There are no comments on this page. [Add comment]