Update KRYPT08132008A: Post-Update Database Changes

The following SQL statements are required for this update:

  • UPDATE ccp0_prodoptions SET section='Options'
  • DELETE FROM khxc_columndefs WHERE cid LIKE '%.deschastags' OR cid LIKE '%.cssclass'
  • DELETE FROM khxc_columndefs WHERE cid='khxc_dbguided.xtable'

In addition, MySQL users should execute the following statements.

Those using a database other than MySQL should delete all columns named 'cssclass' and 'deschastags' from the tables 'khxc_dbguided', 'khxc_formfields', 'khxc_forms', 'ccp0_dynformfields', 'ccp0_dynforms', 'ccp0_prodoptions', 'ccp0_cat', 'ccp0_prod' and 'ccp0_cofields'. This can be done by accessing the Raw DB Admin function and choosing to Maintain each of these tables from the main overview screen. You'll have the option to drop those columns on the manage table screen.

  • ALTER TABLE khxc_dbguided DROP COLUMN xtable
  • ALTER TABLE khxc_formfields DROP COLUMN deschastags
  • ALTER TABLE khxc_formfields DROP COLUMN cssclass
  • ALTER TABLE khxc_forms DROP COLUMN deschastags
  • ALTER TABLE ccp0_dynformfields DROP COLUMN deschastags
  • ALTER TABLE ccp0_dynformfields DROP COLUMN cssclass
  • ALTER TABLE ccp0_dynforms DROP COLUMN deschastags
  • ALTER TABLE ccp0_prodoptions DROP COLUMN deschastags
  • ALTER TABLE ccp0_prodoptions DROP COLUMN cssclass
  • ALTER TABLE ccp0_cat DROP COLUMN deschastags
  • ALTER TABLE ccp0_prod DROP COLUMN deschastags
  • ALTER TABLE ccp0_cofields DROP COLUMN deschastags
  • ALTER TABLE ccp0_cofields DROP COLUMN cssclass
© 1999-Present Kryptronic, Inc. All rights reserved worldwide. Kryptronic, the Kryptronic logo and all Kryptronic software names and logos are trademarks of Kryptronic, Inc. All Kryptronic software is copyrighted and the intellectual property of Kryptronic, Inc. All Kryptronic software is developed and distributed under license by Kryptronic, Inc.