FrontAccounting forum — Upgrade 1.xx to 2.0.2

Re: Upgrade 1.xx to 2.0.2

null@example.com (smummert) — Tue, 30 Sep 2008 19:15:55 +0000

Yup - prior version ignored the type and now it matters. Needs to be JPG

Re: Upgrade 1.xx to 2.0.2

null@example.com (smummert) — Tue, 30 Sep 2008 18:17:40 +0000

Maybe I have a gif logo and the system needs a jpg for the logo?

Re: Upgrade 1.xx to 2.0.2

null@example.com (smummert) — Tue, 30 Sep 2008 18:16:10 +0000

OK things seem to be going however I have a single invoice I an looking to print and during the PDF gen I am getting:

TCPDF error: Missing or incorrect image file: C:\Inetpub\wwwroot\frontaccounting\reporting\fonts\jpg1260.tmp

in the output window - thoughts?

Re: Upgrade 1.xx to 2.0.2

null@example.com (smummert) — Tue, 30 Sep 2008 16:25:23 +0000

OK got the new alter.sql - That is much better - thanks!

Re: Upgrade 1.xx to 2.0.2

null@example.com (smummert) — Tue, 30 Sep 2008 15:44:10 +0000

First - I appreciate the design of a simple open source solution! Second - I could lend a hand for major db changes if you like depending on time of course!

Re: Upgrade 1.xx to 2.0.2

null@example.com (joe) — Tue, 30 Sep 2008 15:08:29 +0000

Hello,
Remember that we do this on a non commercial base. It is all open source, that is why you should help us reporting these things.

You can download a fresh CVS copy of alter.sql from the CVS repository and see if it helps.

/Joe

Upgrade 1.xx to 2.0.2

null@example.com (smummert) — Tue, 30 Sep 2008 14:56:41 +0000

The alter.sql and alter2.sql scripts do NOT reflect the DB I have installed on my instance.

I am in the process of applying schema changes manually, a real pain. Currently stuck on sales orders and sales order details.

I see you now allow for same SKU different pricing on orders - great, but the upgrade is far from smooth. The upgrade scripts should be smart than this.
My current problem is altering :

ALTER TABLE `0_sales_orders` ADD `version` tinyint(1) NOT NULL default '0' after 'order_no';

Which is throwing an error, any thoughts?