Announcement

Collapse
No announcement yet.

How to correct missing primary keys in the SellerDeck database (version 9 only).

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

    How to correct missing primary keys in the SellerDeck database (version 9 only).

    Missing primary keys in the SellerDeck database can cause performance issues such as slow deletion of products, switching between sections in the content tree and copy and pasting duplicates in the content tree with Business plus. If you are suffering similar issues to these you should check that the primary keys in your database are ok.

    These instructions must be performed with great care. Do not make any changes to the database other than what is specified below. You will need Microsoft office Access to make these checks*.

    Instructions to check your databases primary keys are present:

    1. First make a backup of your site. (File | Snapshot | Export site)
    2. CLOSE SELLERDECK DOWN on all PC’s
    3. Browse to your Site** folder (If there is only one site within the software it will be called 'Site1', if there are multiple sites within the software you will need to browse to the site folder name corresponding to the current site you are using)
    4. Right click on 'ActinicCatalog.mdb', and select 'Open with | Microsoft Office Access'
    5. Go to View | Database Objects | Tables
    6. Click on the first table in the list, which should be “Additional Files”, then click the icon “Design”.
    7. Make sure the table has a primary key against “nID”. The primary key will appear as a small key in the first column of the table.
    8. Close the table
    9. Repeat this process of checking the database for a primary key in each of 32+ tables in the database. Make a note of all the tables which do not have a primary key. All tables in the database should have a primary key except “PreprocessedTaxTable” and “tempOrphanDuplicateQuery” or any tables with do not appear in the default SellerDeck database (List of tables below). If there are no missing primary keys, close the database down. There is no need to follow the steps below.

    Instructions to reinstate missing primary keys:

    10. In 9. you made a note of all the tables that are missing primary keys. Look at the list of tables and primary keys below; you will be able to see what the missing keys should be.
    11. To reinstate a missing primary key, for example the “Additional Files” table, click on the table then click the icon “Design”.
    12. Right click on the field which should be the primary key and select “Primary Key”, in this example it is “nID”. (Remember to check what the primary key should be in the “Original” database)
    13. Click the save icon, then close the table. (If an error occurs when you try to save the primary key, make sure you are trying to assign the primary key to the correct field. If you are trying to assign the primary key to the correct field, you may need to contact SellerDeck support to have these tables corrected.)
    14. Repeat this process for all the tables which are missing primary keys.
    15. Close the database down and continue as normal. Revert to your backup if you experience any problems as a result of this.

    List of tables and primary keys:
    <table border="1" cellspacing="0" cellpadding="3"><tbody><tr><th>Tables</th><th>Primary Key</th></tr><tr><td>Additional Files</td><td>nID</td></tr><tr><td>Address</td><td>nID</td></tr><tr><td>AlsoBought</td><td>nID</td></tr><tr><td>BestSellers </td><td>nID</td></tr><tr><td>BrochureFragments</td><td>nFragmentID</td></tr><tr><td>BrochurePages</td><td>nPageID</td></tr><tr><td>Buyer</td><td>nID</td></tr><tr><td>Catalog</td><td>nID</td></tr><tr><td>Catalog section </td><td>nSectionID</td></tr><tr><td>Checkout Phase</td><td>nBlockID</td></tr><tr><td>Checkout Prompt</td><td>nKey</td></tr><tr><td>ColorScheme</td><td>sName</td></tr><tr><td>Configuration</td><td>EntryName</td></tr><tr><td>ContentCategories</td><td>nID</td></tr><tr><td>ContentLists</td><td>nID</td></tr><tr><td>Countries</td><td>nID</td></tr><tr><td>CreditCard</td><td>nID</td></tr><tr><td>Currencies</td><td>nID</td></tr><tr><td>Customer</td><td>nID</td></tr><tr><td>DesignObjects</td><td>nID</td></tr><tr><td>DesignObjectTypes</td><td>nID</td></tr><tr><td> </td><td>sName</td></tr><tr><td> </td><td> </td></tr><tr><td>DesignProperties</td><td>nID</td></tr><tr><td>DesignPropertyGroup</td><td>nID</td></tr><tr><td>DiscountProductGroups</td><td>nID</td></tr><tr><td>DiscountRestrictionList</td><td>nID</td></tr><tr><td>Discounts</td><td>nDiscountID</td></tr><tr><td>DiscountTriggers</td><td>nID</td></tr><tr><td>DuplicatedFields</td><td>nID</td></tr><tr><td>ECMachine</td><td>nMachineID</td></tr><tr><td>ECUser</td><td>nUserID</td></tr><tr><td>EPOSPriceMapping</td><td>nID</td></tr><tr><td>EPOSTaxMapping</td><td>nID</td></tr><tr><td>FileList</td><td>nID</td></tr><tr><td>Formatting</td><td>nID</td></tr><tr><td>ImportMappings</td><td>MappingID</td></tr><tr><td>LandlordAdjustment</td><td>nID</td></tr><tr><td>Marketing Text</td><td>nIndex</td></tr><tr><td>MergeFileState</td><td>sFile</td></tr><tr><td>ML_TEMP_PRINTING_TABLE</td><td>nID</td></tr><tr><td>New Names</td><td>sName</td></tr><tr><td>NewProducts </td><td>nID</td></tr><tr><td>OCCCurrencies</td><td>nID</td></tr><tr><td>OCCOptionalCurrencies</td><td>nID</td></tr><tr><td>OCCProvider</td><td>ID</td></tr><tr><td>OCCProviderAttributes</td><td>nID</td></tr><tr><td>OCCVersions</td><td>ProviderID</td></tr><tr><td>Order</td><td>Order Sequence Number</td></tr><tr><td>OrderColor</td><td>nID</td></tr><tr><td>OrderDetail</td><td>OrderDetailID</td></tr><tr><td>OrderHistory</td><td>nID</td></tr><tr><td>OrderMail</td><td>nMailID</td></tr><tr><td>OrderTracking</td><td>nID</td></tr><tr><td>PageTypes</td><td>nID</td></tr><tr><td>PaymentHistory</td><td>nID</td></tr><tr><td>PaymentMethodLocations</td><td>nPaymentMethodID</td></tr><tr><td> </td><td>nLocationID</td></tr><tr><td> </td><td> </td></tr><tr><td>PaymentMethodRegions</td><td>nPaymentMethodID</td></tr><tr><td> </td><td>nRegionID</td></tr><tr><td> </td><td> </td></tr><tr><td>PaymentMethods</td><td>nID</td></tr><tr><td>PaymentRegionLocations</td><td>nRegionID</td></tr><tr><td> </td><td>nLocationID</td><tr><td> </td><td> </td></tr><tr><td>PaymentRegions</td><td>nID</td></tr><tr><td>Person</td><td>ContactID</td></tr><tr><td>PreprocessedTaxTable</td><td>(NONE for this table)</td></tr><tr>
    <td>Price Schedules</td><td>nID</td></tr><tr><td>Prices</td><td>nPriceID</td></tr><tr><td>Product</td><td>Product Reference</td></tr><tr><td>ProductLinkInfo</td><td>sInternalFieldName</td></tr><tr><td>ProductProperties</td><td>nPropertyID</td></tr><tr><td>PropertyTabs</td><td>nTabID</td></tr><tr><td>RelatedProducts</td><td>nID</td></tr><tr><td>SearchPriceBand </td><td>nMaximum</td></tr><tr><td>Section Classifications</td><td>nID</td></tr><tr><td>Setup</td><td>Magic number</td></tr><tr><td>Setup2</td><td>nID</td></tr><tr><td>Setup3</td><td>nID</td></tr><tr><td>SetupInfo</td><td>nID</td></tr><tr><td>SSL Provider</td><td>nID</td></tr><tr><td>SSL Provider Versions</td><td>ProviderID</td></tr><tr><td>SSPOnlineErrorData</td><td>nID</td></tr><tr><td>SSPProvider</td><td>nProviderID</td></tr><tr><td>SSPProviderClasses</td><td>nID</td></tr><tr><td>SSPProviderFeature</td><td>nID</td></tr><tr><td>SSPProviderFeatureSetup</td><td>nProviderID</td></tr><tr><td> </td><td>sFeatureName</td></tr><tr><td> </td><td>sVariableName</td><tr><td> </td><td> </td></tr><tr><td>SSPProviderVersions</td><td>ProviderID</td></tr><tr><td>States</td><td>nID</td></tr><tr><td>TaxBands</td><td>nBandID</td></tr><tr><td>Taxes</td><td>nTaxID</td></tr><tr><td>TaxModels</td><td>nModelID</td></tr><tr><td>TaxOrderOpaqueData</td><td>OrderSequenceNumber </td></tr><tr><td> <td>nOrderDetailID</td></td></tr><tr><td> </td><td>nTaxID</td></tr><tr><td> </td><td>eTaxOpaqueDataType</td></tr><tr><td>TaxSetup</td><td>nModelID</td></tr><tr><td>TaxZoneMembers</td><td>nTaxZoneMemberID</td></tr><tr><td>TaxZones</td><td>nZoneID</td></tr><tr><td> </td><td>nModelID</td></tr><tr><td>tempOrphanDuplicateQuery</td><td>(NONE for this table)</td></tr><tr><td>TrueFalseValues</td><td>nID</td></tr><tr><td>UserDefinedProperties</td><td>nID</td></tr><tr><td>Variable</td><td>nID</td></tr><tr><td>WarningStatus</td><td>nDescriptionId</td></tr></tr></tr></tbody><tbody><tr><tr></tr></tr></tbody></table>

    * Microsoft Access is supplied as part of the 'Microsoft Office Professional' program suite; it is not supplied by SellerDeck.
    ** Depending on the installation option chosen or operating system used, the 'Site' folder can be found in either 'My Documents', 'Documents', 'Shared Documents' or 'Program Files' in the folder 'SellerDeck vX\Sites\' (with X replacing the version number).

    This is a legacy article and intended for use with version 9 of the software. It is not relevant for version 10 software and later
Working...
X