<![CDATA[FrontAccounting forum — table item_codes]]>2009-04-03T10:07:35ZPunBBhttps://frontaccounting.com/punbb/viewtopic.php?id=559<![CDATA[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]]>https://frontaccounting.com/punbb/profile.php?id=892009-04-03T10:07:35Zhttps://frontaccounting.com/punbb/viewtopic.php?pid=2183#p2183<![CDATA[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]]>https://frontaccounting.com/punbb/profile.php?id=662009-04-03T10:03:49Zhttps://frontaccounting.com/punbb/viewtopic.php?pid=2181#p2181<![CDATA[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]]>https://frontaccounting.com/punbb/profile.php?id=662009-04-03T09:22:37Zhttps://frontaccounting.com/punbb/viewtopic.php?pid=2179#p2179<![CDATA[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
]]>https://frontaccounting.com/punbb/profile.php?id=892009-04-03T08:02:42Zhttps://frontaccounting.com/punbb/viewtopic.php?pid=2175#p2175<![CDATA[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?