4POS Support

4POS => 4POS Features => Topic started by: toddynyoni on April 30, 2011, 08:54:53 PM

Title: Runtime error on stock take commands after doing April upgrade
Post by: toddynyoni on April 30, 2011, 08:54:53 PM

If I restore my backup on the April upgrade and try to run create snapshot or stock take adjustments, I get the following error; Runtime error '-2147217900 (80040e14).....The INSERT INTO statement contains the following unknown field name:StockTake_QuantityOrig'. Make sure you have typed the name correctly, and try the operation again. All the other filters and procedures are ok. When I restore my backup on the February upgrade everything works fine. Please assist, the April upgrade is great news.

Title: Re: Runtime error on stock take commands after doing April upgrade
Post by: Admin on May 01, 2011, 08:36:36 AM

When you reload a backup, you MUST run the upgrade - 4POSDBConvert again. What you have done, is upgrade your 4POS software & THEN reloaded a backup before the upgrade!

When an upgrade is done, 4POS will create all new fields required to match the new upgrade. You simply can't then go & copy an old database back & expect it to work!

Please use your 4POS system wisely!