It's much more fun, when you can discuss your problems with others...
You are not logged in. Please login or register.
FrontAccounting forum → Posts by joe
Ericta, I am really sorry for your data loss. Hopefully you can forgive us. We are doing all this on a voluntary base without any money involved.
We try to do the best we can to avoid this, and it is the first time we have run into this kind of problem. And hopefully it will be the last time.
But for your own safety, please make frequently backup of your companies.
Humble regards
Joe.
2.3 RC2 means release candidate 2 of 2.3. This is where the database structure is locked for 2.3.X.
/Joe
If you are using newer versions of MySql you have to replace the type with engine.
It should be ok to use some of the tables as myisam and other as innodb.
I hope you are getting this to work.
/Joe
Also this should be fixed in 2.3.4
/Joe
This have been fixed in the release 2.3.4 that is about to ship today.
/Joe
Hello ad1t.
I am not sure I understand your question. If you mean how we communicate with the users, well this is one of the places. We also have News on Sourceforge and news on the Website.
We also have some miailing lists, developers and a more general mailing list. These can be found on the Sourceforge project page, were you also can subscribe to the lists.
/Joe
Ok, I misunderstood your question.
I will see what can be done.
/Joe
And remember to restart your Apache Server after the changes in php.ini.
/Joe
There was, for some reason, a missing 0_sys_types table in your script.
Please copy these lines and paste into phpMyAdmin to your database, SQL form, and run the query.
--
-- Table structure for table `0_sys_types`
--
DROP TABLE IF EXISTS `0_sys_types`;
CREATE TABLE IF NOT EXISTS `0_sys_types` (
`type_id` smallint(6) NOT NULL default '0',
`type_no` int(11) NOT NULL default '1',
`next_reference` varchar(100) NOT NULL default '',
PRIMARY KEY (`type_id`)
) TYPE=InnoDB;
--
-- Dumping data for table `0_sys_types`
--
INSERT INTO `0_sys_types` VALUES(0, 19, '3');
INSERT INTO `0_sys_types` VALUES(1, 8, '2');
INSERT INTO `0_sys_types` VALUES(2, 5, '2');
INSERT INTO `0_sys_types` VALUES(4, 3, '1');
INSERT INTO `0_sys_types` VALUES(10, 19, '4');
INSERT INTO `0_sys_types` VALUES(11, 3, '2');
INSERT INTO `0_sys_types` VALUES(12, 6, '1');
INSERT INTO `0_sys_types` VALUES(13, 5, '2');
INSERT INTO `0_sys_types` VALUES(16, 2, '1');
INSERT INTO `0_sys_types` VALUES(17, 2, '1');
INSERT INTO `0_sys_types` VALUES(18, 1, '3');
INSERT INTO `0_sys_types` VALUES(20, 8, '3');
INSERT INTO `0_sys_types` VALUES(21, 1, '1');
INSERT INTO `0_sys_types` VALUES(22, 4, '2');
INSERT INTO `0_sys_types` VALUES(25, 1, '2');
INSERT INTO `0_sys_types` VALUES(26, 1, '8');
INSERT INTO `0_sys_types` VALUES(28, 1, '1');
INSERT INTO `0_sys_types` VALUES(29, 1, '2');
INSERT INTO `0_sys_types` VALUES(30, 5, '6');
INSERT INTO `0_sys_types` VALUES(32, 0, '1');
INSERT INTO `0_sys_types` VALUES(35, 1, '1');
INSERT INTO `0_sys_types` VALUES(40, 1, '3');In the various view popup screens there is a link to the attachemnt, if there is one. It is a link, Attachment, at the bottom together with the print, close links.
Joe
Normally the backup routine runs like a charm.
I guess we should look around. You got that when doing a backup.
Do you see any other errors in your errors.log in the /tmp folder?
Is this a huge company? Huge data?
/Joe
I am not sure if this is the problem.
Can you try to look in the database with phpMyAdmin and see if the table 0_sys_types exists and it is populated.
dirname(__FILE__) means the folder name where the file exists, but this line is commented, which means that it is not used.
/Joe
You are right Pete. I have asked Janusz to fix this item.
/Joe
Hello again. There is no join between the due_date field in debtor_trans and other tables. So it should be risk-free to do the SQL.
I will have another look into this subject you describe.
/Joe
You will have to enter the php.ini file in your server php setup. In this file under extensions, you will have to uncomment the OpenSSL extension.
If you can't do that yourself, you will have to ask your hosting provider to do that for you.
/Joe
This subject has just been fixed and will be included in the next release, 2.3.4 that are planned to ship tomorrow.
The script will not be updated any more.
/Joe
Thanks Pete, nice to have an experienced guy back online again 
/Joe
Hello again chvypwrd,
Which release of FA are you running?
I have now made rigorious testing for this in 2.3.3 without reproducing it.
We are in a hurry for shipping release 2.3.4 due to other serious bugs, so we need more info to investigate this. Otherwise we will continue doing this during the 2.3.4 release.
/Joe
There might be some problems with the tax calculations. I know that certain countries use som kind of even-out up/down to nearest amount without the hundredth part. Maybe this is some kind of the same.
There is, however, possible to give discounts when doing the payment(s)/deposit(s).
/Joe
Hello Pete,
Long time no see.
If you change the invoice date to an older/future value the due date should follow. It is always based on the invoice date. You have tab away from the invoice date field to get any effect.
/Joe
This is not directly possible at the moment. Maybe there are some others that use this in a sophisticated way?
You can only use this adjustment on the lines itself.
/Joe
You can look into the file /includes/types.inc.
/Joe
This is rather difficult to get such a report. We do not have a join on supplier/items and stock moves. As you can have the same item on several suppliers.
This would require more joined tables.
/Joe
Type_id is a special kind of type, like Sales Order, Sales Invoice, Sales Credit, PO, GRN, Supp Invoice, etc. etc.
There is a type_id for every kind of operation.
Trans_no is a unique identifier inside the type_id for assembling the rows to goto the GL.
For more info please look at the https://frontaccounting.com/fawiki
/Joe
See my answer in your topic in the Setup forum.
/Joe
FrontAccounting forum → Posts by joe
Powered by PunBB, supported by Informer Technologies, Inc.
Currently installed 4 official extensions. Copyright © 2003–2009 PunBB.