sms_error_-_missing_line_items [Support]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
====== Missing Products in an Order ======

===== Severity =====

===== Explanation of Error =====

===== Possible Root Cause(s) =====

===== Resolution =====

  - Determine the date the order was created or last edited (money change or status change).
  - If created since the last backup, the customer will have to edit the order and reenter the Products.
  - If created or edited before the last backup, [[:backup_database|]].
  - Create a folder in the SMS folder called TempData
  - Copy the Order Details Database and Order Modifier Database and indexes from the backup to the TempData folder*** - Open the DBBrowser - Go into the Select Alias tab in the DBBrowser and click the Create Alias button and select the TempData folder. - Check to see if a backup has the missing Line Item(s) (e.g. Filter by OrderID = XXXXX in the Order Details and Order Modifiers tables) - Open the Datbase Browser and run **SQL 1**
 - Run **SQL 2** for the Modifiers - [[:dbrebuild|]]
 - Don't forget to go back into the registry and change the Alias path back to the SMS\Data folder. * Note: The corruption could have occurred before the last backup. Check the Adjustments Database to see when the order was edited last. ===== SQL 1 ===== '' Insert into __GESHI_QUOT__Order Details Database__GESHI_QUOT__  Select * From __GESHI_QUOT__ [[\\ServerName\Cyrious$\SMS\TempData\Order|]] Details Database__GESHI_QUOT__  Where OrderID = XXXX ''  <html><div style="margin-left: 20px;">**Note:** ServerName is the name of the computer and use the correct OrderID </div></html>
      * When using the DBBrowser, the path is located at the bottom of the SQL screen.

===== SQL 1 =====

<code sql>
INSERT INTO "Order Details Database"
SELECT * FROM "\\ServerName\Cyrious$\SMS\TempData\Order Details Database"
WHERE OrderID = XXXX
</code>

=====   =====

===== SQL 2 =====

<code sql>
INSERT INTO "Order Modifiers Database"
SELECT * FROM "\\ServerName\Cyrious$\SMS\TempData\ORDER Modifiers Database"
WHERE OrderID = XXXX
</code>