Search options (Page 212 of 247)

The affected file for company is: admin/company_preferences.php

On checking the code, only .jpg seems to be referenced everywhere for display usage.

The above anomaly will probably be there for stock item images as well and the affected file here is: inventory/manage/items.php.

The help strings indicating file types other than .jpg to be allowed for upload are in the language .po files.

The stock item image file is referenced as .jpg in
reporting/rep104.php and
reporting/rep303.php

The database entry in sql/en_US-demo.sql refers to the company logo as:

INSERT INTO `0_sys_prefs` VALUES('coy_logo', 'setup.company', 'varchar', 100, 'logo_frontaccounting.jpg');

Why don't you try the latest codebase from the mercurial repo or just use the difference file set to overwrite the v2.3.19 files?

Attached is the changed fileset after v2.3.19 was released.

Only one sql command needs to be executed on the existing db (change 0_ to whatever your company # is):

ALTER TABLE `0_debtor_trans` ADD INDEX `Order` (`order_`);

You seem to have changed:

$cols = array(4, 100, 130, 190,    250, 320, 385, 450, 515);

to

$cols = array(4, 90, 150, 210, 250, 320, 385, 450, 515);

Notice that a sum of 10+10 units have been increased whilst the others have increased for columns 2 and 3 whilst column 5 has been shortened by 20 units - hope the output is acceptable.

That is a functionality of the apache config and possibly a setting in the config file.

write permissions on the modules and tmp folder?

Probably just a browser cache issue.

Please verify that you are using the latest LDAP - the individual files are available in my personal GitHub Repo.

Enter one Journal Voucher with all Balance Sheet Entries (amounts) in detail dated the beginning of the Fiscal Year (close of last Balance Sheet).

My last post is not a new function but a rehash of the existing function to avoid redundant passes.

The diff patch for the latest Hg is:

--- old/admin/db/fiscalyears_db.inc    Wed Nov 06 16:43:56 2013
+++ new/admin/db/fiscalyears_db.inc    Tue Dec 10 08:53:50 2013
@@ -190,11 +190,15 @@
     
     $sql = "SELECT * FROM ".TB_PREF."attachments WHERE type_no = $type_no AND trans_no = $trans_no";
     $result = db_query($sql, "Could not retrieve attachments");
+    $delflag = false;
     while ($row = db_fetch($result))
     {
+        $delflag = true;
         $dir =  company_path(). "/attachments";
         if (file_exists($dir."/".$row['unique_name']))
             unlink($dir."/".$row['unique_name']);
+    }
+    if ($delflag) {
         $sql = "DELETE FROM ".TB_PREF."attachments WHERE  type_no = $type_no AND trans_no = $trans_no";
         db_query($sql, "Could not delete attachment");
     }    

Instead of hidden names in the form, why not lookup the names from the db in the processing code?

Methodology for module development on GitHub is in the Wiki.

Line 193 in admin/db/fiscalyears_db.inc :

while ($row = db_fetch($result))

will make sure that all pertinent ids will be deleted one at a time, but in the existing code, all pertinent ids will get deleted in the first pass and then be redundantly executed thereafter.

To truly benefit from a single pass deletion, the function would have to be structured thus:

function delete_attachments_and_comments($type_no, $trans_no)
{
    
    $sql = "SELECT * FROM ".TB_PREF."attachments WHERE type_no = $type_no AND trans_no = $trans_no";
    $result = db_query($sql, "Could not retrieve attachments");
    $delflag = false;
    while ($row = db_fetch($result))
    {
        $delflag = true;
        $dir =  company_path(). "/attachments";
        if (file_exists($dir."/".$row['unique_name']))
            unlink($dir."/".$row['unique_name']);
    }
    if ($delflag) {
        $sql = "DELETE FROM ".TB_PREF."attachments WHERE  type_no = $type_no AND trans_no = $trans_no";
        db_query($sql, "Could not delete attachment");
    }
    $sql = "DELETE FROM ".TB_PREF."comments WHERE  type = $type_no AND id = $trans_no";
    db_query($sql, "Could not delete comments");
    $sql = "DELETE FROM ".TB_PREF."refs WHERE  type = $type_no AND id = $trans_no";
    db_query($sql, "Could not delete refs");
}