1

(11 replies, posted in Installation)

Hello. I just wanted to let you know that I solved this problem (a couple of weeks ago but I didn't find the time until today to post on the forum). Basically, FrontAccounting did not support the newest version of PHP (5.3.0) that I had installed with WampServer. What I did is install version 5.2.9 of PHP. Then I tried installing FrontAccounting again and everything worked just fine. Thanks for the suggestions above.

2

(11 replies, posted in Installation)

Joe, there are three parts to this message. The first one describes what my problem is boiling down to right now. The other two parts you don't have to read but I am including them anyways to document the problems I encountered above and the way I "fixed" them. Thanks again. Julio.

Part I #########

When installing the program I get the following error message:

Deprecated: Assigning the return value of new by reference is deprecated in C:\wamp\www\account\includes\session.inc on line 136

I copy below the code that appears in Line 136:

$Ajax =& new Ajax();

Part II #############

In my last message I mentioned getting the following error message:

Error: It appears the Absolute path that you entered is incorrect

In fact there was nothing wrong with the absolute path. What happened was that the computer was searching (as indicated in the save.php file) for the en_US-demo.sql file, which I had taken out of the path. Instead I had put the en_SG-new2.sql file, but was not careful enough to update the references in the save.php file. When I did update the references I no longer got a message about the absolute path being wrong, but I got the same error message as above:

Deprecated: Assigning the return value of new by reference is deprecated in C:\wamp\www\account\includes\session.inc on line 136

Part III ###################

I also tried installing the program with each of the newly uploaded files that you suggested me. This time I made sure that the references in the save.php file were correct. Then I hit "Install FrontAccounting". The computer had no problem in locating the database for the corresponding company. However, I started getting a many error messages regarding the way the data was entered. I "corrected" all these errors [see (*) below] until I hit the same deadend:

Deprecated: Assigning the return value of new by reference is deprecated in C:\wamp\www\account\includes\session.inc on line 136

/////////////////////////

(*) This documents my problems and "fixes" when working with the en_US-demo.sql database. For each error type I put first the tables involved, then the error messages, and finally the modifications I introduced to "solve" the corresponding errors. A friend of mine (Aldy) tells me that these errors might be due to an incompatibility in the versions of the software I was using versus the softwares the programs were ment for. I really don't know. I just went for the quick fixes detailed below:

### Data of table `0_bank_trans` ###

Error: SQL script execution failed in line 102: Incorrect date

value: '' for column 'reconciled' at row 1

Instead of the '' values, put NULL. Do the samething with all other rows of that table.

### Data of table `0_gl_trans` ###


Error: SQL script execution failed in line 704: Incorrect integer value: '' for column 'person_type_id' at row 1

Instead of the '' values, put '0'. Do the samething with all the remaining rows of that table for which 'person_type_id' was assigned a value of ''.

### Data of table `0_users` ###

Error: SQL script execution failed in line 1827: Incorrect datetime value: '' for column 'last_visit_date' at row 1

Instead of the '' value, put '2009-06-21 13:57:38' (I just copied the date from the previous entry).

3

(11 replies, posted in Installation)

Thanks for the suggestion Joe, however I still have an error message showing.  I took out the en_US-demo.sql files and put instead the en_SG-new2.sql file that you mentionned. I repeated the process. Now I  get the following error message:

Error: It appears the Absolute path that you entered is incorrect

4

(11 replies, posted in Installation)

Hello. I am trying to install FrontAccounting in my computer, which uses Windows Vista. I use the lates wampserver. I downloaded the files for FrontAccounting yesterday and put them in a specially created file, as described in "FrontAccounting Installation." After filing the questions for the installation wizard and hiting enter, I get the following message:


Error: SQL script execution failed in line 103: Incorrect integer value: '' for column 'bank_trans_type_id' at row 1

Does anybody know what might be happening?

Thank you.

Julio.