Search options (Page 1 of 2)

Hmm ... Thanks for the investigation apmuthu but after removing all 12 backticks and importing again, the problem is exactly the same. What should I do?

Thanks!

Yes - thank you. Use two different browsers - that's the way. Tested and found that it works.

The issue here was the use of softaculous for installing Frontaccounting in shared Linux hosting provided by InMotion Hosting. I did an install from SourceForge using frontaccounting-2.4.8.tar.gz which succeeded in creating company 0 as well as company 1. Therefore: do not use softaculous for installing frontaccounting at InMotion Hosting.

Thank you for the updated import_transactions module!

After using it to replace the import module, I still had the prep_amount error. After some code analysis (I am not a PHP programmer but know other languages [C, VB, C#] I modified line 220 in import_transaction.PHP to read

    $_SESSION['Items'] = new import_sales_cart($type, 0, false); $_SESSION['Items']->prep_amount = 0.0E0;

because a zero prepay amount is fine for me for the time being. This got me past the error.

I then had to change in the csv input file the values for dimension_id and dimension2_id from strings to integers (between "Retail" and "5551"). The file now looks like this (2 lines):

customer_id,branch_No,reference,date,payment_id,sales_type_name,dimension_id,dimension2_id,item_code,item_description,quantity,
unit,price,discountpercentage,freightcost,delfrom,deldate,delto,deladdress,contactphone,email,custref,shipvia,comments,ex_rate,
prep_amount
1,1,"2345","2020/04/11",2,"Retail",1,2,"5551","Pattern tow",1,"Each",32.00,0,0,"DEF","2020/04/11","Cust","Bergseth Field","206 660 0019","info@pugetsoundsoaring.org","001",0,"Robertos pattern tow",1,0

Unfortunately, the import still fails without reporting an error in the PHP error log: In the UI, green messages say that the import was successful. Checking the database - table 1_sales_orders has one record with contents from the csv import file. But table 1_sales_order_details remains empty; a sales order inquiry shows no records.

There is an error reported in the PHP log, but I believe it is unrelated:
[03-May-2020 09:41:35 America/Los_Angeles] 1:admin:import_transactions.php:399: fclose() expects parameter 1 to be resource, null given

There are no errors reported in the system log that logs the GET and POST requests for the FA website.

What should I do next, please?

Here is the error:

[27-Apr-2020 13:35:45 America/Los_Angeles] <b>DATABASE ERROR :</b> order Cannot be Added<br>error code : 1366<br>error message : Incorrect double value: '' for column `pugets12_fron528`.`1_sales_orders`.`prep_amount` at row 1<br>sql that failed was : INSERT INTO 1_sales_orders (order_no, type, debtor_no, trans_type, branch_code, customer_ref, reference, comments, ord_date,
        order_type, ship_via, deliver_to, delivery_address, contact_phone,
        freight_cost, from_stk_loc, delivery_date, payment_terms, total, prep_amount)
        VALUES ('1','0','          1', '30','        1', '2345','auto','Robertos pattern tow','2020-04-11', '1', '        0','Cust','Bergseth Field', '206 660 0019', '0', 'DEF', '2020-04-11','         2','32','')<br><br><br>

But the template .csv file does not contain a field for prep_amount .

Try trial first and then without it: Yes, I do that routinely. I get green messages, same either way; no red messages.
Platform: webserver is CloudLinux 7.7, cPanel version 86.0.16. Database server: server type = MariaDB, database client version: libmysql 5.6.43; PHP version 7.3.6.
I applied the post release fixes.
There was no PHP.ini file. I copied one (presumably the standard one provided by the hosting company) into the FrontAccounting root directory. Made these changes: display_errors = On ; track_errors = On ; error_log = /home/pugets12/logs/FA_errors.log .
Made no error-logging related changes in config.PHP.

With the above changes, there was no change in FA import_transactions behavior, nor could I find any errors logged in the routine system logging file (in this case /logs/frontaccounting.pugetsoundsoaring.org-Apr-2020.gz). File /logs/FA_errors.log was not written.

Don't know how to go about check db permissions are getting percolated into the extension and file and folder permissions: what I can report is that, when I descend into modules/import_transactions all folders have permission 0755 and all files have 0644.
I am puzzled about constant VARLOG_PATH in config.PHP . Is it set to root/logs ?

That was it! Thank you so much, Rafat!

I just sent a PM to apmuthu.

Directory G:\PleskVhosts\rad129.net\pssafrontacc.rad129.net is the root. These users/groups have full control in the root and all subdirectories: Application pool group, Plesk Domain User. Plesk FTP subaccount can only list the folder contents.

I modified index.php as follows:

<?php
/**********************************************************************
    Copyright (C) FrontAccounting, LLC.
    Released under the terms of the GNU General Public License, GPL, 
    as published by the Free Software Foundation, either version 3 
    of the License, or (at your option) any later version.
    This program is distributed in the hope that it will be useful,
    but WITHOUT ANY WARRANTY; without even the implied warranty of
    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  
    See the License here <http://www.gnu.org/licenses/gpl-3.0.html>.
***********************************************************************/
        error_reporting( E_CORE_ERROR | E_CORE_WARNING | E_COMPILE_ERROR | E_ERROR | E_WARNING | E_PARSE | E_USER_ERROR | E_USER_WARNING | E_RECOVERABLE_ERROR );
        ini_set('display_errors', 1);

    $path_to_root=$_SERVER["DOCUMENT_ROOT"];
        echo "index.php: path_to_root = ".$path_to_root."<br />";

        if(is_writable($path_to_root)){
                echo '&nbsp;&nbsp;It IS writable<br />';
        }else{
                echo '&nbsp;&nbsp;It is NOT writable<br />';
        }

    if (file_exists($path_to_root.'/install.html'))
        echo 'index.php: File '.$path_to_root.'/install.html exists<br />';
    if (!file_exists($path_to_root.'/config_db.php'))
        echo 'index.php: File '.$path_to_root.'/config_db.php does not exist<br />';
/*
     if (!file_exists($path_to_root.'/config_db.php'))
        header("Location:".$path_to_root."/install/index.php");

    $page_security = 'SA_OPEN';
    ini_set('xdebug.auto_trace',1);
    include_once("includes/session.inc");
    add_access_extensions();
    $app = &$_SESSION["App"];
    if (isset($_GET['application']))
        $app->selected_application = $_GET['application'];

    $app->display();
*/
?>

Running the website resulted in:

index.php: path_to_root = G:\PleskVhosts\rad129.net\pssafrontacc.rad129.net
  It IS writable
index.php: File G:\PleskVhosts\rad129.net\pssafrontacc.rad129.net/install.html exists
index.php: File G:\PleskVhosts\rad129.net\pssafrontacc.rad129.net/config_db.php does not exist

Then I modified index.php again by moving the /* down a couple of lines so that the existence of config_db.php would be tested. Running the web site resulted in "This site can't be reached" ... ERR_UNSAFE_REDIRECT

Already a couple of days ago I modified the start of install/index.php as follows:

<?php
/**********************************************************************
    Copyright (C) FrontAccounting, LLC.
...    See the License here <http://www.gnu.org/licenses/gpl-3.0.html>.
***********************************************************************/
$page_security = 'SA_OPEN';
$path_to_root=$_SERVER["DOCUMENT_ROOT"];
echo "install/index.php: path_to_root=".$path_to_root."<br>";
die("Dies intentionally in install/index.php");

if (file_exists($path_to_root.'/config_db.php'))
    header("Location: $path_to_root/index.php");
..
..
..

Execution never gets to install/index.php since I have never seen the message 'Dies intentionally in install/index.php'.

What else should I do towards getting the installation going?

By the way, I have another website that is written in PHP and runs well under IIS and GoDaddy:
http://tng11.rad129.net/login.php
I derived it from http://www.tngsitebuilding.com/

r4

poncho1234, thanks for your link to https://frontaccounting.com/punbb/viewtopic.php?id=2581, but I was unable to make use of the info there where the complaint was too much redirection whereas I am having trouble getting any redirection.

phpinfo is available here: http://pssafrontacc.rad129.net/phpinfo.php

r4