1. PDQ Deploy & Inventory Help Center
  2. Community
  3. PDQ Inventory
 

Important Notice: On February 29th, this community was put into read-only mode. All existing posts will remain but customers are unable to add new posts or comment on existing. Please feel to join our Community Discord for any questions and discussions.

Inventory Upgrade failed -no such table main.Old_CollectionComputers

Avatar
Ray Murphy

PDQ Inventory upgrade attempt from 19.0.40.0 to 19.3.48.0. -no such table main.Old_CollectionComputers

This is the response when attempting to upgrade, it fails to complete, fails to open. 

 

0

Comments

3 comments
Date Votes
  • Avatar
    Ray Murphy

    I created the missing table from CollectionComputers and now have this error.

    I'll keep trying to supply missing pieces, but I am not putting a lot of faith in the end result. Help!!!!!

    0
  • Avatar
    Ray Murphy

    Assuming the jump from 19.0.40.0 to Inventory_19.3.48.0 was too much for the upgrade to handle, I backed it all out and started over.

    Uninstalled, installed the version we had working, Inventory_19.0.40.0, 4/28/2020, 4:56 PM EDT, success.

    Installed the next available version with success, Inventory_19.1.96.0, 8/11/2020, 10:42 AM EDT, success.

    Trying to get to the next version, Inventory_19.2.137.0, 11/5/2020, 9:47 AM EST, this fails once again with the missing table error:
    -no such table main.Old_CollectionComputers

    It is desired to continue upgrading to a more recent version; we have several to install.

    Inventory 19.3.48.0, 7/14/2021, 2:43 PM EDT

    What am I missing?

    0
  • Avatar
    Colby Bouma

    I recommend reaching out to support@pdq.com

    0