FrontAccounting forum — table item_codes

Re: table item_codes

null@example.com (itronics) — Fri, 03 Apr 2009 10:07:35 +0000

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

Re: table item_codes

null@example.com (climbdave) — Fri, 03 Apr 2009 10:03:49 +0000

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

Re: table item_codes

null@example.com (climbdave) — Fri, 03 Apr 2009 09:22:37 +0000

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

Re: table item_codes

null@example.com (itronics) — Fri, 03 Apr 2009 08:02:42 +0000

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

table item_codes

null@example.com (climbdave) — Thu, 02 Apr 2009 20:00:49 +0000

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