FrontAccounting forum — Romanian GL -> Table 1_gl_trans

Re: Romanian GL -> Table 1_gl_trans

null@example.com (serbanc) — Wed, 04 Apr 2012 18:47:05 +0000

thanks for notice!

a corrected version was sent to admins.

Regards

Re: Romanian GL -> Table 1_gl_trans

null@example.com (intelicasa) — Sun, 01 Apr 2012 12:29:31 +0000

I partially solved the issue . It was because of some incorect INSERT statement .
in file ro_RO-general.sql at :

Line 1641
Incorect :
INSERT INTO `1_fiscal_year` VALUES
('1', '2012-01-01', '2012-12-31', '0'),

Correct :
INSERT INTO `1_fiscal_year` VALUES
('1', '2012-01-01', '2012-12-31', '0');

Line 2157
Incorect :
INSERT INTO `1_sales_types` VALUES
('1', 'Regular', '1', '1', '0'),

Correct :
INSERT INTO `1_sales_types` VALUES
('1', 'Regular', '1', '1', '0');

Line 2273
INSERT INTO `1_stock_category` VALUES
Delete it or ###

If it is corect what I've said , please write again ro_RO-general.sql

Thank you

Re: Romanian GL -> Table 1_gl_trans

null@example.com (intelicasa) — Sun, 01 Apr 2012 11:29:39 +0000

I forgot to mention..installing FA with standard american COA works great.

Romanian GL -> Table 1_gl_trans

null@example.com (intelicasa) — Sun, 01 Apr 2012 11:27:04 +0000

Hello dears ,
Despite the fact that first step of installing FA was green (everything that FA requires is installed on hosting) , when I tried to install a company based on Romanian chart of accounts , I have errors with table 1_gl_trans .

First error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DROP TABLE IF EXISTS `1_gl_trans`' at line 6

As long as this table doesn't exist , I skipped it by ### sql ### . After this, save..continue..and encountered second error

Second : SQL script execution failed in line 1641: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CREATE TABLE `1_gl_trans` ( `counter` int(11) NOT NULL AUTO_INCREMENT, `type` sm' at line 8

Do you have any advice ?
Thank you