Update KRYPT10022007A: Pre-Update Database Changes

The following SQL statements are required for this update:

  • UPDATE khxc_namespaces SET groupallow='*', groupdeny='' WHERE namespace='addbook' OR namespace='addbookdelp' OR namespace='addbookins' OR namespace='addbookinsp' OR namespace='addbookupd' OR namespace='addbookupdp' OR namespace='checkoutp' OR namespace='coupdshipaddmult' OR namespace='coupdshipaddmultp' OR namespace='coupdshipaddsin' OR namespace='coupdshipaddsinp' OR namespace='gwprocinternal' OR namespace='olpsetup' OR namespace='orderprocess' OR namespace='ordersummary' OR namespace='ordersummaryco' OR namespace='paypalproexplink' OR namespace='printinvoice' OR namespace='orderlookup'
  • DELETE FROM khxc_namespaces WHERE id='ccp0.Cancel'
  • DELETE FROM khxc_namespaces WHERE id='khxc.Cancel'
  • DELETE FROM khxc_messages WHERE stringmsg='wishconfinv' OR stringmsg='addwishconf' OR stringmsg='cartconfinv' OR stringmsg='addcartconf' OR stringmsg='wishaddrnc' OR stringmsg='cartaddrnc' OR stringmsg='wishgenerr' OR stringmsg='cartgenerr' OR stringmsg='cartaddrncm' OR stringmsg='wishaddrncm' OR stringmsg='deletewishconf' OR stringmsg='deletecartconf' OR stringmsg='movecartconf' OR stringmsg='movewishconf' OR stringmsg='updatewishconf' OR stringmsg='updatecartconf' OR stringmsg='cocartinv'

Due to changes in the way inventory is handled in ClickCartPro, the column type for both the product inventory column and the product option selection items inventory column was changed. Changing the types of these columns will allow the software to better support fractional quantity orders. It is recommended you execute the following statements to update the column types for those two columns. These statements will work on MySQL databases only. It is recommended you execute these statements, however they are not required:

  • ALTER TABLE ccp0_prod CHANGE invlevel invlevel VARCHAR(20) NOT NULL DEFAULT ''
  • ALTER TABLE ccp0_prodoptionsel CHANGE inventory inventory VARCHAR(20) NOT NULL DEFAULT ''
© 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.