• Registered: 11/22/2007
  • Posts: 12

Topic: table item_codes

Hello
I've been upgrading FA from version 2.0 to 2.1 AS the table item_codes is new, i've lost all the items that i've previously created. They are in table grn_items.
Is there any sql statement to fill up the new table item_codes using the data of grn_items and grn_batch?

Thanks
David

  • Registered: 12/25/2007
  • Posts: 2,448

Re: table item_codes

After source upgrade you have to perform database upgrade via Setup/Software Upgrade page. This will migrate all your data to new version.

Read update.html for details.

Janusz

  • Registered: 11/22/2007
  • Posts: 12

Re: table item_codes

I got this error when force upgrade
SQL script execution failed in line 66: Incorrect table definition; there can be only one auto column and it must be defined as a key
Cannot insert stock id into item_codes

  • Registered: 11/22/2007
  • Posts: 12

Re: table item_codes

I think that I've found the problem. One of my old item descriptions in table stock master contains (') symbol.
I changed it and it works.
Thanks
David

  • Registered: 12/25/2007
  • Posts: 2,448

Re: table item_codes

This have to be some very old record, or imported via third party software. Normally apostrophes are quoted in database and therefore does not trigger errors during upgrade.
Janusz