• Registered: 03/27/2012
  • Posts: 12

Topic: Romanian GL -> Table 1_gl_trans

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

  • Registered: 03/27/2012
  • Posts: 12

Re: Romanian GL -> Table 1_gl_trans

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

3 Reply by intelicasa (edited by intelicasa 04/01/2012 12:33:52 pm)

  • Registered: 03/27/2012
  • Posts: 12

Re: Romanian GL -> Table 1_gl_trans

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

  • From: Romania, Bucharest
  • Registered: 11/03/2011
  • Posts: 32

Re: Romanian GL -> Table 1_gl_trans

thanks for notice!

a corrected version was sent to admins.

Regards

serbanc's Website