Update KRYPT05212007A: Pre-Update Database Changes
The following SQL statements are required for this update:
- DELETE FROM khxc_incphp WHERE id='khxc.appsmenulogin' OR id='khxc.appsmenufail' OR id='khxc.recentmenufail' OR id='khxc.popularmenufail' OR id='ccp0.emailfrlink'
- DELETE FROM khxc_settings WHERE id='khxc.altrdbms.dbtype.3'
- UPDATE khxc_formfields SET section='Item Quantity', description='Enter the appropriate quantity for this item below.' WHERE id='ccp0.prodaddtocart.quantity'
- UPDATE ccp0_storemenu SET name='Shopping Cart' WHERE id='viewcart'
- UPDATE khxc_namespaces SET name='Shopping Cart' WHERE id='ccp0.viewcart' OR id='ccp0.addcart' OR id='ccp0.updatecart' OR id='ccp0.movecart' OR id='ccp0.deletecart'
- DELETE FROM ccp0_country
- DELETE FROM ccp0_stateprov
- DELETE FROM ccp0_prodcatdisp WHERE id='wadd' OR id='dsadd'
- DELETE FROM ccp0_proddetdisp