Version 7 to Version 8 In Place Upgrade: Post-Upgrade Database Changes

The following SQL statements are required for this upgrade:

  • DROP TABLE core_custommenu
  • DROP TABLE core_stats
  • ALTER TABLE ecom_prod DROP COLUMN voltext
  • ALTER TABLE ecom_prod DROP COLUMN skinoverride
  • ALTER TABLE ecom_cat DROP COLUMN skinoverride
  • ALTER TABLE cms_dynforms DROP COLUMN skinoverride
  • ALTER TABLE cms_html DROP COLUMN skinoverride
  • ALTER TABLE core_apps DROP COLUMN defaultskin
  • ALTER TABLE core_namespaces DROP COLUMN defaultskin
  • ALTER TABLE cms_dynforms DROP COLUMN xhtmlskin
  • ALTER TABLE core_mail DROP COLUMN xhtmlskin
  • ALTER TABLE ecom_orders DROP COLUMN fax
  • ALTER TABLE core_users DROP COLUMN fax
  • ALTER TABLE ecom_prod DROP COLUMN featuredisp
  • ALTER TABLE ecom_prod DROP COLUMN reldisptype
  • ALTER TABLE ecom_prod DROP COLUMN reldispnum
  • DELETE FROM core_tabledefs WHERE tid='core_custommenu' OR tid='core_stats'
  • DELETE FROM core_columndefs WHERE cid LIKE 'core_stats.%' OR cid LIKE 'core_custommenu.%' OR cid='ecom_prod.voltext' OR cid LIKE '%.skinoverride' OR cid LIKE '%.defaultskin' OR cid LIKE '%.xhtmlskin' OR cid='ecom_orders.fax' OR cid='core_users.fax' OR cid='ecom_prod.featuredisp' OR cid='ecom_prod.reldisptype' OR cid='ecom_prod.reldispnum'
  • DELETE FROM core_incphp WHERE id='ecom.coimgone' OR id='ecom.coimgtwo' OR id='core.dashstats'OR id='ecom.ordersummaryco' OR id='ecom.olpheader' OR id='ecom.storemenuh' OR id='ecom.cartheader'OR id LIKE 'ecom.xmodquickbuy%' OR id='ecom.xmodreviews' OR id='core.formfield_textarearel' OR id='ecom.xmodbombatchinvfootl' OR id='ecom.breadcrumbs' OR id='core.skinwidgetmenucustom' OR id='core.skinwidgetpopular' OR id='core.skinwidgetrecent' OR id='core.dbrelate' OR id='core.formfield_textarearel' OR id='ecom.xmodshipestimator' OR id LIKE 'ecom.xmodshipestimator%' OR id='core.printmsg' OR id='core.xmodsitemap'
  • DELETE FROM core_namespaces WHERE id='ecom.ordersummaryco' OR id='ecom.checkoutp' OR id='core.dashstatsint' OR id='core.xmodhdseo' OR id='ecom.xmodquickbuy' OR id LIKE 'ecom.xmodquickbuy%' OR id='core.skinwidget_menucustom' OR id='core.managecustommenu' OR id='core.skinwidget_popular' OR id='core.skinwidget_recent' OR id='core.reportsadmin' OR id='ecom.xmodreviews' OR id='ecom.managexmodreviews' OR id LIKE 'ecom.xmodreviews%' OR id='ecom.xmodshipestimator' OR id='ecom.xmodshipestimatorf' OR id='core.xmodsitemap' OR id LIKE 'ecom.xmodfup%' OR id='ecom.prodshowint'
  • DELETE FROM core_settings WHERE id='core.xmodhdseo_status' OR id='ecom.disablebreadcrumbs' OR id='ecom.disablestoremenu' OR id='ecom.shipestimator_statusp' OR id='ecom.lang.GATEWAYDESC' OR id='ecom.showcoimg' OR id='ecom.lang.OPTPRICEREC' OR id='ecom.lang.OPTPRICEREG' OR id='ecom.disablewishlist' OR id='ecom.xmodquickbuy_status' OR id='ecom.prodfeaturenum' OR id='ecom.featprodtype' OR id='ecom.featprodnum' OR id='ecom.lang.OPTPRICEINC' OR id='ecom.lang.OPTPRICEDEC' OR id LIKE 'ecom.xmodreviews%' OR id LIKE 'ecom.xmodshipestimator%' OR id LIKE 'core.xmodsitemap%' OR id='core.postcodeanywhere_url' OR id='core.time_store_stats' OR id='ecom.lang.ADDTOCART'
  • DELETE FROM core_formfields WHERE id='core.mailsend.xhtmlskin' OR id='core.subscriptsend.xhtmlskin' OR id='ecom.guestco.fax' OR id='core.accountmaint.fax' OR id='core.createaccount.fax' OR id='core.siteownerfax'
  • DELETE FROM core_messages WHERE id='ecom.cosesschange' OR id='ecom.coordsetupconf' OR id LIKE 'ecom.xmodquickbuy%' OR id LIKE 'ecom.xmodreviews%' OR id LIKE 'core.xmodsendfu%'
  • DELETE FROM core_modules WHERE id='core.XMOD_HDSEO' OR id='ecom.XMOD_QuickBuy' OR id='ecom.XMOD_Reviews' OR id='ecom.XMOD_ShipEstimator' OR id='core.XMOD_SiteMap' OR id='ecom.XMOD_FollowUp' OR id='skin.Mail' OR id='skin.COREMI711'
  • DELETE FROM core_dbguided WHERE id='core.xmodhdseo.DBOVERCUSTTEXT' OR id LIKE 'ecom.xmodfollowup%'
  • DELETE FROM core_forms WHERE id='ecom.xmodreviews' OR id='ecom.xmodshipestimator' OR id='core.xmodfupsend' OR id='ecom.xmodquickbuy'
  • DELETE FROM core_selectcustom WHERE id LIKE 'ecom.prodfeature.%' OR id LIKE 'ecom.xmodshipestimator%' OR id LIKE 'core.xmodsitemap%' OR id LIKE 'ecom.xmodreviews%'
  • DELETE FROM core_formfields WHERE id LIKE 'ecom.xmodshipestimator%' OR id LIKE 'core.xmodfup%' OR id LIKE 'ecom.xmodreviews%' OR form='ecom.xmodquickbuy' OR id='core.appprofile.defaultskin'
  • DELETE FROM core_mail WHERE id='ecom.xmodreviews'
  • UPDATE ecom_prod SET reviewsavg='0', reviewsnum='0'
  • UPDATE core_forms SET description='Please enter your email address or username and password below to login.' WHERE id='core.login'
  • UPDATE core_namespaces SET name='Processing' WHERE id='ecom.manageorders'
  • UPDATE core_namespaces SET name='Account Overview' WHERE id='core.accountconf'
  • UPDATE core_namespaces SET name='Postal Code Lookup' WHERE id='core.postcodeanywhere_changeinfo' OR id='core.postcodeanywhere_lookupproc'
  • UPDATE core_namespaces SET hreftype='SSL' WHERE id='core.license' OR id='core.about' OR id='core.begenericconf' OR id='core.beaccountconf'
  • UPDATE core_namespaces SET hreftype='' WHERE id='ecom.olpsetup'
  • UPDATE core_namespaces SET name='Daily Activity Report' WHERE id='core.reportsday'
  • UPDATE core_namespaces SET name='Monthly Activity Report' WHERE id='core.reportsmonth'
  • UPDATE core_namespaces SET name='Yearly Activity Report' WHERE id='core.reportsyear'
  • UPDATE core_namespaces SET name='Page Access Totals Report' WHERE id='core.reportspages'
  • UPDATE core_namespaces SET name='Submit a Review' WHERE id='ecom.reviewsf'
  • UPDATE core_namespaces SET name='Submit a Review - Process' WHERE id='ecom.reviewsp'
  • UPDATE core_settings SET value='desc' WHERE id='ecom.splashcattype' OR id='ecom.splashprodtype' OR id='ecom.allprodtype' OR id='ecom.newprodtype' OR id='ecom.bestprodtype' OR id='ecom.searchprodtype' OR id='ecom.prodidxprodtype' OR id='ecom.specprodtype'
  • UPDATE ecom_gateway SET dispname='Purchase by transmitting a purchase order' WHERE id='purchord'
  • UPDATE core_formfields SET description='' WHERE id='core.contact.fname' OR id='core.contact.lname' OR id='core.contact.phone' OR id='core.contact.email_address' OR id='core.contact.message' OR id='core.login.user' OR id='core.login.password' OR id='core.sendpass.user' OR id='core.changepass.passnew1' OR id='core.changepass.passnew2' OR id='core.changeemail.emailnew1' OR id='core.changeemail.emailnew2' OR id='core.changeusername.usernamenew1' OR id='core.changeusername.usernamenew2' OR id='core.accountmaint.fname' OR id='core.accountmaint.lname' OR id='core.accountmaint.company' OR id='core.accountmaint.phone' OR id='core.accountmaint.addone' OR id='core.accountmaint.addtwo' OR id='core.accountmaint.city' OR id='core.accountmaint.country' OR id='core.accountmaint.postalcode' OR id='core.accountmaint.rescom' OR id='core.createaccount.emailnew1' OR id='core.createaccount.emailnew2' OR id='core.createaccount.usernamenew1' OR id='core.createaccount.usernamenew2' OR id='core.createaccount.passnew1' OR id='core.createaccount.passnew2' OR id='core.createaccount.fname' OR id='core.createaccount.lname' OR id='core.createaccount.company' OR id='core.createaccount.phone' OR id='core.createaccount.addone' OR id='core.createaccount.addtwo' OR id='core.createaccount.city' OR id='core.createaccount.country' OR id='core.createaccount.postalcode' OR id='core.createaccount.rescom' OR id='core.acctupgrade.fname' OR id='core.acctupgrade.lname' OR id='core.acctupgrade.phone' OR id='core.acctupgrade.email_address' OR id='core.acctupgrade.message' OR id='core.addbookins.fname' OR id='core.addbookins.lname' OR id='core.addbookins.company' OR id='core.addbookins.addone' OR id='core.addbookins.addtwo' OR id='core.addbookins.city' OR id='core.addbookins.country' OR id='core.addbookins.postalcode' OR id='core.addbookins.rescom' OR id='core.addbookupd.fname' OR id='core.addbookupd.lname' OR id='core.addbookupd.company' OR id='core.addbookupd.addone' OR id='core.addbookupd.addtwo' OR id='core.addbookupd.city' OR id='core.addbookupd.country' OR id='core.addbookupd.postalcode' OR id='core.addbookupd.rescom' OR id='core.gsubscript.email' OR id='core.gsubscriptcadd.change' OR id='core.gsubscriptcdel.change' OR id='core.postcodeanywhere_lookupshow.postcode' OR id='core.postcodeanywhere_changeinfo.seladdress' OR id='ecom.guestco.emailnew1' OR id='ecom.guestco.emailnew2' OR id='ecom.guestco.fname' OR id='ecom.guestco.lname' OR id='ecom.guestco.company' OR id='ecom.guestco.addone' OR id='ecom.guestco.addtwo' OR id='ecom.guestco.city' OR id='ecom.guestco.country' OR id='ecom.guestco.postalcode' OR id='ecom.guestco.rescom' OR id='ecom.prodsearch.string' OR id='ecom.prodsearch.type' OR id='ecom.prodsearch.resultspp' OR id='ecom.prodsearch.pricemin' OR id='ecom.prodsearch.pricemax' OR id='ecom.prodaddtocart.quantity' OR id='ecom.emailfriend.email' OR id='ecom.emailfriend.femail' OR id='ecom.emailfriend.msg' OR id='ecom.notifystock.email' OR id='ecom.reviews.nickname' OR id='ecom.reviews.email' OR id='ecom.reviews.subject' OR id='ecom.reviews.rating' OR id='ecom.reviews.ratingquality' OR id='ecom.reviews.ratingvalue' OR id='ecom.reviews.review' OR id='ecom.reviews.reviewpros' OR id='ecom.reviews.reviewcons' OR id='ecom.shipestimator.country' OR id='ecom.shipestimator.postalcode' OR id='ecom.shipestimator.rescom' OR id='ecom.guestco.phone' OR id LIKE 'core.belogin.%'
  • UPDATE ecom_gateway SET refurlstr='sagepay' WHERE id='protxform'
  • UPDATE core_formfields SET description='Browse your local hard drive and select the download file you wish to upload.' WHERE id='core.dlupload.upfile' OR id='core.mediaupload.upfile' OR id='core.skinupdupload.upfile'
  • UPDATE ecom_orders SET loyaltypointstotal='0.00'
  • UPDATE core_namespaces SET groupallow='superuser, admin' WHERE id='core.dbrelatejs' OR id='core.dbrelate'
  • UPDATE core_settings SET value='image/jpeg, image/pjpeg, image/x-png, image/png, image/gif' WHERE id='core.upload_filetypes'
  • UPDATE core_namespaces SET groupallow='superuser, admin' WHERE id='core.servernews' OR id='servernewsint'
  • UPDATE core_namespaces SET groupallow='superuser' WHERE id='ecom.paypalsfcc' OR id='ecom.paypalsfconfig' OR id='ecom.paypalsfconfirm' OR id='ecom.paypalsfintro' OR id='ecom.paypalsfpp' OR id='ecom.paypalsfproc' OR id='core.manageskins'
  • UPDATE core_formfields SET section='Billing Address' WHERE section='Address' AND (form='core.accountmaint' OR form='core.createaccount')
  • UPDATE core_stateprov SET taxrate='6.000' WHERE id='Maryland'
  • UPDATE core_country SET iseu='0' WHERE id='UK - Channel Islands'
  • UPDATE core_namespaces SET hreftype='Non-SSL' WHERE id='ecom.procgwresp'
  • UPDATE core_namespaces SET hreftype='' WHERE id='ecom.xmodgooglebase'
  • DELETE FROM core_messages WHERE id='cms.invalidpage' OR id='ecom.invaliditem'
  • DELETE FROM core_incphp WHERE id='cms.pagenotfound'
  • UPDATE ecom_gateway SET fieldtotal='xxxVar3', refurlstr='http' WHERE id='internetsecure'
  • UPDATE ecom_gateway SET fieldtotal='AMOUNT' WHERE id='epdqform'

If you had the Reviews Extension Module (XMOD) Installed, execute these statements:

  • DROP TABLE ecom_xmodreviews
  • DELETE FROM core_columndefs WHERE cid LIKE 'ecom_xmodreviews%'
  • DELETE FROM core_tabledefs WHERE tid='ecom_xmodreviews'

If you had the FollowUp Extension Module (XMOD) Installed, execute these statements:

  • DROP TABLE ecom_xmodfollowup
  • DELETE FROM core_columndefs WHERE cid LIKE 'ecom_xmodfollowup.%' OR cid='ecom_orderitems.xmodfup_sent'
  • DELETE FROM core_tabledefs WHERE tid='ecom_xmodfollowup'
  • ALTER TABLE ecom_orderitems DROP COLUMN xmodfup_sent

If you had the HDSEO Extension Module (XMOD) Installed, execute these statements:

  • DROP TABLE core_xmodhdseo
  • DELETE FROM core_columndefs WHERE cid LIKE 'core_xmodhdseo.%'
  • DELETE FROM core_tabledefs WHERE tid='core_xmodhdseo'
© 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.