1

(4 replies, posted in Installation)

Can I get the empty DB , too?

after installing version 2.0, What I had done is to delete every data on DB except company and user data and tried to put one by one and it happens. Strnage thing that I doubt is that there is no reference value shown.
What is the reference for?
Why isn't it shown?
Will it be ok to start with deleting all table data except company and user table?

Thanks in advance.

P.S) If I would like to fill the data from the beginning (empty), what is the procedure to do that?

I don't know what to do with the following errors

I clicked purchase> Payments to Suppliers>
and entered amount and discount and memo,
Reference was not shown and so I put 1 into Reference: field and memo : ddd

And the following errors come:
Please let me know what happens.
Thanks in advance.




Supplier Payment Entry


DATABASE ERROR : The supplier GL transaction could not be inserted
error code : 1064
error message : 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 ' 3, '2')' at line 3
sql that failed was : INSERT INTO 0_gl_trans ( type, type_no, tran_date, account, dimension_id, dimension2_id, memo_, amount, person_type_id, person_id) VALUES (22, 1, '2008/04/15', '6', 0, 0, '', , 3, '2')