Kryptronic Software Wiki : ChangingFieldSizes

Kryptronic Internet Software Solutions
Most recent edit on 2009-02-23 07:20:24 by KryptronicWebmaster [Separated SQL commands so each one may be "grabbed" individually]

No differences.

Edited on 2008-10-10 13:52:27 by KryptronicWebmaster [Added explanation of what these changes may be used for]

Additions:
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.

Deletions:
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 instructions for both the US and UK/EU versions of ClickCartPro.


Edited on 2008-10-10 13:45:00 by KryptronicWebmaster [Assigned to "live" categories]

Additions:
Wiki: ClickCartPro 6
ClickCartPro - Administration

Deletions:
Wiki: Pending Inclusion


Edited on 2008-10-10 13:44:00 by KryptronicWebmaster [Highlighted table names for each section]

Additions:
Related Product Options field in the product table
Related Categories field in the product table
Related Products field in the product table
Related Categories field in the category table
Related Product Option Selection Items field in the product options table


Deletions:
Related Product Options field in the product table
Related Categories field in the product table
Related Products field in the product table
Related Categories field in the category table
Related Product Option Selection Items field in the product options table



Edited on 2008-10-10 13:25:01 by KryptronicWebmaster [Added the rest of the fields and tables]

Additions:
US 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


Edited on 2008-10-10 13:15:52 by KryptronicWebmaster

Additions:

Expanding Related Field Sizes

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 instructions for both 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


Deletions:

Enter Page Title Here

Change size of Related Product Options field in the product table

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 following commands one at a time:


Oldest known version of this page was edited on 2008-10-10 12:22:03 by KryptronicWebmaster [Gather field size changing code in one place]
Page view:

Enter Page Title Here


Change size of Related Product Options field in the product table


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 following commands one at a time:

ALTER TABLE `ccp0_prod` CHANGE `xprodoptions` `xprodoptions` TEXT NULL

UPDATE `khxc_columndefs` SET `cnumeric` = '' WHERE `khxc_columndefs`.`cid` = 'ccp0_prod.xprodoptions' LIMIT 1



Wiki: Pending Inclusion
Page History :: 2009-02-23 07:20:24 XML :: Owner: KryptronicWebmaster :: Search: