nathan1

Forum Replies Created

Viewing 15 posts - 16 through 30 (of 31 total)
  • Author
    Posts
  • in reply to: mysql error #63021

    nathan1
    Participant

    I can’t figure out how to change that, do you know where I can find that setting?

    in reply to: mysql error #63015

    nathan1
    Participant

    here it is

    Attachments:
    You must be logged in to view attached files.
    in reply to: mysql error #63014

    nathan1
    Participant

    Some of the log stuff is confusing because I reinstalled and then updated to 2018 QB etc but here it is

    in reply to: lost a bunch of my tasks #28033

    nathan1
    Participant

    I had changed my UAC user access control in Windows and made it more strict. It removed most of my things. Then I took that off and all was back.

    in reply to: lost a bunch of my tasks #27583

    nathan1
    Participant

    I didn’t find any text or editable files so I guess it’s locked. In the future can I copy one particular file to back it up so this doesn’t happen again? I’m going to lose hours and days trying to get all my stuff back.

    in reply to: lost a bunch of my tasks #27577

    nathan1
    Participant

    2.0

    in reply to: lost a bunch of my tasks #27571

    nathan1
    Participant

    where is the current config file located?

    in reply to: Tables aren't getting updated or populated #16270

    nathan1
    Participant

    It’s fixed ( I think). I setup a custom field and for some reason it didn’t work I guess. So I removed the custom field, renamed my inventory assembly table back to the original name and it seemed to populate. All resolved. Now I just have to figure out how I can use a custom field. I’ll figure it out from here.

    in reply to: Tables aren't getting updated or populated #16269

    nathan1
    Participant

    2017-07-16 17:44:27 -2147217865 ModAccess ERROR: [MySQL][ODBC 3.51 Driver][mysqld-5.6.35-cll-lve]Table ‘opensync.dataextdetail’ doesn’t exist(GenDeleteTable in table dataextdetail )
    2017-07-16 17:44:27 -2147217865 ModAccess ERROR: [MySQL][ODBC 3.51 Driver][mysqld-5.6.35-cll-lve]Table ‘opensync.dataextdetail’ doesn’t exist(GenDeleteTable in table dataextdetail )
    2017-07-16 17:44:27 -2147217865 ModAccess ERROR: [MySQL][ODBC 3.51 Driver][mysqld-5.6.35-cll-lve]Table ‘opensync.dataextdetail’ doesn’t exist(GenDeleteTable in table dataextdetail )
    2017-07-16 17:44:27 -2147217865 ModAccess ERROR: [MySQL][ODBC 3.51 Driver][mysqld-5.6.35-cll-lve]Table ‘opensync.dataextdetail’ doesn’t exist(DoLineItemUpdate in table dataext 80000329-1484933589)
    2017-07-16 17:44:27 -2147217865 ModAccess ERROR: [MySQL][ODBC 3.51 Driver][mysqld-5.6.35-cll-lve]Table ‘opensync.dataextdetail’ doesn’t exist(GenMakeDBRecs: [MySQL][ODBC 3.51 Driver][mysqld-5.6.35-cll-lve]Table ‘opensync.dataextdetail’ doesn’t exist in table iteminventoryassembly 0 alt item code STR255TYPE Component c019 80000329-1484933589)
    2017-07-16 17:45:59 0 ModAccess Connect from: OpenSync
    2017-07-16 17:46:04 0 ModAccess Populate Table: Item Discount
    2017-07-16 17:46:05 0 ModAccess Populate Table: Item Fixed Asset
    2017-07-16 17:46:06 0 ModAccess Populate Table: Item Group
    2017-07-16 17:46:09 0 ModAccess Populate Table: Item Inventory
    2017-07-16 17:46:27 0 ModAccess Populate Table: Item Inventory Assembly
    2017-07-16 17:46:33 -2147217865 ModAccess ERROR: [MySQL][ODBC 3.51 Driver][mysqld-5.6.35-cll-lve]Table ‘opensync.dataextdetail’ doesn’t exist(GenDeleteTable in table dataextdetail )
    2017-07-16 17:46:33 -2147217865 ModAccess ERROR: [MySQL][ODBC 3.51 Driver][mysqld-5.6.35-cll-lve]Table ‘opensync.dataextdetail’ doesn’t exist(GenDeleteTable in table dataextdetail )
    2017-07-16 17:46:33 -2147217865 ModAccess ERROR: [MySQL][ODBC 3.51 Driver][mysqld-5.6.35-cll-lve]Table ‘opensync.dataextdetail’ doesn’t exist(GenDeleteTable in table dataextdetail )
    2017-07-16 17:46:33 -2147217865 ModAccess ERROR: [MySQL][ODBC 3.51 Driver][mysqld-5.6.35-cll-lve]Table ‘opensync.dataextdetail’ doesn’t exist(GenDeleteTable in table dataextdetail )
    2017-07-16 17:46:33 -2147217865 ModAccess ERROR: [MySQL][ODBC 3.51 Driver][mysqld-5.6.35-cll-lve]Table ‘opensync.dataextdetail’ doesn’t exist(DoLineItemUpdate in table dataext 80000329-1484933589)
    2017-07-16 17:46:33 -2147217865 ModAccess ERROR: [MySQL][ODBC 3.51 Driver][mysqld-5.6.35-cll-lve]Table ‘opensync.dataextdetail’ doesn’t exist(GenMakeDBRecs: [MySQL][ODBC 3.51 Driver][mysqld-5.6.35-cll-lve]Table ‘opensync.dataextdetail’ doesn’t exist in table iteminventoryassembly 0 alt item code STR255TYPE Component c019 80000329-1484933589)
    2017-07-16 17:47:05 0 ModAccess Populate Table: Item Non Inventory
    2017-07-16 17:47:09 0 ModAccess Populate Table: Item Other Charge
    2017-07-16 17:47:27 0 ModAccess Populate Table: Item Payment
    2017-07-16 17:47:28 0 ModAccess Populate Table: Item Sales Tax
    2017-07-16 17:47:29 0 ModAccess Populate Table: Item Service
    2017-07-16 17:47:33 0 ModAccess Populate Table: Item Sites
    2017-07-16 17:48:18 0 ModAccess Populate Table: Item Subtotal
    2017-07-16 17:48:19 0 ModAccess Populate Table: Items
    2017-07-16 17:48:57 -2147217865 ModAccess ERROR: [MySQL][ODBC 3.51 Driver][mysqld-5.6.35-cll-lve]Table ‘opensync.dataextdetail’ doesn’t exist(GenMakeDBRecs: [MySQL][ODBC 3.51 Driver][mysqld-5.6.35-cll-lve]Table ‘opensync.dataextdetail’ doesn’t exist in table items 0 alt item code STR255TYPE Component c019 80000329-1484933589)
    2017-07-16 17:55:55 0 ModAccess Connect from: OpenSync
    2017-07-16 17:56:00 0 ModAccess SaveReport to table RINV
    2017-07-16 17:56:19 0 ModAccess SaveReport to table complete
    2017-07-16 17:56:59 0 ModAccess Connect from: OpenSync
    2017-07-16 17:57:04 0 ModAccess Refresh Table: itemdiscount
    2017-07-16 17:57:05 0 ModAccess Refresh Table: itemfixedasset
    2017-07-16 17:57:06 0 ModAccess Refresh Table: itemgroup
    2017-07-16 17:57:06 0 ModAccess Refresh Table: iteminventory
    2017-07-16 17:57:07 0 ModAccess Refresh Table: iteminventoryassembly
    2017-07-16 17:57:08 0 ModAccess Refresh Table: itemnoninventory
    2017-07-16 17:57:08 0 ModAccess Refresh Table: itemothercharge
    2017-07-16 17:57:09 0 ModAccess Refresh Table: itempayment
    2017-07-16 17:57:10 0 ModAccess Refresh Table: itemreceipt
    2017-07-16 17:57:10 0 ModAccess Refresh Table: itemsalestax
    2017-07-16 17:57:11 0 ModAccess Refresh Table: itemsalestaxgroup
    2017-07-16 17:57:11 0 ModAccess Refresh Table: itemservice
    2017-07-16 17:57:12 0 ModAccess Refresh Table: itemsites
    2017-07-16 17:59:18 0 ModAccess Refresh Table: itemsubtotal
    2017-07-16 17:59:55 0 ModAccess Connect from: OpenSync
    2017-07-16 18:00:00 0 ModAccess SaveReport to table RINV
    2017-07-16 18:00:20 0 ModAccess SaveReport to table complete
    2017-07-16 18:03:48 0 ModAccess Connect from: OpenSync
    2017-07-16 18:03:53 0 ModAccess Refresh Table: itemdiscount
    2017-07-16 18:03:54 0 ModAccess Refresh Table: itemfixedasset
    2017-07-16 18:03:55 0 ModAccess Refresh Table: itemgroup
    2017-07-16 18:03:56 0 ModAccess Refresh Table: iteminventory
    2017-07-16 18:03:57 0 ModAccess Refresh Table: iteminventoryassembly
    2017-07-16 18:03:57 0 ModAccess Refresh Table: itemnoninventory
    2017-07-16 18:03:58 0 ModAccess Refresh Table: itemothercharge
    2017-07-16 18:03:59 0 ModAccess Refresh Table: itempayment
    2017-07-16 18:03:59 0 ModAccess Refresh Table: itemreceipt
    2017-07-16 18:04:00 0 ModAccess Refresh Table: itemsalestax
    2017-07-16 18:04:01 0 ModAccess Refresh Table: itemsalestaxgroup
    2017-07-16 18:04:01 0 ModAccess Refresh Table: itemservice
    2017-07-16 18:04:02 0 ModAccess Refresh Table: itemsites
    2017-07-16 18:06:07 0 ModAccess Refresh Table: itemsubtotal
    2017-07-16 23:29:33 0 ModAccess Connect from: OpenSync
    2017-07-17 07:57:41 0 ModAccess Connect from: OpenSync
    2017-07-17 07:57:46 0 ModAccess Populate Table: Item Discount
    2017-07-17 07:57:48 0 ModAccess Populate Table: Item Fixed Asset
    2017-07-17 07:57:48 0 ModAccess Populate Table: Item Group
    2017-07-17 07:57:51 0 ModAccess Populate Table: Item Inventory
    2017-07-17 07:58:08 0 ModAccess Populate Table: Item Inventory Assembly
    2017-07-17 07:58:14 -2147217865 ModAccess ERROR: [MySQL][ODBC 3.51 Driver][mysqld-5.6.35-cll-lve]Table ‘opensync.dataextdetail’ doesn’t exist(GenDeleteTable in table dataextdetail )
    2017-07-17 07:58:14 -2147217865 ModAccess ERROR: [MySQL][ODBC 3.51 Driver][mysqld-5.6.35-cll-lve]Table ‘opensync.dataextdetail’ doesn’t exist(GenDeleteTable in table dataextdetail )
    2017-07-17 07:58:14 -2147217865 ModAccess ERROR: [MySQL][ODBC 3.51 Driver][mysqld-5.6.35-cll-lve]Table ‘opensync.dataextdetail’ doesn’t exist(GenDeleteTable in table dataextdetail )
    2017-07-17 07:58:14 -2147217865 ModAccess ERROR: [MySQL][ODBC 3.51 Driver][mysqld-5.6.35-cll-lve]Table ‘opensync.dataextdetail’ doesn’t exist(GenDeleteTable in table dataextdetail )
    2017-07-17 07:58:14 -2147217865 ModAccess ERROR: [MySQL][ODBC 3.51 Driver][mysqld-5.6.35-cll-lve]Table ‘opensync.dataextdetail’ doesn’t exist(DoLineItemUpdate in table dataext 80000329-1484933589)
    2017-07-17 07:58:14 -2147217865 ModAccess ERROR: [MySQL][ODBC 3.51 Driver][mysqld-5.6.35-cll-lve]Table ‘opensync.dataextdetail’ doesn’t exist(GenMakeDBRecs: [MySQL][ODBC 3.51 Driver][mysqld-5.6.35-cll-lve]Table ‘opensync.dataextdetail’ doesn’t exist in table iteminventoryassembly 0 alt item code STR255TYPE Component c019 80000329-1484933589)
    2017-07-17 07:58:43 0 ModAccess Populate Table: Item Non Inventory
    2017-07-17 07:58:48 0 ModAccess Populate Table: Item Other Charge
    2017-07-17 07:59:06 0 ModAccess Populate Table: Item Payment
    2017-07-17 07:59:07 0 ModAccess Populate Table: Item Sales Tax
    2017-07-17 07:59:09 0 ModAccess Populate Table: Item Service
    2017-07-17 07:59:12 0 ModAccess Populate Table: Item Sites
    2017-07-17 07:59:50 0 ModAccess Populate Table: Item Subtotal
    2017-07-17 07:59:51 0 ModAccess Populate Table: Items
    2017-07-17 08:00:25 -2147217865 ModAccess ERROR: [MySQL][ODBC 3.51 Driver][mysqld-5.6.35-cll-lve]Table ‘opensync.dataextdetail’ doesn’t exist(GenMakeDBRecs: [MySQL][ODBC 3.51 Driver][mysqld-5.6.35-cll-lve]Table ‘opensync.dataextdetail’ doesn’t exist in table items 0 alt item code STR255TYPE Component c019 80000329-1484933589)
    2017-07-17 08:13:26 0 ModAccess Connect from: OpenSync
    2017-07-17 08:13:31 0 ModAccess SaveReport to table RINV
    2017-07-17 08:13:53 0 ModAccess SaveReport to table complete
    2017-07-17 08:15:42 0 ModAccess Connect from: OpenSync
    2017-07-17 08:15:48 0 ModAccess Refresh Table: iteminventoryassembly
    2017-07-17 08:16:37 0 ModAccess Connect from: OpenSync
    2017-07-17 08:16:44 0 ModAccess Refresh Table: iteminventoryassembly
    2017-07-17 08:27:02 0 ModAccess Connect from: OpenSync
    2017-07-17 08:27:25 0 ModAccess Connect from: OpenSync
    2017-07-17 08:27:31 0 ModAccess Refresh Table: itemdiscount
    2017-07-17 08:27:32 0 ModAccess Refresh Table: itemfixedasset
    2017-07-17 08:27:33 0 ModAccess Refresh Table: itemgroup
    2017-07-17 08:27:34 0 ModAccess Refresh Table: iteminventory
    2017-07-17 08:27:34 0 ModAccess Refresh Table: iteminventoryassembly
    2017-07-17 08:27:35 0 ModAccess Refresh Table: itemnoninventory
    2017-07-17 08:27:36 0 ModAccess Refresh Table: itemothercharge
    2017-07-17 08:27:36 0 ModAccess Refresh Table: itempayment
    2017-07-17 08:27:37 0 ModAccess Refresh Table: itemreceipt
    2017-07-17 08:27:38 0 ModAccess Refresh Table: itemsalestax
    2017-07-17 08:27:38 0 ModAccess Refresh Table: itemsalestaxgroup
    2017-07-17 08:27:39 0 ModAccess Refresh Table: itemservice
    2017-07-17 08:27:39 0 ModAccess Refresh Table: itemsites
    2017-07-17 08:29:29 0 ModAccess Refresh Table: itemsubtotal
    2017-07-17 08:33:51 0 ModAccess Connect from: OpenSync
    2017-07-17 08:33:58 0 ModAccess Populate Table: Item Discount
    2017-07-17 08:33:59 0 ModAccess Populate Table: Item Fixed Asset
    2017-07-17 08:34:00 0 ModAccess Populate Table: Item Group
    2017-07-17 08:34:03 0 ModAccess Populate Table: Item Inventory
    2017-07-17 08:34:21 0 ModAccess Populate Table: Item Inventory Assembly
    2017-07-17 08:34:28 -2147217865 ModAccess ERROR: [MySQL][ODBC 3.51 Driver][mysqld-5.6.35-cll-lve]Table ‘opensync.dataextdetail’ doesn’t exist(GenDeleteTable in table dataextdetail )
    2017-07-17 08:34:28 -2147217865 ModAccess ERROR: [MySQL][ODBC 3.51 Driver][mysqld-5.6.35-cll-lve]Table ‘opensync.dataextdetail’ doesn’t exist(GenDeleteTable in table dataextdetail )
    2017-07-17 08:34:28 -2147217865 ModAccess ERROR: [MySQL][ODBC 3.51 Driver][mysqld-5.6.35-cll-lve]Table ‘opensync.dataextdetail’ doesn’t exist(GenDeleteTable in table dataextdetail )
    2017-07-17 08:34:28 -2147217865 ModAccess ERROR: [MySQL][ODBC 3.51 Driver][mysqld-5.6.35-cll-lve]Table ‘opensync.dataextdetail’ doesn’t exist(GenDeleteTable in table dataextdetail )
    2017-07-17 08:34:28 -2147217865 ModAccess ERROR: [MySQL][ODBC 3.51 Driver][mysqld-5.6.35-cll-lve]Table ‘opensync.dataextdetail’ doesn’t exist(DoLineItemUpdate in table dataext 80000329-1484933589)
    2017-07-17 08:34:28 -2147217865 ModAccess ERROR: [MySQL][ODBC 3.51 Driver][mysqld-5.6.35-cll-lve]Table ‘opensync.dataextdetail’ doesn’t exist(GenMakeDBRecs: [MySQL][ODBC 3.51 Driver][mysqld-5.6.35-cll-lve]Table ‘opensync.dataextdetail’ doesn’t exist in table iteminventoryassembly 0 alt item code STR255TYPE Component c019 80000329-1484933589)
    2017-07-17 08:35:02 0 ModAccess Populate Table: Item Non Inventory
    2017-07-17 08:35:08 0 ModAccess Populate Table: Item Other Charge
    2017-07-17 08:35:28 0 ModAccess Populate Table: Item Payment
    2017-07-17 08:35:29 0 ModAccess Populate Table: Item Sales Tax
    2017-07-17 08:35:31 0 ModAccess Populate Table: Item Service
    2017-07-17 08:35:36 0 ModAccess Populate Table: Item Sites
    2017-07-17 08:36:20 0 ModAccess Populate Table: Item Subtotal
    2017-07-17 08:36:21 0 ModAccess Populate Table: Items
    2017-07-17 08:37:08 -2147217865 ModAccess ERROR: [MySQL][ODBC 3.51 Driver][mysqld-5.6.35-cll-lve]Table ‘opensync.dataextdetail’ doesn’t exist(GenMakeDBRecs: [MySQL][ODBC 3.51 Driver][mysqld-5.6.35-cll-lve]Table ‘opensync.dataextdetail’ doesn’t exist in table items 0 alt item code STR255TYPE Component c019 80000329-1484933589)
    2017-07-17 08:40:41 0 ModAccess Connect from: OpenSync
    2017-07-17 08:40:46 0 ModAccess SaveReport to table RASSEM
    2017-07-17 08:40:46 3110 ModAccess SaveReport to table error: The enumerated value “InventoryAssembly” in the field “ItemTypeFilter” is unknown or invalid for the qbXML version in use.
    2017-07-17 08:42:05 0 ModAccess Connect from: OpenSync
    2017-07-17 08:42:11 0 ModAccess SaveReport to table RASSEM
    2017-07-17 08:42:11 3110 ModAccess SaveReport to table error: The enumerated value “InventoryAssembly” in the field “ItemTypeFilter” is unknown or invalid for the qbXML version in use.
    2017-07-17 08:43:02 0 ModAccess Connect from: OpenSync
    2017-07-17 08:43:08 0 ModAccess SaveReport to table RASSEM
    2017-07-17 08:43:08 3110 ModAccess SaveReport to table error: The enumerated value “InventoryAssembly” in the field “ItemTypeFilter” is unknown or invalid for the qbXML version in use.
    2017-07-17 08:44:08 0 ModAccess Connect from: OpenSync
    2017-07-17 08:44:14 0 ModAccess SaveReport to table RASSEM
    2017-07-17 08:44:14 3110 ModAccess SaveReport to table error: The enumerated value “InventoryAssembly” in the field “ItemTypeFilter” is unknown or invalid for the qbXML version in use.
    2017-07-17 08:52:34 0 ModAccess Connect from: OpenSync
    2017-07-17 08:52:45 0 ModAccess Connect from: OpenSync
    2017-07-17 08:52:53 0 ModAccess Populate Table: Item Discount
    2017-07-17 08:52:54 0 ModAccess Populate Table: Item Fixed Asset
    2017-07-17 08:52:55 0 ModAccess Populate Table: Item Group
    2017-07-17 08:52:59 0 ModAccess Populate Table: Item Inventory
    2017-07-17 08:53:18 0 ModAccess Populate Table: Item Inventory Assembly
    2017-07-17 08:53:26 -2147217865 ModAccess ERROR: [MySQL][ODBC 3.51 Driver][mysqld-5.6.35-cll-lve]Table ‘opensync.dataextdetail’ doesn’t exist(GenDeleteTable in table dataextdetail )
    2017-07-17 08:53:26 -2147217865 ModAccess ERROR: [MySQL][ODBC 3.51 Driver][mysqld-5.6.35-cll-lve]Table ‘opensync.dataextdetail’ doesn’t exist(GenDeleteTable in table dataextdetail )
    2017-07-17 08:53:26 -2147217865 ModAccess ERROR: [MySQL][ODBC 3.51 Driver][mysqld-5.6.35-cll-lve]Table ‘opensync.dataextdetail’ doesn’t exist(GenDeleteTable in table dataextdetail )
    2017-07-17 08:53:26 -2147217865 ModAccess ERROR: [MySQL][ODBC 3.51 Driver][mysqld-5.6.35-cll-lve]Table ‘opensync.dataextdetail’ doesn’t exist(GenDeleteTable in table dataextdetail )
    2017-07-17 08:53:26 -2147217865 ModAccess ERROR: [MySQL][ODBC 3.51 Driver][mysqld-5.6.35-cll-lve]Table ‘opensync.dataextdetail’ doesn’t exist(DoLineItemUpdate in table dataext 80000329-1484933589)
    2017-07-17 08:53:26 -2147217865 ModAccess ERROR: [MySQL][ODBC 3.51 Driver][mysqld-5.6.35-cll-lve]Table ‘opensync.dataextdetail’ doesn’t exist(GenMakeDBRecs: [MySQL][ODBC 3.51 Driver][mysqld-5.6.35-cll-lve]Table ‘opensync.dataextdetail’ doesn’t exist in table iteminventoryassembly 0 alt item code STR255TYPE Component c019 80000329-1484933589)
    2017-07-17 08:54:02 0 ModAccess Populate Table: Item Non Inventory
    2017-07-17 08:54:07 0 ModAccess Populate Table: Item Other Charge
    2017-07-17 08:54:29 0 ModAccess Populate Table: Item Payment
    2017-07-17 08:54:30 0 ModAccess Populate Table: Item Sales Tax
    2017-07-17 08:54:32 0 ModAccess Populate Table: Item Service
    2017-07-17 08:54:36 0 ModAccess Populate Table: Item Sites
    2017-07-17 08:55:18 0 ModAccess Populate Table: Item Subtotal
    2017-07-17 08:55:19 0 ModAccess Populate Table: Items
    2017-07-17 08:56:04 -2147217865 ModAccess ERROR: [MySQL][ODBC 3.51 Driver][mysqld-5.6.35-cll-lve]Table ‘opensync.dataextdetail’ doesn’t exist(GenMakeDBRecs: [MySQL][ODBC 3.51 Driver][mysqld-5.6.35-cll-lve]Table ‘opensync.dataextdetail’ doesn’t exist in table items 0 alt item code STR255TYPE Component c019 80000329-1484933589)
    2017-07-17 08:57:32 0 ModAccess Connect from: OpenSync
    2017-07-17 08:57:38 0 ModAccess SaveReport to table RASSEM
    2017-07-17 08:57:38 3110 ModAccess SaveReport to table error: The enumerated value “InventoryAssembly” in the field “ItemTypeFilter” is unknown or invalid for the qbXML version in use.
    2017-07-17 09:00:56 0 ModAccess Connect from: OpenSync
    2017-07-17 09:01:01 0 ModAccess Populate Table: Items
    2017-07-17 09:01:46 -2147217865 ModAccess ERROR: [MySQL][ODBC 3.51 Driver][mysqld-5.6.35-cll-lve]Table ‘opensync.dataextdetail’ doesn’t exist(GenMakeDBRecs: [MySQL][ODBC 3.51 Driver][mysqld-5.6.35-cll-lve]Table ‘opensync.dataextdetail’ doesn’t exist in table items 0 alt item code STR255TYPE Component c019 80000329-1484933589)
    2017-07-17 09:18:01 0 ModAccess Connect from: OpenSync
    2017-07-17 09:18:07 0 ModAccess Populate Table: Item Discount
    2017-07-17 09:18:09 0 ModAccess Populate Table: Item Fixed Asset
    2017-07-17 09:18:10 0 ModAccess Populate Table: Item Group
    2017-07-17 09:18:16 0 ModAccess Populate Table: Item Inventory
    2017-07-17 09:18:42 0 ModAccess Populate Table: Item Inventory Assembly
    2017-07-17 09:18:51 -2147217865 ModAccess ERROR: [MySQL][ODBC 3.51 Driver][mysqld-5.6.35-cll-lve]Table ‘opensync.dataextdetail’ doesn’t exist(GenDeleteTable in table dataextdetail )
    2017-07-17 09:18:51 -2147217865 ModAccess ERROR: [MySQL][ODBC 3.51 Driver][mysqld-5.6.35-cll-lve]Table ‘opensync.dataextdetail’ doesn’t exist(GenDeleteTable in table dataextdetail )
    2017-07-17 09:18:51 -2147217865 ModAccess ERROR: [MySQL][ODBC 3.51 Driver][mysqld-5.6.35-cll-lve]Table ‘opensync.dataextdetail’ doesn’t exist(GenDeleteTable in table dataextdetail )
    2017-07-17 09:18:51 -2147217865 ModAccess ERROR: [MySQL][ODBC 3.51 Driver][mysqld-5.6.35-cll-lve]Table ‘opensync.dataextdetail’ doesn’t exist(GenDeleteTable in table dataextdetail )
    2017-07-17 09:18:51 -2147217865 ModAccess ERROR: [MySQL][ODBC 3.51 Driver][mysqld-5.6.35-cll-lve]Table ‘opensync.dataextdetail’ doesn’t exist(DoLineItemUpdate in table dataext 80000329-1484933589)
    2017-07-17 09:18:51 -2147217865 ModAccess ERROR: [MySQL][ODBC 3.51 Driver][mysqld-5.6.35-cll-lve]Table ‘opensync.dataextdetail’ doesn’t exist(GenMakeDBRecs: [MySQL][ODBC 3.51 Driver][mysqld-5.6.35-cll-lve]Table ‘opensync.dataextdetail’ doesn’t exist in table iteminventoryassembly 0 alt item code STR255TYPE Component c019 80000329-1484933589)
    2017-07-17 09:19:30 0 ModAccess Populate Table: Item Non Inventory
    2017-07-17 09:19:37 0 ModAccess Populate Table: Item Other Charge
    2017-07-17 09:20:01 0 ModAccess Populate Table: Item Payment
    2017-07-17 09:20:01 0 ModAccess Populate Table: Item Sales Tax
    2017-07-17 09:20:03 0 ModAccess Populate Table: Item Service
    2017-07-17 09:20:07 0 ModAccess Populate Table: Item Sites
    2017-07-17 09:20:57 0 ModAccess Populate Table: Item Subtotal
    2017-07-17 09:20:58 0 ModAccess Populate Table: Items
    2017-07-17 09:21:52 -2147217865 ModAccess ERROR: [MySQL][ODBC 3.51 Driver][mysqld-5.6.35-cll-lve]Table ‘opensync.dataextdetail’ doesn’t exist(GenMakeDBRecs: [MySQL][ODBC 3.51 Driver][mysqld-5.6.35-cll-lve]Table ‘opensync.dataextdetail’ doesn’t exist in table items 0 alt item code STR255TYPE Component c019 80000329-1484933589)
    2017-07-17 10:30:05 0 ModAccess Connect from: OpenSync
    2017-07-17 10:30:12 0 ModAccess Populate Table: Item Discount
    2017-07-17 10:30:13 0 ModAccess Populate Table: Item Fixed Asset
    2017-07-17 10:30:14 0 ModAccess Populate Table: Item Group
    2017-07-17 10:30:18 0 ModAccess Populate Table: Item Inventory
    2017-07-17 10:30:44 0 ModAccess Populate Table: Item Inventory Assembly
    2017-07-17 10:30:51 -2147217865 ModAccess ERROR: [MySQL][ODBC 3.51 Driver][mysqld-5.6.35-cll-lve]Table ‘opensync.dataextdetail’ doesn’t exist(GenDeleteTable in table dataextdetail )
    2017-07-17 10:30:51 -2147217865 ModAccess ERROR: [MySQL][ODBC 3.51 Driver][mysqld-5.6.35-cll-lve]Table ‘opensync.dataextdetail’ doesn’t exist(GenDeleteTable in table dataextdetail )
    2017-07-17 10:30:52 -2147217865 ModAccess ERROR: [MySQL][ODBC 3.51 Driver][mysqld-5.6.35-cll-lve]Table ‘opensync.dataextdetail’ doesn’t exist(GenDeleteTable in table dataextdetail )
    2017-07-17 10:30:52 -2147217865 ModAccess ERROR: [MySQL][ODBC 3.51 Driver][mysqld-5.6.35-cll-lve]Table ‘opensync.dataextdetail’ doesn’t exist(GenDeleteTable in table dataextdetail )
    2017-07-17 10:30:52 -2147217865 ModAccess ERROR: [MySQL][ODBC 3.51 Driver][mysqld-5.6.35-cll-lve]Table ‘opensync.dataextdetail’ doesn’t exist(DoLineItemUpdate in table dataext 80000329-1484933589)
    2017-07-17 10:30:52 -2147217865 ModAccess ERROR: [MySQL][ODBC 3.51 Driver][mysqld-5.6.35-cll-lve]Table ‘opensync.dataextdetail’ doesn’t exist(GenMakeDBRecs: [MySQL][ODBC 3.51 Driver][mysqld-5.6.35-cll-lve]Table ‘opensync.dataextdetail’ doesn’t exist in table iteminventoryassembly 0 alt item code STR255TYPE Component c019 80000329-1484933589)
    2017-07-17 10:31:31 0 ModAccess Populate Table: Item Non Inventory
    2017-07-17 10:31:37 0 ModAccess Populate Table: Item Other Charge
    2017-07-17 10:31:57 0 ModAccess Populate Table: Item Payment
    2017-07-17 10:31:58 0 ModAccess Populate Table: Item Sales Tax
    2017-07-17 10:32:00 0 ModAccess Populate Table: Item Service
    2017-07-17 10:32:06 0 ModAccess Populate Table: Item Sites
    2017-07-17 10:32:57 0 ModAccess Populate Table: Item Subtotal
    2017-07-17 10:32:57 0 ModAccess Populate Table: Items
    2017-07-17 10:33:55 -2147217865 ModAccess ERROR: [MySQL][ODBC 3.51 Driver][mysqld-5.6.35-cll-lve]Table ‘opensync.dataextdetail’ doesn’t exist(GenMakeDBRecs: [MySQL][ODBC 3.51 Driver][mysqld-5.6.35-cll-lve]Table ‘opensync.dataextdetail’ doesn’t exist in table items 0 alt item code STR255TYPE Component c019 80000329-1484933589)
    2017-07-17 10:35:24 0 ModAccess Connect from: OpenSync
    2017-07-17 13:00:14 0 ModAccess Connect from: OpenSync
    2017-07-17 13:00:19 0 ModAccess Populate Table: Item Discount
    2017-07-17 13:00:20 0 ModAccess Populate Table: Item Fixed Asset
    2017-07-17 13:00:21 0 ModAccess Populate Table: Item Group
    2017-07-17 13:00:25 0 ModAccess Populate Table: Item Inventory
    2017-07-17 13:00:45 0 ModAccess Populate Table: Item Inventory Assembly
    2017-07-17 13:00:52 -2147217865 ModAccess ERROR: [MySQL][ODBC 3.51 Driver][mysqld-5.6.35-cll-lve]Table ‘opensync.dataextdetail’ doesn’t exist(GenDeleteTable in table dataextdetail )
    2017-07-17 13:00:52 -2147217865 ModAccess ERROR: [MySQL][ODBC 3.51 Driver][mysqld-5.6.35-cll-lve]Table ‘opensync.dataextdetail’ doesn’t exist(GenDeleteTable in table dataextdetail )
    2017-07-17 13:00:52 -2147217865 ModAccess ERROR: [MySQL][ODBC 3.51 Driver][mysqld-5.6.35-cll-lve]Table ‘opensync.dataextdetail’ doesn’t exist(GenDeleteTable in table dataextdetail )
    2017-07-17 13:00:52 -2147217865 ModAccess ERROR: [MySQL][ODBC 3.51 Driver][mysqld-5.6.35-cll-lve]Table ‘opensync.dataextdetail’ doesn’t exist(GenDeleteTable in table dataextdetail )
    2017-07-17 13:00:52 -2147217865 ModAccess ERROR: [MySQL][ODBC 3.51 Driver][mysqld-5.6.35-cll-lve]Table ‘opensync.dataextdetail’ doesn’t exist(DoLineItemUpdate in table dataext 80000329-1484933589)
    2017-07-17 13:00:52 -2147217865 ModAccess ERROR: [MySQL][ODBC 3.51 Driver][mysqld-5.6.35-cll-lve]Table ‘opensync.dataextdetail’ doesn’t exist(GenMakeDBRecs: [MySQL][ODBC 3.51 Driver][mysqld-5.6.35-cll-lve]Table ‘opensync.dataextdetail’ doesn’t exist in table iteminventoryassembly 0 alt item code STR255TYPE Component c019 80000329-1484933589)
    2017-07-17 13:01:31 0 ModAccess Populate Table: Item Non Inventory
    2017-07-17 13:01:37 0 ModAccess Populate Table: Item Other Charge
    2017-07-17 13:02:06 0 ModAccess Populate Table: Item Payment
    2017-07-17 13:02:07 0 ModAccess Populate Table: Item Sales Tax
    2017-07-17 13:02:08 0 ModAccess Populate Table: Item Service
    2017-07-17 13:02:13 0 ModAccess Populate Table: Item Sites
    2017-07-17 13:03:07 0 ModAccess Populate Table: Item Subtotal
    2017-07-17 13:03:08 0 ModAccess Populate Table: Items
    2017-07-17 13:04:02 -2147217865 ModAccess ERROR: [MySQL][ODBC 3.51 Driver][mysqld-5.6.35-cll-lve]Table ‘opensync.dataextdetail’ doesn’t exist(GenMakeDBRecs: [MySQL][ODBC 3.51 Driver][mysqld-5.6.35-cll-lve]Table ‘opensync.dataextdetail’ doesn’t exist in table items 0 alt item code STR255TYPE Component c019 80000329-1484933589)
    2017-07-18 13:56:22 0 ModAccess Connect from: OpenSync
    2017-07-18 13:56:41 0 ModAccess Connect from: OpenSync
    2017-07-18 14:06:06 0 ModAccess Connect from: OpenSync
    2017-07-18 14:06:12 0 ModAccess Refresh Table: itemdiscount
    2017-07-18 14:06:13 0 ModAccess Refresh Table: itemfixedasset
    2017-07-18 14:06:14 0 ModAccess Refresh Table: itemgroup
    2017-07-18 14:06:15 0 ModAccess Refresh Table: iteminventory
    2017-07-18 14:06:16 0 ModAccess Refresh Table: iteminventoryassembly
    2017-07-18 14:06:16 0 ModAccess Refresh Table: itemnoninventory
    2017-07-18 14:06:17 0 ModAccess Refresh Table: itemothercharge
    2017-07-18 14:06:18 0 ModAccess Refresh Table: itempayment
    2017-07-18 14:06:18 0 ModAccess Refresh Table: itemreceipt
    2017-07-18 14:06:29 0 ModAccess Refresh Table: itemsalestax
    2017-07-18 14:06:30 0 ModAccess Refresh Table: itemsalestaxgroup
    2017-07-18 14:06:31 0 ModAccess Refresh Table: itemservice
    2017-07-18 14:06:32 0 ModAccess Refresh Table: itemsites
    2017-07-18 14:08:34 0 ModAccess Refresh Table: itemsubtotal
    2017-07-18 14:23:01 0 ModAccess Connect from: OpenSync
    2017-07-18 14:23:06 0 ModAccess Populate Table: Item Discount
    2017-07-18 14:23:07 0 ModAccess Populate Table: Item Fixed Asset
    2017-07-18 14:23:08 0 ModAccess Populate Table: Item Group
    2017-07-18 14:23:12 0 ModAccess Populate Table: Item Inventory
    2017-07-18 14:23:30 0 ModAccess Populate Table: Item Inventory Assembly
    2017-07-18 14:23:39 -2147217865 ModAccess ERROR: [MySQL][ODBC 3.51 Driver][mysqld-5.6.35-cll-lve]Table ‘opensync.dataextdetail’ doesn’t exist(GenDeleteTable in table dataextdetail )
    2017-07-18 14:23:39 -2147217865 ModAccess ERROR: [MySQL][ODBC 3.51 Driver][mysqld-5.6.35-cll-lve]Table ‘opensync.dataextdetail’ doesn’t exist(GenDeleteTable in table dataextdetail )
    2017-07-18 14:23:39 -2147217865 ModAccess ERROR: [MySQL][ODBC 3.51 Driver][mysqld-5.6.35-cll-lve]Table ‘opensync.dataextdetail’ doesn’t exist(GenDeleteTable in table dataextdetail )
    2017-07-18 14:23:39 -2147217865 ModAccess ERROR: [MySQL][ODBC 3.51 Driver][mysqld-5.6.35-cll-lve]Table ‘opensync.dataextdetail’ doesn’t exist(GenDeleteTable in table dataextdetail )
    2017-07-18 14:23:39 -2147217865 ModAccess ERROR: [MySQL][ODBC 3.51 Driver][mysqld-5.6.35-cll-lve]Table ‘opensync.dataextdetail’ doesn’t exist(DoLineItemUpdate in table dataext 80000329-1484933589)
    2017-07-18 14:23:39 -2147217865 ModAccess ERROR: [MySQL][ODBC 3.51 Driver][mysqld-5.6.35-cll-lve]Table ‘opensync.dataextdetail’ doesn’t exist(GenMakeDBRecs: [MySQL][ODBC 3.51 Driver][mysqld-5.6.35-cll-lve]Table ‘opensync.dataextdetail’ doesn’t exist in table iteminventoryassembly 0 alt item code STR255TYPE Component c019 80000329-1484933589)
    2017-07-18 14:24:19 0 ModAccess Populate Table: Item Non Inventory
    2017-07-18 14:24:25 0 ModAccess Populate Table: Item Other Charge
    2017-07-18 14:24:53 0 ModAccess Populate Table: Item Payment
    2017-07-18 14:24:54 0 ModAccess Populate Table: Item Sales Tax
    2017-07-18 14:24:55 0 ModAccess Populate Table: Item Service
    2017-07-18 14:25:00 0 ModAccess Populate Table: Item Sites
    2017-07-18 14:25:56 0 ModAccess Populate Table: Item Subtotal
    2017-07-18 14:25:57 0 ModAccess Populate Table: Items
    2017-07-18 14:26:53 -2147217865 ModAccess ERROR: [MySQL][ODBC 3.51 Driver][mysqld-5.6.35-cll-lve]Table ‘opensync.dataextdetail’ doesn’t exist(GenMakeDBRecs: [MySQL][ODBC 3.51 Driver][mysqld-5.6.35-cll-lve]Table ‘opensync.dataextdetail’ doesn’t exist in table items 0 alt item code STR255TYPE Component c019 80000329-1484933589)
    2017-07-18 14:34:42 0 ModAccess Connect from: OpenSync
    2017-07-18 14:34:49 0 ModAccess Populate Table: Item Discount
    2017-07-18 14:34:50 0 ModAccess Populate Table: Item Fixed Asset
    2017-07-18 14:34:51 0 ModAccess Populate Table: Item Group
    2017-07-18 14:34:56 0 ModAccess Populate Table: Item Inventory
    2017-07-18 14:35:20 0 ModAccess Populate Table: Item Inventory Assembly
    2017-07-18 14:35:28 -2147217865 ModAccess ERROR: [MySQL][ODBC 3.51 Driver][mysqld-5.6.35-cll-lve]Table ‘opensync.dataextdetail’ doesn’t exist(GenDeleteTable in table dataextdetail )
    2017-07-18 14:35:28 -2147217865 ModAccess ERROR: [MySQL][ODBC 3.51 Driver][mysqld-5.6.35-cll-lve]Table ‘opensync.dataextdetail’ doesn’t exist(GenDeleteTable in table dataextdetail )
    2017-07-18 14:35:28 -2147217865 ModAccess ERROR: [MySQL][ODBC 3.51 Driver][mysqld-5.6.35-cll-lve]Table ‘opensync.dataextdetail’ doesn’t exist(GenDeleteTable in table dataextdetail )
    2017-07-18 14:35:28 -2147217865 ModAccess ERROR: [MySQL][ODBC 3.51 Driver][mysqld-5.6.35-cll-lve]Table ‘opensync.dataextdetail’ doesn’t exist(GenDeleteTable in table dataextdetail )
    2017-07-18 14:35:28 -2147217865 ModAccess ERROR: [MySQL][ODBC 3.51 Driver][mysqld-5.6.35-cll-lve]Table ‘opensync.dataextdetail’ doesn’t exist(DoLineItemUpdate in table dataext 80000329-1484933589)
    2017-07-18 14:35:28 -2147217865 ModAccess ERROR: [MySQL][ODBC 3.51 Driver][mysqld-5.6.35-cll-lve]Table ‘opensync.dataextdetail’ doesn’t exist(GenMakeDBRecs: [MySQL][ODBC 3.51 Driver][mysqld-5.6.35-cll-lve]Table ‘opensync.dataextdetail’ doesn’t exist in table iteminventoryassembly 0 alt item code STR255TYPE Component c019 80000329-1484933589)
    2017-07-18 14:35:58 0 ModAccess Populate Table: Item Non Inventory
    2017-07-18 14:36:04 0 ModAccess Populate Table: Item Other Charge
    2017-07-18 14:36:25 0 ModAccess Populate Table: Item Payment
    2017-07-18 14:36:25 0 ModAccess Populate Table: Item Sales Tax
    2017-07-18 14:36:27 0 ModAccess Populate Table: Item Service
    2017-07-18 14:36:31 0 ModAccess Populate Table: Item Sites
    2017-07-18 14:37:12 0 ModAccess Populate Table: Item Subtotal
    2017-07-18 14:37:13 0 ModAccess Populate Table: Items
    2017-07-18 14:37:51 -2147217865 ModAccess ERROR: [MySQL][ODBC 3.51 Driver][mysqld-5.6.35-cll-lve]Table ‘opensync.dataextdetail’ doesn’t exist(GenMakeDBRecs: [MySQL][ODBC 3.51 Driver][mysqld-5.6.35-cll-lve]Table ‘opensync.dataextdetail’ doesn’t exist in table items 0 alt item code STR255TYPE Component c019 80000329-1484933589)
    2017-07-18 14:54:06 0 ModAccess Connect from: OpenSync
    2017-07-18 14:54:12 0 ModAccess Populate Table: Item Discount
    2017-07-18 14:54:13 0 ModAccess Populate Table: Item Fixed Asset
    2017-07-18 14:54:14 0 ModAccess Populate Table: Item Group
    2017-07-18 14:54:17 0 ModAccess Populate Table: Item Inventory
    2017-07-18 14:54:37 0 ModAccess Populate Table: Item Inventory Assembly
    2017-07-18 14:54:44 -2147217865 ModAccess ERROR: [MySQL][ODBC 3.51 Driver][mysqld-5.6.35-cll-lve]Table ‘opensync.dataextdetail’ doesn’t exist(GenDeleteTable in table dataextdetail )
    2017-07-18 14:54:44 -2147217865 ModAccess ERROR: [MySQL][ODBC 3.51 Driver][mysqld-5.6.35-cll-lve]Table ‘opensync.dataextdetail’ doesn’t exist(GenDeleteTable in table dataextdetail )
    2017-07-18 14:54:44 -2147217865 ModAccess ERROR: [MySQL][ODBC 3.51 Driver][mysqld-5.6.35-cll-lve]Table ‘opensync.dataextdetail’ doesn’t exist(GenDeleteTable in table dataextdetail )
    2017-07-18 14:54:44 -2147217865 ModAccess ERROR: [MySQL][ODBC 3.51 Driver][mysqld-5.6.35-cll-lve]Table ‘opensync.dataextdetail’ doesn’t exist(GenDeleteTable in table dataextdetail )
    2017-07-18 14:54:44 -2147217865 ModAccess ERROR: [MySQL][ODBC 3.51 Driver][mysqld-5.6.35-cll-lve]Table ‘opensync.dataextdetail’ doesn’t exist(DoLineItemUpdate in table dataext 80000329-1484933589)
    2017-07-18 14:54:44 -2147217865 ModAccess ERROR: [MySQL][ODBC 3.51 Driver][mysqld-5.6.35-cll-lve]Table ‘opensync.dataextdetail’ doesn’t exist(GenMakeDBRecs: [MySQL][ODBC 3.51 Driver][mysqld-5.6.35-cll-lve]Table ‘opensync.dataextdetail’ doesn’t exist in table iteminventoryassembly 0 alt item code STR255TYPE Component c019 80000329-1484933589)
    2017-07-18 14:55:19 0 ModAccess Populate Table: Item Non Inventory
    2017-07-18 14:55:25 0 ModAccess Populate Table: Item Other Charge
    2017-07-18 14:55:48 0 ModAccess Populate Table: Item Payment
    2017-07-18 14:55:49 0 ModAccess Populate Table: Item Sales Tax
    2017-07-18 14:55:50 0 ModAccess Populate Table: Item Service
    2017-07-18 14:55:54 0 ModAccess Populate Table: Item Sites
    2017-07-18 14:56:52 0 ModAccess Populate Table: Item Subtotal
    2017-07-18 14:56:53 0 ModAccess Populate Table: Items
    2017-07-18 15:29:36 0 ModAccess Connect from: OpenSync
    2017-07-18 15:31:18 0 ModAccess Connect from: OpenSync
    2017-07-18 15:31:26 0 ModAccess Populate Table: Item Discount
    2017-07-18 15:31:28 0 ModAccess Populate Table: Item Fixed Asset
    2017-07-18 15:31:29 0 ModAccess Populate Table: Item Group
    2017-07-18 15:31:34 0 ModAccess Populate Table: Item Inventory
    2017-07-18 15:32:00 0 ModAccess Populate Table: Item Inventory Assembly
    2017-07-18 15:32:08 -2147217865 ModAccess ERROR: [MySQL][ODBC 3.51 Driver][mysqld-5.6.35-cll-lve]Table ‘opensync.dataextdetail’ doesn’t exist(GenDeleteTable in table dataextdetail )
    2017-07-18 15:32:08 -2147217865 ModAccess ERROR: [MySQL][ODBC 3.51 Driver][mysqld-5.6.35-cll-lve]Table ‘opensync.dataextdetail’ doesn’t exist(GenDeleteTable in table dataextdetail )
    2017-07-18 15:32:08 -2147217865 ModAccess ERROR: [MySQL][ODBC 3.51 Driver][mysqld-5.6.35-cll-lve]Table ‘opensync.dataextdetail’ doesn’t exist(GenDeleteTable in table dataextdetail )
    2017-07-18 15:32:08 -2147217865 ModAccess ERROR: [MySQL][ODBC 3.51 Driver][mysqld-5.6.35-cll-lve]Table ‘opensync.dataextdetail’ doesn’t exist(GenDeleteTable in table dataextdetail )
    2017-07-18 15:32:08 -2147217865 ModAccess ERROR: [MySQL][ODBC 3.51 Driver][mysqld-5.6.35-cll-lve]Table ‘opensync.dataextdetail’ doesn’t exist(DoLineItemUpdate in table dataext 80000329-1484933589)
    2017-07-18 15:32:08 -2147217865 ModAccess ERROR: [MySQL][ODBC 3.51 Driver][mysqld-5.6.35-cll-lve]Table ‘opensync.dataextdetail’ doesn’t exist(GenMakeDBRecs: [MySQL][ODBC 3.51 Driver][mysqld-5.6.35-cll-lve]Table ‘opensync.dataextdetail’ doesn’t exist in table iteminventoryassembly 0 alt item code STR255TYPE Component c019 80000329-1484933589)
    2017-07-18 15:32:52 0 ModAccess Populate Table: Item Non Inventory
    2017-07-18 15:32:59 0 ModAccess Populate Table: Item Other Charge
    2017-07-18 15:33:18 0 ModAccess Populate Table: Item Payment
    2017-07-18 15:33:19 0 ModAccess Populate Table: Item Sales Tax
    2017-07-18 15:33:21 0 ModAccess Populate Table: Item Service
    2017-07-18 15:33:26 0 ModAccess Populate Table: Item Sites
    2017-07-18 15:34:28 0 ModAccess Populate Table: Item Subtotal
    2017-07-18 15:34:29 0 ModAccess Populate Table: Items
    2017-07-18 15:35:22 -2147217865 ModAccess ERROR: [MySQL][ODBC 3.51 Driver][mysqld-5.6.35-cll-lve]Table ‘opensync.dataextdetail’ doesn’t exist(GenMakeDBRecs: [MySQL][ODBC 3.51 Driver][mysqld-5.6.35-cll-lve]Table ‘opensync.dataextdetail’ doesn’t exist in table items 0 alt item code STR255TYPE Component c019 80000329-1484933589)
    2017-07-18 15:39:53 0 ModAccess Connect from: OpenSync
    2017-07-18 15:39:59 0 ModAccess Refresh Table: itemdiscount
    2017-07-18 15:40:00 0 ModAccess Refresh Table: itemfixedasset
    2017-07-18 15:40:02 0 ModAccess Refresh Table: itemgroup
    2017-07-18 15:40:03 0 ModAccess Refresh Table: iteminventory
    2017-07-18 15:40:04 0 ModAccess Refresh Table: iteminventoryassembly
    2017-07-18 15:40:06 0 ModAccess Refresh Table: itemnoninventory
    2017-07-18 15:40:06 0 ModAccess Refresh Table: itemothercharge
    2017-07-18 15:40:07 0 ModAccess Refresh Table: itempayment
    2017-07-18 15:40:08 0 ModAccess Refresh Table: itemreceipt
    2017-07-18 15:40:11 0 ModAccess Refresh Table: itemsalestax
    2017-07-18 15:40:12 0 ModAccess Refresh Table: itemsalestaxgroup
    2017-07-18 15:40:13 0 ModAccess Refresh Table: itemservice
    2017-07-18 15:40:14 0 ModAccess Refresh Table: itemsites
    2017-07-18 15:42:43 0 ModAccess Refresh Table: itemsubtotal
    2017-07-18 15:53:34 0 ModAccess Connect from: OpenSync
    2017-07-18 15:53:39 0 ModAccess Populate Table: Item Discount
    2017-07-18 15:53:40 0 ModAccess Populate Table: Item Fixed Asset
    2017-07-18 15:53:41 0 ModAccess Populate Table: Item Group
    2017-07-18 15:53:44 0 ModAccess Populate Table: Item Inventory
    2017-07-18 15:54:02 0 ModAccess Populate Table: Item Inventory Assembly
    2017-07-18 15:54:05 -2147217865 ModAccess ERROR: [MySQL][ODBC 3.51 Driver][mysqld-5.6.35-cll-lve]Table ‘opensync.iteminventoryassembly’ doesn’t exist(GenDeleteTable in table iteminventoryassembly )
    2017-07-18 15:54:05 -2147217865 ModAccess ERROR: [MySQL][ODBC 3.51 Driver][mysqld-5.6.35-cll-lve]Table ‘opensync.iteminventoryassembly’ doesn’t exist(GenMakeDBRecs: [MySQL][ODBC 3.51 Driver][mysqld-5.6.35-cll-lve]Table ‘opensync.iteminventoryassembly’ doesn’t exist in table iteminventoryassembly 0 )
    2017-07-18 15:54:06 -2147217865 ModAccess ERROR: [MySQL][ODBC 3.51 Driver][mysqld-5.6.35-cll-lve]Table ‘opensync.iteminventoryassembly’ doesn’t exist(GenMakeDBRecs: [MySQL][ODBC 3.51 Driver][mysqld-5.6.35-cll-lve]Table ‘opensync.iteminventoryassembly’ doesn’t exist in table iteminventoryassembly 0 )
    2017-07-18 15:54:07 -2147217865 ModAccess ERROR: [MySQL][ODBC 3.51 Driver][mysqld-5.6.35-cll-lve]Table ‘opensync.iteminventoryassembly’ doesn’t exist(GenMakeDBRecs: [MySQL][ODBC 3.51 Driver][mysqld-5.6.35-cll-lve]Table ‘opensync.iteminventoryassembly’ doesn’t exist in table iteminventoryassembly 0 )
    2017-07-18 15:54:07 0 ModAccess Populate Table: Item Non Inventory
    2017-07-18 15:54:13 0 ModAccess Populate Table: Item Other Charge
    2017-07-18 15:54:40 0 ModAccess Populate Table: Item Payment
    2017-07-18 15:54:41 0 ModAccess Populate Table: Item Sales Tax
    2017-07-18 15:54:47 0 ModAccess Populate Table: Item Service
    2017-07-18 15:54:59 0 ModAccess Populate Table: Item Sites
    2017-07-18 15:55:53 0 ModAccess Populate Table: Item Subtotal
    2017-07-18 15:55:54 0 ModAccess Populate Table: Items
    2017-07-18 15:56:36 -2147217865 ModAccess ERROR: [MySQL][ODBC 3.51 Driver][mysqld-5.6.35-cll-lve]Table ‘opensync.iteminventoryassembly’ doesn’t exist(GenMakeDBRecs: [MySQL][ODBC 3.51 Driver][mysqld-5.6.35-cll-lve]Table ‘opensync.iteminventoryassembly’ doesn’t exist in table items 0 80000244-1476309426)
    2017-07-18 15:56:37 -2147217865 ModAccess ERROR: [MySQL][ODBC 3.51 Driver][mysqld-5.6.35-cll-lve]Table ‘opensync.iteminventoryassembly’ doesn’t exist(GenMakeDBRecs: [MySQL][ODBC 3.51 Driver][mysqld-5.6.35-cll-lve]Table ‘opensync.iteminventoryassembly’ doesn’t exist in table items 0 )
    2017-07-18 15:56:40 -2147217865 ModAccess ERROR: [MySQL][ODBC 3.51 Driver][mysqld-5.6.35-cll-lve]Table ‘opensync.iteminventoryassembly’ doesn’t exist(GenMakeDBRecs: [MySQL][ODBC 3.51 Driver][mysqld-5.6.35-cll-lve]Table ‘opensync.iteminventoryassembly’ doesn’t exist in table items 0 )
    2017-07-18 15:56:50 -2147217865 ModAccess ERROR: [MySQL][ODBC 3.51 Driver][mysqld-5.6.35-cll-lve]Table ‘opensync.iteminventoryassembly’ doesn’t exist(GenMakeDBRecs: [MySQL][ODBC 3.51 Driver][mysqld-5.6.35-cll-lve]Table ‘opensync.iteminventoryassembly’ doesn’t exist in table items 0.00 8000002D-1424123527 Sales 0.052 80000017-1423496885 Postage and Delivery 8000005B-1433448199)
    2017-07-18 16:06:16 0 ModAccess Connect from: OpenSync
    2017-07-18 16:06:21 0 ModAccess Refresh Table: itemdiscount
    2017-07-18 16:06:21 0 ModAccess Refresh Table: itemfixedasset
    2017-07-18 16:06:22 0 ModAccess Refresh Table: itemgroup
    2017-07-18 16:06:23 0 ModAccess Refresh Table: iteminventory
    2017-07-18 16:06:24 0 ModAccess Refresh Table: iteminventoryassembly
    2017-07-18 16:06:25 0 ModAccess Refresh Table: itemnoninventory
    2017-07-18 16:06:26 0 ModAccess Refresh Table: itemothercharge
    2017-07-18 16:06:26 0 ModAccess Refresh Table: itempayment
    2017-07-18 16:06:27 0 ModAccess Refresh Table: itemreceipt
    2017-07-18 16:06:29 -2147217865 ModAccess ERROR: [MySQL][ODBC 3.51 Driver][mysqld-5.6.35-cll-lve]Table ‘opensync.iteminventoryassembly’ doesn’t exist(GenMakeDBRecs: [MySQL][ODBC 3.51 Driver][mysqld-5.6.35-cll-lve]Table ‘opensync.iteminventoryassembly’ doesn’t exist in table Items 8000040E-1497912263 )
    2017-07-18 16:06:30 0 ModAccess Refresh Table: itemsalestax
    2017-07-18 16:06:31 0 ModAccess Refresh Table: itemsalestaxgroup
    2017-07-18 16:06:32 0 ModAccess Refresh Table: itemservice
    2017-07-18 16:06:32 0 ModAccess Refresh Table: itemsites
    2017-07-18 16:08:39 0 ModAccess Refresh Table: itemsubtotal
    2017-07-18 16:22:33 0 ModAccess Connect from: OpenSync
    2017-07-18 16:22:40 0 ModAccess Refresh All
    2017-07-18 16:22:40 0 ModAccess Refresh Table: account
    2017-07-18 16:22:42 0 ModAccess Refresh Table: bill
    2017-07-18 16:22:45 0 ModAccess Refresh Table: billpayment
    2017-07-18 16:22:48 0 ModAccess Refresh Table: charge
    2017-07-18 16:22:49 0 ModAccess Refresh Table: check
    2017-07-18 16:22:50 0 ModAccess Refresh Table: class
    2017-07-18 16:22:50 0 ModAccess Refresh Table: creditcardcharge
    2017-07-18 16:22:51 0 ModAccess Refresh Table: creditcardcredit
    2017-07-18 16:22:51 0 ModAccess Refresh Table: creditmemo
    2017-07-18 16:22:55 0 ModAccess Refresh Table: customermsg
    2017-07-18 16:22:56 0 ModAccess Refresh Table: customertype
    2017-07-18 16:22:56 0 ModAccess Refresh Table: terms
    2017-07-18 16:22:57 0 ModAccess Refresh Table: deposit
    2017-07-18 17:26:00 0 ModAccess Connect from: OpenSync
    2017-07-18 17:26:07 0 ModAccess Refresh Table: iteminventoryassembly
    2017-07-18 17:38:39 0 ModAccess Connect from: OpenSync
    2017-07-18 17:38:44 0 ModAccess Refresh Table: iteminventoryassembly
    2017-07-18 17:39:43 0 ModAccess Connect from: OpenSync
    2017-07-18 17:40:37 0 ModAccess Connect from: OpenSync
    2017-07-18 17:40:45 0 ModAccess Refresh Table: iteminventoryassembly
    2017-07-18 21:02:05 0 ModAccess Connect from: OpenSync
    2017-07-19 00:52:09 0 ModAccess Connect from: OpenSync
    2017-07-19 09:19:29 0 ModAccess Connect from: OpenSync
    2017-07-19 09:19:36 0 ModAccess Refresh Table: itemdiscount
    2017-07-19 09:19:38 0 ModAccess Refresh Table: itemfixedasset
    2017-07-19 09:19:40 0 ModAccess Refresh Table: itemgroup
    2017-07-19 09:19:40 0 ModAccess Refresh Table: iteminventory
    2017-07-19 09:19:41 0 ModAccess Refresh Table: iteminventoryassembly
    2017-07-19 09:19:42 -2147217887 ModAccess ERROR: ODBC driver does not support the requested properties.(RefreshDatabase in table iteminventoryassembly )
    2017-07-19 09:19:42 0 ModAccess ERROR: (GenMakeDBRecs: ODBC driver does not support the requested properties. err#:-2147217887 field:: in table iteminventoryassembly 0 – )
    2017-07-19 09:19:42 0 ModAccess Refresh Table: itemnoninventory
    2017-07-19 09:19:44 0 ModAccess Refresh Table: itemothercharge
    2017-07-19 09:19:45 0 ModAccess Refresh Table: itempayment
    2017-07-19 09:19:47 0 ModAccess Refresh Table: itemreceipt
    2017-07-19 09:20:19 0 ModAccess Refresh Table: itemsalestax
    2017-07-19 09:20:20 0 ModAccess Refresh Table: itemsalestaxgroup
    2017-07-19 09:20:21 0 ModAccess Refresh Table: itemservice
    2017-07-19 09:20:22 0 ModAccess Refresh Table: itemsites
    2017-07-19 09:22:59 0 ModAccess Refresh Table: itemsubtotal
    2017-07-19 09:23:28 0 ModAccess Connect from: OpenSync
    2017-07-19 09:23:35 0 ModAccess Refresh Table: itemdiscount
    2017-07-19 09:23:36 0 ModAccess Refresh Table: itemfixedasset
    2017-07-19 09:23:37 0 ModAccess Refresh Table: itemgroup
    2017-07-19 09:23:38 0 ModAccess Refresh Table: iteminventory
    2017-07-19 09:23:39 0 ModAccess Refresh Table: iteminventoryassembly
    2017-07-19 09:23:40 0 ModAccess Refresh Table: itemnoninventory
    2017-07-19 09:23:40 0 ModAccess Refresh Table: itemothercharge
    2017-07-19 09:23:41 0 ModAccess Refresh Table: itempayment
    2017-07-19 09:23:42 0 ModAccess Refresh Table: itemreceipt
    2017-07-19 09:23:43 0 ModAccess Refresh Table: itemsalestax
    2017-07-19 09:23:44 0 ModAccess Refresh Table: itemsalestaxgroup
    2017-07-19 09:23:45 0 ModAccess Refresh Table: itemservice
    2017-07-19 09:23:46 0 ModAccess Refresh Table: itemsites
    2017-07-19 09:25:56 0 ModAccess Refresh Table: itemsubtotal
    2017-07-19 12:02:51 0 ModAccess Connect from: OpenSync
    2017-07-19 12:02:57 0 ModAccess SaveReport to table RASSEMB
    2017-07-19 12:02:57 3110 ModAccess SaveReport to table error: The enumerated value “InventoryAssembly” in the field “ItemTypeFilter” is unknown or invalid for the qbXML version in use.

    in reply to: Tables aren't getting updated or populated #16268

    nathan1
    Participant

    Oh just found the db log

    in reply to: Tables aren't getting updated or populated #16267

    nathan1
    Participant

    A lot of my products have some different characters. It’s been my experience that things like + or ‘ or | or something like that causes problems. Are there any that aren’t able to be used that could be causing this so I can do a search in my item list in QB?

    in reply to: Tables aren't getting updated or populated #16266

    nathan1
    Participant

    I had already rebuilt a few times. There were some errors in the company file. I installed version 3.0 and tried to run all of my items using populate, here is the log below. I noticed it says Processing table: Item InventoryAssembly, but the log doesn’t actually tell you the details and that’s not a real table that you guys use. Are there any other ways to do a detailed trace?
    2017-07-19 14:16:55 0 OpenSync:Runner Runner: Start task items
    2017-07-19 14:16:55 0 WorkTracker Init
    2017-07-19 14:16:55 0 WorkTracker Starting task: items
    2017-07-19 14:16:55 0 BackWorker ExecuteBackground Begin
    2017-07-19 14:17:01 0 BackWorker MakeQbConnection: Connection Opened
    2017-07-19 14:17:01 0 BackWorker PopulateAll
    2017-07-19 14:17:02 0 BackWorker Processing table: Inventory Site
    2017-07-19 14:17:03 0 BackWorker Processing table: Item Discount
    2017-07-19 14:17:04 0 BackWorker Processing table: Item Fixed Asset
    2017-07-19 14:17:05 0 BackWorker Processing table: Item Group
    2017-07-19 14:17:09 0 BackWorker Processing table: Item Inventory
    2017-07-19 14:17:34 0 BackWorker Processing table: Item Inventory Assembly
    2017-07-19 14:17:41 0 BackWorker Processing table: Item Non Inventory
    2017-07-19 14:17:47 0 BackWorker Processing table: Item Other Charge
    2017-07-19 14:18:14 0 BackWorker Processing table: Item Payment
    2017-07-19 14:18:16 0 BackWorker Processing table: Item Receipt
    2017-07-19 14:20:58 0 BackWorker Processing table: Item Sales Tax
    2017-07-19 14:21:00 0 BackWorker Processing table: Item Sales Tax Group
    2017-07-19 14:21:01 0 BackWorker Processing table: Item Service
    2017-07-19 14:21:05 0 BackWorker Processing table: Item Sites
    2017-07-19 14:22:09 0 BackWorker Processing table: Item Subtotal
    2017-07-19 14:22:10 0 BackWorker Processing table: Items
    2017-07-19 14:23:21 0 WorkTracker WorkDone
    2017-07-19 14:23:21 0 BackWorker CloseQbConnection: Close Connection
    2017-07-19 14:23:21 0 BackWorker ExecuteBackground Complete
    2017-07-19 14:23:21 0 OpenSync:Runner Complete

    in reply to: Tables aren't getting updated or populated #16261

    nathan1
    Participant

    Also I noticed none of my assemblies are in the item table. Is there another place I can query the assemblies or can we fix the problem above by running a report where it just lists my inventory assemblies somehow?

    in reply to: opensync 3.0 where are my old settings #16257

    nathan1
    Participant

    I uninstalled 3.0 and installed 2 again. Now all of my settings are back. So you guys just need to fix the upgrade perhaps. I’m on win 7, maybe that’s why. Not sure but letting you know

    in reply to: opensync 3.0 where are my old settings #16251

    nathan1
    Participant

    Thank you for the folder info, I should have thought of that. So, in that folder is a blank xml file. Does that mean all my settings are gone? Does Open Sync do any backup when the 3.0 version gets installed? If all of my settings are gone, can I do something to link my current database back up or will I need to wipe out all data and start over?

Viewing 15 posts - 16 through 30 (of 31 total)